user_id=request.params("user_id") user_pw=request.params("user_pw")sub page_load(S As Object, E As EventArgs) dim conusers as sqlconnection dim sql as string dim rs as sqlcommand conusers=new sqlconnection("server=localhost;uid=sa;database=TDDB") sql="insert users(user_id,user_pw) values(@user_id,@user_pw)" rs=new sqlcommand(sql,concargo) rs.parameters.add("@user_id",user_id) rs.parameters.add("@user_pw",user_pw) conusers.open() rs.executenonquery() conusers.close() end sub修改一下就行啦!
user_pw=request.params("user_pw")sub page_load(S As Object, E As EventArgs)
dim conusers as sqlconnection
dim sql as string
dim rs as sqlcommand
conusers=new sqlconnection("server=localhost;uid=sa;database=TDDB")
sql="insert users(user_id,user_pw) values(@user_id,@user_pw)"
rs=new sqlcommand(sql,concargo)
rs.parameters.add("@user_id",user_id)
rs.parameters.add("@user_pw",user_pw)
conusers.open()
rs.executenonquery()
conusers.close()
end sub修改一下就行啦!
void onclick_btn(Object sender,EventArgs e)
{
String str,text_value;
str="insert into users('id','text') values(default,@value)";
OleDbConnection MyConnection=new OleDbConnection("server=localhost;uid=sa;database=text");
OleDbCommand MyCommand=new OleDbCommand(str,MyConnection);
MyConnection.Open();
MyCommand.parameters.add("@value",textbox1.text);
OleDbDataReader MyReader=MyCommand.ExecuteReader();
MyConnection.Close();
}