Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using System.Data.Sql;
- using System.Data.SqlClient;
- namespace Arsobyc_DataBase_Control
- {
- public partial class Form1 : Form
- {
- SqlCommand cmd;
- SqlConnection con;
- private SqlDataAdapter da;
- public Form1()
- {
- InitializeComponent();
- }
- private void label2_Click(object sender, EventArgs e)
- {
- }
- private void label4_Click(object sender, EventArgs e)
- {
- }
- private void label3_Click(object sender, EventArgs e)
- {
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- // TODO: This line of code loads data into the 'u181542750_arsobDataSet.Archers' table. You can move, or remove it, as needed.
- this.archersTableAdapter.Fill(this.u181542750_arsobDataSet.Archers);
- }
- private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
- {
- }
- private void button1_Click(object sender, EventArgs e)
- {
- SqlConnection con = new SqlConnection("Data Source=sql34.main-hosting.eu;Initial Catalog=u181542750_arsob;Integrated Security=True");
- con.Open();
- 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);
- cmd.Parameters.AddWithValue("@Nume", textBox1.Text);
- cmd.Parameters.AddWithValue("@Prenume", textBox2.Text);
- cmd.Parameters.AddWithValue("@Varsta", textBox3.Text);
- cmd.Parameters.AddWithValue("@Sex", comboBox1.SelectedItem.ToString());
- cmd.Parameters.AddWithValue("@Categorie", comboBox2.SelectedItem.ToString());
- cmd.Parameters.AddWithValue("@E-mail", textBox4.Text);
- cmd.Parameters.AddWithValue("@Telefon", textBox5.Text);
- cmd.Parameters.AddWithValue("@CNP", textBox6.Text);
- cmd.ExecuteNonQuery();
- }
- private void button3_Click(object sender, EventArgs e)
- {
- }
- private void button2_Click(object sender, EventArgs e)
- {
- }
- private void archersBindingSource_CurrentChanged(object sender, EventArgs e)
- {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement