[WebMethod(EnableSession = true)]
public DataSet Findsome(string s)
{
string constr = "Initial Catalog=.........................";
conn = new SqlConnection();
conn.ConnectionString = constr;//Session["Constr"].ToString();
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select distinct " + s + " from table ";
//cmd.Parameters.AddWithValue("@some", s);
cmd.Connection = conn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "table");
return ds;
}
but this code is in a sepereate .asmx page