Question

在C#中在前台的文本框中添加一条信息，使之保存到SQLserver数据库表中，怎样实现？

主要写清楚所实现的代码。
但是我不会啊，所以再次请教！

Answer 1

SqlDataAdapter da = new SqlDataAdapter();
//创建连接对象
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=服务器名;Initial Catalog=初始化的数据库名;User ID=sa;Password=密码;
//创建查询命令对象
SqlCommand selectCmd = new SqlCommand();
selectCmd.CommandText = "select * from Books";
selectCmd.Connection = conn;

//创建添加数据的命令对象
SqlCommand insertCmd = new SqlCommand();
insertCmd.CommandText = "insert into Books values(@BookName,@Author,@Publisher,@UnitPrice,@Discount,@BookImageFileName)";
insertCmd.Connection = conn;
//向插入命令添加参数
insertCmd.Parameters.Add("@BookName",SqlDbType.NVarChar,50, "BookName");
insertCmd.Parameters.Add("@Author", SqlDbType.NVarChar, 50, "Author");
insertCmd.Parameters.Add("@Publisher",SqlDbType.NVarChar,50, "Publisher");
insertCmd.Parameters.Add("@UnitPrice", SqlDbType.Money, 8, "UnitPrice");
insertCmd.Parameters.Add("@Discount", SqlDbType.NVarChar, 8, "Discount");
insertCmd.Parameters.Add("@BookImageFileName", SqlDbType.NVarChar, 50, "BookImageFileName");

da.SelectCommand = selectCmd;
da.InsertCommand = insertCmd;
//创建数据集对象
DataSet data = new DataSet();
//使用数据适配器填充数据适配器
da.Fill(data, "Books");

//向DataSet的“Books”表中添加一条记录
DataRow drNew=data.Tables["Books"].NewRow();
//设置新添加行的值
drNew["BookName"] = txtBookName.Text;-----文本框的内容
drNew["Author"] = txtAuthor.Text;
drNew[3] = txtPublishName.Text;
drNew[4] = txtPrice.Text;
drNew[5] = txtDiscount.Text;
drNew[6] = txtFileName.Text;
//向表中添加行
data.Tables["Books"].Rows.Add(drNew);
//将数据通过数据适配器更新到数据库中
da.Update(data, "Books");

把这些写在一个按钮事件里面 就可以了

Answer 2

简单示例下
Test.aspx.cs:
按钮提交事件(非空,格式均不判断):
TestMange.Update(this.lblId.Text,this.txtName.Text);

TestManage.cs:
public static void Update(string id,string name)
{
TestService.Update(id,name);
}

TestService.cs:
public static void Update(string id,string name)
{
string sql = "update user set name='"+name+"' where id="+id;//更新语句
try
{
string sqlConnection = "Data Source=localhost;Initial Catalog=test;Integrated Security=True";
SqlConnection conn = new SqlConnection(sqlConnection);
SqlCommand objSqlCommand = new SqlCommand(sql,conn);
objSqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}

Answer 3

这样的任何一个程序都应该有的

Answer 4

不是很理解你的意思

insert into table values()

Answer 5

用sqlhelper