how to do data fetching from two data sources(xml and database) and show into a single control

Question

5.00/5 (1 vote)

See more:

Hello All

I have a task in which i need to show the images into a data list. Data list already contain some images that are coming through the API of templatemonster.com and I want to add some images from my side into the database and those images should be shown into the same data list.
When I created an xml file and inserted data manually into xml file then it is generating an error because in item template field I am using the path of database field so if any one has a good idea about how to show images from database and xml file together on a single data list then please let me know.
If any body can provide code then it will be appreciated

...Thanks in advance.

Posted 5-Nov-12 19:06pm

abhinavashubajpai

Add a Solution

Comments

manognya kota 6-Nov-12 1:19am

Can you please provide code how you are binding the xml and dataset to the data list?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manognya kota · Accepted Answer · 2012-11-05T19:29:00

Solution 1

Hi,

As per my understanding you have a dataset from database and one from xml.
If you are getting dataset from the xml and then binding it to datalist like,

DataSet ds = new DataSet();
           ds.ReadXmlSchema(Server.MapPath("XML/CustomersOrders.xsd"));
           ds.ReadXml(Server.MapPath("XML/CustomersOrders.xml"));
           Yourdatalist.DataSource = ds.Tables["table1"].DefaultView;
           Yourdatalist.DataBind();

you can merge the datatables of this 2 and bind it to the datalist.

Sample code for merging data tables

 datatblAll = datatblOne.Copy();
datatblAll .Merge(datatblTwo);

Hope this helps.

Posted 5-Nov-12 19:29pm

manognya kota

Updated 5-Nov-12 19:31pm

v3

Comments

abhinavashubajpai 6-Nov-12 2:21am

thanks i got the solution but i am not getting the images that are coming from XML file i am sending my code please have a look...

string sTemplateCategory = ddlCategoryName.SelectedValue == "Select Template Category" ? "" : ddlCategoryName.SelectedValue;
Templatecl oTemplatecl = new Templatecl();
DataTable dtTemplate = oTemplatecl.GetTop20Template(sTemplateTypeName, sTemplateCategory);
dtTemplate.Columns.Add("screen", typeof(bool));
PagedDataSource pdsPaging = new PagedDataSource();
pdsPaging.DataSource = dtTemplate.DefaultView;
//----------------------------------------------------

string sFile = Server.MapPath("/testingdata/Arcstemp.xml");
DataSet odatatable = new DataSet();
odatatable.ReadXml(sFile);
PagedDataSource oPageDataSource = new PagedDataSource();
oPageDataSource.DataSource = odatatable.Tables["image"].DefaultView;
DataTable all = new DataTable();
all = odatatable.Tables["image"].Copy();
all.Merge(dtTemplate);
pdsPaging.DataSource = all.DefaultView;
//----------------------------------------------------------

dlTemplates.DataSource = pdsPaging;
dlTemplates.DataBind();
foreach (DataListItem dl in dlTemplates.Items)
{
string sScreenShotUrl = ((HiddenField)dl.FindControl("hdnScreenShotUrl")).Value;
Panel pnlShadowBox = (Panel)dl.FindControl("pnlShadow");
Panel pnlThumbImg = (Panel)dl.FindControl("pnlThumb");
if (sScreenShotUrl != "")
{
pnlShadowBox.Visible = true;
}
else
{
pnlThumbImg.Visible = true;
}
}

please make modification in the code and let me know thanks ..