private void Add_Button1_Click(object sender, System.EventArgs e)
{
string StrConn="server=dz;database=xx;uid=sa;pwd=;pooling=true;";
SqlConnection myConnection = new SqlConnection(StrConn);
myConnection.Open();
string StrSql="insert into G_Book (G_User,G_Sex,G_Age,G_From,G_Email,G_Oicq,G_Home,G_Title,G_Body) values ('"+user_text+"','"+sex_text+"','"+age_text+"','"+from_text+"','"+email_text+"','"+oicq_text+"','"+home_text+"','"+title_text+"','"+body_text+"')";
SqlCommand StrCmd = new SqlCommand(StrSql,myConnection); try
{
StrCmd.ExecuteNonQuery();
myConnection.Close();
Response.Write("添加成功!");
}
catch(SqlException err)
{
Response.Write("错误提示:"+err.Message);
}
}