using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Data.SqlClient;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication2
{
public partial class Form1 : Form
{
private int GetID = 0;
private string conected = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBtest.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
public Form1()
{
InitializeComponent();
}
//***************************************************************درج اطلاعات****************************************
private void insert_tbl()
{
if (!label6.Visible && !label5.Visible && !label4.Visible)
{
if (GetID==0)
{
SqlConnection cnn = new SqlConnection(conected);
SqlCommand cmd = new SqlCommand("Insert Into arzeshyabi (personalnum,year,score)Values(@1,@2,@3)", cnn);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@1", textBox1.Text);
cmd.Parameters.AddWithValue("@2", textBox2.Text);
cmd.Parameters.AddWithValue("@3", textBox3.Text);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
MessageBox.Show("ok");
}
else
{
looktbl();
}
}
txtclr();
gridshow();
}
void txtclr()
{
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
button1.Text = "ثبت";
GetID = 0;
}
private void button1_Click(object sender, EventArgs e)
{
insert_tbl();
}
//****************************************************************اتمام متد درج در تیبل******************************
private void looktbl()
{
string txtnum = textBox2.Text.Trim();//اینو نادیده بگیر
SqlCommand cmd1;
SqlConnection cnn1;
SqlDataReader reader;
cnn1 = new SqlConnection(conected);
cmd1 = new SqlCommand();
cmd1.Connection = cnn1;
cnn1.Open();
cmd1.CommandText = "Select score From arzeshyabi";
reader = cmd1.ExecuteReader();
if (!reader.Read())
{
SqlConnection cnn = new SqlConnection(conected);
SqlCommand cmd = new SqlCommand("Update arzeshyabi Set personalnum=@1,year=@2,score=@3 Where ID=" + GetID, cnn);
cmd.Parameters.AddWithValue("@1", textBox1.Text);
cmd.Parameters.AddWithValue("@2", textBox2.Text);
cmd.Parameters.AddWithValue("@3", textBox3.Text);
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
gridshow();
}
else
{
MessageBox.Show("قبلا امتیاز ثبت شده");
txtclr();
return;
}
}
//*************************************تابع نمایش دیتاگرید******************************************
private void gridshow()
{
SqlConnection cn = new SqlConnection(conected);
SqlDataAdapter adap = new SqlDataAdapter("Select * From arzeshyabi", cn);
DataSet dset = new DataSet();
adap.Fill(dset, "arzeshyabi");
dataGridView1.DataSource = dset.Tables[0].DefaultView;
dataGridView1.DataSource = dset;
dataGridView1.DataMember = "arzeshyabi";
}
//*******************************************************************************************************
private void Form1_Load(object sender, EventArgs e)
{
gridshow();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
label6.Visible=(textBox1.Text.Trim()=="");
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
label5.Visible = (textBox2.Text.Trim() == "");
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
label4.Visible = (textBox3.Text.Trim() == "");
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
//textBox1.Text = dataGridView1[1, dataGridView1.CurrentRow.Index].Value.ToString();
// textBox2.Text = dataGridView1[2, dataGridView1.CurrentRow.Index].Value.ToString();
//textBox3.Text = dataGridView1[3, dataGridView1.CurrentRow.Index].Value.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow != null)
{
textBox1.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
textBox2.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
GetID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
button1.Text = "اعمال تغییر";
}
gridshow();
}
}
}
توسط
Dany
(7,164 امتیاز)
●4 ●7 ●141