vs2010连接数据库部分程序

                   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();

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值