retreiving value from sql server
Hi! i want to retreive value from a table named costomer, this code is working , but there is a problem that is always give the first row value, and i required the last inserted value.
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString01"].ToString();
SqlCommand cmd = new SqlCommand("select cost_id from costomer",con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
string temp = ds.Tables.Rows.ToString()
can anyone tell me how to retreive last value of table????
Re: retreiving value from sql server
Obviously Rows will give the first value.
If you want the Item from last row, I think this will work :
|All times are GMT +5.5. The time now is 03:04.|