help man
دوشنبه 19 فروردین 1387, 01:38 صبح
با سلام من برنامه زیر رو نوشتم ولی یک مشکلی که داره اینه که با زدن باتوم بایستی تغییرات داخل دیتا گرید ویو داخل بانکم انجام بشه که این اتفاق نمیفته لطفا اشکال کار برنامم رو بگید ممنوم با تشکر
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.Sql;
namespace sql3
{
publicpartialclassForm1 : Form
{
// SqlConnection objconnection = new SqlConnection();
SqlDataAdapter objadapter = newSqlDataAdapter();
DataSet objdataset = newDataSet();
public Form1()
{
InitializeComponent();
}
privatevoid Form1_Load(object sender, EventArgs e)
{
objadapter.SelectCommand = newSqlCommand();
objadapter.SelectCommand.Connection = sqlConnection1;
objadapter.SelectCommand.CommandText=("Select ali from people where ali >1 order by ali asc ");
objadapter.SelectCommand.CommandType = CommandType.Text;
sqlConnection1.Open();
objadapter.Fill(objdataset,"people");
sqlConnection1.Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objdataset;
dataGridView1.DataMember = "people";
}
privatevoid dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
privatevoid button1_Click(object sender, EventArgs e)
{
DataTable objDataSet = newDataTable();
SqlCommandBuilder cb = newSqlCommandBuilder(objadapter);
sqlConnection1.Open();
objadapter.Update(objdataset, "people");
sqlConnection1.Close();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Data.Sql;
namespace sql3
{
publicpartialclassForm1 : Form
{
// SqlConnection objconnection = new SqlConnection();
SqlDataAdapter objadapter = newSqlDataAdapter();
DataSet objdataset = newDataSet();
public Form1()
{
InitializeComponent();
}
privatevoid Form1_Load(object sender, EventArgs e)
{
objadapter.SelectCommand = newSqlCommand();
objadapter.SelectCommand.Connection = sqlConnection1;
objadapter.SelectCommand.CommandText=("Select ali from people where ali >1 order by ali asc ");
objadapter.SelectCommand.CommandType = CommandType.Text;
sqlConnection1.Open();
objadapter.Fill(objdataset,"people");
sqlConnection1.Close();
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = objdataset;
dataGridView1.DataMember = "people";
}
privatevoid dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
privatevoid button1_Click(object sender, EventArgs e)
{
DataTable objDataSet = newDataTable();
SqlCommandBuilder cb = newSqlCommandBuilder(objadapter);
sqlConnection1.Open();
objadapter.Update(objdataset, "people");
sqlConnection1.Close();
}
}
}