关于把datagridview的数据updata到数据库的有关问题
关于把datagridview的数据updata到数据库的问题
我用下面的方法实现了对数据在datagridview里的显示
Dim strCon As String = "Data Source=.;Initial Catalog=;User Id=newu;Password=newu;Connection Timeout=120; "
Dim strSQL As String = "select * from config "
Dim dataAdapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(strSQL, strCon)
Dim commandBuilder As New System.Data.SqlClient.SqlCommandBuilder(dataAdapter)
Dim table As New DataTable
dataAdapter.Fill(table)
dbBindSource.DataSource = table
dbGridView.DataSource = dbBindSource
请问我在对datagridview里的数据进行修改之后怎么 updata回数据库呢？
我这种写法是不是不行？
------解决方案--------------------
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindRole();
}
}
private void BindRole()
{
DataTable dt = roleDB.GetAllRole();
gvRoles.DataSource = dt.DefaultView;
gvRoles.DataBind();
}
protected void gvRoles_RowEditing(object sender, GridViewEditEventArgs e)
{
gvRoles.EditIndex = e.NewEditIndex;
BindRole();
}
protected void gvRoles_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gvrRoles = gvRoles.Rows[gvRoles.EditIndex];
int iRoleID = int.Parse(gvRoles.DataKeys[gvRoles.EditIndex].Value.ToString());
string strRoleName = ((TextBox)gvrRoles.FindControl( "txtRoleName ")).Text.Trim();
string strRoleDes = ((TextBox)gvrRoles.FindControl( "txtDes ")).Text.Trim();
int iFlag = 0;
CheckBox chkFlagNew = (CheckBox)gvrRoles.FindControl( "chkEFalg ");
if (chkFlagNew.Checked == true)
iFlag = 1;
bool bFlag = roleDB.UpDateRole(strRoleName, strRoleDes, iFlag,iRoleID);
gvRoles.EditIndex = -1;
BindRole();
}
}
------解决方案--------------------
在cell_beginedit中取得要修改行的id之类（最好是主键，这样不会重复）的 并取得这个cell的值
在cell_endedit中判断如果这个cell的值改变了就 执行一个update语句，根据上面取得这行数据的主键来更新数据库
------解决方案--------------------
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Dim conn As SqlConnection
Dim da As SqlDataAdapter
Dim ds As DataSet
' 加载窗体时在DataGridView1中显示数据
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New SqlConnection( "Data Source=.;Initial Catalog=;User Id=newu;Password=newu;Connection Timeout=120; ")
conn.Open()
da = New SqlDataAdapter( "SELECT * FROM config ", conn)
ds = New DataSet
da.Fill(ds)
Me.DataGridView1.DataSource = ds.Tables(0)
End Sub
' 点击Button1时将DataGridView1中的修改保存入数据库
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
我用下面的方法实现了对数据在datagridview里的显示
Dim strCon As String = "Data Source=.;Initial Catalog=;User Id=newu;Password=newu;Connection Timeout=120; "
Dim strSQL As String = "select * from config "
Dim dataAdapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(strSQL, strCon)
Dim commandBuilder As New System.Data.SqlClient.SqlCommandBuilder(dataAdapter)
Dim table As New DataTable
dataAdapter.Fill(table)
dbBindSource.DataSource = table
dbGridView.DataSource = dbBindSource
请问我在对datagridview里的数据进行修改之后怎么 updata回数据库呢？
我这种写法是不是不行？
------解决方案--------------------
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindRole();
}
}
private void BindRole()
{
DataTable dt = roleDB.GetAllRole();
gvRoles.DataSource = dt.DefaultView;
gvRoles.DataBind();
}
protected void gvRoles_RowEditing(object sender, GridViewEditEventArgs e)
{
gvRoles.EditIndex = e.NewEditIndex;
BindRole();
}
protected void gvRoles_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow gvrRoles = gvRoles.Rows[gvRoles.EditIndex];
int iRoleID = int.Parse(gvRoles.DataKeys[gvRoles.EditIndex].Value.ToString());
string strRoleName = ((TextBox)gvrRoles.FindControl( "txtRoleName ")).Text.Trim();
string strRoleDes = ((TextBox)gvrRoles.FindControl( "txtDes ")).Text.Trim();
int iFlag = 0;
CheckBox chkFlagNew = (CheckBox)gvrRoles.FindControl( "chkEFalg ");
if (chkFlagNew.Checked == true)
iFlag = 1;
bool bFlag = roleDB.UpDateRole(strRoleName, strRoleDes, iFlag,iRoleID);
gvRoles.EditIndex = -1;
BindRole();
}
}
------解决方案--------------------
在cell_beginedit中取得要修改行的id之类（最好是主键，这样不会重复）的 并取得这个cell的值
在cell_endedit中判断如果这个cell的值改变了就 执行一个update语句，根据上面取得这行数据的主键来更新数据库
------解决方案--------------------
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Dim conn As SqlConnection
Dim da As SqlDataAdapter
Dim ds As DataSet
' 加载窗体时在DataGridView1中显示数据
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
conn = New SqlConnection( "Data Source=.;Initial Catalog=;User Id=newu;Password=newu;Connection Timeout=120; ")
conn.Open()
da = New SqlDataAdapter( "SELECT * FROM config ", conn)
ds = New DataSet
da.Fill(ds)
Me.DataGridView1.DataSource = ds.Tables(0)
End Sub
' 点击Button1时将DataGridView1中的修改保存入数据库
Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click