You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

为何GridBox无法显示数据?SQL参数查询异常求助

GridBox无法显示数据问题

我遇到GridBox无法显示数据的问题:运行代码后,所需信息并未在GridBox中显示。最初使用语句string cumle = "select tc_no,car_plate,total,date,tax from [invoice] WHERE (status=0) AND tc_no=@tc_no";执行时会报错,于是修改为添加变量声明的语句string cumle = "declare @tc_no bigint select tc_no,car_plate,total,date,tax from [invoice] WHERE (status=0) AND tc_no=@tc_no";,但调整后运行代码,GridBox仍无法显示所需数据。

相关代码如下:

public partial class fatura : Form
{
    SqlConnection baglanti = new SqlConnection("Server=localhost;Database=master; Trusted_Connection=True");
    DataTable tablo;
    araba_ekleme araba_ekleme = new araba_ekleme();
    public fatura()
    {
        InitializeComponent();
    }
    public DataTable listele(SqlDataAdapter adtr, string sorgu)
    {
        tablo = new DataTable();
        adtr = new SqlDataAdapter(sorgu, baglanti);
        adtr.Fill(tablo);
        baglanti.Close();
        return tablo;
    }
    private void onay_bekleyen()
    {
        string cumle = "declare @tc_no bigint select tc_no,car_plate,total,date,tax from [invoice] WHERE (status=0) AND tc_no=@tc_no";
        SqlDataAdapter adtr2 = new SqlDataAdapter();
        dg_pending.DataSource = listele(adtr2, cumle);
    }
    private void onaylanan()
    {
        string cumle = "declare @tc_no bigint select tc_no,car_plate,total,date,tax from [invoice] WHERE (status=1) AND tc_no=@tc_no";
        SqlDataAdapter adtr2 = new SqlDataAdapter();
        dg_done.DataSource = listele(adtr2, cumle);
    }
    private void fatura_Load(object sender, EventArgs e)
    {
        onay_bekleyen();
        onaylanan();
    }
}

运行效果截图:
GridBox无数据显示截图

内容的提问来源于stack exchange,提问作者Axciom

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.05 04:25:39