sraj44

I want to use a datatable to bind values based upon'if,else if,else' so that my column values change in each condition.how can i do this.please help and emonstrate along with code snippet,Thanks.

[code] <%@Language=VBScript %> <!-- #include file = "connectOracle.asp" --> <%if trim(session("UserName"))<>"" then%> <% Response.Buffer = true SET con = server.CreateObject("adodb.connection") con.open "DSN=VTSDSN;UID=vtsplop;PWD=vts@123" set rs = server.CreateObject("adodb.recordset") set rsdest=server.CreateObject("adodb.recordset") rs.ActiveConnection = con Set ORACON = server.CreateObject("adodb.connection") ORACON.Open "Provider=MSDAORA.1;User ID=SAPVTS;password=VTSSAP;Data Source=prd;Persist Security Info=False" tdate = date() fdate = date()-1 VEHMOV=trim(request("VEHMOV")) trans_code = …

First create a class file with access,oracle,or sql, add data,data.sqlclient() namespace to the class and cs file both, then add the following code in class file { public static bool match(string s) { //to match record or data SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"); SqlCommand cmd = new …