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();
반응형