saeedhushmand
یک شنبه 08 مرداد 1391, 13:49 عصر
فرق کوئری که با dataset به راحتی می شه ایجاد کرد با کم ترین کد نویسی با کوئری زیر چیه...
SqlConnection myConn;
SqlCommand myComm;
SqlDataReader myDR;
StrConn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\AnbarDari.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
StrQury = "Delete Kala Where Name=N'" + textBox1.Text + "'";
myConn = newSqlConnection(StrConn);
myComm = newSqlCommand();
myComm.Connection = myConn;
myComm.CommandType = CommandType.Text;
myComm.CommandText = StrQury;
myConn.Open();
myComm.ExecuteNonQuery();
myDR = myComm.ExecuteReader();
SqlConnection myConn;
SqlCommand myComm;
SqlDataReader myDR;
StrConn = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\AnbarDari.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
StrQury = "Delete Kala Where Name=N'" + textBox1.Text + "'";
myConn = newSqlConnection(StrConn);
myComm = newSqlCommand();
myComm.Connection = myConn;
myComm.CommandType = CommandType.Text;
myComm.CommandText = StrQury;
myConn.Open();
myComm.ExecuteNonQuery();
myDR = myComm.ExecuteReader();