IDC资讯中心
这段代码我没整理过，希望哪位整理一下重新贴上来
using system;
using system.data;
using system.drawing;
using system.collections;
using system.globalization;
using system.windows.forms;
using system.componentmodel;
using system.data.sqlclient;
namespace comboboxindatagrid
{
public class form2:system.windows.forms.form
{
/// <summary>
/// required designer variable.
/// </summary>
private sqldataadapter sqlda;
private sqlcommand sqlselectstudent;
private sqlcommand sqlinsertstudent;
private sqlcommand sqlupdatestudent;
private sqlcommand sqldeletestudent;
private system.componentmodel.container components = null;
private string strsql;
private sqlconnection sqlconn;
private dataset _studentds;
private datatable _coursedt;
private datagridtablestyle gridtablestyle;
private system.windows.forms.button btnupdate;
private system.windows.forms.button btnmovefirst;
private system.windows.forms.button btnmoveprevious;
private system.windows.forms.button btnmovenext;
private system.windows.forms.button btnmovelast;
private system.windows.forms.datagrid datagrid1;
private system.windows.forms.label label1;
private currencymanager objstudentcm;
public form2()
{
//
// required for windows form designer support
//
initializecomponent();
//
// todo: add any constructor code after initializecomponent call
//
}
/// <summary>
/// clean up any resources being used.
/// </summary>
protected override void dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.dispose();
}
}
base.dispose( disposing );
}
#region windows form designer generated code
/// <summary>
/// required method for designer support – do not modify
/// the contents of this method with the code editor.
/// </summary>
private void initializecomponent()
{
this.sqlupdatestudent = new system.data.sqlclient.sqlcommand();
this.sqlconn = new system.data.sqlclient.sqlconnection();
this.sqlda = new system.data.sqlclient.sqldataadapter();
this.sqldeletestudent = new system.data.sqlclient.sqlcommand();
this.sqlinsertstudent = new system.data.sqlclient.sqlcommand();
this.sqlselectstudent = new system.data.sqlclient.sqlcommand();
this.btnmovelast = new system.windows.forms.button();
this.datagrid1 = new system.windows.forms.datagrid();
this.btnupdate = new system.windows.forms.button();
this.btnmovenext = new system.windows.forms.button();
this.btnmovefirst = new system.windows.forms.button();
this.btnmoveprevious = new system.windows.forms.button();
this.label1 = new system.windows.forms.label();
((system.componentmodel.isupportinitialize)(this.datagrid1)).begininit();
this.suspendlayout();
//
// sqlupdatestudent
//
this.sqlupdatestudent.commandtext = @"update student set sno = @sno, sname = @sname, course = @course where (sno = @original_sno) and (course = @original_course or @original_course1 is null and course is null) and (sname = @original_sname or @original_sname1 is null and sname is null); select sno, sname, course from student where (sno = @select_sno)";
this.sqlupdatestudent.connection = this.sqlconn;
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.current, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@sname", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.current, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@course", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.current, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@original_sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.original, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@original_course", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.original, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@original_course1", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.original, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@original_sname", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.original, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@original_sname1", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.original, null));
this.sqlupdatestudent.parameters.add(new system.data.sqlclient.sqlparameter("@select_sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.current, null));
//
// sqlconn
//
this.sqlconn.connectionstring = "data source=localhost;initial catalog=mydata;persist security info=false;user id=" +
"sa;workstation id=nwad-sjalli;packet size=4096";
//
// sqlda
//
this.sqlda.deletecommand = this.sqldeletestudent;
this.sqlda.insertcommand = this.sqlinsertstudent;
this.sqlda.selectcommand = this.sqlselectstudent;
this.sqlda.tablemappings.addrange(new system.data.common.datatablemapping[] {
new system.data.common.datatablemapping("table", "student", new system.data.common.datacolumnmapping[] {
new system.data.common.datacolumnmapping("sno", "sno"),
new system.data.common.datacolumnmapping("sname", "sname"),
new system.data.common.datacolumnmapping("course", "course")})});
this.sqlda.updatecommand = this.sqlupdatestudent;
//
// sqldeletestudent
//
this.sqldeletestudent.commandtext = "delete from student where (sno = @sno) and (course = @course or @course1 is null " +
"and course is null) and (sname = @sname or @sname1 is null and sname is null)";
this.sqldeletestudent.connection = this.sqlconn;
this.sqldeletestudent.parameters.add(new system.data.sqlclient.sqlparameter("@sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.original, null));
this.sqldeletestudent.parameters.add(new system.data.sqlclient.sqlparameter("@course", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.original, null));
this.sqldeletestudent.parameters.add(new system.data.sqlclient.sqlparameter("@course1", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.original, null));
this.sqldeletestudent.parameters.add(new system.data.sqlclient.sqlparameter("@sname", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.original, null));
this.sqldeletestudent.parameters.add(new system.data.sqlclient.sqlparameter("@sname1", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.original, null));
//
// sqlinsertstudent
//
this.sqlinsertstudent.commandtext = "insert into student(sno, sname, course) values (@sno, @sname, @course); select sn" +
"o, sname, course from student where (sno = @select_sno)";
this.sqlinsertstudent.connection = this.sqlconn;
this.sqlinsertstudent.parameters.add(new system.data.sqlclient.sqlparameter("@sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.current, null));
this.sqlinsertstudent.parameters.add(new system.data.sqlclient.sqlparameter("@sname", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "sname", system.data.datarowversion.current, null));
this.sqlinsertstudent.parameters.add(new system.data.sqlclient.sqlparameter("@course", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, true, ((system.byte)(0)), ((system.byte)(0)), "course", system.data.datarowversion.current, null));
this.sqlinsertstudent.parameters.add(new system.data.sqlclient.sqlparameter("@select_sno", system.data.sqldbtype.varchar, 50, system.data.parameterdirection.input, false, ((system.byte)(0)), ((system.byte)(0)), "sno", system.data.datarowversion.current, null));
//
// sqlselectstudent
//
this.sqlselectstudent.commandtext = "select sno, sname, course from student";
this.sqlselectstudent.connection = this.sqlconn;
//
// btnmovelast
//
this.btnmovelast.anchor = (system.windows.forms.anchorstyles.bottom | system.windows.forms.anchorstyles.left);
this.btnmovelast.font = new system.drawing.font("microsoft sans serif", 8.25f, system.drawing.fontstyle.bold, system.drawing.graphicsunit.point, ((system.byte)(0)));
this.btnmovelast.location = new system.drawing.point(128, 264);
this.btnmovelast.name = "btnmovelast";
this.btnmovelast.size = new system.drawing.size(32, 24);
this.btnmovelast.tabindex = 5;
this.btnmovelast.text = "|>";
this.btnmovelast.click += new system.eventhandler(this.btnmovelast_click);
//
// datagrid1
//
this.datagrid1.alternatingbackcolor = system.drawing.color.whitesmoke;
this.datagrid1.anchor = (((system.windows.forms.anchorstyles.top | system.windows.forms.anchorstyles.bottom)
| system.windows.forms.anchorstyles.left)
| system.windows.forms.anchorstyles.right);
this.datagrid1.backcolor = system.drawing.color.gainsboro;
this.datagrid1.backgroundcolor = system.drawing.color.beige;
this.datagrid1.captionbackcolor = system.drawing.color.blue;
this.datagrid1.captionforecolor = system.drawing.color.yellow;
this.datagrid1.datamember = "";
this.datagrid1.forecolor = system.drawing.color.navy;
this.datagrid1.gridlinecolor = system.drawing.color.chocolate;
this.datagrid1.headerbackcolor = system.drawing.color.cadetblue;
this.datagrid1.headerfont = new system.drawing.font("microsoft sans serif", 10f, system.drawing.fontstyle.bold);
this.datagrid1.headerforecolor = system.drawing.color.brown;
this.datagrid1.location = new system.drawing.point(16, 8);
this.datagrid1.name = "datagrid1";
this.datagrid1.preferredcolumnwidth = -1;
this.datagrid1.selectionbackcolor = system.drawing.color.brown;
this.datagrid1.selectionforecolor = system.drawing.color.aqua;
this.datagrid1.size = new system.drawing.size(512, 224);
this.datagrid1.tabindex = 0;
