代码抛出execption [英] code throw execption
本文介绍了代码抛出execption的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
所有代码都在运行，但它会抛出异常，如下所示。它给出的错误是无效的对象名称'ISB VAS NODE $''
protected void Page_Load（ object sender，EventArgs e）
{
if （！Page.IsPostBack）
{
binddata（）;
}
}
private void binddata（）
{
尝试
{
string connstring = @ 数据源= LENOVO-41B3F2CE\SQLEXPRESS;初始目录= IMS;集成安全性=真;池化=假;
string query = SELECT * FROM ['ISB VAS Nodes $'] ;
SqlDataAdapter da = new SqlDataAdapter（query，connstring）;
DataTable dt = new DataTable（）;
da.Fill（dt）;
GridView1.DataSource = dt;
GridView1.DataBind（）;
}
catch （例外）
{
}
}
protected void GridView1_RowEditing（ object sender，GridViewEditEventArgs e）
{
GridView1.EditIndex = e.NewEditIndex;
binddata（）;
}
protected void GridView1_RowUpdating（ object sender，GridViewUpdateEventArgs e）
{
GridViewRow row = GridView1.Rows [e.RowIndex];
TextBox TextBoxEditID =（TextBox）row.FindControl（ TextBoxEditID） ;
TextBox TextBoxEditRackName =（TextBox）row.FindControl（ TextBoxEditRackName）;
TextBox TextBoxEditqty =（TextBox）row.FindControl（ TextBoxEditqty）;
TextBox TextBoxEdittype =（TextBox）row.FindControl（ TextBoxEdittype）;
TextBox TextBoxEditdesc =（TextBox）row.FindControl（ TextBoxEditdesc）;
TextBox TextBoxEditmodel =（TextBox）row.FindControl（ TextBoxEditmodel）;
TextBox TextBoxEditsn =（TextBox）row.FindControl（ TextBoxEditsn）;
TextBox TextBoxEditassettag =（TextBox）row.FindControl（ TextBoxEditassettag）;
TextBox TextBoxEditcity =（TextBox）row.FindControl（ TextBoxEditcity）;
TextBox TextBoxEditNodeName =（TextBox）row.FindControl（ TextBoxEditNodename）;
TextBox TextBoxEditIPAddress =（TextBox）row.FindControl（ TextBoxEditIPAddress）;
TextBox TextBoxEditFloatIP =（TextBox）row.FindControl（ TextBoxEditFloatIP）;
TextBox TextBoxEditProcessors =（TextBox）row.FindControl（ TextBoxEditProcessors）;
TextBox TextBoxEditRAM =（TextBox）row.FindControl（ TextBoxEditRAM）;
TextBox TextBoxEditHardDisks =（TextBox）row.FindControl（ TextBoxEditHarddisks）;
TextBox TextBoxEditRAIDManager =（TextBox）row.FindControl（ TextBoxEditRAIDManager）;
// int productID = Int32.Parse（GridView1 .DataKeys [e.RowIndex] .Value.ToString（））;
string ID = TextBoxEditID.Text;
string Name = TextBoxEditRackName.Text;
string qty = TextBoxEditqty.Text;
string type = TextBoxEdittype.Text;
string desc = TextBoxEditdesc.Text;
string model = TextBoxEditmodel.Text;
string sn = TextBoxEditsn.Text;
string tag = TextBoxEditassettag.Text;
string cty = TextBoxEditcity.Text;
string node = TextBoxEditNodeName.Text;
string ip = TextBoxEditIPAddress.Text;
string fip = TextBoxEditFloatIP.Text;
string pro = TextBoxEditProcessors.Text;
string ram = TextBoxEditRAM.Text;
string hd = TextBoxEditHardDisks.Text;
string rmana = TextBoxEditRAIDManager.Text;
更新（ID，名称，数量，类型，desc，模型，sn，标签，cty，node，ip，fip，pro，ram，hd，rmana）;
}
私有 void 更新（ string ID， string 名称， string qty，字符串类型，字符串 desc，字符串模型，字符串 sn，字符串标记，字符串 cty， string node， string ip， string fip，< span class =code-keyword> string pro， string ram， string hd， string rmana）
{
尝试
{
string constr = @ 数据源= LENOVO-41B3F2CE\SQLEXPRESS;初始目录=库存;集成安全性=真;池化=假;
string query = UPDATE ['ISB VAS节点$'] SET RackName = @Name，QTY = @qty，Type = @ type，[Desc] = @desc，Model = @model，SN = @sn，AssetTag = @tag，City = @cty，NodeName = @node，IPAddress = @ip，FloatIP = @fip，Processors = @pro，RAM = @ram，HardDisks = @hd，RAIDManager = @rmana WHERE ID = @ID;
SqlConnection con = new SqlConnection（constr）;
SqlCommand com = new SqlCommand（query，con）;
com.Parameters.Add（ @ Name ，SqlDbType.VarChar）.Value = Name;
com.Parameters.Add（ @ qty，SqlDbType.VarChar）.Value =数量;
com.Parameters.Add（ @ type，SqlDbType.VarChar）.Value =类型;
com.Parameters.Add（ @ desc，SqlDbType.VarChar）.Value =说明;
com.Parameters.Add（ @ model，SqlDbType.VarChar）.Value =模型;
com.Parameters.Add（ @ sn，SqlDbType.VarChar）.Value = SN;
com.Parameters.Add（ @ tag，SqlDbType.VarChar）.Value =标签;
com.Parameters.Add（ @ cty，SqlDbType.VarChar）.Value = CTY;
com.Parameters.Add（ @ node，SqlDbType.VarChar）.Value =节点;
com.Parameters.Add（ @ ip，SqlDbType.VarChar）.Value = IP;
com.Parameters.Add（ @ fip，SqlDbType.VarChar）.Value = FIP;
com.Parameters.Add（ @ pro，SqlDbType.VarChar）.Value =亲;
com.Parameters.Add（ @ ram，SqlDbType.VarChar）.Value =内存;
com.Parameters.Add（ @ hd，SqlDbType.VarChar）.Value = HD;
com.Parameters.Add（ @ rmana，SqlDbType.VarChar）.Value = rmana;
com.Parameters.Add（ @ ID，SqlDbType.VarChar）.Value = ID;
con.Open（）;
com.ExecuteNonQuery（）;
con.Close（）;
GridView1.EditIndex = -1;
binddata（）;
}
catch （例外情况）
{
throw ex; // 此时发出错误
}
}
解决方案
''
protected void Page_Load（ object sender，EventArgs e）
{
if （！Page.IsPostBack）
{
binddata（）;
}
}
私有 void binddata（ ）
{
try
{
string connstring = @ 数据源= LENOVO-41B3F2CE\SQLEXPRESS;初始目录= IMS;集成安全性= True; Pooling = False ;
string query = SELECT * FROM [ 'ISB增值节点
'];
SqlDataAdapter da = new SqlDataAdapter（query，connstring）;
DataTable dt = new DataTable（）;
da.Fill（dt）;
GridView1.DataSource = dt;
GridView1.DataBind（）;
}
catch （例外）
{
}
}
protected void GridView1_RowEditing（ object sender，GridViewEditEventArgs e）
{
GridView1.EditIndex = e.NewEditIndex;
binddata（）;
}
protected void GridView1_RowUpdating（ object sender，GridViewUpdateEventArgs e）
{
GridViewRow row = GridView1.Rows [e.RowIndex];
TextBox TextBoxEditID =（TextBox）row.FindControl（ TextBoxEditID） ;
TextBox TextBoxEditRackName =（TextBox）row.FindControl（ TextBoxEditRackName）;
TextBox TextBoxEditqty =（TextBox）row.FindControl（ TextBoxEditqty）;
TextBox TextBoxEdittype =（TextBox）row.FindControl（ TextBoxEdittype）;
TextBox TextBoxEditdesc =（TextBox）row.FindControl（ TextBoxEditdesc）;
TextBox TextBoxEditmodel =（TextBox）row.FindControl（ TextBoxEditmodel）;
TextBox TextBoxEditsn =（TextBox）row.FindControl（ TextBoxEditsn）;
TextBox TextBoxEditassettag =（TextBox）row.FindControl（ TextBoxEditassettag）;
TextBox TextBoxEditcity =（TextBox）row.FindControl（ TextBoxEditcity）;
TextBox TextBoxEditNodeName =（TextBox）row.FindControl（ TextBoxEditNodename）;
TextBox TextBoxEditIPAddress =（TextBox）row.FindControl（ TextBoxEditIPAddress）;
TextBox TextBoxEditFloatIP =（TextBox）row.FindControl（ TextBoxEditFloatIP）;
TextBox TextBoxEditProcessors =（TextBox）row.FindControl（ TextBoxEditProcessors）;
TextBox TextBoxEditRAM =（TextBox）row.FindControl（ TextBoxEditRAM）;
TextBox TextBoxEditHardDisks =（TextBox）row.FindControl（ TextBoxEditHarddisks）;
TextBox TextBoxEditRAIDManager =（TextBox）row.FindControl（ TextBoxEditRAIDManager）;
// int productID = Int32.Parse（GridView1 .DataKeys [e.RowIndex] .Value.ToString（））;
string ID = TextBoxEditID.Text;
string Name = TextBoxEditRackName.Text;
string qty = TextBoxEditqty.Text;
string type = TextBoxEdittype.Text;
string desc = TextBoxEditdesc.Text;
string model = TextBoxEditmodel.Text;
string sn = TextBoxEditsn.Text;
string tag = TextBoxEditassettag.Text;
string cty = TextBoxEditcity.Text;
string node = TextBoxEditNodeName.Text;
string ip = TextBoxEditIPAddress.Text;
string fip = TextBoxEditFloatIP.Text;
string pro = TextBoxEditProcessors.Text;
string ram = TextBoxEditRAM.Text;
string hd = TextBoxEditHardDisks.Text;
string rmana = TextBoxEditRAIDManager.Text;
更新（ID，名称，数量，类型，desc，模型，sn，标签，cty，node，ip，fip，pro，ram，hd，rmana）;
}
私有 void 更新（ string ID， string 名称， string qty，字符串类型，字符串 desc，字符串模型，字符串 sn，字符串标记，字符串 cty， string node， string ip， string fip，< span class =code-keyword> string pro， string ram， string hd， string rmana）
{
尝试
{
string constr = @ 数据源= LENOVO-41B3F2CE\SQLEXPRESS;初始目录=库存;集成安全性=真;池化=假;
string query = UPDATE ['ISB VAS节点
'] SET RackName = @ Name，QTY = @qty，Type = @type，[Desc] = @desc，Model = @model，SN = @sn，AssetTag = @tag，City = @cty，NodeName = @node，IPAddress = @ip，FloatIP = @fip，Processors = @pro，RAM = @ram，HardDisks = @hd，RAIDManager = @rmana WHERE ID = @ID;
SqlConnection con = new SqlConnection（constr）;
SqlCommand com = new SqlCommand（query，con）;
com.Parameters.Add（ @ Name ，SqlDbType.VarChar）.Value = Name;
com.Parameters.Add（ @ qty，SqlDbType.VarChar）.Value =数量;
com.Parameters.Add（ @ type，SqlDbType.VarChar）.Value =类型;
com.Parameters.Add（ @ desc，SqlDbType.VarChar）.Value =说明;
com.Parameters.Add（ @ model，SqlDbType.VarChar）.Value =模型;
com.Parameters.Add（ @ sn，SqlDbType.VarChar）.Value = SN;
com.Parameters.Add（ @ tag，SqlDbType.VarChar）.Value =标签;
com.Parameters.Add（ @ cty，SqlDbType.VarChar）.Value = CTY;
com.Parameters.Add（ @ node，SqlDbType.VarChar）.Value =节点;
com.Parameters.Add（ @ ip，SqlDbType.VarChar）.Value = IP;
com.Parameters.Add（ @ fip，SqlDbType.VarChar）.Value = FIP;
com.Parameters.Add（ @ pro，SqlDbType.VarChar）.Value =亲;
com.Parameters.Add（ @ ram，SqlDbType.VarChar）.Value =内存;
com.Parameters.Add（ @ hd，SqlDbType.VarChar）.Value = HD;
com.Parameters.Add（ @ rmana，SqlDbType.VarChar）.Value = rmana;
com.Parameters.Add（ @ ID，SqlDbType.VarChar）.Value = ID;
con.Open（）;
com.ExecuteNonQuery（）;
con.Close（）;
GridView1.EditIndex = -1;
binddata（）;
}
catch （例外情况）
{
throw ex; // 此时发出错误
}
}
all code is running but it throw exception as shown below. and error it give is "invalid object name ''ISB VAS NODE$''
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
binddata();
}
}
private void binddata()
{
try
{
string connstring = @"Data Source=LENOVO-41B3F2CE\SQLEXPRESS;Initial Catalog=IMS;Integrated Security=True;Pooling=False";
string query = "SELECT * FROM ['ISB VAS Nodes$']";
SqlDataAdapter da = new SqlDataAdapter(query, connstring);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception)
{
}
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
binddata();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
TextBox TextBoxEditID = (TextBox)row.FindControl("TextBoxEditID");
TextBox TextBoxEditRackName = (TextBox)row.FindControl("TextBoxEditRackName");
TextBox TextBoxEditqty = (TextBox)row.FindControl("TextBoxEditqty");
TextBox TextBoxEdittype = (TextBox)row.FindControl("TextBoxEdittype");
TextBox TextBoxEditdesc = (TextBox)row.FindControl("TextBoxEditdesc");
TextBox TextBoxEditmodel = (TextBox)row.FindControl("TextBoxEditmodel");
TextBox TextBoxEditsn = (TextBox)row.FindControl("TextBoxEditsn");
TextBox TextBoxEditassettag = (TextBox)row.FindControl("TextBoxEditassettag");
TextBox TextBoxEditcity = (TextBox)row.FindControl("TextBoxEditcity");
TextBox TextBoxEditNodeName = (TextBox)row.FindControl("TextBoxEditNodename");
TextBox TextBoxEditIPAddress = (TextBox)row.FindControl("TextBoxEditIPAddress");
TextBox TextBoxEditFloatIP = (TextBox)row.FindControl("TextBoxEditFloatIP");
TextBox TextBoxEditProcessors = (TextBox)row.FindControl("TextBoxEditProcessors");
TextBox TextBoxEditRAM = (TextBox)row.FindControl("TextBoxEditRAM");
TextBox TextBoxEditHardDisks = (TextBox)row.FindControl("TextBoxEditHarddisks");
TextBox TextBoxEditRAIDManager = (TextBox)row.FindControl("TextBoxEditRAIDManager");
//int productID = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());
string ID = TextBoxEditID.Text;
string Name = TextBoxEditRackName.Text;
string qty = TextBoxEditqty.Text;
string type = TextBoxEdittype.Text;
string desc = TextBoxEditdesc.Text;
string model = TextBoxEditmodel.Text;
string sn = TextBoxEditsn.Text;
string tag = TextBoxEditassettag.Text;
string cty = TextBoxEditcity.Text;
string node = TextBoxEditNodeName.Text;
string ip = TextBoxEditIPAddress.Text;
string fip = TextBoxEditFloatIP.Text;
string pro = TextBoxEditProcessors.Text;
string ram = TextBoxEditRAM.Text;
string hd = TextBoxEditHardDisks.Text;
string rmana = TextBoxEditRAIDManager.Text;
Update(ID, Name, qty, type, desc, model, sn, tag, cty, node, ip, fip, pro, ram, hd, rmana);
}
private void Update(string ID, string Name, string qty, string type, string desc, string model, string sn, string tag, string cty, string node, string ip, string fip, string pro, string ram, string hd, string rmana)
{
try
{
string constr = @"Data Source=LENOVO-41B3F2CE\SQLEXPRESS;Initial Catalog=inventory;Integrated Security=True;Pooling=False";
string query = "UPDATE ['ISB VAS Nodes$'] SET RackName = @Name, QTY = @qty, Type = @type, [Desc] = @desc, Model = @model, SN = @sn, AssetTag = @tag, City = @cty, NodeName = @node, IPAddress = @ip, FloatIP = @fip, Processors = @pro, RAM = @ram, HardDisks = @hd, RAIDManager = @rmana WHERE ID = @ID";
SqlConnection con = new SqlConnection(constr);
SqlCommand com = new SqlCommand(query, con);
com.Parameters.Add("@Name", SqlDbType.VarChar).Value = Name;
com.Parameters.Add("@qty", SqlDbType.VarChar).Value = qty;
com.Parameters.Add("@type", SqlDbType.VarChar).Value = type;
com.Parameters.Add("@desc", SqlDbType.VarChar).Value = desc;
com.Parameters.Add("@model", SqlDbType.VarChar).Value = model;
com.Parameters.Add("@sn", SqlDbType.VarChar).Value = sn;
com.Parameters.Add("@tag", SqlDbType.VarChar).Value = tag;
com.Parameters.Add("@cty", SqlDbType.VarChar).Value = cty;
com.Parameters.Add("@node", SqlDbType.VarChar).Value = node;
com.Parameters.Add("@ip", SqlDbType.VarChar).Value = ip;
com.Parameters.Add("@fip", SqlDbType.VarChar).Value = fip;
com.Parameters.Add("@pro", SqlDbType.VarChar).Value = pro;
com.Parameters.Add("@ram", SqlDbType.VarChar).Value = ram;
com.Parameters.Add("@hd", SqlDbType.VarChar).Value = hd;
com.Parameters.Add("@rmana", SqlDbType.VarChar).Value = rmana;
com.Parameters.Add("@ID", SqlDbType.VarChar).Value = ID;
con.Open();
com.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
binddata();
}
catch (Exception ex)
{
throw ex; // give error at this point
}
} 解决方案
''
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { binddata(); } } private void binddata() { try { string connstring = @"Data Source=LENOVO-41B3F2CE\SQLEXPRESS;Initial Catalog=IMS;Integrated Security=True;Pooling=False"; string query = "SELECT * FROM ['ISB VAS Nodes
']"; SqlDataAdapter da = new SqlDataAdapter(query, connstring); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception) { } } protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; binddata(); } protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; TextBox TextBoxEditID = (TextBox)row.FindControl("TextBoxEditID"); TextBox TextBoxEditRackName = (TextBox)row.FindControl("TextBoxEditRackName"); TextBox TextBoxEditqty = (TextBox)row.FindControl("TextBoxEditqty"); TextBox TextBoxEdittype = (TextBox)row.FindControl("TextBoxEdittype"); TextBox TextBoxEditdesc = (TextBox)row.FindControl("TextBoxEditdesc"); TextBox TextBoxEditmodel = (TextBox)row.FindControl("TextBoxEditmodel"); TextBox TextBoxEditsn = (TextBox)row.FindControl("TextBoxEditsn"); TextBox TextBoxEditassettag = (TextBox)row.FindControl("TextBoxEditassettag"); TextBox TextBoxEditcity = (TextBox)row.FindControl("TextBoxEditcity"); TextBox TextBoxEditNodeName = (TextBox)row.FindControl("TextBoxEditNodename"); TextBox TextBoxEditIPAddress = (TextBox)row.FindControl("TextBoxEditIPAddress"); TextBox TextBoxEditFloatIP = (TextBox)row.FindControl("TextBoxEditFloatIP"); TextBox TextBoxEditProcessors = (TextBox)row.FindControl("TextBoxEditProcessors"); TextBox TextBoxEditRAM = (TextBox)row.FindControl("TextBoxEditRAM"); TextBox TextBoxEditHardDisks = (TextBox)row.FindControl("TextBoxEditHarddisks"); TextBox TextBoxEditRAIDManager = (TextBox)row.FindControl("TextBoxEditRAIDManager"); //int productID = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString()); string ID = TextBoxEditID.Text; string Name = TextBoxEditRackName.Text; string qty = TextBoxEditqty.Text; string type = TextBoxEdittype.Text; string desc = TextBoxEditdesc.Text; string model = TextBoxEditmodel.Text; string sn = TextBoxEditsn.Text; string tag = TextBoxEditassettag.Text; string cty = TextBoxEditcity.Text; string node = TextBoxEditNodeName.Text; string ip = TextBoxEditIPAddress.Text; string fip = TextBoxEditFloatIP.Text; string pro = TextBoxEditProcessors.Text; string ram = TextBoxEditRAM.Text; string hd = TextBoxEditHardDisks.Text; string rmana = TextBoxEditRAIDManager.Text; Update(ID, Name, qty, type, desc, model, sn, tag, cty, node, ip, fip, pro, ram, hd, rmana); } private void Update(string ID, string Name, string qty, string type, string desc, string model, string sn, string tag, string cty, string node, string ip, string fip, string pro, string ram, string hd, string rmana) { try { string constr = @"Data Source=LENOVO-41B3F2CE\SQLEXPRESS;Initial Catalog=inventory;Integrated Security=True;Pooling=False"; string query = "UPDATE ['ISB VAS Nodes
'] SET RackName = @Name, QTY = @qty, Type = @type, [Desc] = @desc, Model = @model, SN = @sn, AssetTag = @tag, City = @cty, NodeName = @node, IPAddress = @ip, FloatIP = @fip, Processors = @pro, RAM = @ram, HardDisks = @hd, RAIDManager = @rmana WHERE ID = @ID"; SqlConnection con = new SqlConnection(constr); SqlCommand com = new SqlCommand(query, con); com.Parameters.Add("@Name", SqlDbType.VarChar).Value = Name; com.Parameters.Add("@qty", SqlDbType.VarChar).Value = qty; com.Parameters.Add("@type", SqlDbType.VarChar).Value = type; com.Parameters.Add("@desc", SqlDbType.VarChar).Value = desc; com.Parameters.Add("@model", SqlDbType.VarChar).Value = model; com.Parameters.Add("@sn", SqlDbType.VarChar).Value = sn; com.Parameters.Add("@tag", SqlDbType.VarChar).Value = tag; com.Parameters.Add("@cty", SqlDbType.VarChar).Value = cty; com.Parameters.Add("@node", SqlDbType.VarChar).Value = node; com.Parameters.Add("@ip", SqlDbType.VarChar).Value = ip; com.Parameters.Add("@fip", SqlDbType.VarChar).Value = fip; com.Parameters.Add("@pro", SqlDbType.VarChar).Value = pro; com.Parameters.Add("@ram", SqlDbType.VarChar).Value = ram; com.Parameters.Add("@hd", SqlDbType.VarChar).Value = hd; com.Parameters.Add("@rmana", SqlDbType.VarChar).Value = rmana; com.Parameters.Add("@ID", SqlDbType.VarChar).Value = ID; con.Open(); com.ExecuteNonQuery(); con.Close(); GridView1.EditIndex = -1; binddata(); } catch (Exception ex) { throw ex; // give error at this point } }
这篇关于代码抛出execption的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
