📄 form1.cs
字号:
ts.MappingName="good";
DataGridColumnStyle colgoodid = new DataGridTextBoxColumn();
colgoodid.HeaderText="编号";
colgoodid.NullText="0";
colgoodid.MappingName="goodid";
ts.GridColumnStyles.Add(colgoodid);
DataGridColumnStyle colgoodnm = new DataGridTextBoxColumn();
colgoodnm.HeaderText="名称";
colgoodnm.NullText="";
colgoodnm.MappingName="goodnm";
ts.GridColumnStyles.Add(colgoodnm);
DataGridColumnStyle colgoodprice = new DataGridTextBoxColumn();
colgoodprice.HeaderText="单价";
colgoodprice.NullText="0.0000";
colgoodprice.MappingName="goodprice";
ts.GridColumnStyles.Add(colgoodprice);
DataGridColumnStyle colgoodnum = new DataGridTextBoxColumn();
colgoodnum .HeaderText="数量";
colgoodnum .NullText="0";
colgoodnum .MappingName="goodnum";
ts.GridColumnStyles.Add(colgoodnum);
this.dataGrid1.TableStyles.Add(ts);
this.txtid.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11.good, "goodid"));
this.txtnm.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11.good, "goodnm"));
this.txtprice.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11.good, "goodprice"));
this.txtnum.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11.good, "goodnum"));
this.sqlDataAdapter1.Fill(dataSet11,"good");
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void button3_Click(object sender, System.EventArgs e)//保存text中直接修改的信息不成功！！！
{
try
{
this.dataGrid1.UnSelect (this.dataGrid1.CurrentRowIndex);
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
this.sqlDataAdapter1.Update(dataSet11,"good");
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnprev_Click(object sender, System.EventArgs e)
{
try
{
this.dataGrid1.UnSelect(this.dataGrid1.CurrentRowIndex);
if(this.dataGrid1.CurrentRowIndex >0)
this.dataGrid1.CurrentRowIndex --;
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnnext_Click(object sender, System.EventArgs e)
{
try
{
this.dataGrid1.CurrentRowIndex = this.BindingContext[dataSet11.Tables["good"]].Position;
this.dataGrid1.UnSelect(this.dataGrid1.CurrentRowIndex);
this.BindingContext[dataSet11.Tables["good"]].Position++;
this.dataGrid1.CurrentRowIndex = this.BindingContext[dataSet11.Tables["good"]].Position;
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnnewout_Click(object sender, System.EventArgs e)
{
try
{
Form2 frm = new Form2(this);
frm.ShowDialog();
this.sqlDataAdapter1.Fill(dataSet11, "good");
//this.dataGrid1.DataSource = dataSet11;
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnclose_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void btnnewin_Click(object sender, System.EventArgs e)
{
try
{
Form3 frmin = new Form3(this);
frmin.ShowDialog();
this.sqlDataAdapter1.Fill(dataSet11, "good");
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void button1_Click(object sender, System.EventArgs e)
{
currRow = this.dataSet11.Tables[0].Rows[this.BindingContext[this.dataSet11.Tables[0]].Position];
currRow.Delete();
this.sqlDataAdapter1.Update(dataSet11, "good");
}
private void btnlast_Click(object sender, System.EventArgs e)
{
try
{
this.dataGrid1.CurrentRowIndex = this.BindingContext[dataSet11.good ].Position;
this.dataGrid1.UnSelect(this.dataGrid1.CurrentRowIndex);
this.dataGrid1.CurrentRowIndex = this.BindingContext[dataSet11.good ].Count;
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnfirst_Click(object sender, System.EventArgs e)
{
try
{
this.dataGrid1.CurrentRowIndex = this.BindingContext[dataSet11.good].Position;
this.dataGrid1.UnSelect(this.dataGrid1.CurrentRowIndex);
this.dataGrid1.CurrentRowIndex = 0;
this.dataGrid1.Select(this.dataGrid1.CurrentRowIndex);
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void btnnew_Click(object sender, System.EventArgs e)//更新数据未成功！！
{
try
{
this.sqlCommand1.Parameters["@goodid"].Value=txtid.Text;
this.sqlCommand1.Parameters["@goodnm"].Value=txtprice.Text;
this.sqlCommand1.Parameters["@goodprice"].Value=txtprice.Text;
this.sqlCommand1.Parameters["@goodnum"].Value=txtprice.Text;
this.sqlCommand1.ExecuteNonQuery();
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
try
{
Form2 frm = new Form2(this);
frm.ShowDialog();
this.sqlDataAdapter1.Fill(dataSet11, "good");
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void menuItem3_Click(object sender, System.EventArgs e)
{
try
{
Form3 frmin = new Form3(this);
frmin.ShowDialog();
this.sqlDataAdapter1.Fill(dataSet11, "good");
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void menuItem5_Click(object sender, System.EventArgs e)
{
this.Close();
}
private void btnxearch_Click(object sender, System.EventArgs e)
{
try
{
int flagg=0;
for (int i=0; i < this.dataSet11.good.Rows.Count; i++)
{
if(comboBox1.Text==this.dataSet11.good.Rows[i]["goodnm"].ToString())
{
MessageBox.Show("编号: "+this.dataSet11.good.Rows[i]["goodid"].ToString()+'\n'+'\n'+"名称: "+this.dataSet11.good.Rows[i]["goodnm"].ToString()+'\n'+'\n'+"单价: "+this.dataSet11.good.Rows[i]["goodprice"].ToString()+'\n'+'\n'+"数量: "+this.dataSet11.good.Rows[i]["goodnum"].ToString());
flagg=1;
}
}
if(flagg==0)
MessageBox.Show("没有您要找的商品！");
}
catch(Exception err)
{
MessageBox.Show(err.Message);
}
}
private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
{
}
/*//应用存储过程未成功！！！！！！！
CREATE PROCEDURE GetgoodInfo
@goodid int,
@goodnm varchar(50) output,
@goodprice money output,
@goodnum int output
AS
if exists (select * from good where goodid = @goodid)
begin
select @goodnm =goodnm, @goodprice=goodprice, @goodnum=goodnum
from good where goodid = @goodid
return 0
end
return -1
GO
*/
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -