ASP.NET学习基础一：连接SQLSERVER数据库

String constr="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=dianxinkapin;Data Source=192.168.0.10";

String command="select * from comeout"; 

OleDbConnection myConn = new OleDbConnection(constr) ;

myConn.Open ( ) ;

//创建一个 DataSet

DataSet  myDataSet = new DataSet ( ) ;

//用 OleDbDataAdapter 得到一个数据集

OleDbDataAdapter myCommand = new OleDbDataAdapter (command,constr ) ;

//把Dataset绑定person数据表

myCommand.Fill (myDataSet,"comeout") ;

//关闭此OleDbConnection

myConn.Close () ;

2、与DATAGRID绑定

String constr="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=dianxinkapin;Data Source=new";

String command="select * from comeout"; 

OleDbConnection myConn = new OleDbConnection(constr) ;

myConn.Open ( ) ;

//创建一个 DataSet

DataSet  myDataSet = new DataSet ( ) ;

//用 OleDbDataAdapter 得到一个数据集

OleDbDataAdapter myCommand = new OleDbDataAdapter (command,constr ) ;

//把Dataset绑定person数据表

myCommand.Fill (myDataSet,"select * from comeout") ;

//关闭此OleDbConnection

//DataRow dr = myDataSet.Tables["comeout"].Rows.Count .Rows[1];

//DataRow dr = ds.Tables["comeout"].Rows[1];

OleDbCommand myCmd1=new OleDbCommand(command,myConn);

OleDbDataReader Dr1=myCmd1.ExecuteReader();

DropDownList1.Items.Clear();

while(Dr1.Read())

{

DropDownList1.Items.Add(Dr1["卡类"].ToString());

}

Dr1.Close();

myConn.Close () ;

DataGrid1.AutoGenerateColumns = false;

DataGrid1.Columns.Clear();

EditCommandColumn editbtn=new EditCommandColumn();

editbtn.HeaderText="记录操作";

editbtn.EditText="修改";

editbtn.UpdateText="提交";

editbtn.CancelText="撤消";

//editbtn.ButtonType=ButtonColumnType.PushButton;

DataGrid1.Columns.Add(editbtn);

ButtonColumn com=new ButtonColumn();

com.HeaderText="选择";

com.Text="选择";

com.ButtonType=ButtonColumnType.PushButton;

DataGrid1.Columns.Add(com);            

BoundColumn col = new BoundColumn();

col.HeaderText="出库编号";

col.DataField="出库编号";

col.ReadOnly=true;

DataGrid1.Columns.Add(col);

col = new BoundColumn();

col.HeaderText="出库日期";

col.DataField="出库日期";

DataGrid1.Columns.Add(col);

。。。。。。

DataGrid1.DataSource = myDataSet.Tables[0];

//DataGrid1.DataMember="comeout";

DataGrid1.DataBind();

选择按钮的事件在DataGrid1_ItemCommand事件中写

TableRow tr = e.Item;

//获取每个TableCell的数据

TextBox1.Text= tr.Cells[2].Text;

TextBox2.Text= tr.Cells[3].Text;

TextBox3.Text= tr.Cells[4].Text;

if (tr.Cells[5].Text!="")

list.Items[list.SelectedIndex].Text= tr.Cells[5].Text;

TextBox5.Text= tr.Cells[6].Text;

TextBox6.Text= tr.Cells[7].Text;

TextBox7.Text= tr.Cells[8].Text;

TextBox8.Text= tr.Cells[9].Text;

TextBox9.Text= tr.Cells[10].Text;

TextBox10.Text= tr.Cells[11].Text;

TextBox11.Text= tr.Cells[12].Text;

DataGrid1.SelectedIndex= (int)e.Item.ItemIndex;

修改按钮的事件在DataGrid1_EditCommand事件中写

DataGrid1.EditItemIndex = (int)e.Item.ItemIndex;

TextBox1.ReadOnly=true;

datagridbuild();

提交按钮的事件是在DataGrid1_UpdateCommand事件中写

string s2=((TextBox)e.Item.Cells[3].Controls[0]).Text;

string s3=((TextBox)e.Item.Cells[4].Controls[0]).Text;

string s4=((TextBox)e.Item.Cells[5].Controls[0]).Text;

string s6=((TextBox)e.Item.Cells[7].Controls[0]).Text;

string s8=((TextBox)e.Item.Cells[9].Controls[0]).Text;

string s10=((TextBox)e.Item.Cells[11].Controls[0]).Text;

string s11=((TextBox)e.Item.Cells[12].Controls[0]).Text;

int i1=Int32.Parse(e.Item.Cells[2].Text);

int i5=Int32.Parse(((TextBox)e.Item.Cells[6].Controls[0]).Text);

double f7=double.Parse(((TextBox)e.Item.Cells[8].Controls[0]).Text);

double f9=double.Parse(((TextBox)e.Item.Cells[10].Controls[0]).Text);

//更新数据库中的数据       

   

string strUpdate = "Update comeout Set 出库编号='"+i1+"',出库日期='"+s2+"',领卡单位='"+s3+"',卡类='"+s4+"',数量='"+i5+"',面值价='"+s6+"',面值金额='"+f7+"',折扣率='"+s8+"',折扣额='"+f9+"',领卡人='"+s10+"',备注='"+s11+"'  Where 出库编号='"+i1+"'";

string constr="Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=dianxinkapin;Data Source=new";

 

OleDbConnection myConn = new OleDbConnection(constr) ;

myConn.Open ( ) ;

OleDbCommand MyComm = new OleDbCommand(strUpdate,myConn);

MyComm.ExecuteNonQuery();

myConn.Close(); 

DataGrid1.EditItemIndex = -1;

TextBox1.ReadOnly=false;

datagridbuild();

取消按钮的事件是在DataGrid1_CancelCommand事件中写

DataGrid1.EditItemIndex = -1;

TextBox1.ReadOnly=false;

datagridbuild();//动态绑定DataGrid1

分页控制在DataGrid1_PageIndexChanged事件中写

DataGrid1.CurrentPageIndex = e.NewPageIndex;

datagridbuild();//这是datagrid数据绑定的过程