سوال و جواب ها با برچسب sqlconnection

  
 namespace WindowsFormsApplication1  
 {  
 public partial class Form1 : Form  
  
 {  
 SqlConnection my_cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\DATA\\sql 2014 student1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");  
  
 SqlCommand my_cm = new SqlCommand();  
  
 public Form1()  
 {  
 InitializeComponent();  
 }  
  
 private void Form1_Load(object sender, EventArgs e)  
 {  
 textBox1.Focus();  
 }  
  
 private void button1_Click(object sender, EventArgs e)  
 {  
  
 if (radioButton1.Checked)  
 {  
 string s;  
 s = "insert into p1 (code,name,family,bed)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
  
  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
  
 }  
  
  
 else  
 {  
 string s;  
 s = "insert into p1 (code,name,family,best)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
 }  
  
 }  
 }  
 } 

  
 namespace WindowsFormsApplication1  
 {  
 public partial class Form1 : Form  
  
 {  
 SqlConnection my_cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\DATA\\sql 2014 student1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");  
  
 SqlCommand my_cm = new SqlCommand();  
  
 public Form1()  
 {  
 InitializeComponent();  
 }  
  
 private void Form1_Load(object sender, EventArgs e)  
 {  
 textBox1.Focus();  
 }  
  
 private void button1_Click(object sender, EventArgs e)  
 {  
  
 if (radioButton1.Checked)  
 {  
 string s;  
 s = "insert into p1 (code,name,family,bed)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
  
  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
  
 }  
  
  
 else  
 {  
 string s;  
 s = "insert into p1 (code,name,family,best)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
 }  
  
 }  
 }  
 } 

  
 namespace WindowsFormsApplication1  
 {  
 public partial class Form1 : Form  
  
 {  
 SqlConnection my_cn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Program Files\\Microsoft SQL Server\\MSSQL10.SQLEXPRESS\\MSSQL\\DATA\\sql 2014 student1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");  
  
 SqlCommand my_cm = new SqlCommand();  
  
 public Form1()  
 {  
 InitializeComponent();  
 }  
  
 private void Form1_Load(object sender, EventArgs e)  
 {  
 textBox1.Focus();  
 }  
  
 private void button1_Click(object sender, EventArgs e)  
 {  
  
 if (radioButton1.Checked)  
 {  
 string s;  
 s = "insert into p1 (code,name,family,bed)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
  
  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
  
 }  
  
  
 else  
 {  
 string s;  
 s = "insert into p1 (code,name,family,best)) values('" + Int32.Parse(maskedTextBox1.Text) + "','" + textBox1.Text + "','" + textBox2.Text + "','" + Int32.Parse(maskedTextBox2.Text) + "'";  
 my_cm.CommandText = s;  
 my_cm.Connection = my_cn;  
 my_cn.Open();  
 my_cm.ExecuteNonQuery();  
 }  
  
 }  
 }  
 }