How to write a method to return a DataTable Object?

Question

Hi friends I want to write a method to return a DataTable Object.. Input parameters can be overloaded depending on parameters required by Stored Procedure.. How can i write this please guide as i am new to c#

Santhosh Kumar Jayaraman · Answer

public static DataTable ExecuteDataTable(string storedProcedureName params SqlParameter[] arrParam) { DataTable dt = new DataTable(); using (SqlConnection cnn = new SqlConnection( Data Source=.\sqlexpress;Initial Catalog=NorthWind; Integrated Security=True)) { cnn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = storedProcedureName; if (arrParam != null) { foreach (SqlParameter param in arrParam) cmd.Parameters.Add(param); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } } } return dt; }

rani m mk · Answer

Thanks Very much Santhosh