Import and export sql data in microsoft excel file - ASP.NET Discussion Boards

Re: 3D Controls

Christian Graus14-Dec-07 14:25

Christian Graus

14-Dec-07 14:25

Silverlight

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 )

Handling a SoapException

dubbele onzin14-Dec-07 8:47

dubbele onzin

14-Dec-07 8:47

Hi,

I call a web service method and if it fails I get a load of Soap error stuff that I don't want:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: MyErrorMsgString.
at MyWebService.TestThrowException()
--- End of inner exception stack trace ---

How can I get it to just display the error message I want? In the stuff above I just want to get the MyErrorMsgString text.

Thanks Smile | :)

Re: Handling a SoapException

Guffa14-Dec-07 10:51

Guffa

14-Dec-07 10:51

The InnerException property of the SOAP exception contains the exception from the server.

Experience is the sum of all the mistakes you have done.

Re: Handling a SoapException

dubbele onzin14-Dec-07 12:51

dubbele onzin

14-Dec-07 12:51

Thanks for replying Smile | :)

The message shows the inner exception though - it has all that extra text around it and that's what I don't want.

It seems that when I get an error message back from a web service I've written, it contains all that extra stuff. I just want it to send back the error text I provide not all that other stuff.

Re: Handling a SoapException

thowra14-Dec-07 14:01

thowra

14-Dec-07 14:01

Make sure your web service is throwing an actual SoapException rather than just an Exception. You can throw one as easily as this:

throw new SoapException("My Error Text", SoapException.ClientFaultCode);

You'll get a more "concise" message that way.

For more general information see here[^].

Evil cannot be conquered in the world... It can only be resisted within oneself.

Re: Handling a SoapException

Guffa15-Dec-07 8:01

Guffa

15-Dec-07 8:01

Read my previous post.

Repeat until it sinks in.

If it doesn't sink in, ask about what it is that you don't understand.

Experience is the sum of all the mistakes you have done.

Edit mode Grid view

wasimsharp14-Dec-07 3:19

wasimsharp

14-Dec-07 3:19

hi i had a grid view in its edit mode i put a drop down List wich is bounded with my my database in this drop down the role of the user are shown. I want that when admin want to edit wny specific user of the data base.
when he click the edit lblbutton the grid view slected value should be the default role of the user can any body tell me about that

wasim khan

Import and export sql data in microsoft excel file

arslanjatt14-Dec-07 3:15

arslanjatt

14-Dec-07 3:15

Hi,
I want to import data from sqlserver to excel file and export data from excel to sqlserver. I have imported the data from sqlserver but i don't have idea to export data from excel to sqlserver. Do you guys have any solution that can help me. Thanks

Arslan Ilyas
.Net Developer
Red Signal

Re: Import and export sql data in microsoft excel file

Paddy Boyd14-Dec-07 3:32

Paddy Boyd

14-Dec-07 3:32

Have you had a look at DTS (SQL Server 2000) or SSIS (Sql Server 2005). Do you have to do this from an ASP.net front end?

Re: Import and export sql data in microsoft excel file

Paddy Boyd14-Dec-07 3:35

Paddy Boyd

14-Dec-07 3:35

You could also look at this post from today in the SQL forum:
http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2356976[^]

How to Use Com component(Vb 6.0 .dll) in ASP.net

Binod K14-Dec-07 2:38

Binod K

14-Dec-07 2:38

Hi,
I have a migration project. I want to use existing vb 6.0 dll's in ASP.net. Hope you all understand my requirement, we are migrating from Window based application to Web based Application.
Has any of implemented it before, if yes please let me know. Will there be any kind of performance difference ????

Thanks a lot to all !

Re: How to Use Com component(Vb 6.0 .dll) in ASP.net

Christian Graus14-Dec-07 10:01

Christian Graus

14-Dec-07 10:01

What do you want the dll to do ? If it's business rule, server side stuff, you may be able to call it with p/invoke. If the dlls provide UI, or otherwise need to run on the client, you probably can't do it, at least not easily.

ASCII ENTER symbol in text box

Jay_se14-Dec-07 1:57

Jay_se

14-Dec-07 1:57

Hi,

My text (notepad) cotains few ascii characters; one of which is ENTER symbol (like a square box).
I want the text as it is, while I paste it to a textbox. (Access it through Textbox.Text property in code) -- Asp.net/ vb.net

Instead,
(i) when I pasted in a textbox with text mode as single line, the portion of the text before the enter symbol alone pasted.
(ii) when I pasted it in the with text mode as multiline, then it is pasted as two lines.

Is there any way to get the same text in textbox?

Jey

Re: ASCII ENTER symbol in text box

Christian Graus14-Dec-07 10:02

Christian Graus

14-Dec-07 10:02

No - in fact, it's notepad that's messing with you, the textbox is correctly showing you two lines, if it's in that mode. If it's not, it's correctly stopping at the end of the single line.

SSL - Auto-switching protocols based on security

Chris_Green14-Dec-07 1:48

Chris_Green

14-Dec-07 1:48

For performance I would like to switch between https and http automatically depending on if the page content is sensitive. I am hosting on godaddy which does not allow you to turn on SSL for a directory. I'm trying to think of the most clever way to accomplish this. One idea which I am using is to have 2 master pages, default.master and defaultsecure.master. The pageload event swaps the users protocol, if necessary. This way I can simply mark a page a secure by masterpage and know that the user will access that page via https and go back to http when back to a public page.

Is there a more clever way of doing this? Or some setting I missed in the web.config? I'm using .net 2 login controls and was surprised there was nothing there to support this.

how i can convert any date formate to dd/mm/yyyy

jagan12314-Dec-07 1:29

jagan123

14-Dec-07 1:29

iam havaing a text box where the user enters the date in any formate but the it should get get in dd/mm/yyyy

Re: how i can convert any date formate to dd/mm/yyyy

Paddy Boyd14-Dec-07 3:31

Paddy Boyd

14-Dec-07 3:31

You need to know which format the user chooses to enter it in, otherwise how can you tell the difference between:

09/10/2007 (9th October 2007)

&

09/10/2007 (10th September 2007)

Have you considered a calendar control?

Re: how i can convert any date formate to dd/mm/yyyy

Pushpendra patwal14-Dec-07 3:33

Pushpendra patwal

14-Dec-07 3:33

while casting string to Datetime .User IFromatprovider

P.S.

inserting XML data into database.

I Never Look Behind14-Dec-07 1:14

I Never Look Behind

14-Dec-07 1:14

Hi1 i have an XML file that contains RSS feed data. my task is to read the data of RSS feed into a dataset 7 then to create tables in the dayabase corresponding to each table in the dataset with relationships & primary keys. i have successed reading data into dataset & then inserting into database. now i want maitain relationships among these tables with primary key for each table. can any help me?

delete files after adding them? AND focus on a control...

Support12314-Dec-07 0:38

Support123

14-Dec-07 0:38

Hi...

Is it posible to delete a file (from a hard disk) after adding it into the database by clicking on a button. (the click event allready stores the file in the database) I want to delete the file (from the hard drive) using asp.net. BUT is it possible to do this using asp.net code???

I am very new to asp.net but have worked with c# before. (and a little vb.net --- but not much)

2nd question... als in ASP.net
How do i gain focus on a control? (lets say "myTextBox")
i thought it should work like this... myTextBox.Focus(); but this is not working... Why not? It seems to work in the form load but not on the button click event???

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Re: delete files after adding them? AND focus on a control...

Sun Rays14-Dec-07 0:43

Sun Rays

14-Dec-07 0:43

Hi,
you can delete file if you are having permission to delete it.

Create fileinfo object of that file and then delete it.

And to set focus you can do below code.

private void Set_Focus(string controlname)<br />
{<br />
string strScript;<br />
strScript = "<script language=javascript> document.all('" + controlname + "').focus() </script>";<br />
RegisterStartupScript("focus", strScript);<br />
}<br />

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: delete files after adding them? AND focus on a control...

Support12314-Dec-07 0:47

Support123

14-Dec-07 0:47

Thank you i will try it Smile | :)

"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison

Opening all files in browser from ASP.Net Web Page

Anuradha61214-Dec-07 0:36

Anuradha612

14-Dec-07 0:36

Hi,

I am developing an application which needs, to open the file in the browser, the file can be of any type (i.e.) Word Document or excel sheet or Jpeg image or any thing
Can any one suggest some mechanism to do this.
I am developing ASP.Net web application with VB.Net

Thanks in advance

Re: Opening all files in browser from ASP.Net Web Page

Sun Rays14-Dec-07 0:40

Sun Rays

14-Dec-07 0:40

Hi,
you can do Reponse.Redirect("full Path of file")
So it will open file in browser.

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Re: Opening all files in browser from ASP.Net Web Page

Paddy Boyd14-Dec-07 1:27

Paddy Boyd

14-Dec-07 1:27

But the browser will only open those file types that it can support within itself. If you try to, for example, open a .cs file, it will open outside the browser.

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