Comments by Raj.Rautela (Top 86 by date)

Fill: SelectCommand.Connection property has not been initialized.

m doing like this to bind listview on searcresult page by dt store in session
SqlConnection con = new SqlConnection(str);
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
dt = Session["Search"] as DataTable;
da.Fill(dt);
listview1.DataSource = dt;
listview1.DataBind();
but it is showing error..

Sir got te values in datatable in stored it in Session but now how to bind these values to listview on another page..

tell me how can i store my search result in datatable..

sir but i debugged the code there it is no data in Datatable...

SqlConnection con = new SqlConnection(str);
string strQ = ("select s.Property_Type,C.City_Name,L.Locality_Name,s.Price,s.Bedrooms,s.Area From tbl_post_property_sale as s inner join tbl_City as C on C.City_Id=s.City_id inner join tbl_Locality as L on L.Locality_Id=s.Locality_Id where s.Property_type='" + ddlpropertytype.SelectedItem.Text + "'and C.City_Id=" + ddlcity.SelectedValue + " and L.Locality_Id=" + ddllocality.SelectedValue + " and s.price between " + ddlminprice.SelectedValue + " and " + ddlmaxprice.SelectedValue + " and s.Bedrooms=" + ddlbedrooms.SelectedItem.Text + " and s.Area between '" + (txtminarea.Text).Trim() + " " + ddlarea.SelectedItem.Text + "'and '" + (txtmaxarea.Text).Trim() + " " + ddlarea.SelectedItem.Text + "'");
SqlCommand cmdsearch = new SqlCommand(strQ, con);
con.Open();
cmdsearch.ExecuteNonQuery();
SqlDataAdapter da = new SqlDataAdapter(strQ,con);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();

this is the way to fill result in dt..m i correct or wrong..

sir can u give me an example howw to store my result in session.and how to retrive it on another page

sir can pls give one example....

in my database data is stored like this...
P_ID Property_Type City_Id Locality_Id Address Pincode Price Bedrooms Build_up_area Key_Features Property_Image Name Email Mobile_No
----------- -------------------------------------------------- ----------- ----------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- -------------------- ----------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ---------------------------------------
10 Residential 1 1 Kharghar East 456324 90 Lakh 2 800 sqft Gym,Swimming 0xFFD8FFE1001845786966000049492A00080000000000000000000000FFEC00114475636B7900010004000000320000FFEE000E41646F62650064C000000001FFDB008400080606060606080606080C0807080C0E0A08080A0E100D0D0E0D0D10110C0E0D0D0E0C110F12131413120F18181A1A181823222222232727272727 XYZ xyz@gmail.com 1234567890
12 Commercial 1 5 Vashi Near XYZ mall 123455 10 Crores 0 2000 sqft Near to stn 0xFFD8FFE000104A46494600010100000100010000FFDB0084000906061212111414131414151415151617161718131E181415141416151715161617181B281E1819231C1614202F202427292C2C2C161F3135302A35262B2C2901090A0A0E0C0E1A0F0F1A2E1C1C1F292C2A2C29292C292C2C29292929292C29292C2C2C292C ascd abcd@gmail.com 1234567890

m not getting u

SqlConnection con = new SqlConnection(str); SqlCommand cmdins = new SqlCommand("dbo.Post_Requirement_Buy", con); cmdins.CommandType = CommandType.StoredProcedure; cmdins.Parameters.AddWithValue("@Property_Type", ddlpropertytype.SelectedItem.Text); cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Locality_Id",Convert.ToInt32(ddllocality.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Min_Price", ddlminprice.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Max_Price", ddlmaxprice.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Bedrooms", Convert.ToInt32(ddlbedrooms.SelectedItem.Text)); cmdins.Parameters.AddWithValue("@Build_up_area", txtarea.Text + ' ' + ddlarea.SelectedItem.Text); cmdins.Parameters.AddWithValue("@Key_Features", txtfeatures.Text); cmdins.Parameters.AddWithValue("@Name", txtname.Text); cmdins.Parameters.AddWithValue("@Email", txtemail.Text); cmdins.Parameters.AddWithValue("@Mobile_No", txtmobileno.Text); con.Open(); cmdins.ExecuteNonQuery(); lblmessage.Text = "Submitted Sucessfully"; con.Close(); input type not in correct format error sir...at cmdins.Parameters.AddWithValue("@City_Id",Convert.ToInt32(ddlcity.SelectedItem.Text));

thanks sir..