ADO Extension Properties

1, the class name to expand the same, 2 classes plus (partial)

Small example:

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingsystem.web;usingSystem.Data;usingSystem.Data.SqlClient;/// <summary>///Stores Extended Properties (extension of one Stores Class)/// </summary> Public Partial classstores{PrivateSqlConnection _conn; PrivateSqlCommand _cmd; PrivateSqlDataReader _dr;  PublicStores () {_conn=Dbconnection.conn; _cmd=_conn.    CreateCommand (); }     Public intlogin_id {Get{_cmd.commandtext="SELECT * from Ims_dish_login where [email protected]_username";//go to another table in query ID _cmd. Parameters.addwithvalue ("@Login_Username", This.            Login_username); _conn.            Open (); _DR=_cmd.            ExecuteReader (); intA =0;  while(_DR. Read ()) {a= Convert.ToInt32 (_dr["login_id"]); } _conn.            Close (); returnA; }    }}

ADO Extension Properties