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=22.214.171.124;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 want to fetch invoice data from two tables
table a is in single row and table b data should be multiple rows
single data is fetching correctly but facing ...
hello coders, i hope you all are going well, one thing blows my mind today in c i can't explain it this is why title is akward, so the thing ...
First of, i didn't know where to post this question as it isn't actually programming based but yeah. sorry.. Anyway, I was going through my binary file trying to figure ...