protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strConnString);
con.Open();
str = "select * from emp where id = max(id)"
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
reader.Read();
labelname1.Text = reader["Name"].ToString();
reader.Read();
labelname2.Text = reader["Name"].ToString();
reader.Read();
labelname3.Text = reader["Name"].ToString();
reader.Close();
con.Close();
con.Open();
SqlDataReader reader1 = com.ExecuteReader();
reader1.Read();
labelage1.Text = reader1["Age"].ToString();
reader1.Read();
labelage2.Text = reader1["Age"].ToString();
reader1.Read();
labelage3.Text = reader1["Age"].ToString();
reader.Close();
con.Close();
}
but this code is not working guys kindly help me.
Loading
Abhishek KumarPosted Oct 3, 2014, 9:45 AM
Seems issue with the sql query you are using .
Please try using this query.
select * from emp where ID=(select max(ID) from emp)
Abhishek
Pradeep ShetPosted Oct 3, 2014, 7:39 AM
Find the below code, hope you are getting what i want to say.
SqlConnection conn = new SqlConnection(strConnString);
conn.Open();
str = "select * from emp where id = max(id)";
com = new SqlCommand(str, con);
SqlDataReader reader = com.ExecuteReader();
while(reader.Read())
{
//This will iterate till you have all records.
// labelname1.Text = reader["Name"].ToString();
}
reader.Close();
conn.Read();
If you are not getting plz feel free to ask it.
Mark it as answered if it helped you.
Seyedhamed VahediPosted Oct 3, 2014, 2:20 AM