c#关于数据库SQL的

[zzmmtt206]

怎么用C#作为前台给数据库的表中添加信息？

[CPlusPlusFans]

使用ADO.NET
包括Connection用于连接
Command用于执行Sql语句
ResultSet用于操作结果集
还有其他高级的DataSet,DataTable等

[zhuanshen712]

ado.net

[hongqi162]

OleDbConnection conn = new OleDbConnection(DAL.dbConnection); 
OleDbCommand comm = new OleDbCommand(); 
comm.Connection = conn; 
comm.CommandType = CommandType.Text; 
comm.CommandText = "insert into mem_mas( MemName,RealName,[Password],Sex,GroupID,GroupName,Company,Address,ZipCode,Telephone,Fax,Mobile,Email,HomePage,Working) values(@MemName,@RealName,@Password,@Sex,@GroupID,@GroupName,@Company,@Address,@ZipCode,@Telephone,@Fax,@Mobile,@Email,@HomePage,@Working)"; 
cmd.Parameters.AddWithValue("@MemName", this.MemName.Text); 
cmd.Parameters.AddWithValue("@RealName", this.RealName.Text); 
cmd.Parameters.AddWithValue("@Password", this.Password.Text); 
cmd.Parameters.AddWithValue("@Sex", this.getSex()); 
cmd.Parameters.AddWithValue("@GroupID", this.GroupID.SelectedValue); 
cmd.Parameters.AddWithValue("@GroupName", this.getGroupNameSi()); 
cmd.Parameters.AddWithValue("@Company", this.Company.Text); 
cmd.Parameters.AddWithValue("@Address", this.Address.Text); 
cmd.Parameters.AddWithValue("@ZipCode", this.ZipCode.Text); 
cmd.Parameters.AddWithValue("@Telephone", this.Telephone.Text); 
cmd.Parameters.AddWithValue("@Fax", this.Fax.Text); 
cmd.Parameters.AddWithValue("@Mobile", this.Mobile.Text); 
cmd.Parameters.AddWithValue("@Email", this.Email.Text); 
cmd.Parameters.AddWithValue("@HomePage", this.HomePage.Text); 
cmd.Parameters.AddWithValue("@Working", this.ViewFlagSi.Checked); 
conn.Open(); 
comm.ExecuteNonQuery(); 

[hechenqingtian]

数据库DB
表 student
字段： id，name，sex，address
id 自动增长

string sql="insert into student values (@name,@sex,@address)";
string query="server=.;database=DB;Integrated Security=true";
SqlConnection con=new SqlConnection(query);
con.open();
SqlCommand command=new SqlCommand(sql,con);
SqlParameter [] param=new SqlParameter[]{
new SqlParameter("@name",this.txtName.Text),
new SqlParameter("@sex",this.txtSex.Text),
new SqlParameter("@address",this.txtAddress.Text),
};
foreach (SqlParameter p in param)
{
command.Parameters.Add(p);
}
command.ExecuteQuery();

[jiang_jiajia10]

protected void btnSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DBConnectionString"]);
        SqlCommand insertCmd = new SqlCommand("insert into AddressLists(userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdEmail,frdQQ) values(@userId,@Name,@Phone,@MobilePhone,@Address,@Email,@QQ)", conn);
        insertCmd.Parameters.Add("@userId", SqlDbType.VarChar, 15);        
        insertCmd.Parameters.Add("@Name", SqlDbType.VarChar, 10);        
        insertCmd.Parameters.Add("@Phone", SqlDbType.VarChar, 15);
        insertCmd.Parameters.Add("@MobilePhone", SqlDbType.VarChar, 11);        
        insertCmd.Parameters.Add("@Address", SqlDbType.VarChar, 200);
        insertCmd.Parameters.Add("@Email", SqlDbType.VarChar, 50);
        insertCmd.Parameters.Add("@QQ", SqlDbType.VarChar, 15);
        insertCmd.Parameters["@userId"].Value = Session["userID"].ToString();
        insertCmd.Parameters["@Name"].Value = txtName.Text;
        insertCmd.Parameters["@Phone"].Value = txtUtel2.Text;
        insertCmd.Parameters["@MobilePhone"].Value = txtUtel3.Text;        
        insertCmd.Parameters["@Address"].Value = txtUaddr.Text;
        insertCmd.Parameters["@Email"].Value = txtUemail.Text;
        insertCmd.Parameters["@QQ"].Value = txtUQQ.Text;
        try
        {
            conn.Open();
            int flag = insertCmd.ExecuteNonQuery();
            if (flag > 0)
            {
                Response.Write("<script language=javascript>alert('成功添加好友记录！')</script>");
            }
            else
            {
                Response.Write("<script language=javascript>alert('添加好友记录失败，查看输入是否正确！')</script>");
            }
        }
        catch (System.Exception ee)
        {
            Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
        }
        finally
        {
            conn.Close();
        }
    }

[yistudio]

基础性的东西，先找本书来看看

[crowzwong]

     string sql_insert = "insert into tb_Customer(allName,shortName,Contacts,Post,telphone,address,faxNum,website,eMail,bankNum) values('" + tbx公司名.Text.Trim() + "','" + tbx简称.Text.Trim() + "','" + tbx联络代表.Text.Trim() + "','" + tbx职称.Text.Trim() + "','" + tbx电话.Text + "','" + tbx地址.Text + "','" + tbx传真.Text + "','" + tbx网站.Text.Trim() + "','" + tbx电邮.Text.Trim() + "','" + tbx支付账号.Text + "')";
               
                if (MessageBox.Show("再次确认数据", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
                {
                    sql_class.RunSql(sql_insert);
                    MessageBox.Show("新客户资料录入完毕","提示");
                }

[oec2003]

参考

[benyouyong]

雷倒！
楼主真懒！

[码YouMe]

Coomand对象的ExecuteNonQuery()方法，执行Insert操作。。。

[love__kongjiang]

找本书看数据库连接部分