Create DatabaseGuoji--set up a databaseGo UseGuojiGoCreate TableXinxi--Establish Table I(Namevarchar( -), Minzuvarchar( -))Insert intoXinxiValues('Lisi','101');Insert intoXinxiValues('Wangwu','102');Insert intoXinxiValues('Zhaoliu','103');Select * fromXinxiGoCreate TableMinz--set up table two(Mcodevarchar( -), Mnamevarchar( -))Insert intoMinzValues('101','Han');Insert intoMinzValues('102','Manchu');Insert intoMinzValues('103','Tibetan');GoSelect * fromMinz
Requirements: Query form One, the national part with the Han show out!!!
//Xinxi The manifest of the table
UsingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;namespaceBiao. app_code{ Public classXinxi {Private string_name; Public stringName {Get{return_name;} Set{_name =value;} } Private string_minzu; Public stringMinzu//use this to receive data { Get{return_minzu;} Set{_minzu =value;} } Public stringMinzustr//with this output data { Get{minzdata n=NewMinzdata (); stringm =N.mname (_minzu); returnm; } }
//Data data access classes for Xinxi tablesusingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Data.SqlClient;namespaceBiao. app_code{ Public classXinxidata {SqlConnection CNN=NULL; SqlCommand cmd=NULL; PublicXinxidata () {CNN=NewSqlConnection ("server=.; Database=guoji;user=sa;pwd=123"); CMD=CNN. CreateCommand (); } PublicList<xinxi>Select()//query All information, put the information in the collection{Xinxi x=NULL; List<xinxi> list =NewList<xinxi>(); Cmd.commandtext="SELECT * from Xinxi"; Cnn. Open (); SqlDataReader SS=cmd. ExecuteReader (); if(ss. HasRows) { while(ss. Read ()) {x=NewXinxi (); X.name= ss["name"]. ToString (); X.minzu= ss["Minzu"]. ToString (); List. ADD (x); } } Else{Console.WriteLine ("This table is empty, no data! "); } CNN. Close (); returnlist; }
//Minz The manifest of a tableusingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;namespaceBiao. app_code{ Public classMinz {Private string_mcode; Public stringMcode {Get{return_mcode;} Set{_mcode =value;} } Private string_mname; Public stringMname {Get{return_mname;} Set{_mname =value;} } }}
//data access classes for Minz tablesusingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Data.SqlClient;namespaceBiao. app_code{ Public classMinzdata {SqlConnection CNN=NULL; SqlCommand cmd=NULL; PublicMinzdata () {CNN=NewSqlConnection ("server=.; Database=guoji;user=sa;pwd=123"); CMD=CNN. CreateCommand (); } Public stringMname (stringCode//Check the name according to the number { stringA ="< no >"; Cmd.commandtext="SELECT * from Minz where [email protected]"; Cmd. Parameters.clear (); Cmd. Parameters.Add ("@a", code); Cnn. Open (); SqlDataReader SS=cmd. ExecuteReader (); if(SS. HasRows)//Do you have this data{ss. Read (); A= ss[1]. ToString (); } Else{Console.WriteLine ("data table is empty"); } CNN. Close (); returnA; } }}
//The main function of the program classusingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingBiao. App_Code;namespacebiao{classProgram {Static voidMain (string[] args) {Xinxidata a=NewXinxidata (); List<xinxi> list = A.Select(); foreach(Xinxi binchList//iterate through the collection query all content{Console.WriteLine (b.name+" "+B.minzustr);//output statements with B.minzustr} console.readline (); } }}
Finish!!
ADO SQL Property Extension ———— Multi-table group composition new more complete table