本文介绍了如何解决此错误:对象引用未设置为对象的实例。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
自昨晚以来我自动遇到此问题。当我想在数据库中保存我的数据时,我的窗口中会出现此错误。
我尝试了什么:
I have this problem since last night automatically. When I want to save my data in data base this error is appears in my window.
What I have tried:
protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
string query1 = "insert into AboutVennder(Name,Address,Phone,Email,SallerStatus) values (@name,@add,@phone,@email,@status)";
cmd = new SqlCommand(query1, con);
cmd.Parameters.AddWithValue("@name", TextBox1.Text.ToString());
cmd.Parameters.AddWithValue("@add", TextBox14.Text.ToString());
cmd.Parameters.AddWithValue("@phone", TextBox16.Text.ToString());
cmd.Parameters.AddWithValue("@email", TextBox17.Text.ToString());
cmd.Parameters.AddWithValue("@status", sts);
cmd.ExecuteNonQuery();
con.Close();
Panel3.Visible = false;
Panel1.Attributes.CssStyle.Add("opacity", "1");
Panel1.Enabled = true;
TextBox25.Text = TextBox1.Text;
}
其Dropdown coading:
Its Dropdown coading:
else if(!Page.IsPostBack)
{
SqlConnection cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
string cm = ("select Name from AboutVennder");
SqlDataAdapter da = new SqlDataAdapter(cm,cn);
DataTable dt= new DataTable();
da.Fill(dt);
DropDownList7.DataSource = dt;
DropDownList7.DataBind();
DropDownList7.DataTextField = "Name";
DropDownList7.DataBind();
DropDownList7.Items.Add("Creat");
推荐答案
这篇关于如何解决此错误:对象引用未设置为对象的实例。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!