Table.dbo对象？

Question

我正在尝试添加一个记录，但是我得到了一个异常。有什么想法吗？

    private void Form1_Load(object sender, EventArgs e)
    {
        string _connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
        string _query = "INSERT INTO Table1 VALUES ('MS','AH','BOSS')";
        DataSet _ds = new DataSet();

        try
        {

            using (SqlConnection _conn = new SqlConnection(_connStr))
            {
                SqlDataAdapter _da = new SqlDataAdapter(_query, _conn);
                _conn.Open();
                _da.Fill(_ds);
            }

            // insert null dataset or invalid return logic (too many tables, too few columns/rows, etc here. 


            if (_ds.Tables.Count == 1)
            { //There is a table, assign the name to it.
                MessageBox.Show("1");
                _ds.Tables[0].TableName = "Table1";
            }

            //Then work with your tblWorkers 
            MessageBox.Show(_ds.ToString());
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
            Console.Write("An error occurred: {0}", ex.Message);
        } 
    }

如何向表中添加记录？？数据类型为nchar

Answer 1

试试这个：

    string _connStr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
    string _query = "INSERT INTO Table1 VALUES ('MS','AH','BOSS')";

    using (SqlConnection _conn = new SqlConnection(_connStr))
    {
        SqlCommand _com = _conn.CreateCommand();
        _conn.Open();
        _com.CommandText = _query;
        _com.ExecuteNonQuery();
    }

一般而言：

• SqlDataAdapter (和DataSet.Fill方法)用于在第一轮读取数据(并更新加载的数据集，以防您更改它)。Read MSDN on this subject
• SqlCommand用于执行

的sql查询

Answer 2

此外，只有在表中有3个字段时，INSERT命令才有效。如果有三个以上的字段，则需要显式声明要将这些值插入到哪三个字段中。

INSERT INTO TableName (Field1, Field2, Field3) VALUES ('MS','AH','BOSS')