rating in website

This means there is no column with name ID returned by your SQL query

hi

but in my database is id column when i use this query in sql show columns 

It may be in database but in your query you have not included it that's why it is throwing that error

i add id in my query it worked

this is my new query

 SqlCommand _cm2 = new SqlCommand(" SELECT  id,address   ,tell,name,(Select COUNT(behcode) from furniture_p where behcode= furniture_ch.behcode) as [count] from furniture_ch where F_code ='"+Request.QueryString["Code"]+"' order by [count] desc", _cn);

i have 2 question

1-i wrote above query in procedure in sql  but i dont  know how i can use it in my web page  I  can  use procedure in my web site but here i have querystring i dont know how i can use procedure for this?

1-i want my query sort my data  by  date 

  furniture_p table has  date column that save date the  user has entered a new product

  i want query that show the user that  Recently enter  their product

i want sort by date...

thanks

You can use the following stored proc

CREATE PROCEDURE [dbo].[GetProducts] 
@F_Code VARCHAR(100)
AS
BEGIN
SELECT  id, [address]   ,tell,name, count(behcode) as [count] 
FROM furniture_ch, furniture_p 
WHERE F_code =@F_Code
ORDER BY furniture_p.date desc
END

In Order by change the "furniture_p.date" to your date column

And for calling this stored proc

String strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetProducts";
cmd.Parameters.Add("@F_Code", SqlDbType.VarChar).Value = Request.QueryString["Code"];         
cmd.Connection = con;
try
{
    con.Open();
    GridView1.EmptyDataText = "No Records Found";
    GridView1.DataSource = cmd.ExecuteReader();
    GridView1.DataBind();
}
catch (Exception ex)
{
    throw ex;
}
finally
{
    con.Close();
    con.Dispose();
}