摘要： 1 get all columnname select [name] from syscolums where id=object_id('tablename) 2 get all tables select [name] from SysObjects where type='U' 3 get all datatype of system select [xtype],[name] from ... 阅读全文

摘要： Create procedure pre_name @variable list as pro_doby Eg. Create procedure sp_GetUserInformation @userid char(15)=’00001’, @username char(2) output, //which means username is outout @addr... 阅读全文

摘要： when one class just declares its private constructor , then it’s not allowed to derive another class from which and also create an instance of which. Therefore, private construtor class usually o... 阅读全文

摘要： Abstract base bool break box unboxing byte case Catch char checked class const continue Demical default delegate do double else ... 阅读全文

摘要： Problem description: for many developer, they don't care much about Passcode identity. when Logining into the database server ,they just write like this: sql="select * from user where username='"+... 阅读全文

摘要： 1 we must set different template of the datalist object as diffirent appearance, such as itemplate,editplate,headertemplate,footertemplate. in edit template, Update function should have the Updat... 阅读全文

摘要： SqlDataAdapter da = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand("select * from t_upload", conn); da.SelectCommand = cmd; SqlCommandBui... 阅读全文

摘要： The class to process the file and directory mainly include Directory, DirectoryInfo, File, FileInfo Directory : create, move, rename, delete directory with static method . if you will use a directo... 阅读全文

摘要： private void GetFileContents(String FileName) { try { FileInfo inf = new FileInfo(FileName); StreamReader rd = new StreamReader(inf.OpenRead()); ... 阅读全文

摘要： 4. update value in XML file XmlNodeList nodeList=xmlDoc.SelectSingleNode("bookstore").ChildNodes;//获取bookstore节点的所有子节点 foreach(XmlNode xn in nodeList)//遍历所有子节点 { XmlElement xe=(XmlElement)xn... 阅读全文