|
Hi guyzz.. Im developing a web application here i get datas from the user and on a button click these datas get stored in my data base now i have another button on clicking it,it retrieves all the data from the database and gets saved in my system as an XML file... the code is as follows for the button that creates an xml file...
private void Button1_Click(object sender, System.EventArgs e)
{
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details",con);
DataSet ds = new DataSet();
da.Fill(ds,"card_details");
ds.WriteXml("D:\ADIB\OutputXML.xml");
}
catch(SqlException ex)
{
throw new System.Exception ("Error -- " +ex.Message);
}
catch(Exception exp)
{
throw new System.Exception ("Error -- " +exp.Message);
}
finally
{
con.Close();
da.Dispose();
}
}
Now my issue is i need my application to create the xml file,before saving it into my system it should ask me whether to open the file or save the file so that i can specify the file name (something similar to a download window in our web browser)... please advice me...
Thanx in advance..
Regards,
Tash
|
|
|
|
|
Maybe use something like SaveFileDialog[^] 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Im using VS2003 framework1.1
Any other ideas or any other ways do please let me know....
Thanx in advance
Regards,
Tash
modified on Wednesday, February 3, 2010 11:05 PM
|
|
|
|
|
Sorry it dint work.. Im using VS2003... plz advice me...
Thanx in advance..
Regards,
Tash
|
|
|
|
|
Any ideas or any ways do please let me know......
Regards,
Tash
|
|
|
|
|
use below code
private void button1_Click(object sender, EventArgs e)
{
saveFileDialog1.FileOk += new CancelEventHandler(saveFileDialog1_FileOk);
saveFileDialog1.ShowDialog(this);
}
void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
SaveFileDialog ss = sender as SaveFileDialog;
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(ss.FileName);
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}
}
saveFileDialog1 is SaveFileDialog type win control.
|
|
|
|
|
Hi thanx for ur reply... My problem is not solved yet... as u said when i type saveFileDialog1. i dont find "FileOk"... i dont know why... may be its because im using VS2003??? plz help me...
Thanx in advance...
Regards,\
Tash
|
|
|
|
|
Following code should solve your problem:
Response.Clear();
Response.ContentType = "text/plain";
Response.WriteFile("D:\\ADIB\\OutputXML.xml");
Response.Flush();
|
|
|
|
|
I wrote my code in VS 2008. Under dialog section of toolbox you can get the specified control.
TRY this Code
System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();
saveFileDialog.Filter = "XML Files (*.xml)|*.*";
if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
{
string FileName = saveFileDialog.FileName;
if (FileName.Trim() != "")
{
}
}
|
|
|
|
|
I did as u said.. but got an error in this line --->
if (saveFileDialog.ShowDialog(this) == DialogResult.OK)
The error stated was --->
<br />
The best overloaded method match for 'System.Windows.Forms.CommonDialog.ShowDialog(System.Windows.Forms.IWin32Window)' has some invalid arguments<br />
Thanx in advance...
Regards,
Tash
|
|
|
|
|
try this
if (saveFileDialog.ShowDialog() == DialogResult.OK)
|
|
|
|
|
Hi.. now ther was no build errors but after execution.. when i click my button to create Xml file i receive the following exception --->
<br />
It is invalid to show a modal dialog or form when the application is not running in UserInteractive mode. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.<br />
And the line in which this exception ocuurs -->>
if (saveFileDialog.ShowDialog() == DialogResult.OK)
thanx in advance..
Regards,
Tash
|
|
|
|
|
I think you are not use win form application . Is that true if it is then you can't do it using previous procedure.Please use a Custom pop up to do this.
|
|
|
|
|
Ohh no.. so what am i supposed 2 do??? any idea???
regards,
tash
|
|
|
|
|
This will help you much , I think it works fine 
Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}
modified on Thursday, February 4, 2010 6:01 AM
|
|
|
|
|
Try this i think it will help you;
Response.ContentType = "text/xml"; <br />
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");<br />
Response.TransmitFile(Server.MapPath("~/images/sailbig.jpg"));<br />
SqlDataAdapter da = null;<br />
try<br />
{<br />
con = new SqlConnection();<br />
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];<br />
da = new SqlDataAdapter("select * from card_details", con);<br />
DataSet ds = new DataSet(); da.Fill(ds, "card_details");<br />
ds.WriteXml(Response.OutputStream);<br />
Response.End();<br />
}<br />
catch (SqlException ex)<br />
{<br />
throw new System.Exception("Error -- " + ex.Message);<br />
}<br />
catch (Exception exp)<br />
{<br />
throw new System.Exception("Error -- " + exp.Message);<br />
}<br />
finally<br />
{<br />
con.Close(); da.Dispose();<br />
}<br />
<br />
}
|
|
|
|
|
use ...
Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}
|
|
|
|
|
I think , The below code will help you much
Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}
|
|
|
|
|
Hi all
When i tried to send email from my website,the mail is going to Queue folder in the server and stayed there and after sometimes some mails will go to my mailbox.Why this happen? If anyone knows about this problem,please help me.
Thanks
Denny
|
|
|
|
|
Member 4260270 wrote: When i tried to send email from my website
I guess you are talking about SMTP Server Queue. Does your SMTP configured properly ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi All,
I created a website using Visual Studio 2005 ASP.NET. Can I run this on a 3rd party server? I purchased a 3rd party web hosting plan ( www.znetindia.com) which supports ASP.NET/SQL/MS Access features.
Can someone tell me how to do this, any links,reference would be useful.
Regards
R.S
|
|
|
|
|
jeshra279 wrote: I purchased a 3rd party web hosting plan
Its not Free right..?
So ask them .they can give better support then us..!
When u Purchase from them, they will be support team from the site hosters..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Hi,
I am having an web site that, two sections.
the first section will have the labels,
and the second section will have the repeater controls,
as per condition the repeater control take some time to load,
so the user does not now what happens as the page remains white.
I plan to go with two update panels for two sections,
that is i can load the first section, and show in the page, and after that i can load the second section, so that the user knows something is going on??
is it feasible with update panels, or is any other method there,
please help me.
|
|
|
|
|
yes you can do it. there is no problem in using two update pagen but i think its must be conditional updates i.e content of the update panel update based on condition
|
|
|
|
|
Thanks Pranay,
but here, i did with that, after i get the content of the first section, i gave the UpdatePanel1.Update(), where the update panels update mode is set to conditional..
but i am not getting any display of the page in the page??
can you please tell me how to do the same.?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
