Any body please help me , how to use the Sql Statement "Select max(column.A) from TBL_table" using asp.net in C# platform and I also want the result(the maximum number ) to insert onto a text box.
mahmud.riyadh
0
Newbie Poster
Recommended Answers
Jump to Postuse this code to get max number from table in asp.net
public string login_id(string str) { string id; SqlCommand cmd = new SqlCommand("SELECT MAX(CONVERT(int, SUBSTRING(id,3,3)))+1 FROM uploadebook", con); if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); Object obj …
All 2 Replies
Mind Bird
0
Newbie Poster
ashutoshjha
commented:
good one bro...it was really helpful...
+0
sknake
1,622
Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.