C#
[C#] DB연결 SQLConnection
키플레이어
2021. 2. 16. 14:18
반응형

SqlConn = new SqlConnection("server=localhost;uid=sa;pwd=ssss; database=OurI");
SqlConn.Open();
string Sqlstr = "select Password from Login where Id = " + "'" + Form_Login.LoginID + "'";
SqlComm = new SqlCommand(Sqlstr, SqlConn);
SqlConn = new SqlConnection("server=localhost;uid=sa;pwd=ssss;database=OurI");
SqlConn.Open();
string Sqlstr = "Insert Login values('" + Form_UserCreate.CreateName + "','"
+ Form_UserCreate.CreateID+ "','"
+ Form_UserCreate.CreatePassword + "','"
+ Form_UserCreate.CreateRePassword + "','"
+ Form_UserCreate.PersonNum1 + "','"
+ Form_UserCreate.PersonNum2 + "','"
+ Form_UserCreate.CreateAddress + "','"
+ Form_UserCreate.CreateTel + "','"
+ Form_UserCreate.CreateEmail + "','"
+ Form_UserCreate.Woman + "','"
+ Form_UserCreate.Man + "','"
+ Form_UserCreate.PBirth + "','"
+ Form_UserCreate.CBirth + "')";
SqlComm = new SqlCommand(Sqlstr, SqlConn);
SqlComm.ExecuteNonQuery();반응형