我现在想datagridview中添加一行的代码如下:
private void Form1_Load(object sender, EventArgs e)
{ thisAdapter = new SqlDataAdapter("select * from chaxun where Gname='zhengfen'", myconnection);
thisAdapter.Fill(thisDataset, "chaxun");
dataGridView1.DataSource = thisDataset.Tables[0].DefaultView;
if (thisDataset.Tables["chaxun"].Rows.Count == 0)
{
bupdate.Enabled = false;;
bdelete.Enabled = false;
}
BindingSource bind = new BindingSource();
bind.DataSource = thisDataset.Tables["chaxun"];
bindingNavigator1.BindingSource = bind;
} private void insertbutton1_Click(object sender, EventArgs e)
{
string insCmd = "insert into chaxun(Gname,shijian)values(@Gname,@shijian)";
thisAdapter.InsertCommand = new SqlCommand(insCmd, myconnection);
SqlParameter parameter = new SqlParameter("@Gname", SqlDbType.Char, 20);
thisAdapter.InsertCommand.Parameters.Add(parameter);
parameter.SourceColumn = "Gname";
parameter.SourceVersion = DataRowVersion.Current; SqlParameter parametershijian = new SqlParameter("@shijian", SqlDbType.DateTime);
thisAdapter.InsertCommand.Parameters.Add(parametershijian);
parametershijian.SourceColumn = "shijian";
parametershijian.SourceVersion = DataRowVersion.Current;
if (thisDataset.HasChanges())
{
try
{
thisAdapter.Update(thisDataset, "chaxun");
MessageBox.Show("插入!");
bupdate.Enabled = true;
bdelete.Enabled = true;
}
catch(SqlException ex)
{MessageBox.Show("ex.Message");}
}
else
MessageBox.Show("提供详细信息添加!");
//thisAdapter.Update(thisDataset, "chaxun");
}
希望使Gname列的值等文本框textbox输入的值,怎么修改这段程序呀,急用,谢谢各位大虾了!
private void Form1_Load(object sender, EventArgs e)
{ thisAdapter = new SqlDataAdapter("select * from chaxun where Gname='zhengfen'", myconnection);
thisAdapter.Fill(thisDataset, "chaxun");
dataGridView1.DataSource = thisDataset.Tables[0].DefaultView;
if (thisDataset.Tables["chaxun"].Rows.Count == 0)
{
bupdate.Enabled = false;;
bdelete.Enabled = false;
}
BindingSource bind = new BindingSource();
bind.DataSource = thisDataset.Tables["chaxun"];
bindingNavigator1.BindingSource = bind;
} private void insertbutton1_Click(object sender, EventArgs e)
{
string insCmd = "insert into chaxun(Gname,shijian)values(@Gname,@shijian)";
thisAdapter.InsertCommand = new SqlCommand(insCmd, myconnection);
SqlParameter parameter = new SqlParameter("@Gname", SqlDbType.Char, 20);
thisAdapter.InsertCommand.Parameters.Add(parameter);
parameter.SourceColumn = "Gname";
parameter.SourceVersion = DataRowVersion.Current; SqlParameter parametershijian = new SqlParameter("@shijian", SqlDbType.DateTime);
thisAdapter.InsertCommand.Parameters.Add(parametershijian);
parametershijian.SourceColumn = "shijian";
parametershijian.SourceVersion = DataRowVersion.Current;
if (thisDataset.HasChanges())
{
try
{
thisAdapter.Update(thisDataset, "chaxun");
MessageBox.Show("插入!");
bupdate.Enabled = true;
bdelete.Enabled = true;
}
catch(SqlException ex)
{MessageBox.Show("ex.Message");}
}
else
MessageBox.Show("提供详细信息添加!");
//thisAdapter.Update(thisDataset, "chaxun");
}
希望使Gname列的值等文本框textbox输入的值,怎么修改这段程序呀,急用,谢谢各位大虾了!
解决方案 »
- 请推荐一个C#学习QQ群
- 用C#从邮件服务器上面读到的都是一些类似html之类的文件是怎么回事?
- windows mobile中使用datagrid自定义绑定数据
- 带几个问题来跪求各位师兄姐赐教...不胜感激!!!
- C# TreeList 添加节点 ,如何区分是父节点,等等,小弟不会用,希望大家帮忙啊,不使用数据绑定代码添加。。谢谢
- 如何用代码改变richTextBox某一行字体大小和颜色??
- 请问Developer Express中的表格打印预览,怎么设置它的打印默认值,例如A4横打之类?
- 请问在WinForm里怎样用水晶报表
- 请问类如何绑定到datalist上面
- 串口数据?
- C#中的treeview问题
- 会循环引用?
直接赋给你想要设置的单元格。
然后在更行到数据库。
{
string insCmd = "insert into chaxun(Gname,shijian)values(@Gname,@shijian)";
thisAdapter.InsertCommand = new SqlCommand(insCmd, myconnection);
SqlParameter parameter = new SqlParameter("@Gname", SqlDbType.Char, 20);
thisAdapter.InsertCommand.Parameters.Add(parameter);
parameter.SourceColumn = "Gname";
parameter.SourceVersion = DataRowVersion.Current;
parameter.Value=TextBox1.Text;
SqlParameter parametershijian = new SqlParameter("@shijian", SqlDbType.DateTime);
thisAdapter.InsertCommand.Parameters.Add(parametershijian);
parametershijian.SourceColumn = "shijian";
parametershijian.SourceVersion = DataRowVersion.Current;
parametershijian.Value=TextBox2.Text;
if (thisDataset.HasChanges())
{
try
{
thisAdapter.Update(thisDataset, "chaxun");
MessageBox.Show("插入!");
bupdate.Enabled = true;
bdelete.Enabled = true;
}
catch(SqlException ex)
{MessageBox.Show("ex.Message");}
}
else
MessageBox.Show("提供详细信息添加!");
//thisAdapter.Update(thisDataset, "chaxun");
}