vs2010连接数据库部分程序

来源：互联网发布：苹果5支持联通4g网络吗编辑：程序博客网时间：2024/05/16 15:01

                   SqlConnection cnn = new SqlConnection();
                    cnn.ConnectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
                    /// SqlCommand cmm = new SqlCommand();
                    SqlCommand cmm = new SqlCommand("Insert Into Table1(dd) Values(@dd)", cnn);
                    /// cmm.Connection = cnn;
                    cnn.Open();
                    ///cmm.CommandText = "Insert Into t0522(type)" + "Values(@type)";
                    ///cmm.Parameters.Add("@type", System.Data.SqlDbType.NVarChar).Value=L1.Text; ///这种也是加参数的方式，只是下面一种更加简洁
                    // cmm.Parameters.AddWithValue("@id", 50);
                    cmm.Parameters.AddWithValue("@dd", "happy");
                    //cmm.Parameters.AddWithValue("@err_message", str[ERR_NUM]);
                    ///cmm.Parameters["@type"].Value = L1.Text;
                    ///cmm.ExecuteNonQuery();
                    int s = cmm.ExecuteNonQuery();

//以下这几句是用于在dataGridView中显示数据库中的全部数据

                    SqlDataAdapter adp = new SqlDataAdapter("select id,dd From Table1", cnn);
                    DataTable dt = new DataTable();
                    adp.Fill(dt);
                    GridView1.DataSource = dt.DefaultView;

                    if (s > 0)
                    {
                        MessageBox.Show("数据上传成功");
                    }
                    else
                    {
                        MessageBox.Show("数据更新失败");
                    }

cnn.Close();