SqlConnection myConnection = new SqlConnection ("Data Source=localhost;Initial Catalog=AutoLot;Integrated Security=True;Pooling=False
");
SqlCommand myCommand = new SqlCommand("INSERT INTO [hello] ([hello]) VALUES (@hello)", myConnection);
SqlParameter helloParam = myCommand.Parameters.Add("@hello", SqlDbType.VarChar );
helloParam.Value = MyTextBox.Text;
myConnection.Open();
myCommand.ExecuteNonQuery();
ReplyQuote
이것때문에 한참 고생하다가 겨우... 찾았다
visual studio 2010 의 서버 익스플로러에서 데이타 커넥션 메뉴에 db를 띄워놓고
클릭하면 오른쪽 아래 속성창에
이런식으로 나온다.저 부분을 커넥션 스트링에다가 그냥 대입하면 된다.
문자열을 어떻게 넣어야될지 몰라서 고생했다면... 이렇게 하는것도 좋을듯... 한참고생했네
/**처음에 썼다가 안되서 이것저것 덕지덕지 붙여가지고 소스가 너무 더러워졌다. 엄청난 노가다 소스를 제작했다가 실패한부분
////SQL입력,.. 입력할게 너무 많아서 이걸로 못해먹겠다 해결방법은 스트링에 반복문 합체하기로 해서 입력하면 될듯하다.
string cnStr ="Data Source=localhost;Initial Catalog=AutoLot;Integrated Security=True;Pooling=False";
string connectionString =//"Source=localhost;Initial Catalog=StockPrice;Persist Security Info=True;User ID=아이디;Password=비번";
"Data Source=MSSQLSERVER; Integrated Security=SSPI;Initial Catalog=StockPrice;connection timeout=5";
/** "user id=아이디;" +
"password=비밀번호;
server=localhost;" +
"Trusted_Connection=yes;" +
"database=StockPrice; " +
"connection timeout=5";**/
// Create a connection string via the builder object.
/**
SqlConnectionStringBuilder cnStrBuilder = new SqlConnectionStringBuilder();
cnStrBuilder.InitialCatalog = "StockPrice";
cnStrBuilder.DataSource = "localhost";
cnStrBuilder.ConnectTimeout = 10;
cnStrBuilder.IntegratedSecurity = true;
**/
string connectionString = "Data Source=localhost;Initial Catalog=AutoLot;Integrated Security=True;Pooling=False";
SqlConnection sqlCn = new SqlConnection();
sqlCn = new SqlConnection();
sqlCn.ConnectionString = connectionString;
//sqlCn.ConnectionString = cnStrBuilder.ConnectionString;
sqlCn.Open();
// Format and execute SQL statement.
string sql = string.Format("Insert Into FutureHoga" +
"(date, hotime, sametime, futcode, offerho1, offerho2, offerho3, offerho4, offerho5, bidho1, bidho2, bidho3, bidho4, bidho5, offerrem1, offerrem2, offerrem3, offerrem4, offerrem5, bidrem1, bidrem2, bidrem3, bidrem4, bidrem5, offercnt1,offercnt2,offercnt3,offercnt4,offercnt5, bidcnt1,bidcnt2,bidcnt3,bidcnt4,bidcnt5,totofferrem,totofferrem,totoffercnt,totobidcnt" +
"('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}', '{24}', '{25}', '{26}', '{27}', '{28}', '{29}', '{30}', '{31}', '{32}', '{33}', '{34}', '{35}', '{36}', '{37}', '{38}')",
DateTime.Now.Date,
m_RealFH0[i].GetFieldData("OutBlock", "hotime"),
(sametime++),
m_RealFH0[i].GetFieldData("OutBlock", "futcode"),
m_RealFH0[i].GetFieldData("OutBlock", "offerho1"),
m_RealFH0[i].GetFieldData("OutBlock", "offerho2"),
m_RealFH0[i].GetFieldData("OutBlock", "offerho3"),
m_RealFH0[i].GetFieldData("OutBlock", "offerho4"),
m_RealFH0[i].GetFieldData("OutBlock", "offerho5"),
m_RealFH0[i].GetFieldData("OutBlock", "bidho1"),
m_RealFH0[i].GetFieldData("OutBlock", "bidho2"),
m_RealFH0[i].GetFieldData("OutBlock", "bidho3"),
m_RealFH0[i].GetFieldData("OutBlock", "bidho4"),
m_RealFH0[i].GetFieldData("OutBlock", "bidho5"),
m_RealFH0[i].GetFieldData("OutBlock", "offerrem1"),
m_RealFH0[i].GetFieldData("OutBlock", "offerrem2"),
m_RealFH0[i].GetFieldData("OutBlock", "offerrem3"),
m_RealFH0[i].GetFieldData("OutBlock", "offerrem4"),
m_RealFH0[i].GetFieldData("OutBlock", "offerrem5"),
m_RealFH0[i].GetFieldData("OutBlock", "bidrem1"),
m_RealFH0[i].GetFieldData("OutBlock", "bidrem2"),
m_RealFH0[i].GetFieldData("OutBlock", "bidrem3"),
m_RealFH0[i].GetFieldData("OutBlock", "bidrem4"),
m_RealFH0[i].GetFieldData("OutBlock", "bidrem5"),
m_RealFH0[i].GetFieldData("OutBlock", "offercnt1"),
m_RealFH0[i].GetFieldData("OutBlock", "offercnt2"),
m_RealFH0[i].GetFieldData("OutBlock", "offercnt3"),
m_RealFH0[i].GetFieldData("OutBlock", "offercnt4"),
m_RealFH0[i].GetFieldData("OutBlock", "offercnt5"),
m_RealFH0[i].GetFieldData("OutBlock", "bidcnt1"),
m_RealFH0[i].GetFieldData("OutBlock", "bidcnt2"),
m_RealFH0[i].GetFieldData("OutBlock", "bidcnt3"),
m_RealFH0[i].GetFieldData("OutBlock", "bidcnt4"),
m_RealFH0[i].GetFieldData("OutBlock", "bidcnt5"),
m_RealFH0[i].GetFieldData("OutBlock", "totofferrem"),
m_RealFH0[i].GetFieldData("OutBlock", "totofferrem"),
m_RealFH0[i].GetFieldData("OutBlock", "totoffercnt"),
m_RealFH0[i].GetFieldData("OutBlock", "totobidcnt"));
// Execute using our connection.
using (SqlCommand cmd = new SqlCommand(sql, this.sqlCn))
{
cmd.ExecuteNonQuery();
}
sqlCn.Close();//SQL닫기