|
Hi,
I need to read the contents of a xml file and upload them into a database.
Do we have any xml specific class which could be used in this scenario.
Thanks in Advance:
Rakesh
|
|
|
|
|
Using XmlDocument you can load your xml file.
The namespace would be System.Xml
You can use the Xml Path to acces your nodes in your xml file accordingly.
To see more examples on xpath refer w3schools.com
Gautham
|
|
|
|
|
Thanks for the response
I am already using XMLDocument class. Let me tell you what exactly I am doing:
I am reading one set of record of an xml file and opening a SQL connection and inserting the data and then closing the connection. If I have 100 set of records in the XML file then my application opens connection 100 times which I dont see appropriate. I want to do it at one short. Read all the sets from the xml file, open the connection and insert all the records and close it.
Do we have any way to do this?
Rakesh
|
|
|
|
|
Why are you opening and closing the connection? Why not open the connection and command object, loop through the records in the XML file building the SQL on the fly each time and runnning the query. Only close the connection once your done.
|
|
|
|
|
Yah thats really a simple idea.
But I see one issue here. Let say that there are 100 sets of employee records in the xml file and the process finished inserting 60 of the records and suddenly the connection is lost, then what must be done. I mean how can we track the record to be inserted next.
Thanks:
Rakesh
|
|
|
|
|
I think its very easy to use the Dataset method..
ie use the namespace System.Data
then code as follows
Dataset Ds;
ds.ReadXml(xmlfilepath);
here if you check the dataset viewer, you can see all the xml contents as tables.
from there you can extract data and put it in database.
|
|
|
|
|
Thank you, I will try it out...
Rakesh
|
|
|
|
|
I have implemented your suggestion, but facing some issues:
Below is the code I have used:
protected void Button1_Click(object sender, EventArgs e)
{
string path = @"D:\emp.xml";
string dsTable = "";
string connectionString = @"Server = DB\SQL2; Database = CWBDB; user = sa; password = sa";
DataSet ds = new DataSet("EMPDS");
ds.ReadXml(path);
foreach (DataTable t in ds.Tables)
{
dsTable = t.ToString();
}
SqlConnection con = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
da.TableMappings.Add("EMP", dsTable);
if ((da.Update(ds))>0)
{
Label1.Text = "Uploaded the data successfully";
}
else
{
Label1.Text = "Could not Upload the data";
}
}
But I see an exception:
"Update unable to find TableMapping['Table'] or DataTable 'Table'."
Please let me know what needs to be done for this!
Rakesh
|
|
|
|
|
hai all,
I am having a gridview.. if i click select button in a row..
the details shuold display in a seperate panel below.i tried
writing visiblity in selectedpage index event.. but its not
working...can anyone help me with this......
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
If your select button is not doing a post back, there won't be anything to show since the panel didn't get rendered. So make sure the select button is doing a postback. Then on the gridview rowcommand you can see the command is Select so that that point you can make your panel visible. I would actually get rid of the panel and use a PlaceHolder. Those work much better to show and hide controls on an asp.net page.
Hope that helps.
Ben
|
|
|
|
|
Hi all, I want to redirect searching to google.co.in. The user must get redirected to google page showing the desired keyword..what to do?
|
|
|
|
|
Response.Redirect("http://www.google.co.in/search?hl=en&q=KEYWORD&meta")
If your keyword is long concatenate with '+' symbol.
For example if your search text is ' what is my name ' then you could give what+is+your+name as the keyword in the url.
Gautham
|
|
|
|
|
hai all,
Can anyone tell me how to generate serial number in
Gridview(ASP2.0)...Thanks in advance
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
hope this will help
create a static variable
if u have enabled paging in grid then
in pageindexchanging event set the static variable to e.newpageindex*5(no:of rows per page)
in row_created event
if(e.row.rowindex>0)
(LinkButton)e.row.cells[1].controls[0]).text=Convert.tostring(e.row.rowindex+1+staticvariable)
|
|
|
|
|
You should have a column say S.No in gridview as
<template column="">
Best Luck
Faiq Afridi
|
|
|
|
|
Hi,
Could anyone point me in the right direction.
I have a procedure that populates a DataSet with details from a database, it uses connections, dataadapters and commandbuilder objects. The DataSet is then stored in the session object and displayed to the user for editing etc (this might be done on different pages). At a later stage the changes made by the user need to be updated back to the database using a different procedure, do I need to use the same dataadapter / commandbuilder / sqlcommand objects I originally used to create the DataSet, or can I simply create new ones in the second procedure?
Thanks
Tim
|
|
|
|
|
I would create new ones in a second procedure.
Ben
|
|
|
|
|
Thanks Ben,
I wasn't sure if the DataSet object had some sort of connection / memory of the objects that created it, and thus needed the same objects for updating the database.
Cheers
Tim
|
|
|
|
|
I am using asp.net login control for authentification. How to delete users that are registered?
Thanks!
|
|
|
|
|
There is a aspnet_membership table. Find the user based off email and delete them.
I would delete based off userid
Select * from aspnet_membership where email = 'puttheiremailhere'
Then based off the userid returned
delete from aspnet_membership where userid = 'thisisaGUID'
NOTE if you didn't want to delete the logins, but wanted to disable them there is a IsApproved flag that you can set to 0. This is also the table to check if they typed their password too many times and locked themselves out. There is a IsLockedOut flag as well.
Hope that helps.
Ben
|
|
|
|
|
I think using Membership.DeleteUser(username); is easier.
|
|
|
|
|
how to connect ASP.net and COM+ which are running in two machines?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi all,
Am using editor and multiline textbox.user selects one of it by using radio button.I used 2 required field validators,to validate those 2 controls.
Its all fine upto here.In the button click event,in Internet explorer its working fine by displaying appropriate error message, but in mozilla it is showing two error messages at a time.
I hard coded these validators visibility to false in the appropriate radio button selected value loop.
Pls guide me any other way to forward
Have a Nice Day Dudes
|
|
|
|
|
All I have to say is what the F**K was microsoft thinking when they made the textbox component this way. Microsoft left no easy way to trap the error code coming off a detected client side script attack. It makes no sense that there is no event to capture when a detected validation has failed. The work arounds to make something as simple as string x = Textbox.Text; is rediculous. If you work at Microsoft and you read this all I have to say is EAT MY ASS!
nothing
|
|
|
|
|
The time shown at the bottom of the page in Last Visit is : 6:22 Monday 2nd April, 2007. But the actual time (in India) was 4:15pm Monday 2nd April 2007. The later is the same date/time on pc as well at that instance. What could be the problem? How can I obtain the time/date from the zone where the client is located?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
