ASP.NET

Exported data from grid to excel

11-Oct-07 0:20

ya copy it in server and share it.

suchitamanandhar@hotmail.com

SSIS in ASP.Net 1.1

Falguni Joshi9-Oct-07 17:01

Falguni Joshi

9-Oct-07 17:01

Hi Friends,

I have one problem.My application is in asp.net 1.1 and packages i made using sql server 2005 integration services.My DTS runs on every 20 minutes and now i want to know wheather currently it is running or not.How can i trace that???Do anybody have idea about it???
I have gone through logging also.I can check my DTS status from sysdtslog90 table but i cant know wheather DTS which is currently running is done successfully or it is failed ??
Please help me out..!! Confused | :confused:

Thanks in advance.

Falguni

bigeyed9-Oct-07 15:21

bigeyed

9-Oct-07 15:21

i have a dll which helps me to export data from grid to an excel sheet.

//these are the codes...
Response.Charset = "ks_c_5601-1987"; //(to korean character-set)

LgaGrdToXlsLib.ExportData.Export objExportM = new LgaGrdToXlsLib.ExportData.Export("Web");
objExportM.ExportDetails(dtTaskMember,iColumnsM, Export.ExportFormat.Excel, "("+DateTime.Now.ToString("yyyyMMddHHmmss")+").xls");

/////////

and it works fine, but the problem is that i save this file on my computer and open this file, i confirm what i have downloaded and then i modify some data , then i save it as different name and that is the problem.

when i save this file as a different name, on the botton of the dialogwindow, this file type should be automatically selected as "Microsoft office document excel (*.xls)", but it keeps showing "text (*.txt)" type...

what is wrong with this!!! does any body know why???

Returning a Datatable in a Func results in empty table

srone9-Oct-07 12:09

srone

9-Oct-07 12:09

This is driving me crazy. I used to do this in .net 1.1

The table will have rows in GetTable, but the client will have an empty table.

I used to return a ref to the table in GetTable...I shouldn't have to clone.

I've tried no clone, and cloning at the client call.
I've tried creating a new table at the client.
I've tried moving the function to the calling sub's class.
I've tried standing on my head.
I've tried rolling chicken bones and calling the spirits of my ancestors.

Please help if you can.

Thank you

Class DataHandler
Public Function GetTable(ByVal Query As String) As DataTable

Dim oCon As New SqlConnection(ConfigurationManager.ConnectionStrings("DispatchData").ConnectionString)

Dim oAdapter As New SqlDataAdapter(Query, oCon)
Dim oTable As DataTable

Try
Dim oDataset As New DataSet
oCon.Open()
oAdapter.Fill(oDataset)
oTable = oDataset.Tables(0)

'Table has x number of rows
Return oTable.Clone

Catch ex As Exception
Throw New Exception("Failed to read data", ex)
Return Nothing
Finally
oAdapter.Dispose()
oCon.Close()
End Try
End Function
End Class

Private SomeSub()
Dim oDataHndlr as new DataHandler
Dim MyQuery as string = "SELECT * FROM MyTable"

'Table will contain 0 rows
Dim oTable as DataTable = oDataHndlr.GetTable(MyQuery)

End Sub

Place the Return outside of the Try block

srone9-Oct-07 15:21

srone

9-Oct-07 15:21

Ok, I have solved the problem, but I don't know why it's so.

The Return keyword has to be outside of the try block.

Can anyone explain why?

Thanks.

IE vs. Firefox

gates099-Oct-07 9:05

gates09

9-Oct-07 9:05

Okay im using a .css file and it's working in IE but not Firefox, I noticed the textsizes i was setting are getting set to the appropriate sizes, in IE but not in Firefox, although if I comment out the .css file it affects both.

Just wondering if anyone has run into this bofore, or any tips in regards to using .css file with Firefox as opposed to IE

Re: IE vs. Firefox

Christian Graus9-Oct-07 18:31

Christian Graus

9-Oct-07 18:31

EVeyone has run into this. You need to change your CSS to something that works for both. And test for any other browser you want it to work with.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: IE vs. Firefox

Guffa9-Oct-07 20:58

Guffa

9-Oct-07 20:58

Differences between IE and other browsers are quite common. If you are building your pages for IE, there is a great risk that they are depending on rendering bugs in IE, and won't look the same in any other browser.

Firefox is a bit stricter with the correctness of the code. IE sometimes accepts code that is incorrect, by guessing what you might have meant.

Example:

Incorrect code, but accepted by IE:

font-size: 12;<br />
color: bad;

Correct code:

font-size: 12pt;<br />
color: #bad;

Open up the Error Console in Firefox and open your site, and it will tell you about all the incorrect css code.

---
single minded; short sighted; long gone;

Re: IE vs. Firefox

gates0910-Oct-07 2:37

gates09

10-Oct-07 2:37

Thanks that helped alot.

Typing In Combo

John.G9-Oct-07 8:57

John.G

9-Oct-07 8:57

Dear Buddies,
In ASP.Net,I would like to type in Combo Box during run time. Is it possible.?
This is possible in .Net 2003 & 2005. But in ASP.Net this is not the case.Any solution to this prob?

Thanks..

Muthu

Re: Typing In Combo

il_masacratore9-Oct-07 21:46

il_masacratore

9-Oct-07 21:46

Type in runtime... How? When user types you want control whick key presses?

Visit my blog at http://dotnetforeveryone.blogspot.com/

Re: Typing In Combo

John.G18-Oct-07 8:47

John.G

18-Oct-07 8:47

Well, When user wants to include one more item with the existing items from combo box and save a record in database, it should be enabled in web also. this is the reason why I seek for the possiblity to type in combo box during run time.
I think, it should be possible...!!

Muthu

asp.net connection string

omer erakman9-Oct-07 7:36

9-Oct-07 7:36

hi i developed a website using asp.net c# and sqlexpress (2005). It works fine on my machine but when publish it to host i always take this error message:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

My database files are in App_Data directory. I am accessing them from there. the host doesnt allow remote connections. I think the connection string can cause this problem but i dont know how to solve it. Here is my connection string:
<connectionStrings>
<add name="sqlBaglantiStr" connectionString="server=.\SQLExpress;AttachDbFileName=|DataDirectory|ahsapeviniz.mdf;Integrated Security=true;User Instance=true"/>
</connectionStrings>

And for databases, i use windows authentication. Can it be about it? i dont know how can i create user for a database in App_Data folder.
thanks.

Not Active9-Oct-07 8:20

Not Active

9-Oct-07 8:20

Is SQLExpress installed on your host?

only two letters away from being an asset

omer erakman9-Oct-07 9:37

9-Oct-07 9:37

Yes it is installed, they told me "use SQLExpress" before

Dhyanga11-Oct-07 0:25

11-Oct-07 0:25

check whelter you sql server allows remote connection or not...
please check in sql server configuration manager and put enable tcp/ip also.

suchitamanandhar@hotmail.com

omer erakman11-Oct-07 6:40

11-Oct-07 6:40

It will not help, if i will change my sql server settings. Because the problem is when publishing website on my host. And my host does not allow remote connections with sql server.
I am asking what my connection string should be to not make a remote connection.

Dhyanga13-Oct-07 19:31

13-Oct-07 19:31

ok may be you windows firewall is ON.If so, please OFF your firewall and then check.

suchitamanandhar@hotmail.com

omer erakman14-Oct-07 8:54

14-Oct-07 8:54

How can i close firewall on host? Confused | :confused:

Dhyanga14-Oct-07 21:31