How to get all the parameter of store procedure through query

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on May 30th , 2009 by Admin

private void bindParameters( string strName)

{

SqlConnection conn = new SqlConnection(connectionstring);

StringBuilder stbr = new StringBuilder();

sb.Append("select s.id, s.name, t.name as [type], t.length ");

sb.Append("from syscolumns s ");

sb.Append("inner join systypes t ");

sb.Append("on s.xtype = t.xtype ");

sb.Append("where id = (select id from sysobjects where name='" + strName + "')"

);

SqlDataAdapter adapter = new SqlDataAdapter(stbr.ToString(), conn);

DataTable dt = new DataTable();

try

{

conn.Open();

adapter.Fill(dt);

DataGrid1.DataSource=dt; //bind parametr with datagrid for visual

DataGrid1.DataBind();

}

catch (Exception ex)

{

lblException.Text = ex.ToString();

}

finally

{

conn.Close();

}