Generate xml file from sql server in asp.net - ASP.NET Discussion Boards

Re: in 3 tier how can we access in asp.net, how can we make object of them.

Abhijit Jana31-Aug-09 2:48

31-Aug-09 2:48

vaishali.terse wrote:
In Asp.Net 3.5 In One Project 3 solutions are there One is BOl, DAl , Presentation Layer how can access through them.

This is not Only the case of ASP.NET 3.5, this is the normal 3 Tier Architecture for Application Development.
UI/Presentation layer will interact with BAL and BAL will Interact with DAL.

DAL will directly Communicate with Datbase, and BAL should contain the Object of DAL Class. And You should call BAL Object from your UI.

Here is one of the good Example for you,
3-Tier Application with ASP.NET and C#[^]

Hope this will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

calendar popup

ankitjain111031-Aug-09 1:59

ankitjain1110

31-Aug-09 1:59

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page
{
private void calDate_SelectionChanged(object sender, System.EventArgs e)
{
control.Value = calDate.SelectedDate.ToShortDateString();
Response.Write("<script language='javascript'>window.returnValue='" + calDate.SelectedDate.ToString("dd/MM/yyyy") + "';window.close();</script>");
}

protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
private void calDate_SelectionChanged(object sender, System.EventArgs e)
{
control.Value = calDate.SelectedDate.ToShortDateString();
Response.Write("<script language='javascript'>window.returnValue='" + calDate.SelectedDate.ToString("dd/MM/yyyy") + "';window.close();</script>");
}
}
protected void calDate_SelectionChanged1(object sender, EventArgs e)
{
Response.Write("<script language = "javascript">opener.document.getElementById(Request.QueryString["ID"]).value='" + (Calendar1.SelectedDate) + "'; self.close();</script>");
}

}

can anyone help me out wid this code.i just want to generate a popup calendar.
this piece of code is throwing some errors.

i got this code from http://www.codeproject.com/Messages/2246753/calendar-in-popup-window.aspx[^]
plz help me to use this

Re: calendar popup

sashidhar31-Aug-09 2:22

sashidhar

31-Aug-09 2:22

Why Dont You Use Calendar Exrender Controlinstead of script .If this is not your Answer Sorry

Re: calendar popup

ankitjain111031-Aug-09 2:45

ankitjain1110

31-Aug-09 2:45

can u give me some idea of that

Re: calendar popup

Abhijit Jana31-Aug-09 2:54

Abhijit Jana

31-Aug-09 2:54

Can you tell me what is you exact requirment ? Smile | :)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: calendar popup

ankitjain111031-Aug-09 3:00

ankitjain1110

31-Aug-09 3:00

i want to have a calendar inside a dropdown list or attached to a text box.can u help me

Re: calendar popup

Abhijit Jana31-Aug-09 3:14

Abhijit Jana

31-Aug-09 3:14

Below are the two reference which may help you Smile | :)

Creating a Dropdown Calendar Control for ASP.NET[^]
and
Extending the Calendar Control's Date Navigation [^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Generate xml file from sql server in asp.net

.NET- India 31-Aug-09 1:56

.NET- India

31-Aug-09 1:56

Hello Friends,

I'm generating a xml file from sql table in asp.net(c#). Here is my code given below

using (SqlConnection mCon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
{
mCon.Open();

string strsql = "Select * From MakeTable Where Active=1 For XML Auto,ELEMENTS";
//string strsql = "Select * From MakeTable Where Active=1 ";

SqlCommand mDataCom = new SqlCommand();
mDataCom.Connection = mCon;
mDataCom.CommandText = strsql;
mDataCom.CommandTimeout = 15;

DataSet ds = new DataSet();
XmlReader xmlReader = null;
xmlReader = mDataCom.ExecuteXmlReader();
ds.ReadXml(xmlReader);
ds.DataSetName = "Halo";
ds.WriteXml("F://Manoj//Autoneed/Rough//XMLFile2.xml");
}

but it's giving me output as shown here
<MakeTable>
<MakeID>10</MakeID>
<MakeNameID>36</MakeNameID>
<MakeYear>2009</MakeYear>
<Active>1</Active>
</MakeTable>

but if i run my sql command in sql then it's giving me following records
as shown below

<MakeTable>
<MakeID>1</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2009</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>3</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2006</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>4</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2007</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>5</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2005</MakeYear>
<Active>1</Active>
</MakeTable>
<MakeTable>
<MakeID>7</MakeID>
<MakeNameID>17</MakeNameID>
<MakeYear>2004</MakeYear>
<Active>1</Active>
</MakeTable>

can anybody let me know how can i get this output or where and what change i should make in my code or sqlcommand

Re: Generate xml file from sql server in asp.net

compninja2531-Aug-09 4:31

compninja25

31-Aug-09 4:31

What happens if you try this?

while (xmlReader.Read())
{
ds.ReadXml(xmlReader);
ds.DataSetName = "Halo";
ds.WriteXml("F://Manoj//Autoneed/Rough//XMLFile2.xml");
}

Knowledge is not power, however, the acquisition and appropriate application of knowledge can make you a very powerful individual.

Re: Generate xml file from sql server in asp.net

compninja2531-Aug-09 6:16

compninja25

31-Aug-09 6:16

it didn't dawn on me at first glance that you had a dataset in there...so I don't think the above would work. Since it appears to be coming back from the SQL server correctly, what if you avoided the DataSet all together and just saved it straight to a file?

// create a writer and open the file
TextWriter tw = new StreamWriter("output.xml");


while (datareader.read())
{
// write a line of text to the file
tw.WriteLine(datareader.ToString());
}

// close the stream
tw.Close();

Knowledge is not power, however, the acquisition and appropriate application of knowledge can make you a very powerful individual.

Re: Generate xml file from sql server in asp.net

www.Developerof.NET31-Aug-09 7:28

www.Developerof.NET

31-Aug-09 7:28

Is it mandatory for you to write down the file to the server?????

why don`t you try

ds.GetXml();

But remember to fill you dataset with the data.

which actually returns you a XmlDocument. Debug your code and see what results you get in the document object.

When you fail to plan, you are planning to fail.

Div overlapping

meghamaharshi31-Aug-09 1:38

meghamaharshi

31-Aug-09 1:38

Hi all,
I have div with property

there are some more div below this div in different table i am making its visible on click of link its working in IE 7 but not in IE 8.In IE 8 its not visible properly means not expanding its hidden by below text.

Thanks.

Re: Div overlapping

sashidhar31-Aug-09 1:52

sashidhar

31-Aug-09 1:52

Sorry Dude ? I have div with property ..!What is the Question?

Opacity mask in IE8

vikash_singh31-Aug-09 1:38

vikash_singh

31-Aug-09 1:38

hi friends,

On a web page, when iam clicking a button it is displaying a popup
but i applied prop "Opacity" in CSS to that popup. which is not working. mine IE VERSION IS 8.0. where the same opacity is working fine in mozilla firefox.

Could you help me in ASP.Net.

abglorie31-Aug-09 1:19

abglorie

31-Aug-09 1:19

Sorry for the distrubing. Please give your answer.

Now, I want store a picture in database. Later retrieve the picture
from database and show in a page.

1. Which type of datatype to create in SQL?

and

2. How to retrieve from (picture) data and display on IE.

Please give exact coding.
Thanking you,
abglorie

Re: Could you help me in ASP.Net. [modified]

sashidhar31-Aug-09 1:40

sashidhar

31-Aug-09 1:40

It Is Easy To Store And Retrive the image From Database

1)The DataType In sqlServer Is [image]
2) -->First Store the image in byte format
-->Retrieve the Bytes And Conver the Byte In buffer Stream
-->And Display the image in image Control

To Understand More Clearly You Can Refer the Following Article With Example

http://www.beansoftware.com/asp.net-tutorials/images-database.aspx[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129[^]

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

http://www.dotnetspider.com/resources/460-Store-Retrieve-SQL-Server-database.aspx[^]

If the Above Is Helpful Mark It As Answer And let Me Know

modified on Monday, August 31, 2009 7:49 AM

Re: Could you help me in ASP.Net.

Abhijit Jana31-Aug-09 3:10

Abhijit Jana

31-Aug-09 3:10

I am agree what sashidhar suggested,

You can do one more thing, rather than sotring image in DB in byte format, store image in your hard drive and store the path in Database.

Retreive the path from database, and display the image from your hard drive. This will make your task simple.

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

how to open filled page which was not saved due to system has shutdown

itsmitm31-Aug-09 1:08

itsmitm

31-Aug-09 1:08

I have a problem , that
see if a user is filling a information page , after filling more then half, suddenly system automatically shuts down. so again user start the system . so is it possible that when he open that page again, it should be half filled from where the system shut down.

image in ASP.Net

Amit Patel198531-Aug-09 0:49

Amit Patel1985

31-Aug-09 0:49

Hi ,

I want to display image from the particular path in ASP:Image . what is the procedure for this for this.

Thanks,
Amit PAtel

Re: image in ASP.Net

myinstincts31-Aug-09 1:30

myinstincts

31-Aug-09 1:30

add in your project folder the image and in the image url of the image control properties give that path

Re: image in ASP.Net

mylogics31-Aug-09 1:30

mylogics

31-Aug-09 1:30

you shud create image folder in ur own project then only u can access
that image....

Re: image in ASP.Net

Amit Patel198531-Aug-09 2:17

Amit Patel1985

31-Aug-09 2:17

Hi ,

Byte array is coming from the data base at that time i want to display.

Thanks,

Amit PAtel

Re: image in ASP.Net

sashidhar31-Aug-09 2:25

sashidhar

31-Aug-09 2:25

Refer the following Link

http://www.beansoftware.com/asp.net-tutorials/images-database.aspx[^][^]

Re: image in ASP.Net

Abhijit Jana31-Aug-09 2:49

Abhijit Jana

31-Aug-09 2:49

Amit Patel1985 wrote:
Byte array is coming from the data base at that time i want to display.

So you mean, you want to show Image from database ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: image in ASP.Net

Amit Patel198531-Aug-09 3:38

Amit Patel1985

31-Aug-09 3:38

Yes image coming from the data base

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.