Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -
i student , quite new programming, , given task using asp.net , c#, without being taught either. plan learn teach ourselves.
the task stuck on making website import csv file sql server database of last year's room bookings around campus.
the table has following columns:
request_id; priority; module_id; day; start_time; length; park; students; room_code; status; semester_id; linked_request; week_1; week_2; week_3; week_4; week_5; week_6; week_7; week_8; week_9; week_10; week_11; week_12; week_13; week_14; week_15; ) in code, try make work 3 columns (request_id,priority,module) starters.
when press import button, want read .csv file (with fixed name @ fixed directory) eg "1,2,3" - comma separating fields [delimiter] - , import sql server database. want data grid show well.
something this:
visual studio build code, when press "import" button, nothing happens. have been experimenting days code, , can't pinpoint mistake is. since deadline coming tomorrow, grateful if tell me missing.
here code:
aspx:
<!doctype html> <script runat="server"> protected sub import_button_click(sender object, e eventargs) end sub protected sub page_load(sender object, e eventargs) end sub </script> <html lang="en"> <head> <meta charset="utf-8"> <title>timetabling support website</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- loading bootstrap --> <link href="css/bootstrap.css" rel="stylesheet"> <!-- loading flat ui --> <link href="css/flat-ui.css" rel="stylesheet"> <!-- loading unsemantic --> <link href="css/unsemantic-grid-responsive.css" rel="stylesheet"> <!-- loading personalized style --> <link href="css/style.css" rel="stylesheet"> <link rel="shortcut icon" href="images/favicon.ico"> <!-- html5 shim, ie6-8 support of html5 elements. other js @ end of file. --> <!--[if lt ie 9]> <script src="js/html5shiv.js"></script> <![endif]--> </head> <body> <form id="form1" runat="server"> <div class="grid-container"> <div class="header grid-100"> <div class="banner grid-70"> <img src="images/banner3.png" id="banner" alt="loughborough uni logo" /> </div> <div class="logout grid-30"> <p id="logout"> welcome, computer science timetabler. | <a href="index.html">logout</a></p> </div> </div> <div class="navbar navbar-inverse"> <div class="navbar-inner"> <ul class="nav"> <li> <a href="home.html"> home </a> </li> <li> <a href="#"> requests </a> <ul> <li> <a href="request_new.html">new request</a> </li> <li> <a href="request_import.html">import requests</a> </li> <li> <a href="request_current.html">current requests</a> </li> <li> <a href="request_adhoc.html">ad-hoc request</a> </li> </ul> <!-- /sub menu --> </li> <li> <a href="room_availability.html"> room availability </a> </li> <li> <a href="#"> history </a> <ul> <li> <a href="#">semester 1</a> <ul> <li> <a href="history_s1priority.html">priority round</a> </li> <li> <a href="history_s1round1.html">round 1</a> </li> <li> <a href="history_current.html">round 2</a> </li> <li> <a href="history.html">final allocations</a> </li> </ul> <!-- /sub menu --> </li> <li> <a href="#">semester 2</a> <ul> <li> <a href="history.html">priority round</a> </li> <li> <a href="history.html">round 1</a> </li> <li> <a href="history.html">round 2</a> </li> <li> <a href="history.html">final allocations</a> </li> </ul> <!-- /sub menu --> </li> </ul> <!-- /sub menu --> </li> <li> <a href="#"> maintenance </a> <ul> <li> <a href="module_add.html">add module</a> </li> <li> <a href="module_edit.html">edit module</a> </li> </ul> <!-- /sub menu --> </li> <li> <a href="help.html"> </a> </li> </ul> </div><!--/.nav-collapse --> </div> <div class="content center"> <h1>import request <asp:gridview id="gridview1" runat="server" datasourceid="sqldatasource1" autogeneratecolumns="false"> <columns> <asp:boundfield datafield="request_id" headertext="request_id" sortexpression="request_id" /> <asp:boundfield datafield="priority" headertext="priority" sortexpression="priority" /> <asp:boundfield datafield="module_id" headertext="module_id" sortexpression="module_id" /> </columns> </asp:gridview> </h1> <asp:button id="button1" runat="server" text="import" onclick="import_button_click" style="height: 26px"/> </div> <div class="grid-100 footer"> <p>copyright © 2013 team 3 timetabling support website</p> </div> </div> <!-- /container --> <asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:team03connectionstring %>" selectcommand="select * [archive]"></asp:sqldatasource> <!-- load js here greater =============================--> <script src="js/jquery-1.8.2.min.js"></script> <script src="js/jquery-ui-1.10.0.custom.min.js"></script> <script src="js/jquery.dropkick-1.0.0.js"></script> <script src="js/custom_checkbox_and_radio.js"></script> <script src="js/custom_radio.js"></script> <script src="js/jquery.tagsinput.js"></script> <script src="js/bootstrap-tooltip.js"></script> <script src="js/jquery.placeholder.js"></script> <script src="http://vjs.zencdn.net/c/video.js"></script> <script src="js/application.js"></script> <!--[if lt ie 8]> <script src="js/icon-font-ie7.js"></script> <script src="js/icon-font-ie7-24.js"></script> <![endif]--> </form> </body> </html> c#:
using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; using microsoft.visualbasic.fileio; using system.data.sqlclient; namespace importpage { public class csvfile { public int request_id { get; set; } public int priority { get; set; } public int module_id { get; set; } //... } public class csv { public string getconnectionstring() { return system.configuration.configurationmanager.connectionstrings["team03connectionstring"].connectionstring; } protected void import_button_click(object sender, eventargs e) { //string request_id2 = ""; list<csvfile> entries = new list<csvfile>(); using (textfieldparser parser = new textfieldparser(@"previousyear.txt")) { parser.textfieldtype = fieldtype.delimited; parser.delimiters = new string[] { "," }; string[] fields; while (!parser.endofdata) { fields = parser.readfields(); entries.add(new csvfile() { request_id = convert.toint32(fields[0]), priority = convert.toint32(fields[1]), module_id = convert.toint32(fields[2]) //... }); } } using (sqlconnection conn = new sqlconnection(getconnectionstring())) { string sql = "insert requests (priority, module_id) output inserted.request_id values (@priority, @module_id)"; try { conn.open(); foreach (csvfile entry in entries) { using (sqlcommand cmd = new sqlcommand(sql, conn)) { cmd.parameters.addwithvalue("@priority", entry.priority); cmd.parameters.addwithvalue("@module_id", entry.module_id); // ... cmd.executenonquery(); } } } catch (system.data.sqlclient.sqlexception ex) { string msg = "insert error:"; msg += ex.message; throw new exception(msg); } catch (formatexception ee) { system.web.httpcontext.current.response.write("<script language='javascript'>alert('please enter valid value');</script>"); } catch (system.exception eeee) { system.web.httpcontext.current.response.write("<script language='javascript'>alert('system exception');</script>"); } } } } } thanks in advance. form of appreciated.
looks on right track. import button looks wired empty import_button_click method in .aspx page when should wired import_button_click method in csv class. since first method empty, nothing happens.
Comments
Post a Comment