ASP.NETR Custom classes that import Excel into SQL databases
The following is a reference fragment: public class Savetosql { public string Strnewcodeid = string. Empty; public string Strnewcode = string. Empty; public string strnewdes = string. Empty; public string Stroldcodeid = string. Empty; public string Stroldcode = string. Empty; public string strolddes = string. Empty; public string Server = string. Empty; public string DataBase = string. Empty; public string Uid = string. Empty; public string Pwd = string. Empty; private string tablename = String. Empty; <summary> The name of the destination table </summary> public string Tablenames { Get{return TableName;} Set{tablename=value;} } Public Savetosql () { } <summary> Save data </summary> public void Save () { String Strconpath = String. Format ("server={0};d atabase={1};uid={2};p wd={3}", this. Server,this. Database,this. Uid,this. PWD); SqlConnection con1 = new SqlConnection (Strconpath); Con1. Open (); SqlCommand com1 = new SqlCommand (); Com1.commandtext = "Insert into" +tablename+ "(newcodeid,newcode,newdes,oldcodeid,oldcode,olddes) Values (' +strNewCodeId+ "', '" +strnewcode+ "," "+strnewdes+" ', ' "+stroldcodeid+", "" +stroldcode+ "," "+strolddes+" "; COM1. Connection=con1; COM1. ExecuteNonQuery (); Con1. Dispose (); } } |