Hi guys how can I insert multiple xml files in one table.
could you provide more information/example? This is really unclear.
i have 3 xml files and i want to insert them in database in one single table . Let me know what you dont understand.
alright guys i got it.below is the way how you can achieve this
string myString = "";
string sXMLFilePath = "C:\\Dict1.txt";
XmlDocument document = new XmlDocument();
XmlNodeList nodelist = document.SelectNodes("ArrayOfString/string");
SqlConnection cn = new SqlConnection(@"Server=18.104.22.168;Database=RTLUser;UID=sa;");
SqlDataAdapter da = new SqlDataAdapter();
foreach (XmlNode node in nodelist)
string coll = node.InnerText.Replace("'","''");
myString = @"INSERT INTO levelTbl(word,level) Values('" + coll + "','" + "1" + "')";
SqlCommand myCmd = new SqlCommand(myString, cn);
I was wondering if it was possible to create a software like visual studio (in addition simple, obviously). We could program in vb.net, c ++, etc.
Write a looping program for Theater Seating selection
The program will display the theater seating (shown later) and prompt the user to select a seat to purchase using the row ...
Hi Maam and Sir.
I need your expertise on vb.net.
I have two data grid with database on their own. I want to copy/update the data from one database to ...