public partial class Frmsupadd : Form
{
public string connString = @"Data Source=STU891826ZZ\SQL_NET;Initial Catalog=InventoryMgt;Integrated Security=True"; public Frmsupadd()
{
InitializeComponent();
} private void btnsave_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string sql = "Insert into 供应商表(供应商ID,姓名,年龄,性别,出生地,出生日期,打印条码,地址,部门,记录时间) values ('" + this.txtSupId.Text + "','" + this.txtName.Text + "','" + this.txtAge.Text + "','" + this.txtsex.Text + "','" + this.txtbirthplace.Text + "','" + this.txtbirthday.Text + "','" + this.txtcope.Text + "','" + this.txtaddress.Text + "','" + this.txttime.Text + "','" + this.comboBox1.SelectedValue + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("插入成功!");
ShowEmp();
} private void Frmsupadd_Load(object sender, EventArgs e)
{
ShowEmp();
}
public void ShowEmp()
{
SqlConnection conn = new SqlConnection(connString);
//string sql = "Select * from Employee";
string sql = "select *from 供应商信息";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
}
其中dataGridView1是另一界面中的如何将变量插入dataGridView1中
{
public string connString = @"Data Source=STU891826ZZ\SQL_NET;Initial Catalog=InventoryMgt;Integrated Security=True"; public Frmsupadd()
{
InitializeComponent();
} private void btnsave_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(connString);
conn.Open();
string sql = "Insert into 供应商表(供应商ID,姓名,年龄,性别,出生地,出生日期,打印条码,地址,部门,记录时间) values ('" + this.txtSupId.Text + "','" + this.txtName.Text + "','" + this.txtAge.Text + "','" + this.txtsex.Text + "','" + this.txtbirthplace.Text + "','" + this.txtbirthday.Text + "','" + this.txtcope.Text + "','" + this.txtaddress.Text + "','" + this.txttime.Text + "','" + this.comboBox1.SelectedValue + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("插入成功!");
ShowEmp();
} private void Frmsupadd_Load(object sender, EventArgs e)
{
ShowEmp();
}
public void ShowEmp()
{
SqlConnection conn = new SqlConnection(connString);
//string sql = "Select * from Employee";
string sql = "select *from 供应商信息";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
}
}
其中dataGridView1是另一界面中的如何将变量插入dataGridView1中
上改这个界面的信息 我不想直接去添加。它显示的错误是无法找到dataGridView1 其实就是如何把这两个界面连到一起
DataRow dr=dt.NewRow();
然后给把你的变量放到这个dr里面
再把dr添加到 dt里面:dt.Rows.Add(dr);
this.dataGridView1.DataSource = dt;
if(b.ShowDialog() == DialogResult.OK))
{
调用绑定datagridview的方法;
}FormB中 public FormB(int _id)
{
InitializeComponent();
id=_id;
}private int id; private void FormB_Load(object sender, EventArgs e)
{
通过id查找相应的信息显示在FormB窗口中 }
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
更新信息到数据库;
this.DialogResult = DialogResult.OK;
}
Error 2 The name 'b' does not exist in the current context C:\Documents and Settings\Gem\桌面\InventoryMgt\InventoryMgt\Frmsupadd.cs 25 17 InventoryMgt
的意思是本类中的dataGridView的数据源为ds.Tables[0],而你这个窗体中又没有这个DGV,当然不行。
如果在创建这类实例前已经有了你要显示DGV的窗体,
那是不是可以用Form2.dataGridView1.DataSource = ds.Tables[0];//Form2为你有DGV的窗体