2023年6月21日发(作者：)
C#中SQL语句的参数写法MySql语句参数写法总结：数据库驱动有两种：mysql-connector-odbc和mysql-connector-net, 前者不⽀持参数，后者⽀持，这是我测试的结果；2.参数变量使⽤跟SqlServer⼀样，只需把@变为？， 如，mysql中写为：insert into test values (?id,?title,?type,now())";3.使⽤mysql-connector-net驱动很简单，到⽹上下载mysql-connector-net-5.2.3-src， 解压后，把添加到项⽬的bin⽂件夹即可使⽤；4.连接本机mysql数据库⽅法例⼦如下： string connStr = "server=localhost;user id=root; password=yourPassword;database=yourDatabase"; MySqlConnection conn = new MySqlConnection(connStr);下⾯附上测试通过的代码： string connStr = "server=localhost;user id=root; password=***; database=test"; MySqlConnection conn = new MySqlConnection(connStr); if (conn != null) (); else return;
string SQL_INSERT_TOPIC = "insert into test values (null,?title,?type,now())"; string PARM_TITLE = "?title"; string PARM_TYPE = "?type";
MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter(PARM_TITLE,r,80), new MySqlParameter(PARM_TYPE,r,1)
}; parms[0].Value = "welcome to beijing"; parms[1].Value = "C"; MySqlCommand cmd = new MySqlCommand(); tion = conn; dType = ; dText = SQL_INSERT_TOPIC; foreach (MySqlParameter pram in parms) (pram); eNonQuery(); ();
还可以这样写：MySqlParameter name = new MySqlParameter("?name", );(name);hValue("?sex", );C#中SQL语句参数写法leConnection oc=new OracleConnection("data source=osserver;User Id=****;password=**");OracleCommand cmd=new OracleCommand("insert into file (filename,filecontent) values (:filename,:filecontent)",oc);OracleParameter op1=new OracleParameter("filename",r,256);OracleParameter op2=new OracleParameter("filecontent",,);=eName();(op1);=filedata;(op2);();eNonQuery();();在ORACLE中，SQL语句参数是：+参数名，insert into file (filename,filecontent) values (:filename,:filecontent)在定义此参数的参数变量⾥⾯参数名不⽤写：OracleParameter op1=new OracleParameter("filename",r,256);
SqlConnection conn=new SqlConnection("data source=ccserver;user id=sa;password=****;initial catalog=cym1");SqlCommand cmd =new SqlCommand("insert into uploadfile (filename) values (@filename)",conn);SqlParameter sp=new SqlParameter("@filename",r,256);="";();eNonQuery();();在SQLSERVER中，SQL语句参数是@+参数名，insert into uploadfile (filename) values (@filename)在定义此参数的参数变量⾥⾯参数要写@SqlParameter sp=new SqlParameter("@filename",r,256); string id = "zawp"; string name = "wwwwwww"; string strCon = @"Data Source=(local);Integrated Security=SSPI;Initial Catalog =northwind"; // 直接在sql语句中写添加的参数名,这⾥没有做任何类型验证，在定义参数时需要准确的类型定义和长度设置 string delegeSql = "insert into Customers(CompanyName,CustomerID) values(@Name,@id)"; SqlConnection strConn = new SqlConnection(strCon); (); SqlDataAdapter thisAdapter = new SqlDataAdapter(delegeSql, strCon); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); ine(dText); SqlCommand strComm = new SqlCommand(delegeSql, strConn); //⽣成⼀个名字为@Id的参数,在这⾥必须要准确设定参数类型和类型长度，并且必须以@开头表⽰是添加的参数 //注意可以⽤⼀个SqlParameter对像来添加多个参数，并且这⾥的参数定义、添加可以不安照sql语句⾥参数值的顺序（如果是存储过程的话，要注意顺序） SqlParameter para = new SqlParameter("@id", , 5); = id; (para); para = new SqlParameter("@name", ar, 40); = name; (para); eNonQuery(); ();
2023年6月21日发(作者：)
C#中SQL语句的参数写法MySql语句参数写法总结：数据库驱动有两种：mysql-connector-odbc和mysql-connector-net, 前者不⽀持参数，后者⽀持，这是我测试的结果；2.参数变量使⽤跟SqlServer⼀样，只需把@变为？， 如，mysql中写为：insert into test values (?id,?title,?type,now())";3.使⽤mysql-connector-net驱动很简单，到⽹上下载mysql-connector-net-5.2.3-src， 解压后，把添加到项⽬的bin⽂件夹即可使⽤；4.连接本机mysql数据库⽅法例⼦如下： string connStr = "server=localhost;user id=root; password=yourPassword;database=yourDatabase"; MySqlConnection conn = new MySqlConnection(connStr);下⾯附上测试通过的代码： string connStr = "server=localhost;user id=root; password=***; database=test"; MySqlConnection conn = new MySqlConnection(connStr); if (conn != null) (); else return;
string SQL_INSERT_TOPIC = "insert into test values (null,?title,?type,now())"; string PARM_TITLE = "?title"; string PARM_TYPE = "?type";
MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter(PARM_TITLE,r,80), new MySqlParameter(PARM_TYPE,r,1)
}; parms[0].Value = "welcome to beijing"; parms[1].Value = "C"; MySqlCommand cmd = new MySqlCommand(); tion = conn; dType = ; dText = SQL_INSERT_TOPIC; foreach (MySqlParameter pram in parms) (pram); eNonQuery(); ();
还可以这样写：MySqlParameter name = new MySqlParameter("?name", );(name);hValue("?sex", );C#中SQL语句参数写法leConnection oc=new OracleConnection("data source=osserver;User Id=****;password=**");OracleCommand cmd=new OracleCommand("insert into file (filename,filecontent) values (:filename,:filecontent)",oc);OracleParameter op1=new OracleParameter("filename",r,256);OracleParameter op2=new OracleParameter("filecontent",,);=eName();(op1);=filedata;(op2);();eNonQuery();();在ORACLE中，SQL语句参数是：+参数名，insert into file (filename,filecontent) values (:filename,:filecontent)在定义此参数的参数变量⾥⾯参数名不⽤写：OracleParameter op1=new OracleParameter("filename",r,256);
SqlConnection conn=new SqlConnection("data source=ccserver;user id=sa;password=****;initial catalog=cym1");SqlCommand cmd =new SqlCommand("insert into uploadfile (filename) values (@filename)",conn);SqlParameter sp=new SqlParameter("@filename",r,256);="";();eNonQuery();();在SQLSERVER中，SQL语句参数是@+参数名，insert into uploadfile (filename) values (@filename)在定义此参数的参数变量⾥⾯参数要写@SqlParameter sp=new SqlParameter("@filename",r,256); string id = "zawp"; string name = "wwwwwww"; string strCon = @"Data Source=(local);Integrated Security=SSPI;Initial Catalog =northwind"; // 直接在sql语句中写添加的参数名,这⾥没有做任何类型验证，在定义参数时需要准确的类型定义和长度设置 string delegeSql = "insert into Customers(CompanyName,CustomerID) values(@Name,@id)"; SqlConnection strConn = new SqlConnection(strCon); (); SqlDataAdapter thisAdapter = new SqlDataAdapter(delegeSql, strCon); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); ine(dText); SqlCommand strComm = new SqlCommand(delegeSql, strConn); //⽣成⼀个名字为@Id的参数,在这⾥必须要准确设定参数类型和类型长度，并且必须以@开头表⽰是添加的参数 //注意可以⽤⼀个SqlParameter对像来添加多个参数，并且这⾥的参数定义、添加可以不安照sql语句⾥参数值的顺序（如果是存储过程的话，要注意顺序） SqlParameter para = new SqlParameter("@id", , 5); = id; (para); para = new SqlParameter("@name", ar, 40); = name; (para); eNonQuery(); ();
发布评论