为何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(); } }
运行效果截图:
内容的提问来源于stack exchange,提问作者Axciom
相关产品推荐
相关产品推荐

