时间戳

首页 > 解决方案 > asp.net webform中的案例查询sql命令

asp.net - asp.net webform中的案例查询sql命令

问题描述

我在 sqlserver 中编写了一个运行良好的查询。现在我想在 asp.net 中单击一个按钮来添加这个查询来填充网格。这个怎么写？

这是我的查询：

SqlConnection con = new SqlConnection("ConnectionString");
var command= "SELECT ActName,
    CASE WHEN SUM(DebitAmount - CreditAmount ) > THEN 
      SUM(DebitAmount - CreditAmount) ELSE 0 END AS DebitAmount,
    CASE WHEN SUM(DebitAmount - CreditAmount) < 0 
         THEN SUM(CreditAmount- DebitAmount) ELSE 0 END AS CreditAmount 
    FROM TblAWSLocalTrans GROUP BY ActName ORDER BY ActName"
SqlCommand cmd = new SqlCommand(command, con); 
SqlDataAdapter da= new SqlDataAdapter();
DataTable dt= new DataTable();
da.Fill(dt);
GridView1.DataSource = dt; 
GridView1.DataBind(); 
con.Close();

标签： asp.netsql-server

解决方案

Ans.. 在 ado.net 代码中使用内联查询。

    public void btn_click(object sender,EventArgs e) 
     { 
       SqlConnection con = new SqlConnection("ConnectionString"); 
       var command= "SELECT ActName,CASE WHEN SUM(DebitAmount - CreditAmount ) > THEN 
      SUM(DebitAmount - CreditAmount)ELSE 0 END AS DebitAmount,CASE WHEN SUM(DebitAmount - 
     CreditAmount) < 0 THEN SUM(CreditAmount- DebitAmount )ELSE 0 END AS CreditAmount 
      FROM TblAWSLocalTrans GROUP BY ActName ORDER BY ActName"
      SqlCommand cmd = new SqlCommand(command, con); 
      SqlDataAdapter da= new SqlDataAdapter();
      DataTable dt= new DataTable();
      da.Fill(dt);
      GridView1.DataSource = dt; 
      GridView1.DataBind(); 
      con.Close();
   }

推荐阅读