ASP.NET

2-Apr-07 3:20

Try not to repost questions. I answered your other post below.

Ben

XML Upload

rockyl2-Apr-07 2:59

2-Apr-07 2:59

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

gauthee2-Apr-07 3:12

gauthee

2-Apr-07 3:12

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

rockyl2-Apr-07 3:38

2-Apr-07 3:38

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

badgrs2-Apr-07 5:26

badgrs

2-Apr-07 5:26

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.

rockyl2-Apr-07 21:07

2-Apr-07 21:07

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

Nicejith2-Apr-07 20:10

Nicejith

2-Apr-07 20:10

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.

rockyl2-Apr-07 21:04

2-Apr-07 21:04

Thank you, I will try it out...

Rakesh

rockyl11-Apr-07 2:15

Displaying details in a penel from gridview

11-Apr-07 2:15

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

Imthu2-Apr-07 2:46

Imthu

2-Apr-07 2:46

with Regards,
Imthiyas Ahamed.A

Re: Displaying details in a penel from gridview

kubben2-Apr-07 3:19

redirect to google search

2-Apr-07 3:19

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

iamdking2-Apr-07 2:37

iamdking

2-Apr-07 2:37

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?

Re: redirect to google search

gauthee2-Apr-07 3:05

gauthee

2-Apr-07 3:05

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

generating serial number in gridview

Imthu2-Apr-07 2:33

Imthu

2-Apr-07 2:33

hai all,

Can anyone tell me how to generate serial number in
Gridview(ASP2.0)...Thanks in advance

with Regards,
Imthiyas Ahamed.A

Re: generating serial number in gridview

Smitha Appukuttan2-Apr-07 2:54

Smitha Appukuttan

2-Apr-07 2:54

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)

Re: generating serial number in gridview

faiqshah2-Apr-07 7:47

faiqshah

2-Apr-07 7:47

You should have a column say S.No in gridview as

<template column="">

Best Luck

Faiq Afridi

Saving connections & Scope

TimGee2-Apr-07 2:07

TimGee

2-Apr-07 2:07

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

Re: Saving connections & Scope

kubben2-Apr-07 3:05

Re: Saving connections & Scope

2-Apr-07 3:05

I would create new ones in a second procedure.

Ben

TimGee2-Apr-07 3:14

TimGee

2-Apr-07 3:14

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

Deleting registered users

draksa2-Apr-07 1:50

draksa

2-Apr-07 1:50

I am using asp.net login control for authentification. How to delete users that are registered?
Thanks!

Re: Deleting registered users

kubben2-Apr-07 3:10