大家一般新建是怎么做的啊? 一个窗体中有多个TextBox,一个DataGrid(已绑定数据)如果要新建一个新的记灵,TextBox是不是一个一个的清空,然后DataGrid的行一个一个Remove掉请问大家是怎么做的? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ,一个DataGrid(已绑定数据)怎么绑定啊,朋友 this.BindingContext[dt].AddNew();//dt為DataGrid的數據源 //確定 private void toolStripButton4_Click(object sender, EventArgs e) { using (SqlConnection cnn = new SqlConnection(Data.Data_Connection.ConnectionString)) { try { SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cnn.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "P_EIP_INSUPDSALES"; cmd.Parameters.Add(new SqlParameter("@NOSALES", SqlDbType.VarChar, 10, "NO_SALES")); cmd.Parameters.Add(new SqlParameter("@NMSALES", SqlDbType.VarChar, 20, "NM_SALES")); cmd.Parameters.Add(new SqlParameter("@IDDEPT", SqlDbType.Int, 4, "ID_DEPT")); cmd.Parameters.Add(new SqlParameter("@IDJOB", SqlDbType.Int, 4, "ID_JOB")); cmd.Parameters.Add(new SqlParameter("@NOTEL", SqlDbType.VarChar, 20, "NO_TEL")); cmd.Parameters.Add(new SqlParameter("@NOMOBLE", SqlDbType.VarChar, 20, "NO_MOBLE")); cmd.Parameters.Add(new SqlParameter("@NOSALESID", SqlDbType.VarChar, 20, "NO_SALESID")); cmd.Parameters.Add(new SqlParameter("@ADHOME", SqlDbType.VarChar, 20, "AD_HOME")); cmd.Parameters.Add(new SqlParameter("@ADNOWIN", SqlDbType.VarChar, 20, "AD_NOWIN")); cmd.Parameters.Add(new SqlParameter("@CDMERRY", SqlDbType.VarChar, 20, "CD_MERRY")); cmd.Parameters.Add(new SqlParameter("@ADEMAIL", SqlDbType.VarChar, 20, "AD_EMAIL")); cmd.Parameters.Add(new SqlParameter("@IDSALESEDU", SqlDbType.VarChar, 20, "ID_SALESEDU")); cmd.Parameters.Add(new SqlParameter("NMSCHOLL", SqlDbType.VarChar, 20, "NO_SCHOLL")); //cmd.Parameters.Add(new SqlParameter("")); cmd.Parameters[0].Value = this.txtSalesNo.Text.Trim(); cmd.Parameters[1].Value = this.txtSalesName.Text.Trim(); cmd.Parameters[2].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_DEPT"]; cmd.Parameters[3].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_JOB"]; cmd.Parameters[4].Value = this.txtTel.Text.Trim(); cmd.Parameters[5].Value = this.txtMoble.Text.Trim(); cmd.Parameters[6].Value = this.txtSalesID.Text.Trim(); cmd.Parameters[7].Value = this.txtAddrHome.Text.Trim(); cmd.Parameters[8].Value = this.txtAddrNow.Text.Trim(); cmd.Parameters[9].Value = this.cmbMerry.ValueMember; cmd.Parameters[10].Value = this.txtEmail.Text.Trim(); cmd.Parameters[11].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_SALESEDU"]; cmd.Parameters[12].Value = this.txtScholl.Text.Trim(); cmd.ExecuteNonQuery(); } catch (Exception elx) { MessageBox.Show(elx.ToString() ); } finally { cnn.Close(); } } } 将textbox.text也绑定在数据源上,清数据源就行了 一个基础的问题!!! asp.net编写注册模块的时候出错了 如何在 linux 平台 运行 net程序 一个超菜的截字符串问题 WinForm主窗口使用完毕,如何切换到第二个WinForm窗口?? C# 动态dataGridView 中动态生成菜单,如何获取当前选中datagridview的选中值 如何用c#编写电子邮件系统,需要加密功能,有哪位高手帮个忙? C#中获取字符串中间一段内容的函数 救命呀! 1310已经把我逼疯了! 使用dataview绑定出错,请教高手!!!!! 请教了~~有关弹出窗体的问题? 关于c#操作oracle数据库的几个问题,望指教
怎么绑定啊,朋友
//dt為DataGrid的數據源
//確定
private void toolStripButton4_Click(object sender, EventArgs e)
{
using (SqlConnection cnn = new SqlConnection(Data.Data_Connection.ConnectionString))
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cnn.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "P_EIP_INSUPDSALES";
cmd.Parameters.Add(new SqlParameter("@NOSALES", SqlDbType.VarChar, 10, "NO_SALES"));
cmd.Parameters.Add(new SqlParameter("@NMSALES", SqlDbType.VarChar, 20, "NM_SALES"));
cmd.Parameters.Add(new SqlParameter("@IDDEPT", SqlDbType.Int, 4, "ID_DEPT"));
cmd.Parameters.Add(new SqlParameter("@IDJOB", SqlDbType.Int, 4, "ID_JOB"));
cmd.Parameters.Add(new SqlParameter("@NOTEL", SqlDbType.VarChar, 20, "NO_TEL"));
cmd.Parameters.Add(new SqlParameter("@NOMOBLE", SqlDbType.VarChar, 20, "NO_MOBLE"));
cmd.Parameters.Add(new SqlParameter("@NOSALESID", SqlDbType.VarChar, 20, "NO_SALESID"));
cmd.Parameters.Add(new SqlParameter("@ADHOME", SqlDbType.VarChar, 20, "AD_HOME"));
cmd.Parameters.Add(new SqlParameter("@ADNOWIN", SqlDbType.VarChar, 20, "AD_NOWIN"));
cmd.Parameters.Add(new SqlParameter("@CDMERRY", SqlDbType.VarChar, 20, "CD_MERRY"));
cmd.Parameters.Add(new SqlParameter("@ADEMAIL", SqlDbType.VarChar, 20, "AD_EMAIL"));
cmd.Parameters.Add(new SqlParameter("@IDSALESEDU", SqlDbType.VarChar, 20, "ID_SALESEDU"));
cmd.Parameters.Add(new SqlParameter("NMSCHOLL", SqlDbType.VarChar, 20, "NO_SCHOLL"));
//cmd.Parameters.Add(new SqlParameter("")); cmd.Parameters[0].Value = this.txtSalesNo.Text.Trim();
cmd.Parameters[1].Value = this.txtSalesName.Text.Trim();
cmd.Parameters[2].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_DEPT"];
cmd.Parameters[3].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_JOB"];
cmd.Parameters[4].Value = this.txtTel.Text.Trim();
cmd.Parameters[5].Value = this.txtMoble.Text.Trim();
cmd.Parameters[6].Value = this.txtSalesID.Text.Trim();
cmd.Parameters[7].Value = this.txtAddrHome.Text.Trim();
cmd.Parameters[8].Value = this.txtAddrNow.Text.Trim();
cmd.Parameters[9].Value = this.cmbMerry.ValueMember;
cmd.Parameters[10].Value = this.txtEmail.Text.Trim();
cmd.Parameters[11].Value = this.dt.Rows[this.BindingContext[dt].Position]["ID_SALESEDU"];
cmd.Parameters[12].Value = this.txtScholl.Text.Trim(); cmd.ExecuteNonQuery();
}
catch (Exception elx)
{
MessageBox.Show(elx.ToString() );
}
finally
{ cnn.Close();
} } }