Re: Crystal Reprot logon problem - ASP.NET Discussion Boards

niki_nilu9-Dec-07 22:26

9-Dec-07 22:26

hi
i want on butttonclick event all data transfer in excel and save it.
in my code when i click on btnSaveToExcel button that time one dialogbox open wheh ask you want to save file in .exe . if yes click then file saved on desktop or whtever path.but when you want to open it that time excel open but there one popupbox comming which have message unable to read file.
pls help me.
this is my code

protected void btnSaveToExcel_Click(object sender, EventArgs e)
{
objVarInit.sqlDS.Reset();
objVarInit.sqlDT.Reset();
objClsDllSql.sqlCon = objReadIniFile.funReadIniSql();
objClsDllSql.sqlCon.Open();
objVarInit.sqlDA = new SqlDataAdapter("select * from tUser", objClsDllSql.sqlCon);
//objVarInit.sqlDT = new DataTable();
objVarInit.sqlDA.Fill(objVarInit.sqlDT);
objClsDllSql.sqlCon.Close();
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
string sep = "";
foreach (DataColumn dc in objVarInit.sqlDT.Columns)
{
Response.Write(sep + dc.ColumnName);
sep = "\t";
}
Response.Write("\n");

int i;
foreach (DataRow dr in objVarInit.sqlDT.Rows)
{
sep = "";
for (i = 0; i < objVarInit.sqlDT.Columns.Count; i++)
{
Response.Write(sep + dr[i].ToString());
sep = "\t";
}
Response.Write("\n");
}

}

Gayatri

Re: excel

Christian Graus9-Dec-07 22:49

Christian Graus

9-Dec-07 22:49

Where is the file coming from ? Is the file created on the server and then sent to the client ? Does the file exist as you expect ? Are you sure it will exist on the server, not the client, when this is deployed ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: excel

niki_nilu9-Dec-07 23:00

niki_nilu

9-Dec-07 23:00

hi i want code for --
i am using farpoint spreadshhet control. and my database is in sql.
i want to save data in excel on button click.
and iam using asp.net 2.0 with c#.

Gayatri

Re: excel [modified]

Prateek G9-Dec-07 22:59

Prateek G

9-Dec-07 22:59

I can think of two ways to put your data into excel file...

1.) Use com object.Add reference to microsoft office and use namespace microsoft.office.interop.excel;
then create ur workbook, worksheet and put all the data one by one in a forloop.
Export To Excel[^]

Export to excel.[^]

2.) Another and very interesting way of doing it use xsl transformation.wot u need to do is just get xml from dataset and then apply xsl on the same and create ur excel sheet.Lemme knw if u r interested...

modified on Monday, December 10, 2007 5:24:30 AM

asp.net webpage fails to load a C# windows control in it

Naveen Gowda9-Dec-07 22:08

Naveen Gowda

9-Dec-07 22:08

i have a windows control which is to be loaded on a webpage(.aspx page)
control is loaded with the aid of "object" tag
the control is developed in C#.net(managed code basically)
the control makes use of the system resources and even makes use of some other dll's too

problem:
the control fails to load on the webpage

first solution tried:
change the .net security with the aid of caspol
so i tried giving full trust to all code
this worked fine and the control got loaded.

however this worked fine only when the webpage was a part of the default website in IIS
in case if the webpage which hosts the control is a part of a virtual website apart from the default website
the control is failing to load

so what might be the problem...??

from some of the blogs which i read...the .net tries to give trust
to assemblies based on from where the assembly is getting streamed
so i also tried to load the control by making this site a trusted one
still the control didn't load

any idea...as to might b wrong....

Cross post. Please ignore

Pete O'Hanlon10-Dec-07 0:04

Pete O'Hanlon

10-Dec-07 0:04

See topic

Deja View - the feeling that you've seen this post before.

My blog | My articles

Crystal Reprot logon problem

Raza Hussain9-Dec-07 21:25

Raza Hussain

9-Dec-07 21:25

Hi! ALL
I m generating Crystal Reports by Push method (via DataSet);
but while executing it display a message & four fields in which two are editable & two are uneditable as following
report further inofmration.
Dataset name;
Server name : DataSet name;
DataBase name ..uneditable
User ID ..
Password ...
All these are requested when generating reports with pull method nevertheless I passed all these in ConnectionInfo to TableLogOnInfo.

so how i tackle this.
Any suggestion regarding this will be anticipated.
Thanks in Advance.

Re: Crystal Reprot logon problem

Raza Hussain10-Dec-07 0:14

Raza Hussain

10-Dec-07 0:14

Hi! ALL
I done the report.
The solution of above problem is:
DataSet ds = GetDataset(); // generate dataset here.
DataTable dt = ds.Tables[0];
report.Load(Server.MapPath("report.rpt"));
report.SetDatabaseLogon("abc","xyz");
report.SetDataSource(dt);
CrystalReportViewer1.ReportSource= report;
CrystalReportViewer1.DataBind();
That's way i achieve the task.

Regards.

To upload a file without using upload file ?

jagadeeshkumar19849-Dec-07 20:19

jagadeeshkumar1984

9-Dec-07 20:19

hi all,
i would like to save a file from clients machine onto server without using an fileupload or user interaction. It should be done when a user clicks a button then say a file in C:\\temp.txt(like any file) shuld be save in my server.any ideas..
plz.

Re: To upload a file without using upload file ?

N a v a n e e t h9-Dec-07 20:30

N a v a n e e t h

9-Dec-07 20:30

jagadeeshkumar1984 wrote:
clicks a button then say a file in C:\\temp.txt(like any file) shuld be save in my server.any ideas..

Impossible

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Re: To upload a file without using upload file ?

Christian Graus9-Dec-07 21:16

Christian Graus

9-Dec-07 21:16

To add to the answer you got, the reason you can't do this, and the reason you can't get at a file upload path in javascript, is security. While your use may be benign, imagine if someone could write a webpage, and make it so when you browsed it, any file that had a known path ( such as Windows files ) could be uploaded to a server ?

DataList Item Enumeration in ASP .NET 2.0

ReactiveX9-Dec-07 20:01

ReactiveX

9-Dec-07 20:01

Hi there.

I'm having an issue with enumerating through the bound items in my DataList. It seems as though the Items property of the DataList control only contains the control that you add as an Item Template.

Is there anyway to enumerate through the DataList's BOUND items and convert it back to the original control type?

Daniel Minnaar
Lead Software Developer

Re: DataList Item Enumeration in ASP .NET 2.0

ReactiveX9-Dec-07 20:42

ReactiveX

9-Dec-07 20:42

I've solved the problem.

The way to enumerate is:

For Each item As DataListItem In lstControlList
For Each ctl As Control In item.Controls
CType(ctl, MyControlObject).Property = Value
Next
Next

Daniel Minnaar
Lead Software Developer

Encrypt and Decrypt?

Kasi Viswanathan9-Dec-07 19:51

Kasi Viswanathan

9-Dec-07 19:51

How to Encrypt and Decrypt a String(Password)...Any Reference will be helpful.

Thanks in Advance... Rose | [Rose]

Erasers are for people who are willing to correct their mistakes.

Re: Encrypt and Decrypt?

Christian Graus9-Dec-07 19:52

Christian Graus

9-Dec-07 19:52

The Cryptography namespace is where you should be looking.

Re: Encrypt and Decrypt?

Michael Sync9-Dec-07 20:56

Michael Sync

9-Dec-07 20:56

Don't forget to check out this discussion http://www.codeproject.com/script/Forums/View.aspx?fid=1159&msg=2333796[^]

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Download File

serene joey9-Dec-07 19:46

serene joey

9-Dec-07 19:46

Hi experts,
I need a linkbutton/button to download the files which my clients have uploaded.

Below is my upload method and it works.

protected void uploadFile()<br />
    {<br />
        String projectID = (String)Session["projId"];<br />
        //change the file name<br />
        if (!FileUpload.FileName.Equals(""))<br />
        {<br />
            // Create a new folder in Docs folder (folder name = projectID)<br />
            System.IO.Directory.CreateDirectory(Server.MapPath("Docs/") + projectID);<br />
<br />
            // Save the file into the new folder.<br />
            FileUpload.PostedFile.SaveAs(Server.MapPath("Docs/" + projectID + "/" + FileUpload.FileName));<br />
            lblFile.Text = FileUpload.FileName + " is uploaded!";<br />
            lblFile.Visible = true;<br />
<br />
        }<br />
    }//end of method

However, it's not working for downloading of file (in another asp)
May I know how can I do that?

protected void btnLink_OnClientClick(object sender, EventArgs e)<br />
{<br />
   String projectID = (String)Session["projId"];<br />
   String file1 = System.IO.Path.GetFileName(Server.MapPath("Docs/" + pid + "/"));<br />
}

The files format that are uploaded are not consistent. Usually it's excel, word or pdf format.

Please help. Thanks!

serene

Re: Download File

Christian Graus9-Dec-07 19:54

Christian Graus

9-Dec-07 19:54

You need to set the header and then do a Response.BinaryWrite. You can also specify the filename, which will force a download. There's tons of examples on the web.

Re: Download File

N a v a n e e t h9-Dec-07 19:56

N a v a n e e t h

9-Dec-07 19:56

Where you are storing the file name ? Get the file name user need to be downloaded and do a Response.Redirect() to the file URL.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Execution Problem

Member 46484919-Dec-07 19:41

Member 4648491

9-Dec-07 19:41

Hi All...
We are developing a site...we have done all the coding part and we have also executed every part of it successfully...after a few days we just checked out our app but now it is throwing an exception like

Type: 'Acme.SubAcme.ConvertMeTypeConverter' cannot be found...

Description:

An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException:
Source Error:

An unhandled exception was generated during the execution of the current web request.

we coudnt able to get wat's it....
Help us out.... Frown | :(

Regards
Nandu
Abhishek

Re: Execution Problem

Sun Rays9-Dec-07 19:46

Sun Rays

9-Dec-07 19:46

Hi,
have you seen this ?

Link[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: Execution Problem

Member 46484919-Dec-07 19:55

Member 4648491

9-Dec-07 19:55

Hi Sun Rays...

Its working out...

Thank you so much.... Smile | :)

Regards
Abhishek
Nandu

Re: Execution Problem

Member 46484919-Dec-07 20:01

Member 4648491

9-Dec-07 20:01

Hi Sun Rays...
Cud u tell us what's a converter...Sorry if im sounding very basic coz m very new to AJAX environment... Frown | :(

Re: Execution Problem

Sun Rays9-Dec-07 20:08

Sun Rays

9-Dec-07 20:08

Hi,
you can have this link..

Link[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Display tree structure in asp.net1.1

gopal_Pandey9-Dec-07 19:23

gopal_Pandey

9-Dec-07 19:23

Hi friends,
I am using tree view control in asp.net2.0 which have that controls but if i want to use it in asp.net 1.1 then there is not an option in the controls for the tree view.

now i want to use tree view in asp.net 1.1 and looking for any hint how they will use in asp.net 1.1
i searched on google for the solution but didn't get it..
so if you have alternatives to this then please reply me...
this will very helpful for me....
thanks in advance....
all reply appreciated.....
bye.....

Last Visit: 31-Dec-99 18:00 Last Update: 15-May-24 0:30

Refresh

ᐊ Prev 1...3839 3840 3841 384238433844 3845 3846 3847 3848 Next ᐅ

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