使用c#将文本框值插入到sql server中

本文关键字：sql server 插入 文本 使用 | 更新日期: 2023-09-27 18:01:17

我需要向SQL Server数据库表添加一个文本框值。以下是我的代码：

private void button1_Click(object sender, EventArgs e)
{
    string str = "Data Source=.''SQLEXPRESS;AttachDbFilename=|DataDirectory|''timetablesystem.mdf;Integrated Security=True;User Instance=True";
    SqlConnection con = new SqlConnection(str);
    string qry = "insert into SubjectMaster (SubjectName) values (@TxtSubjectName)";
    con.Open();
    SqlCommand cmd = new SqlCommand(qry, con);
    cmd.CommandType = CommandType.Text;
    cmd.Parameters.AddWithValue("@TxtSubjectName", TxtSubjectName.Text);
    cmd.ExecuteNonQuery();
    MessageBox.Show("Added Successfully!!");
    con.Close();
}

但是，数据不应该添加到表中。。。请帮帮我。。。谢谢你的帮助。。。

使用c#将文本框值插入到sql server中

如果查询有效，请先尝试调试它。我认为您与数据库的连接不起作用。

string str = "Data Source=.''SQLEXPRESS;AttachDbFilename=|DataDirectory|''timetablesystem.mdf;Integrated Security=True;User Instance=True";

应该有这个吗在数据源Data Source=.''SQLEXPRESS 之后

试试这个，告诉我什么是消息信息内容

private void button1_Click(object sender, EventArgs e)
{
    string str = "Server=.'SQLEXPRESS;Database=TestDB;Trusted_Connection=True;";
    using( SqlConnection con = new SqlConnection(str)){
                            try{
                                con.Open();
                                string qry = "insert into SubjectMaster (SubjectName) values (@TxtSubjectName)";
                                SqlCommand cmd = new SqlCommand(qry, con);
                                cmd.CommandType = CommandType.Text;
                                cmd.Parameters.AddWithValue("@TxtSubjectName", TxtSubjectName.Text);
                                cmd.ExecuteNonQuery();
                                MessageBox.Show("Added Successfully!!");
                               }
                          catch{
                                MessageBox.Show("connection is failed!!");
                               }
                                                       }
}

尝试这个

     SqlConnection con = new SqlConnection(@"Data Source=SL-20'SQLEXPRESS;Initial   Catalog=TestDB;User ID=sa;Password=sl123;");
        string query = " insert into name(name)values('" + TextboxTest.Text + "')";
        con.Open();
        SqlCommand cmd = new SqlCommand(query, con);
        cmd.ExecuteNonQuery();
        con.Close();
相关文章：