Re: asp.net connection string - ASP.NET Discussion Boards

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.

Re: asp.net connection string

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

Re: asp.net connection string

omer erakman9-Oct-07 9:37

omer erakman

9-Oct-07 9:37

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

Re: asp.net connection string

Dhyanga11-Oct-07 0:25

Dhyanga

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

Re: asp.net connection string

omer erakman11-Oct-07 6:40

omer erakman

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.

Re: asp.net connection string

Dhyanga13-Oct-07 19:31

Dhyanga

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

Re: asp.net connection string

omer erakman14-Oct-07 8:54

omer erakman

14-Oct-07 8:54

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

Re: asp.net connection string

Dhyanga14-Oct-07 21:31

Dhyanga

14-Oct-07 21:31

i mean you have to close the firewall of the computer where your sql server resides.If your sql server is in the host computer, then you have to request them to close....or change some configuration in the firewall so that firewall recognizes your sql server.

suchitamanandhar@hotmail.com

ASP .Net 2.0 Page events.

aakar9-Oct-07 6:25

aakar

9-Oct-07 6:25

Hi,

I am new to ASP .Net.
I was going through the Page LifeCycle in ASP .Net 2.0 and what I found was a lot of events like

TestDeviceFilter()
AddParsedSubObject()
OnInitComplete()
OnPreRender()
OnRenderComplete() etc. that can be overridden.

What I want to know is where would one override these events, I mean in what scenarios.

Any help would be appreciated.
Aakar.

Re: ASP .Net 2.0 Page events.

Not Active9-Oct-07 8:23

Not Active

9-Oct-07 8:23

Start here http://msdn2.microsoft.com/en-us/library/system.web.ui.page_events(vs.80).aspx[^]

only two letters away from being an asset

Class vs SP

ss.mmm9-Oct-07 6:17

ss.mmm

9-Oct-07 6:17

I need to convert the row entries to column in dataset.
Eg:
emplid assigned to
xxx work1
xxx work2
yyy work2

my dataset shud be changed to
emplid work1 work2
xxx checkboxchkd checkboxchkd
yyy notchecked checkboxchkd
to bind to grid.

There are two different ways am considering. One is the stored proc on sql and the other is C# class. Which would be better in performance?

Thanks for help.

Thanks

Re: Class vs SP

ToddHileHoffer9-Oct-07 7:04

ToddHileHoffer

9-Oct-07 7:04

If you are using sql server 2005 then you can use the pivot command. If not, I would use ado.net. Create a dataTable with the proper columns and use a data reader to populate it. I don't think the C# is more efficient, but it sure is easier. Writing complicated stuff is SQL tough to debug and generally more difficult to follow.

How many rows are you going to be pulling back? If you have 1000s of rows you are probably better off using a user defined function in SQL for performance, but if you have 50 or less rows, it won't matter how you do it and the C# will be much easier to maintain / modify / debug if you need to.

I didn't get any requirements for the signature

SQL Query Translation.

Saksida Bojan9-Oct-07 5:37

Saksida Bojan

9-Oct-07 5:37

I am using database MSSQL, i have also installed MySQL throught ODBC driver. I Know these databases sql queryies are a diffrent, but does a certan controll/class/dll exsist to translate query betwen them? If it doesnt it's not a big problem.

Re: SQL Query Translation.

il_masacratore9-Oct-07 21:47

il_masacratore

9-Oct-07 21:47

Queries are not different if you use standard sql in your app...

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

javascript datetime dynamically (ASP.Net)

veluCovansys9-Oct-07 5:31

veluCovansys

9-Oct-07 5:31

hi this is velu

i need to display the date and time in my web application in ASP.Net with C#,
i created in Server side. But it is a web application, several user use this,so server get the request in every second(performance is low).

i need clientside date and time.

how to create please reply soon

Re: javascript datetime dynamically (ASP.Net)

ToddHileHoffer9-Oct-07 7:05

ToddHileHoffer

9-Oct-07 7:05

just google javascript date time counter. You should find something.

I didn't get any requirements for the signature

Dataset on Immediate window

ss.mmm9-Oct-07 5:30

ss.mmm

9-Oct-07 5:30

Can you suggest me ways to look at the entire dataset or datatable on the immediate window?

Thanks

Re: Dataset on Immediate window

Paddy Boyd9-Oct-07 5:38

Paddy Boyd

9-Oct-07 5:38

If you're using VS 2005, try hovering over the datatable variable and then clicking the little magnifying glass icon when it pops up.

Populating a drop down list

Brendan Vogt9-Oct-07 3:50

Brendan Vogt

9-Oct-07 3:50

Hi,

I have a drop down list in a:

<asp:CreateUserWizardStep ID="CreateUserStep1" runat="server">

<ContentTemplate>

<asp:DropDownList ID="ddlTitles" runat="server" />

I need to populate this drop down list. I am having some issues because normally I would do it like:

private void BindTitles()
{
ddlTitles.DataSource = Title.GetAllTitles();
ddlTitles.DataValueField = "ID";
ddlTitles.DataTextField = "Name";
ddlTitles.DataBind();

// Insert a "None" choice
ddlTitles.Items.Insert(0, new ListItem("None", String.Empty));
}

But because it is in <ContentTemplate> I need to find the control, something like CreateUserStep1.ContentTemplateContainer.FindControl("ddlTitles")... But I do not know how to populate it. In BindTitles() I changed it to create a drop down list control and populated this control the samwe way, but I need to assign this control to ddlTitles. I don't know how to do this.

Please can someone help me??

Thanks

Re: Populating a drop down list

Eduard Keilholz9-Oct-07 4:38

Eduard Keilholz

9-Oct-07 4:38

You're pretty close...

<br />
Control cltrFound = ....FindControl("YourControl");<br />
if (ctrlFound is DropDownList)<br />
{<br />
    DropDownList ddlToBind = (DropDownList)ctrlFound;<br />
    BindTitles(ddlToBind);<br />
}<br />
<br />
private void BindTitles(DropDownList ListToBind)<br />
{<br />
   ListToBind.DataSource = Title.GetAllTitles();<br />
   ListToBind.DataValueField = "ID";<br />
   ListToBind.DataTextField = "Name";<br />
   ListToBind.DataBind();<br />
<br />
   // Insert a "None" choice<br />
   ListToBind.Items.Insert(0, new ListItem("None", String.Empty));<br />
}<br />

That mey help you get even closer Wink | ;)

.: I love it when a plan comes together :.
http://www.zonderpunt.nl

Re: Populating a drop down list

Brendan Vogt9-Oct-07 5:28

Brendan Vogt

9-Oct-07 5:28

Thanks for this, it really helped!!

How do I stop the response object from renaming files?

Al Ortega9-Oct-07 3:33

Al Ortega

9-Oct-07 3:33

I have an file management tool that has just one problem that I can not figure out. The files are stored in an MsSQL 2005 db and can be retrieved with no problem. The problem comes when the response object renames it. Example if the file is name "file 1.doc" then when the IE response sends it to the client it is renamed "file_1.doc" but FF renames it "File" with no "1" or file extension rendering it useless.

Any ideas on what could be causing this and what can be done to stop it?

-Al

Re: How do I stop the response object from renaming files?

Paddy Boyd9-Oct-07 5:24

Paddy Boyd

9-Oct-07 5:24

Are you setting the filename in the response?

Something like:

Response.AppendHeader("content-type", "inline;filename=file.doc")

Re: How do I stop the response object from renaming files?

Al Ortega9-Oct-07 5:52

Al Ortega

9-Oct-07 5:52

no, I have

Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name)

I tried using inline vice attachment - but there was no difference.

-Al

Gridview DropDownlist

ss.mmm9-Oct-07 3:27

ss.mmm

9-Oct-07 3:27

Can dropdown list be put on gridview bound column? Many places, I read that it has to be converted to template column to put a dropdown. Can you please help with this?

Thanks

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