DataGridView中的數(shù)據(jù)在文本中顯示

DataGridView中的數(shù)據(jù)在文本中顯示作者：逆命之心實(shí)現(xiàn)汽車信息的查詢和編輯，可根據(jù)輸入的查詢條件進(jìn)行查詢，也可以僅輸入部分條件。單擊“汽車基本信息”中的汽車信息，將在“汽車詳細(xì)信息”中顯示汽車的詳細(xì)信息1.在數(shù)據(jù)庫中建一個(gè)表CaressinfocreatetableCarsInfo(Carldintprimarykeyidentity(1,1),Brandvarchar(50)notnull,--品牌Typevarchar(50)notnull,--型號Dischaargenumeric(18,1)notnull，--排量GearBoxvarchar(50)notnullcheck(GearBox=*手動(dòng)'orGearBox='自動(dòng)'orGearBox='手自一體'),--變速箱oilUsenumeric(18,1)notnull,--理論耗油Friceintnotnull--報(bào)價(jià))2.創(chuàng)建窗體

變速箱里的內(nèi)容為：不限，自動(dòng)，手動(dòng)，手自一體3.代碼//DataSet實(shí)例化，聲明SqlDataAdapter類型的dsaDataSetda=newDataSet();SqlDataAdapterdsa;〃聲明Select方法用于查詢publicvoidSelect()(this.da.Clear();〃品牌文本框(txtBrand)，排量文本框(txtDischaarge)，變速箱文本框(cmbGearBox)stringstr=this.txtBrand.Text.Trim();stringstr1二this.txtDischaarge.Text.Trim();stringstr2=this.cmbGearBox.Text.Trim();〃判斷各種查詢條件if(!str.Equals(〃〃)&&!str1.Equals(〃〃)&&!str2.Equals(〃〃))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereBrand=+str+〃'andDischaarge='〃+str1+〃'andGearBox='〃+str2+〃'〃；dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}if(!str.Equals("")&&str1.Equals("")&&str2.Equals(""))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereBrand='"+str.〃,〃+ ;dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}if(str.Equals("")&&!str1.Equals("")&&str2.Equals(""))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereDischaarge='"+str1+"'";dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}if(str.Equals("")&&str1.Equals("")&&!str2.Equals(""))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereGearBox='"+str2+"'";dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}if(!str.Equals("")&&!str1.Equals("")&&str2.Equals(""))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereBrand='"+str+"'andDischaarge='"+str1+"'";dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables[〃CarsInfo〃];}if(!str.Equals(〃〃)&&str1.Equals(〃〃)&&!str2.Equals(〃〃))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereBrand='"+str+"'andGearBox='"+str2+"'";dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}if(str.Equals("")&&!str1.Equals("")&&!str2.Equals(""))(stringSql="selectBrand,Type,Dischaarge,GearBox,FricefromCarsInfowhereDischaarge='"+str1+"'andGearBox='"+str2+"'";dsa=newSqlDataAdapter(Sql,Dbhpler.con);dsa.Fill(da,"CarsInfo");this.dgv.DataSource=da.Tables["CarsInfo"];}}privatevoidbtnOk_Click(objectsender,EventArgse)(〃調(diào)用Select方法Select();}//DataGridView的CellClick事件privatevoiddgv_CellClick(objectsender,DataGridViewCellEventArgse)(//當(dāng)前行intindex=e.RowIndex;DataTabletable=(DataTable)this.dgv.DataSource;//在文本框中加載所選中數(shù)據(jù)的信息this.txtBrand1.Text=table.Rows[index]["Brand"].ToString();this.txtDischaarge1.Text=table.Rows[index]["Dischaarge"].ToString();this.txtFrice.Text=table.Rows[index][〃Frice〃].ToString();this.txtType.Text=table.Rows[index][〃Type〃].ToString();this.cmbGearBox1.Text=table.Rows[index][〃GearBox〃].ToString();〃在數(shù)據(jù)庫中查找理論耗油的數(shù)據(jù)stringsql=string.Format(〃selectoilUsefromCarsInfowhereBrand='{0}'andDischaarge='{1}'andFrice={2}andType='{3}'andGearBox='{4}'〃，this.txtBrand1.Text,this.txtDischaarge1.Text,this.txtFrice.Text,this.txtType.Text,this.cmbGearBox1.Text);Dbhpler.con.Open(