mehdisiavashian
دوشنبه 12 شهریور 1386, 13:56 عصر
SqlConnection objConnection;
SqlDataAdapter objDataAdabter;
DataTable objDataTable;
private void frmAddNewType_Load ( object sender, EventArgs e )
{
objConnection = new SqlConnection ( "server=MEHDI;database=indexer;uid=sa;pwd=" );
objDataAdabter = new SqlDataAdapter ( "select fileTypeName as 'نوع فایل', comment as 'توضیحات ' from indexer_fileType", objConnection );
objDataTable = new DataTable ();
objDataAdabter.Fill ( objDataTable );
dataGridView1.DataSource = objDataTable;
objConnection.Close ();
}
private void btnSave_Click ( object sender, EventArgs e )
{
objDataAdabter.InsertCommand = new SqlCommand ( "insert into indexer_fileType (fileTypeName, comment) values (@fileTypeName, @Comment)" ,objConnection);
objDataAdabter.InsertCommand.Parameters.AddWithVal ue ( "@fileTypeName", txtFileType.Text );
objDataAdabter.InsertCommand.Parameters.AddWithVal ue ( "@Comment", txtFileType.Text );
objDataAdabter.Update (objDataTable);
objDataTable.Clear ();
//Refresh DataSet with new Data
objDataAdabter.Fill ( objDataTable );
objConnection.Close ();
//Rfresh Grid With New DataSet
dataGridView1.Refresh ();
//Clear Form
txtFileType.Clear ();
txtComments.Clear ();
txtFileType.Focus ();
}
با کلیک بر دکمه btnSave تغییرات (آیتم جدید) در جدول اعمال نمی شود
با تشکر
SqlDataAdapter objDataAdabter;
DataTable objDataTable;
private void frmAddNewType_Load ( object sender, EventArgs e )
{
objConnection = new SqlConnection ( "server=MEHDI;database=indexer;uid=sa;pwd=" );
objDataAdabter = new SqlDataAdapter ( "select fileTypeName as 'نوع فایل', comment as 'توضیحات ' from indexer_fileType", objConnection );
objDataTable = new DataTable ();
objDataAdabter.Fill ( objDataTable );
dataGridView1.DataSource = objDataTable;
objConnection.Close ();
}
private void btnSave_Click ( object sender, EventArgs e )
{
objDataAdabter.InsertCommand = new SqlCommand ( "insert into indexer_fileType (fileTypeName, comment) values (@fileTypeName, @Comment)" ,objConnection);
objDataAdabter.InsertCommand.Parameters.AddWithVal ue ( "@fileTypeName", txtFileType.Text );
objDataAdabter.InsertCommand.Parameters.AddWithVal ue ( "@Comment", txtFileType.Text );
objDataAdabter.Update (objDataTable);
objDataTable.Clear ();
//Refresh DataSet with new Data
objDataAdabter.Fill ( objDataTable );
objConnection.Close ();
//Rfresh Grid With New DataSet
dataGridView1.Refresh ();
//Clear Form
txtFileType.Clear ();
txtComments.Clear ();
txtFileType.Focus ();
}
با کلیک بر دکمه btnSave تغییرات (آیتم جدید) در جدول اعمال نمی شود
با تشکر