Advertisement
Guest User

Control baza de date

a guest
Jul 28th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.58 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using System.Data.Sql;
  11. using System.Data.SqlClient;
  12.  
  13. namespace Arsobyc_DataBase_Control
  14. {
  15.     public partial class Form1 : Form
  16.     {
  17.         SqlCommand cmd;
  18.         SqlConnection con;
  19.         private SqlDataAdapter da;
  20.  
  21.         public Form1()
  22.         {
  23.             InitializeComponent();
  24.         }
  25.  
  26.         private void label2_Click(object sender, EventArgs e)
  27.         {
  28.  
  29.         }
  30.  
  31.         private void label4_Click(object sender, EventArgs e)
  32.         {
  33.  
  34.         }
  35.  
  36.         private void label3_Click(object sender, EventArgs e)
  37.         {
  38.  
  39.         }
  40.  
  41.         private void Form1_Load(object sender, EventArgs e)
  42.         {
  43.             // TODO: This line of code loads data into the 'u181542750_arsobDataSet.Archers' table. You can move, or remove it, as needed.
  44.             this.archersTableAdapter.Fill(this.u181542750_arsobDataSet.Archers);
  45.  
  46.         }
  47.  
  48.         private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
  49.         {
  50.  
  51.         }
  52.  
  53.         private void button1_Click(object sender, EventArgs e)
  54.         {
  55.             SqlConnection con = new SqlConnection("Data Source=sql34.main-hosting.eu;Initial Catalog=u181542750_arsob;Integrated Security=True");
  56.             con.Open();
  57.             cmd = new SqlCommand("INSERT INFO Archers (Nume,Prenume,Varsta,Sex,Categorie,E-mail,Telefon,CNP) VALUES (@Nume,@Prenume,@Varsta,@Sex,@Categorie,@E-mail,@Telefon,@CNP)", con);
  58.             cmd.Parameters.AddWithValue("@Nume", textBox1.Text);
  59.             cmd.Parameters.AddWithValue("@Prenume", textBox2.Text);
  60.             cmd.Parameters.AddWithValue("@Varsta", textBox3.Text);
  61.             cmd.Parameters.AddWithValue("@Sex", comboBox1.SelectedItem.ToString());
  62.             cmd.Parameters.AddWithValue("@Categorie", comboBox2.SelectedItem.ToString());
  63.             cmd.Parameters.AddWithValue("@E-mail", textBox4.Text);
  64.             cmd.Parameters.AddWithValue("@Telefon", textBox5.Text);
  65.             cmd.Parameters.AddWithValue("@CNP", textBox6.Text);
  66.             cmd.ExecuteNonQuery();
  67.         }
  68.  
  69.         private void button3_Click(object sender, EventArgs e)
  70.         {
  71.            
  72.         }
  73.  
  74.         private void button2_Click(object sender, EventArgs e)
  75.         {
  76.            
  77.         }
  78.  
  79.         private void archersBindingSource_CurrentChanged(object sender, EventArgs e)
  80.         {
  81.            
  82.         }
  83.     }
  84. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement