gpt4 book ai didi

c# - {"Object reference not set to an instance of an object."}

转载 作者:太空宇宙 更新时间:2023-11-03 23:37:27 25 4
gpt4 key购买 nike

<分区>

我正在使用下面的代码从数据库中选择数据并绑定(bind)数据 GridView ,但我遇到了这个错误,其他用户之前提出的所有问题都没有帮助我。

代码:

        public void popRuta()
{
string cs = "Data Source=CODRINMA\\CODRINMA;Initial Catalog=TrafficManager;Integrated Security=True";
string select = "SELECT ats.NrOrdine, o.Oras as Oras, a.Denumire as Autogara FROM AutogariTrasee ats INNER JOIN Autogari a on a.IDAutogara=ats.IDAutogara INNER JOIN Orase o on o.IDOras=a.IDOras where IDTraseu=@IDTraseu ORDER BY ats.NrOrdine";

try
{
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand(select, con);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("IDTraseu", int.Parse(grdTrasee.CurrentRow.Cells[0].FormattedValue.ToString()));
SqlDataReader sda = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sda);
grdRuta.DataSource = dt;
grdRuta.Refresh();
con.Close();
}
}
catch (Exception er) { MessageBox.Show(er.Message); }

}

错误:

{"Object reference not set to an instance of an object."}

无法弄清楚我错过了什么...当它停止我的应用程序时,c# 界面会突出显示这一行:cmd.Parameters.AddWithValue("IDTraseu", int.Parse(grdTrasee.CurrentRow.Cells[ 0].FormattedValue.ToString()));

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com