using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Text.RegularExpressions;
using System.Collections;
using System.Windows.Forms;
namespace amir
{
public partial class Form1 : Form
{
SqlConnection cnn = new SqlConnection();
SqlDataAdapter sda = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
ArrayList arr = new ArrayList();
private void Connect()
{
cnn.ConnectionString = "Data Source=localhost;initial catalog=amir ;User ID = sa ;Password=tara;";
}
private DataSet LoadAllb()
{
Connect();
cmd.CommandText = "SELECT tarm AS [تاريخ ثبت], shom AS [شماره شناسايي], nam AS نام, namk AS [نام خانوادگي], namp AS [نام پدر], kar AS [محل كار], tel AS تلفن FROM dbo.moshn";
cmd.Connection = cnn;
sda.SelectCommand = cmd;
cnn.Open();
sda.Fill(ds, "tar");
cnn.Close();
return ds;
}
private void Insert(SqlCommand cmd)
{
Connect();
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("اضافه شود", "ذخيره", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1, MessageBoxOptions.RightAlign);
if (result == DialogResult.Cancel)
{
this.Hide();
}
if (result == DialogResult.OK)
{
arr.Add(textBox1.Text);
arr.Add(textBox2.Text);
arr.Add(textBox3.Text);
arr.Add(textBox4.Text);
arr.Add(textBox5.Text);
arr.Add(textBox6.Text);
arr.Add(textBox7.Text);
cmd.CommandText = "insert into moshr(tarm,shom,nam,namk,namp,kar,tel)Values(@tarm ,@shom,@nam,@namk,@namp,@kar,@tel)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@tarm", SqlDbType.Text).Value = arr[0].ToString();
cmd.Parameters.Add("@shom", SqlDbType.Int).Value = int.Parse(arr[1].ToString());
cmd.Parameters.Add("@nam", SqlDbType.Text).Value = arr[2].ToString();
cmd.Parameters.Add("@namk", SqlDbType.Text).Value = arr[3].ToString();
cmd.Parameters.Add("@namp", SqlDbType.Text).Value = arr[4].ToString();
cmd.Parameters.Add("@kar", SqlDbType.Text).Value = arr[5].ToString();
cmd.Parameters.Add("@tel", SqlDbType.Text).Value = arr[6].ToString();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
Insert(cmd);
LoadAlla();
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "beh";
}
}
}
ممنون مي شم اگه كسي جواب بده