Sqldatasource select

Please login or create account to add a snippet.

Follow @TagMyCode

Language: ASP

Posted by: Mario Lopes

Added: Apr 23, 2018 3:21 PM

Tags: command select

SqlDataSource2.SelectCommand = "SELECT sum(valor) as total from movimentos where (tipo='Pagamento'and edificio=@a) ";
SqlDataSource2.SelectParameters.Add("@a", DropDownList1.SelectedValue);
SqlDataSource2.DataBind();
DataView dvsqllist = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
DataTable tablelist = dvsqllist.Table;
txtPagamentos.Text = tablelist.Rows[0]["total"].ToString();