Dataset Designer using it programmatically?
-
I am using an extensive dataset that was designed through the graphical dataset designer, how do i call a method(query) from that dataset programmatically? thanks
Do you want to get data from a database and display in your application datagridview? // this is a routine i wrote public static void SP_WITH_DATAGRIDVIEW(string SP, DataGridView DATAGRIDVIEW_X, string PARAMETER_NAME1, SqlDbType SQLDBTYPE1, object OBJECT1, string PARAMETER_NAME2, SqlDbType SQLDBTYPE2, object OBJECT2) { SqlConnection conn = new SqlConnection(your_connection_string); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = SP; cmd.CommandType = CommandType.StoredProcedure; // how many parameters to you have? here is 2, and of what kind? cmd.Parameters.Add(PARAMETER_NAME1, SQLDBTYPE1).Value = OBJECT1; cmd.Parameters.Add(PARAMETER_NAME2, SQLDBTYPE2).Value = OBJECT2; conn.Open(); SqlDataAdapter sql_da = new SqlDataAdapter(); sql_da.SelectCommand = cmd; DataTable dt = new DataTable(); sql_da.Fill(dt); conn.Close(); DATAGRIDVIEW_X.DataSource = dt; } Good luck!!!:cool: