C# .net crystal report

Question

i have a crystal report and i want to display only the max value of id in it from the database.PLease help in this stuck in this for about 3-4 days.. thanks

Amitesh Verma · Answer

thanks fro the replybut tell me one thing where to put this code.before i bind the crystal report to database or after binding

Satyapriya Nayak · Answer

Hi Amitesh Try OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = select max(id)from tablename; com = new OleDbCommand(str con); textBox1.Text = com.ExecuteScalar().ToString(); con.Close(); Thanks