[WebMethod] public string searching1(int city,int badroom,Int64 min,Int64 maximum) { //DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlConnection cn; dataacc d; try { StringWriter st = new StringWriter(); cn = new SqlConnection(); d = new dataacc(); cn = d.getconnection(); SqlCommand cmd = new SqlCommand("searching", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@city", city); cmd.Parameters.AddWithValue("@badroom", badroom); cmd.Parameters.AddWithValue("@min", min); cmd.Parameters.AddWithValue("@maximum", maximum); cn.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); //new ds.WriteXml(st); cn.Close(); //string s= dt.Rows[0][0].ToString(); return st.ToString(); } catch (Exception ex) { throw new Exception(ex.Message); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)