faramarz_s
پنج شنبه 27 شهریور 1382, 21:37 عصر
به نظر شما کد زیر چه ایرادی دارد؟
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
bindToDatGrid("id");
}
//------------------------------------------------------------------------------------------------
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
bindToDatGrid("id");
}
//------------------------------------------------------------------------------------------------
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
string un = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string uf = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string password = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
string email = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
SqlConnection conn =
new SqlConnection("server=(local);uid=sa;pwd=yaali;database=MDB;");
// Prepare the command text
String strCmd = "UPDATE tblPrimary SET password='"+
password+ "'" + "email='" + email+ "'"+
" WHERE id=" + id;
SqlCommand cmd = new SqlCommand(strCmd, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// Reset the edit mode for the current item
DataGrid1.EditItemIndex = -1;
// create data source again.........
bindToDatGrid("id");
}
تکست باکسی ایجاد نمیشود.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblPrimary]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblPrimary]
GO
CREATE TABLE [dbo].[tblPrimary] (
[id] [int] NOT NULL ,
[un] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[uf] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[password] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = e.Item.ItemIndex;
bindToDatGrid("id");
}
//------------------------------------------------------------------------------------------------
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = -1;
bindToDatGrid("id");
}
//------------------------------------------------------------------------------------------------
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
string un = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string uf = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string password = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
string email = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
SqlConnection conn =
new SqlConnection("server=(local);uid=sa;pwd=yaali;database=MDB;");
// Prepare the command text
String strCmd = "UPDATE tblPrimary SET password='"+
password+ "'" + "email='" + email+ "'"+
" WHERE id=" + id;
SqlCommand cmd = new SqlCommand(strCmd, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// Reset the edit mode for the current item
DataGrid1.EditItemIndex = -1;
// create data source again.........
bindToDatGrid("id");
}
تکست باکسی ایجاد نمیشود.
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblPrimary]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblPrimary]
GO
CREATE TABLE [dbo].[tblPrimary] (
[id] [int] NOT NULL ,
[un] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[uf] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[password] [nchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO