.net 动态sql 参数应用 oracle和sql server的比较

oracle:

OracleConnection Ocon = new OracleConnection("user id=cmes;data source=mes;password=cmes");

OracleCommand Ocom = new OracleCommand("insert into c_emp_t (emp_id,emp_no,emp_name,emp_password,emp_desc,used_date,change_date,logout_date,logout_flag)values(:emp_id,:emp_no,:emp_name,:emp_password,:emp_desc,sysdate,sysdate,null,'0')",Ocon);

Ocom.Parameters.Add(new OracleParameter("emp_id","Number"));

Ocom.Parameters.Add(new OracleParameter("emp_no","VarChar"));

Ocom.Parameters.Add(new OracleParameter("emp_name","VarChar"));

Ocom.Parameters.Add(new OracleParameter("emp_password","VarChar"));

Ocom.Parameters.Add(new OracleParameter("emp_desc","VarChar"));

Ocom.Parameters["emp_id"].Value = int.Parse(TextBox1.Text);

Ocom.Parameters["emp_no"].Value = TextBox1.Text;

Ocom.Parameters["emp_name"].Value = TextBox1.Text;

Ocom.Parameters["emp_password"].Value = TextBox1.Text;

Ocom.Parameters["emp_desc"].Value = TextBox1.Text;

Ocon.Open();

Ocom.ExecuteNonQuery();

Ocon.Close();

sql server

SqlConnection Mcon = new SqlConnection("workstation id=LIWULI;packet size=4096;user id=sa;password=sa;data source=\"192.168.200.156\";persist security info=False;initial catalog=mcms");

SqlCommand Mcom = new SqlCommand("Insert into userinfo (userid,username,password) values(@userid,@username,@password)",Mcon);

Mcom.Parameters.Add(new SqlParameter("@userid","interger"));

Mcom.Parameters.Add(new SqlParameter("@username","VarChar"));

Mcom.Parameters.Add(new SqlParameter("@password","VarChar"));

Mcom.Parameters["@userid"].Value = int.Parse(TextBox1.Text);

Mcom.Parameters["@username"].Value = TextBox1.Text;

Mcom.Parameters["@password"].Value = TextBox1.Text;

Mcon.Open();

Mcom.ExecuteNonQuery();

Mcon.Close();