how to use the MAX(Date) in C#

Question

Hi All

I want to search about max date from a table but my code don't work,

can any one help me please .

-------------------------------------------------------------------------------------

C#-code in class:

public DataSet ShowFees(int no_mum)

{

string sql = "select MAX(f_date) from fees where no_mum=" + no_mum;

return (Getdata(sql, "fees"));

}

-----------------------------------------------------------

C#-code in presintion:

private void button1_Click(object sender, EventArgs e)

{

DataSet ds2 = wor.ShowFees(Convert.ToInt32(textBox2.Text));

label5.Text = ds2.Tables["fees"].Rows[0]["f_date"].ToString();

}

Ranjit Powar · Answer

Give column name for Max date as follows and try string sql = select MAX(f_date) As f_date from fees where no_mum= + no_mum; If this is correct answer please select it as correct answer.

Ravi Patel · Answer

Hi check this link http://stackoverflow.com/questions/2337770/c-sharp-calculate-min-date-max-date-from-a-list

Hawi Aden · Answer

code of Get Data From DtaBase public DataSet Getdata( string SQL string TBL) { SqlDataAdapter da = new SqlDataAdapter (SQL cn); DataSet ds = new DataSet (); da.Fill(ds TBL); return ds; } ----------------------------------------------------------------------------------------------------------- The Message Error: is A first chance exception of type 'System.ArgumentException' occurred in System.Data.dll Additional information: Column 'f_date' does not belong to table fees. Thanx

Ranjit Powar · Answer

Give code of Getdata method. And description of error.

Ranjit Powar · Answer

Give code of Getdata method. And description of error.