Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: ASP
Posted by: Mario Lopes
Added: Dec 3, 2019 3:38 PM
Views: 6
  1. SqlDataSource2.SelectParameters.Clear();
  2.         SqlDataSource2.SelectCommand = "select * from seguros where fracao=? and edificio=?";
  3.         SqlDataSource2.SelectParameters.Add("@a", DropDownList1.Text);
  4.         SqlDataSource2.SelectParameters.Add("@b", Session["edificio"].ToString());        
  5.         DataView dvsqllist = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
  6.         DataTable tablelist = dvsqllist.Table;
  7.         SqlDataSource2.DataBind();
  8.         System.Data.DataView dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
  9.         Response.Write( dv.Count.ToString());