ASP.NET

How to read data from xml file to dataset [modified]

25-Jul-06 8:35

Im sorry if my post sounded like that, I wasn't angry by any means, Im actually a super nice girl. I was just very tired after working a long day...
To answer your question on "did you wake up one morning and suddenly know EVERYTHING"; no, I am not the all-knowing since I am not God (not even close!). All I did was to try and help out some other person, but you had to start and argue with me.

Nila Fridley

B Desai21-Jul-06 9:56

B Desai

21-Jul-06 9:56

Hello All,
Have some problem, and trying since last two days.
I have a xml file something like this:
I am puting just one node.
- <ROW>
<EVENT_ID>2054767</EVENT_ID>
<EVENT_STATUS>Completed</EVENT_STATUS>
<RESCHD_IND>Y</RESCHD_IND>
<VENUE_CHG_IND>N</VENUE_CHG_IND>
<EVENT_DT>09/23/2004</EVENT_DT>
<EVENT_START_TM>06:30:00 PM</EVENT_START_TM>
<EVENT_END_TM>09:30:00 PM</EVENT_END_TM>
- <CITY>
<CUST_ID>357363</CUST_ID>
<TBGID>1</TBGID>
</CITY>
</ROW>

earlier, I have only data upto <EVENT_END_TM>
and I am able to read it in my dataset easily, using the following code:

System.Xml.XmlNode xNode = somemethod;(this method fetch data from webservice-xml file)
XmlNodeReader xReader = new XmlNodeReader(xNode);
ds.ReadXml(xReader, System.Data.XmlReadMode.Auto);

And I am displaying it directly in datagrid by binding it with dataset.

but now, when I am binding it with datagrid with the same procedure, it only display the column headings, and no data in that.
Can anybody know, how to read this nested node data?
Thank you very much.
Robin

<div class="ForumSig"></div>

-- modified at 16:04 Friday 21st July, 2006

Re: How to read data from xml file to dataset

Grapes-R-Fun21-Jul-06 15:17

Re: How to read data from xml file to dataset

21-Jul-06 15:17

Have you specified an xPath to tell your datagrid which nodes to display from the XML doc? By default, datagrids show tag values and not the text within them.

Nila Fridley

B Desai22-Jul-06 17:20

B Desai

22-Jul-06 17:20

Hi Nila,
Thanks for your help.But I am new in this xml field.If you can explain with a small example it will be a great help to me.
You know the xml file structure of my file.let say, i want to read first two value. can you pz explain using xpath?
Thanks

Re: How to read data from xml file to dataset

Grapes-R-Fun23-Jul-06 8:25

Crystal Reports fail to load in web comonent

23-Jul-06 8:25

Hi Robin,

Sorry for getting back to you so late... if you are trying to capture EVEN_ID and EVENT_STATUS then you need xPath that reads something like this:

/ROW[position()<3]

However, if you want to capture CUST_ID and TBGID then your xPath should be as follows:

/ROW/CITY[position()<3]

xPath is pretty simple; it is the query language of XML, and there are may articles and tutorials available over the Internet in that subject. Just go to google.com and make a search for "xPath tutorial", you'll get a million hits! One site that I like the best is: http://www.w3.org/TR/xpath[^]

Hope that helped you Smile | :)

Nila

icestatue21-Jul-06 9:11

icestatue

21-Jul-06 9:11

While using the Crystal Report SDK and Business Objects Enterprise XI R2 on a web site that is not hosted on the same machine as the Business Objects server all attempts to retrieve a report from any binding senario available from business objects all fail. A sample block of code for any who are curious.

<br />
string temp=null;<br />
string sampleReportName = "Report1.rpt		<br />
SessionMgr sessionMgr = new SessionMgr();<br />
EnterpriseSession enterpriseSession;<br />
EnterpriseService enterpriseService;<br />
EnterpriseService RasService;<br />
InfoStore infoStore;<br />
nfoObjects infoObjects;<br />
InfoObject infoObject;<br />
					<br />
ReportAppFactory reportAppFactory;<br />
ReportClientDocument reportClientDocument;<br />
 enterpriseSession = sessionMgr.Logon           (UserName,password,"BOHost","secEnterprise");<br />
<br />
try<br />
{		<br />
   enterpriseService = enterpriseSession.GetService("BOHost","InfoStore");<br />
//the code dies here if it is hosted on a server other then the B.O. server<br />
RasService = enterpriseSession.GetService("BOHost",","RASReportFactory");<br />
			<br />
 infoStore = new InfoStore(enterpriseService);<br />
 infoObjects = infoStore.Query("Select SI_ID From CI_INFOOBJECTS Where    SI_NAME Like '" + sampleReportName +"'");<br />
<br />
 infoObject = infoObjects[1];<br />
 temp = infoObject.ID.ToString();<br />
<br />
 reportAppFactory = (ReportAppFactory)RasService.Interface;<br />
 reportClientDocument = reportAppFactory.OpenDocument(infoObject.ID,0);<br />
 CrystalReportViewer1.ReportSource = reportClientDocument;<br />
}<br />
catch(Exception et)<br />
{<br />
	temp =et.Message;<br />
	enterpriseSession.Logoff();	<br />
}<br />
enterpriseSession.Logoff();<br />

I wish those dead beats at Business Objects would spend more time fixing their buggy products then going around advertising to all the idiot managers who think this product is the answer to all their problems. We have a saying for this in America that the French don't understand, its called "False Advertising" Thanks again. I will try to stop complaining. Mad | :mad:

nothing

need help about DataView [modified]

mahesh kukkadapu21-Jul-06 9:07

mahesh kukkadapu

21-Jul-06 9:07

In My App, we are reading data from database into a dataView and then binding it to repeater control.
now we want to implement column sort for repeater control.
i know, we can sort data by using dataview sort method.
my question is for each and every time user clicks on repeater column, do we need to make a database call to get data.
Is there some efficient way to store default dataview somewhere, before binding to repeater?
how far it is safe, to use session variable, viewstate variable etc?
Or is there any other alternative?

Thanks
MK

-- modified at 11:27 Monday 24th July, 2006

Re: need help about DataView

leckey21-Jul-06 11:51

leckey

21-Jul-06 11:51

Part of it depends on the type of data. Is it sensitive? Session variables are an easy route but they expire after 20 minutes (unless you change the default setting). I'm not as familiar with viewstates as I either use a session variable or a query string.

Felipe Dalorzo21-Jul-06 7:48

21-Jul-06 7:48

Web Services can't return unknown(generic) types, a web service should explain it self all the time.
It means that what you are doing is not a good a idea

<br />
<WebMethod()> Public Function Test(ByVal sl() as TestList ) As String<br />
        Return sL(1).Value.ToString<br />
End Function<br />

From application AppTest:

<br />
Dim param() As New ArrayList<br />
param.Add(New TestList("N1", "V1", "T1", "S1"))<br />
param.Add(New TestList("N2", "V2", "T2", "S2"))<br />
Response.Write( ws.Test(parm.ToArray( GetType(TestList) ) ) )<br />

I am assuming implicit convertion on of the Array with the array list but you can cast that array to any type you want before passing it to the web service.

Greetings Laugh | :laugh:

FMD

JimFeng21-Jul-06 8:37

JimFeng

21-Jul-06 8:37

Thanks for your reply.

When I tried your code and got the following error:

error BC30311: Value of type 'System.Collections.Generic.List(Of AppTest.ParmList)' cannot be converted to 'Integer'

By the way, on both webservice and application side I have a generic class TestList. It's not unknow type.

Thanks.

Felipe Dalorzo21-Jul-06 10:12

21-Jul-06 10:12

I have some questions 4 u.

What? What r u doing?
Do u know VB.NET? Do u know Web Services?

Not loading ascx in some websites only

JimFeng24-Jul-06 7:04

JimFeng

24-Jul-06 7:04

Can I ask u a Q?
What r u doing here???

SIJUTHOMASP21-Jul-06 6:36

SIJUTHOMASP

21-Jul-06 6:36

Hi,
I am having a strange issue.If any body can hel that would be great.
I am loading an asc file in another ascx file by
ctl=me.loadcontrol("abc.ascx")
and it is showing in a place holder like
plceholder.controls.add(ctl)
It is working in some site but it is not loading in some sites..
Why it is like that...I am very confused..
Thanks much..
RPM..

Non Item Selected on RadioButtonList

Armando_Ramirez21-Jul-06 6:33

Armando_Ramirez

21-Jul-06 6:33

Hi

I have a RadioButtonList Control and I dont have any Item selected.
Is there an instruction that validates if you selected an Item or Not from this RadioButtonList Control???

I would expect something like this in VB:
RadioButtonList1.AnyItemSelected=True

Any ideas??
Thanx ¡¡

Re: Non Item Selected on RadioButtonList

Grapes-R-Fun21-Jul-06 14:45

21-Jul-06 14:45

Armando, you need to test your radio button list items using a foreach statement... Im more confortable with C#, if you are a VB person try to convert the below code to VB syntax

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
foreach (ListItem li in RadioButtonList1.Items)
{
if (li.Selected == true)
{
//execute some instruction
}
}
}

}

Le me know if you are still confused

Nila Fridley

Type.GetType()

Mircea Grelus21-Jul-06 6:10

21-Jul-06 6:10

I'm trying to instantiate a class by name.
The class is in my projects namespace and located in a file in the App_Code folder.

Basically I am calling :
Type tip = Type.GetType("PortalModuleControl");
where PortalModuleControl is the mentioned class;
But tip returns null.
Isn't Type.GetType supposed to look for the definition of the class in the current assembly?

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

Felipe Dalorzo21-Jul-06 8:11

21-Jul-06 8:11

Yes what you are doing is not right...

Here is a the rith way:

<br />
Type type = Type.GetType("MyNameSpace.TheWholeThing.MyClassName, MyNameSpace");<br />

MyAssemblyName issually is the same as the namespace, for instance but not always:

<br />
namespace TQU.Demo{<br />
	public class Test2{<br />
		<br />
	}<br />
}<br />
<br />
namespace TestingTypes<br />
{<br />
	class Class1<br />
	{<br />
<br />
<br />
		[STAThread]<br />
		static void Main(string[] args)<br />
		{<br />
                   Type type = Type.GetType("TQU.Demo.Test2, TestingTypes");<br />
                }<br />
        }<br />
}<br />

Greetings

FDM

Mircea Grelus21-Jul-06 8:28

21-Jul-06 8:28

Type type = Type.GetType("myNameSpace.PortalModuleControl, myNameSpace");
doesn't work either.

I have only one namespace in my application.
I'm dealing with an ASP.NET application. Are there some restrictions regarding this?

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

Felipe Dalorzo21-Jul-06 10:05

21-Jul-06 10:05

Type type = Type.GetType("myNameSpace.PortalModuleControl, MyAssemblyName");

Can you tell me if your namespace is the same as your assembly name.
What's your assembly name?

Mircea Grelus21-Jul-06 10:23

21-Jul-06 10:23

Hmm, I'm guessing it is. My Asp.Net application is running using the ASP.NET Development server which from my understanding acts like IIS and precompiles the code while running. I tried deploying the application but there's no DLL in the bin folder Confused | :confused:

Anyway, from my understanding the assembly doesn't need to be specified when you use Type.GetType. Only when you use Assembly.GetType
Am I wrong?

regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.

Felipe Dalorzo21-Jul-06 10:40

21-Jul-06 10:40

Buddy u got all wrong.
If you don't see the dll in your bin directory it is because either you did not compile it
or you are getting a compilation error.
ASP.NET does not compile the ASP.NET code in runtime, .NET compiles IL in runtime.

If you want to see the your assembly name right click the project and click properties, there are some tabs there one of them will have the assembly name.

Greetings Sniff | :^)

Mircea Grelus21-Jul-06 12:53