sqldatasource dataTable

Please login or create account to add a snippet.

Follow @TagMyCode

Language: ASP

Posted by: Mario Lopes

Added: May 17, 2018 2:28 PM

Tags: datatable sql tablelist

SqlDataSource2.SelectCommand = "select * from disciplinas where codigo=?";
SqlDataSource2.SelectParameters.Add("a", codigo_txt.Text);
DataView dvsqllist = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
DataTable tablelist = dvsqllist.Table;
SqlDataSource2.DataBind();
foreach (DataRow row in tablelist.Rows)
{
codigo = row["codigo"].ToString();
}