mohammadreza0123
سه شنبه 26 شهریور 1392, 17:46 عصر
سلام
متاسفانه یه مشکلی در لود جدول بعد از آپدیت دارم
خواهشا کسانی که میتونن کمک کنن
SqlDataAdapter DaUpdate = new SqlDataAdapter();
DaUpdate = new SqlDataAdapter("update phone set نام=N'" + txtname.Text + "' ,[نام خانوادگی]=N'" + txtFamily.Text + "' , استان=N'" + txtOstan.Text + "',شهر=N'" + txtShahr.Text + "' , [کد شهر]=N'" + txtCodeShahr.Text + "' , [شماره تلفن]=N'" + txtTell.Text + "' , [شماره همراه]=N'" + txtMob.Text + "' , [شماره محل کار]=N'" + txtWorkTell.Text + "' , ایمیل=N'" + txtMail.Text + "' , توضیحات='"
+ richTozaihat.Text + "' , عکس='" + pic + "' where شناسه=N'"+txtShenase.Text+"'", C1);
DaUpdate.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
انتظار دارم بعد از زدن دکمه آپدیت بشه و جدول رو نشون بده
اما آپدیت میشه ولی جدول قبلی رو نشون میده
باید روی دکمه دیگر که عنوان مشاهده لیست داره کلیک کنم تا جدول به صورت آپدیت شده بیاد
کد اون دکمه هم اینه
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
اگه کسی هست که نفهمید اینم کل کد من هست در پروژه
using System;
using System.Data.Common;
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.Windows.Forms;
namespace Advance_PhoneNoteBook
{
public partial class Form1 : Form
{
SqlConnection C1 = new SqlConnection("Data Source=(local);Initial Catalog=parsaAdvancePhoneNoteBook;Integrated Security=True");
SqlDataAdapter Da;
DataSet ds = new DataSet();
DataRow newrow;
public Form1()
{
InitializeComponent();
}
private void toolStripContainer1_ContentPanel_Load(object sender, EventArgs e)
{
}
string pic;
public void btnEntekhabAks_Click(object sender, EventArgs e)
{
openFileDialogEntekhabAks.Title = "انتخاب عکس";
openFileDialogEntekhabAks.FileName = "";
openFileDialogEntekhabAks.FilterIndex = 1;
openFileDialogEntekhabAks.Filter = "jpegFile(*.jpg)|*.jpg" + "gifFile(*.gif)|*.gif" + "All(*.*)|*.*";
if (openFileDialogEntekhabAks.ShowDialog() == DialogResult.OK)
pic = openFileDialogEntekhabAks.FileName;
picBoxSabt.ImageLocation = pic;
}
private void خروجToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void توضیحاتنرمافزارToolStripMenuItem_Cl ick(object sender, EventArgs e)
{
Form fAboutProg = new Form2();
fAboutProg.Show();
}
private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
C1.Open();
Da = new SqlDataAdapter("select * from phone", C1);
DataTableMapping DTM = new DataTableMapping();
Da.TableMappings.Add("Table", "phoneBook");
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
private void sqlDataAdapter1_RowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
}
private void btnSabt_Click(object sender, EventArgs e)
{
try
{
SqlCommandBuilder Cb = new SqlCommandBuilder(Da);
newrow = ds.Tables[0].NewRow();
newrow["شناسه"] = int.Parse(txtShenase.Text);
newrow["نام"] = txtname.Text;
newrow["نام خانوادگی"] = txtFamily.Text;
newrow["استان"] = txtOstan.Text;
newrow["شهر"] = txtShahr.Text;
newrow["کد شهر"] = txtCodeShahr.Text;
newrow["شماره تلفن"] = txtTell.Text;
newrow["شماره همراه"] = txtMob.Text;
newrow["شماره محل کار"] = txtWorkTell.Text; ;
newrow["ایمیل"] = txtMail.Text;
newrow["توضیحات"] = richTozaihat.Text;
newrow["عکس"] = pic;
ds.Tables["phoneBook"].Rows.Add(newrow);
Da.InsertCommand = Cb.GetInsertCommand();
Da.Update(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
/* SqlCommand Cm1 = new SqlCommand("insert into phone (نام,[نام خانوادگی],استان,شهر,[کد شهر],[شماره تلفن],[شماره همراه],[شماره محل کار],ایمیل,توضیحات,عکس) values(N'" + txtname.Text + "',N'" + txtFamily.Text + "',N'" + txtOstan.Text + "',N'" + txtShahr.Text + "',N'" + txtCodeShahr.Text + "',N'" + txtTell.Text + "',N'" + txtMob.Text + "',N'" + txtWorkTell.Text + "',N'" + txtMail.Text + "',N'" + richTozaihat.Text + "','" + pic+ "')", C1);
Cm1.ExecuteNonQuery();
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;*/
MessageBox.Show("عملیات با موفقیت انجام شد", "وضعیت عملیات");
txtShenase.Text = "";
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;
}
catch
{
MessageBox.Show("یکی از موارد ضروری را وارد نکردید", "وضعیت عملیات ثبت", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void sabtTab_Click(object sender, EventArgs e)
{
}
private void btnHazf_Click(object sender, EventArgs e)
{
// try
// {
SqlCommand cm2 = new SqlCommand("delete from phone where نام=N'" + txtNameHazf.Text.Trim() + "'", C1);
// if (txtNameHazf.Text == "")
// label27.Visible = true;
// else if(txtNameHazf.Text!="")
// label27.Visible = false;
// if (txtFamilyHazf.Text == "")
// label28.Visible = true;
//else if(txtFamilyHazf.Text!="")
// label28.Visible=false;
// if (txtTellHazf.Text == "")
// label29.Visible = true;
// else if (txtTellHazf.Text != "")
// label29.Visible = false;
//else
//{
cm2.ExecuteNonQuery();
MessageBox.Show("عملیات با موفقیت انجام شد", "وضعیت عملیات");
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
//}
// }
/* catch
{
if (txtNameHazf.Text == "")
else
label27.Visible = false;
if (txtFamilyHazf.Text == "")
else
label28.Visible = false;
if (txtTellHazf.Text == "")
label29.Visible = true;
else
} */
}
private void button1_Click(object sender, EventArgs e)
{
}
private void hazfTab_Click(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void button1_Click_1(object sender, EventArgs e)
{
}
private void btnSearch_Click(object sender, EventArgs e)
{
if ((txtNameSearch.Text != null) && (txtFamilyHazf.Text != null) && (txtShahrSearch.Text != null))
{
SqlDataAdapter DaSearch = new SqlDataAdapter("select * from phone where نام=N'" + txtNameSearch.Text.Trim() + "' and [نام خانوادگی]=N'" + txtFamilySearch.Text + "' and شهر=N'" + txtShahrSearch.Text + "'", C1);
DaSearch.Fill(ds,"phone");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phone";
}
else
MessageBox.Show("یکی از موارد را وارد نکردید", ",وضعیت عملیات", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtShenase.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
txtname.Text= dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
txtFamily.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
txtOstan.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
txtShahr.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
txtCodeShahr.Text = dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
txtTell.Text = dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
txtMob.Text = dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
txtWorkTell.Text = dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
txtMail.Text = dataGridView1.SelectedRows[0].Cells[9].Value.ToString();
richTozaihat.Text = dataGridView1.SelectedRows[0].Cells[10].Value.ToString();
picBoxSabt.ImageLocation = dataGridView1.SelectedRows[0].Cells[11].Value.ToString();
}
private void btnPak_Click(object sender, EventArgs e)
{
txtShenase.Text = "";
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;
}
private void مشاهدهلیستکاملافرادToolStripMen uItem_Click(object sender, EventArgs e)
{
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
//public void namayeshelist()
//{
// ds.Clear();
// Da.Fill(ds);
// dataGridView1.DataSource = ds;
// dataGridView1.DataMember = "phoneBook";
//}
private void btnVirayesh_Click(object sender, EventArgs e)
{
picBoxSabt.ImageLocation = pic;
SqlDataAdapter DaUpdate = new SqlDataAdapter();
DaUpdate = new SqlDataAdapter("update phone set نام=N'" + txtname.Text + "' ,[نام خانوادگی]=N'" + txtFamily.Text + "' , استان=N'" + txtOstan.Text + "',شهر=N'" + txtShahr.Text + "' , [کد شهر]=N'" + txtCodeShahr.Text + "' , [شماره تلفن]=N'" + txtTell.Text + "' , [شماره همراه]=N'" + txtMob.Text + "' , [شماره محل کار]=N'" + txtWorkTell.Text + "' , ایمیل=N'" + txtMail.Text + "' , توضیحات='"
+ richTozaihat.Text + "' , عکس='" + pic + "' where شناسه=N'"+txtShenase.Text+"'", C1);
DaUpdate.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
}
}
متاسفانه یه مشکلی در لود جدول بعد از آپدیت دارم
خواهشا کسانی که میتونن کمک کنن
SqlDataAdapter DaUpdate = new SqlDataAdapter();
DaUpdate = new SqlDataAdapter("update phone set نام=N'" + txtname.Text + "' ,[نام خانوادگی]=N'" + txtFamily.Text + "' , استان=N'" + txtOstan.Text + "',شهر=N'" + txtShahr.Text + "' , [کد شهر]=N'" + txtCodeShahr.Text + "' , [شماره تلفن]=N'" + txtTell.Text + "' , [شماره همراه]=N'" + txtMob.Text + "' , [شماره محل کار]=N'" + txtWorkTell.Text + "' , ایمیل=N'" + txtMail.Text + "' , توضیحات='"
+ richTozaihat.Text + "' , عکس='" + pic + "' where شناسه=N'"+txtShenase.Text+"'", C1);
DaUpdate.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
انتظار دارم بعد از زدن دکمه آپدیت بشه و جدول رو نشون بده
اما آپدیت میشه ولی جدول قبلی رو نشون میده
باید روی دکمه دیگر که عنوان مشاهده لیست داره کلیک کنم تا جدول به صورت آپدیت شده بیاد
کد اون دکمه هم اینه
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
اگه کسی هست که نفهمید اینم کل کد من هست در پروژه
using System;
using System.Data.Common;
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.Windows.Forms;
namespace Advance_PhoneNoteBook
{
public partial class Form1 : Form
{
SqlConnection C1 = new SqlConnection("Data Source=(local);Initial Catalog=parsaAdvancePhoneNoteBook;Integrated Security=True");
SqlDataAdapter Da;
DataSet ds = new DataSet();
DataRow newrow;
public Form1()
{
InitializeComponent();
}
private void toolStripContainer1_ContentPanel_Load(object sender, EventArgs e)
{
}
string pic;
public void btnEntekhabAks_Click(object sender, EventArgs e)
{
openFileDialogEntekhabAks.Title = "انتخاب عکس";
openFileDialogEntekhabAks.FileName = "";
openFileDialogEntekhabAks.FilterIndex = 1;
openFileDialogEntekhabAks.Filter = "jpegFile(*.jpg)|*.jpg" + "gifFile(*.gif)|*.gif" + "All(*.*)|*.*";
if (openFileDialogEntekhabAks.ShowDialog() == DialogResult.OK)
pic = openFileDialogEntekhabAks.FileName;
picBoxSabt.ImageLocation = pic;
}
private void خروجToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void توضیحاتنرمافزارToolStripMenuItem_Cl ick(object sender, EventArgs e)
{
Form fAboutProg = new Form2();
fAboutProg.Show();
}
private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)
{
}
private void Form1_Load(object sender, EventArgs e)
{
C1.Open();
Da = new SqlDataAdapter("select * from phone", C1);
DataTableMapping DTM = new DataTableMapping();
Da.TableMappings.Add("Table", "phoneBook");
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
private void sqlDataAdapter1_RowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
}
private void btnSabt_Click(object sender, EventArgs e)
{
try
{
SqlCommandBuilder Cb = new SqlCommandBuilder(Da);
newrow = ds.Tables[0].NewRow();
newrow["شناسه"] = int.Parse(txtShenase.Text);
newrow["نام"] = txtname.Text;
newrow["نام خانوادگی"] = txtFamily.Text;
newrow["استان"] = txtOstan.Text;
newrow["شهر"] = txtShahr.Text;
newrow["کد شهر"] = txtCodeShahr.Text;
newrow["شماره تلفن"] = txtTell.Text;
newrow["شماره همراه"] = txtMob.Text;
newrow["شماره محل کار"] = txtWorkTell.Text; ;
newrow["ایمیل"] = txtMail.Text;
newrow["توضیحات"] = richTozaihat.Text;
newrow["عکس"] = pic;
ds.Tables["phoneBook"].Rows.Add(newrow);
Da.InsertCommand = Cb.GetInsertCommand();
Da.Update(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
/* SqlCommand Cm1 = new SqlCommand("insert into phone (نام,[نام خانوادگی],استان,شهر,[کد شهر],[شماره تلفن],[شماره همراه],[شماره محل کار],ایمیل,توضیحات,عکس) values(N'" + txtname.Text + "',N'" + txtFamily.Text + "',N'" + txtOstan.Text + "',N'" + txtShahr.Text + "',N'" + txtCodeShahr.Text + "',N'" + txtTell.Text + "',N'" + txtMob.Text + "',N'" + txtWorkTell.Text + "',N'" + txtMail.Text + "',N'" + richTozaihat.Text + "','" + pic+ "')", C1);
Cm1.ExecuteNonQuery();
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;*/
MessageBox.Show("عملیات با موفقیت انجام شد", "وضعیت عملیات");
txtShenase.Text = "";
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;
}
catch
{
MessageBox.Show("یکی از موارد ضروری را وارد نکردید", "وضعیت عملیات ثبت", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void sabtTab_Click(object sender, EventArgs e)
{
}
private void btnHazf_Click(object sender, EventArgs e)
{
// try
// {
SqlCommand cm2 = new SqlCommand("delete from phone where نام=N'" + txtNameHazf.Text.Trim() + "'", C1);
// if (txtNameHazf.Text == "")
// label27.Visible = true;
// else if(txtNameHazf.Text!="")
// label27.Visible = false;
// if (txtFamilyHazf.Text == "")
// label28.Visible = true;
//else if(txtFamilyHazf.Text!="")
// label28.Visible=false;
// if (txtTellHazf.Text == "")
// label29.Visible = true;
// else if (txtTellHazf.Text != "")
// label29.Visible = false;
//else
//{
cm2.ExecuteNonQuery();
MessageBox.Show("عملیات با موفقیت انجام شد", "وضعیت عملیات");
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
//}
// }
/* catch
{
if (txtNameHazf.Text == "")
else
label27.Visible = false;
if (txtFamilyHazf.Text == "")
else
label28.Visible = false;
if (txtTellHazf.Text == "")
label29.Visible = true;
else
} */
}
private void button1_Click(object sender, EventArgs e)
{
}
private void hazfTab_Click(object sender, EventArgs e)
{
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private void button1_Click_1(object sender, EventArgs e)
{
}
private void btnSearch_Click(object sender, EventArgs e)
{
if ((txtNameSearch.Text != null) && (txtFamilyHazf.Text != null) && (txtShahrSearch.Text != null))
{
SqlDataAdapter DaSearch = new SqlDataAdapter("select * from phone where نام=N'" + txtNameSearch.Text.Trim() + "' and [نام خانوادگی]=N'" + txtFamilySearch.Text + "' and شهر=N'" + txtShahrSearch.Text + "'", C1);
DaSearch.Fill(ds,"phone");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phone";
}
else
MessageBox.Show("یکی از موارد را وارد نکردید", ",وضعیت عملیات", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtShenase.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
txtname.Text= dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
txtFamily.Text = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
txtOstan.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString();
txtShahr.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString();
txtCodeShahr.Text = dataGridView1.SelectedRows[0].Cells[5].Value.ToString();
txtTell.Text = dataGridView1.SelectedRows[0].Cells[6].Value.ToString();
txtMob.Text = dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
txtWorkTell.Text = dataGridView1.SelectedRows[0].Cells[8].Value.ToString();
txtMail.Text = dataGridView1.SelectedRows[0].Cells[9].Value.ToString();
richTozaihat.Text = dataGridView1.SelectedRows[0].Cells[10].Value.ToString();
picBoxSabt.ImageLocation = dataGridView1.SelectedRows[0].Cells[11].Value.ToString();
}
private void btnPak_Click(object sender, EventArgs e)
{
txtShenase.Text = "";
txtname.Text = "";
txtFamily.Text = "";
txtOstan.Text = "";
txtShahr.Text = "";
txtCodeShahr.Text = "";
txtTell.Text = "";
txtMob.Text = "";
txtWorkTell.Text = "";
txtMail.Text = "";
richTozaihat.Text = "";
picBoxSabt.Image = null;
}
private void مشاهدهلیستکاملافرادToolStripMen uItem_Click(object sender, EventArgs e)
{
ds.Clear();
Da.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
//public void namayeshelist()
//{
// ds.Clear();
// Da.Fill(ds);
// dataGridView1.DataSource = ds;
// dataGridView1.DataMember = "phoneBook";
//}
private void btnVirayesh_Click(object sender, EventArgs e)
{
picBoxSabt.ImageLocation = pic;
SqlDataAdapter DaUpdate = new SqlDataAdapter();
DaUpdate = new SqlDataAdapter("update phone set نام=N'" + txtname.Text + "' ,[نام خانوادگی]=N'" + txtFamily.Text + "' , استان=N'" + txtOstan.Text + "',شهر=N'" + txtShahr.Text + "' , [کد شهر]=N'" + txtCodeShahr.Text + "' , [شماره تلفن]=N'" + txtTell.Text + "' , [شماره همراه]=N'" + txtMob.Text + "' , [شماره محل کار]=N'" + txtWorkTell.Text + "' , ایمیل=N'" + txtMail.Text + "' , توضیحات='"
+ richTozaihat.Text + "' , عکس='" + pic + "' where شناسه=N'"+txtShenase.Text+"'", C1);
DaUpdate.Fill(ds);
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "phoneBook";
}
}
}