CREATE PROCEDURE [dbo].[prcDisplaydataTemplate] AS BEGIN (SELECT DataTable.objectOriginalName FROM dbo.DataTable) END
private void btDataTemplate_Click(object sender, EventArgs e) { DataSet dsobbtemp = new DataSet(); DBConnection objConnection = new DBConnection(); try { objConnection.GetConnection(); dsobbtemp = objConnection.GetDataSet("prcDisplaydataTemplate"); dgDtParameters.DataSource = dsobbtemp; } catch (Exception) { throw; } finally { if (objConnection.sconnConnection.State == ConnectionState.Open) { objConnection.CloseConnection(); } } }
public void GetConnection() { try { sconnConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ToString()); sconnConnection.Open(); } catch (SqlException) { throw; } }
public DataSet GetDataSet(string sql) { DataSet dataset = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(sql, this.sconnConnection); adapter.SelectCommand = cmd; adapter.Fill(dataset); return dataset; }
dgDtParameters.DataSource = dsobbtemp.Tables[0];
cmd.CommandType = CommandType.StoredProcedure
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)