StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POC# NULL VALUES BEING INSERTED IN DB
text
Body
copied!<p>I am reading an XML file and saving the extracted data according to the elements of the XML file. I am using XmlReader. BUT WHEN I AM RUNNING THE PROGRAM ... IT RUNS FINE BUT, only NULL values are being sent into my db. My codes are as follows :</p> <pre><code> using System; using System.Xml; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using System.Data; public partial class _Default : System.Web.UI.Page { string org_id; string org_desig; string org_name; string add_1; string add_2; string add_3; string cityname; string countrycode; string countryname; string postalcode; protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { // Load the XML file XmlTextReader reader = new XmlTextReader("PXMLF-8612013050420130606105906.xml"); // Loop over the XML file while (reader.Read()) { // look for element if (reader.NodeType == XmlNodeType.Element) { // If the element is the one required if (reader.Name == "OrganizationID") { org_id = (reader.ReadElementString()); } if (reader.Name == "OrganisationDesignator") { org_desig = (reader.ReadElementString()); } if (reader.Name == "OrganizationName1") { org_name = (reader.ReadElementString()); } if (reader.Name == "AddressLine1") { add_1 = (reader.ReadElementString()); } if (reader.Name == "AddressLine2") { add_2 = (reader.ReadElementString()); } if (reader.Name == "AddressLine3") { add_3 = (reader.ReadElementString()); } if (reader.Name == "CityName") { cityname = (reader.ReadElementString()); } if (reader.Name == "CountryCode") { countrycode = (reader.ReadElementString()); } if (reader.Name == "CountryName") { countryname = (reader.ReadElementString()); } if (reader.Name == "PostalCode") { postalcode = (reader.ReadElementString()); } //populate table data from extracted values //connect to db string connStr = ConfigurationManager.ConnectionStrings["connXML"].ConnectionString; SqlConnection con = new SqlConnection(connStr); con.Open(); //send extracted data to db SqlCommand cmd = new SqlCommand(); cmd.CommandText = "insert into INV_HEADER VALUES ('" + org_id + "','" + org_desig + "', '" + org_name + "' , '" + add_1 + "', '" + add_2 + "', '" + add_3 + "', '" + cityname + "', '" + countrycode + "', '" + countryname + "', '" + postalcode + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con; cmd.ExecuteNonQuery(); con.Close(); reader.Close(); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload