본문 바로가기

C#

[C#] DB연결 SQLConnection

반응형

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

'C#' 카테고리의 다른 글

[C#] Form 호출  (0) 2021.02.16
[C#] Invoke, InvokeRequired  (0) 2021.02.16
[C#] KeyPress / KeyDown 이벤트 (Enter 입력)  (0) 2021.02.16
[C#] 폼의 X버튼 클릭시 확인 메세지 생성  (0) 2021.02.16
[C#] textbox값 전송 (속성)  (0) 2019.12.04