7,765
社区成员
发帖
与我相关
我的任务
分享
sql server数据库_修改
using System.Data.SqlClient;
修改
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strUpdate = "Update wd_index set wd_name=@a1,wd_lx2=@a2,wd_zy=@a3 Where wd_id=@ID";
SqlCommand cmdUpdate = new SqlCommand( strUpdate, MyConnection );
cmdUpdate.Parameters.Add( "@a1",TextBox1.Text );
cmdUpdate.Parameters.Add( "@a2",DropDownList1.SelectedItem.Text );
cmdUpdate.Parameters.Add( "@a3",FreeTextBox1.Text);
cmdUpdate.Parameters.Add( "@ID",Request.QueryString["wd_id"] );
MyConnection.Open();
int intUpdateCount = cmdUpdate.ExecuteNonQuery();
MyConnection.Close();
string js=@"<script language=javascript>alert('修改成功!')</";
js+="script>";
Page.RegisterStartupScript("kkk1",js);
sql server数据库_显示数据
using System.Data.SqlClient;
显示数据
if(!IsPostBack)
{
dd1();
}
private void dd1()
{
SqlConnection MyConnection1 = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strSel2 = "select * from wd_lx where wd_lx=@Id";
SqlCommand myCommand = new SqlCommand(strSel2,MyConnection1);
myCommand.Parameters.Add(new SqlParameter("@Id",111));
myCommand.Parameters["@Id"].Value = DropDownList1.SelectedItem.Text;
MyConnection1.Open();
SqlDataReader cccc = myCommand.ExecuteReader( CommandBehavior.SingleRow );
if ( cccc.Read() )
{
Label1.Text = cccc[ "wd_id" ].ToString();
}
cccc .Close();
MyConnection1.Close();
}
//删除
private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
SqlConnection MyConnection = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
String deleteCmd = "DELETE from wd_sp where sp_id = @Id";
SqlCommand myCommand = new SqlCommand(deleteCmd, MyConnection);
myCommand.Parameters.Add(new SqlParameter("@Id", 115));
myCommand.Parameters["@Id"].Value = DataGrid1.DataKeys[(int)e.Item.ItemIndex];
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
Response.Redirect("wz_hy_lx.aspx");
}
添加
SqlConnection myConn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["connectionString"]);
string strInsert = "Insert Into rc_xzzw (zw_1,zw_2,zw_3,hy_name) Values (@T1,@T2,@T3,@T4)";
SqlCommand cmdInsert = new SqlCommand( strInsert, myConn );
cmdInsert.Parameters.Add(new SqlParameter("@T1", 1150));
cmdInsert.Parameters["@T1"].Value =TextBox1.Text ;
cmdInsert.Parameters.Add(new SqlParameter("@T2", 1150));
cmdInsert.Parameters["@T2"].Value = TextBox2.Text ;
cmdInsert.Parameters.Add(new SqlParameter("@T3", 5150));
cmdInsert.Parameters["@T3"].Value = RadioButtonList1.SelectedItem.Text ;
cmdInsert.Parameters.Add(new SqlParameter("@T4", 51150));
cmdInsert.Parameters["@T4"].Value =Session["user_name_huiyuan"];
myConn.Open();
cmdInsert.ExecuteNonQuery();
myConn.Close();
string js=@"<script language=javascript>alert('添加成功!')</";
js+="script>";
Page.RegisterStartupScript("kkk2",js);