Connection Issue While connecting to SqlServer 2000 from ASP.NET 2.0 - ASP.NET Discussion Boards

The v1.1 version is here:

http://www.microsoft.com/downloads/details.aspx?familyid=86ce6052-d7f4-4aeb-9b7a-94635beebdda&displaylang=en

hi all,
am developeing a webportal ,inthis application i do provided login,regestration ........pages.I want to have a feature that when ever a new user regestered in our portal ,the regestered informtion(some information like his name,address...) must send to my mobile as sms .

could anybody sujjest the solution or plz let know some URL's regording this issue....!

Blush | :O

yuvachandra

Are you looking for something like this?

http://www.codeproject.com/aspnet/SendingSMS.asp

thanqs for replay...!
but the stuff u given not working properly man....could u suggest any better approch...plz,it's urgent for me.. Confused | :confused:

Hello technicals
i m new to crystal reports,so i dont even know
"How can i display 20 records in detail section per page in crystal reports."

From one of the site i come to know that

First create a record counter.
Then change the format option of the detail area and choose a formula on new page before. The result has to be true: {#Counter} = 20

but i dont even know
"How to create a record counter in crystal reports.And also how to set its value."

pls guide me...

hi all,

i want to upload files or folders on my server with the use of drag and drop functionality. the files may be one by one draged and droped in a listbox where the whole path of the files should get copied. and then on pressing upload button all the files listed in list box should be uploaded on my server.
pls give me code for the same. its urgent.
i am using VS-2005, asp.net,vb.net

thanks in advance for help.

regards,
gauri

hi all .
iam a new user of this site. if anyone kindly send me some basics or site address featuing how to design any web mail server like yahoo, rediff etc. using .net and how much time it require to design a simpler one

prashant jain malviya national institute of technology

HI
I have got some error while connecting Sql Server 2000 from ASP.NEt 2.0
i.e My ASP.NET Application and SqlServer 2000 are avaliable in diffrent machine.I remotly connecting the sql server 2000.

I am getting the following error

"System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at _Default.click_Click(Object sender, EventArgs e) in d:\WebSite2\Default.aspx.cs:line 27"

Please send me ur sugessions.

Thanks

Paul

Hi,
can you paste your code u are using to connect to the database.

The way it is usually done is pasted below for your reference

The connection stings are specified in the web config file.

In Web.Config, you can add a key to the AppSettings Section

<appsettings>

<add key="MyDBConnection" value="data source=<ServerName>;Initial catalog =<DBName>;user id=<Username>;password=<Password>;">

Example:
<add key="ConnectionString" value="data source=localhost;Initial catalog=northwind;user id=sa;password=mypass">

Then, in your ASP.Net application - just refer to it like this:
using System.Configuration;
string connectionString = (string )ConfigurationSettings.AppSettings["ConnectionString"];

try also adding
<identidy impersonate="true"> segment to your web config file.

i hope this helps

Renu.K

Thanks for your sugession Renu,

I exaclty did the same what u mentioned in the above example, but i am used to connect with sql server 2000, but the error says that sql server 2005.

Is there any conflict to connedct with Sql server 2000 from ASP.NEt 2.0 remotely.

try giving the ip address of that sql server in the web config file...

hope this works..

Renu.K

HI
I Also tried this.

Thanks

Paul

Hi,

I had to run the code in local server after copying it from a shared folder from another system.i am not able to open it at all, the error message i am getting is "web access failed as the default web access is shared mode".Other error message is "required components are not loaded in the local server".Please help because i am unable to continue with my work

Have you registered the necessary controls on the published server?

I am attempting to test a browser hosted control in a secure server (IIS 5) environment. My test computer is running .Net 2.0, and the Policy managing the control on the client side is set for full trust (at the moment). My setup is as follows:

Visual Studio 2005 / .Net 2.0 / Win XP SP2 (both .NET 1.1 and 2.0 installed)
IIS 5 on a Win 2000 SP3 server (both .NET 1.1 and 2.0 installed)
ASP classic (migrating to ASP.NET)
IE 6

The server secure site is configured for .NET 1.1 with classic ASP, but my test page is a .NET 2.0 w/ ASP.NET (that is in a virtual directory configured for .net 2). The server has both installed. The server has older because we are preparing to convert the site to ASP.NET and .NET 2.0. It is the only secure server on which I can test at the moment, so I have to live with the mix until the site is fully converted (which may take months). I navigate to my page from the secure login page. This all seems to work fine, and the control runs fine, except when I attempt to call SmtpClient() from my hosted control resulting in a configuration failure during the call. This problem only occurs on the secure server. When running on any other unsecure server, the SMTP works flawlessly, but then I don't have to go through a login page to test on unsecure sites.

Could the problem be happening because of a mix of .NETs (starting to configure from 2.0 schemas and then droping back to the 1.1 schemas and getting confused, or could it be something else. The only thing that SUGGESTS that it might be this is because the error says that the configuration file has a format error in it). I have been trying to find the source of this problem for several days and am out of ideas. I am no closer to finding the problem now than when I started. I would appreciate any help/ideas/suggestions anyone might have. I am at wits end Mad | :mad:

and am almost out of hair Smile | :)

I’m currently working on a website that we are trying to make accessible. Now I added a page to the site which provide some drop down lists to the users. Such as background color (bgcolor), text size, zoom in (? Not sure how yet), font and things like that. The problem is my very limited experience with ASP.Net. I am a starter. I’d appreciate if one of you guru’s can help me out. Now I can’t or perhaps I should say don’t want to use Java script (user requirement). So basically I have to write server side code that will perform those things (change color, size, font ) etc. Now in my HTML code I have added the runat = “server” attribute to the form element. But that only exposes the Style property when I use it in code behind (under Page_Load event). I don’t want to use style because we won’t be using a CSS for this and I think style property only works with CSS. Since I will be hard coding a few values below in my drop down list and set the values of the color to their hexadecimal value such as #00ff00 for green.

<br />
<br />
<asp:dropdownlist id="ddl2" Runat="server" Width="145px"><br />
				<asp:ListItem Value="Select Me">- Select One -</asp:ListItem><br />
				<asp:ListItem Value="#ff0033"> RED</asp:ListItem><br />
				<asp:ListItem Value="#0000ff"> BLUE</asp:ListItem><br />
				<asp:ListItem Value="#00ff00"> GREEN</asp:ListItem><br />
				<asp:ListItem Value="#000000"> BLACK</asp:ListItem><br />
			</asp:dropdownlist><br><br />

All I want to be able to do when the user clicks the Button, the page and a few more pages will adopt those properties and change color, font etc. The later having the other pages adopt the same values is something I have figured out (I’m planning on using session state for that) Please help me out with this. I even tried exposing a runat = server attribute to the element so that I could programatically change the value of the whole body under the button_click event. But that didn’t work either. Thanks~ Tina

This sounds like a homework problem (no CSS?)

Anyway try something like this:

runat=server in body tag with an ID

<body runat="server" id="TheBody">

Configure your DDL to AutoPostBack = true and wire up a SelectedIndexChanged handler:

<asp:DropDownList ID="ddlBG" runat="server" AutoPostBack="True" OnSelectedIndexChanged="ddlBG_SelectedIndexChanged" Width="100px">
        <asp:ListItem>Pick one</asp:ListItem>
        <asp:ListItem>Red</asp:ListItem>
	<asp:ListItem>Blue</asp:ListItem>
	<asp:ListItem>Green</asp:ListItem>
<asp:DropDownList>

For some reason it turns "OnSelectedIndexChanged" into "removed"

Then set up your DDL with color choices and do something like this in the code behind:

protected void ddlBG_SelectedIndexChanged(object sender, EventArgs e)
{
	string color = string.Empty;

	switch (this.ddlBG.SelectedItem.Text)
	{
		case "Red":
			color = "#FF0000";
               		break;
		case "Blue":
			color = "#0000FF";
			break;
		case "Green":
			color = "#00FF00";
			break;
		default:
			color = "#dfdfdf";
			break;
	}

	this.TheBody.Attributes.Add("bgcolor", color);
}

This probably won't persist accross pages, but you said you have it figured out using session.

Hello there, thanks for the response. No it's actually not a hw problem...I'm doing an internship for a pretty small software company. By the way, I did try setting the runat = server attribute on the body element...but I still can't use it programatically on the server side.
i.e theBody.Attribure (this doesn't work) which made me wonder if body and form elements perhaps can't be run at server??? Any ideas why they aren't?
I'm using asp .net 1.1.
Thanks
Tina

Hello,

If you are using visual studio Environment for the development then you get response from that for asp.net control.

Nimit Patel

hmmm... I did it here and it worked fine, you have to give it an id too (though I suspect you did that), but I'm using .NET 2.0 so that might be the issue?

Yup...I do have the ID specified. id=myBody runat = server

Could you please tell me how to accomplish that using CSS. I know little about the CSS stuff but I'll be learning about them. Creating a css is not a problem, but how do I dynamically change those colors, fonts and other things I mentioned in my prior post using the CSS approach. Please let me know if you have any input?

Thanks

Also, since I didn't see the "myBody" element declaration in the code behind...I figured I could do that myself. So I tried to declare a variable
of type HTMLcontrol protected System.Web.UI.HtmlControl....but guess what...the body element is not a member of HTMLControl class either. So I tried using it with HtmlForm element. And in my html I made the form element (runat = server and set the ID = myForm) but even that doesn't show up in my code behind programatically.

Because if that shows up...then like you suggested, I could have done
myForm.Attributes.Add("bgcolor", color);

THANKS for you time.
Tina

Hey Display name eggsovereasy:

Thanks for all your help with the color stuff. Apparently the only things missing (which 1.1 doesn't do automatically was the declaration of the body's id as a protected variable of type HtmlGenericControl). So thanks sooo much for your help.

Anyways, I have another question for you.

I want the user to be able to select font (such as Bold, Italic, underline) and stuff like that from a dropdown list) and then I wanna apply these properties to all my page (all text). Now I'm doing something like this:

string font = string.Empty;
switch(ddl2.SelectedItem.Text)
{
case "Bold":

font = Convert.ToString(System.Drawing.FontStyle.Bold);

break;

case "Italic":
font = Convert.ToString(System.Drawing.FontStyle.Italic);
break;

}
myBody.Attributes.Add("Font", font);
Session["theColor"] = font;

This worked for changing the color of the entire page as I hard coded the colors hexa decimal values in the cases, but here these are enums, and can only be compared.

Anyways does anyone has any input on this???? I want this to happen when the user select from the DDL and on the button click event it should change the font.

Thanks
Tina

I have a gridview with a link in the parent page.when i click on the link it opens up another gridview.this child gridview has 2 columns,one is a checkbox created using an itemtemplate and another a boundfield retreiving data from the database.what i want is when i check the checkbox of a particular row and hit a button,the data existing in that particular row of the child gridview which has been checked,has to transfer the data from that row to the parent gridview,in a sense the parent gridview has to refresh and show up with the new data that has come from the child gridview control.How can i do this?..........urgent..........

hi

If you want to use pop up window for child gridview, write
window.open ("popupwindowname.aspx","mywindow","toolbar=no,scrollbars=yes,resizable=yes,menubar=0,width=700,height=520");
in Parent window design page.

And write
Session("var1") = gvChild.SelectedDataKey.Value.ToString()
Dim scriptSubmit As String = " window.opener.document.forms(0).submit(); "
If Not Page.ClientScript.IsClientScriptBlockRegistered(scriptSubmit) Then
Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), "script", scriptString)
End If
Dim ScriptClose As String = " window.close();"
Page.ClientScript.RegisterClientScriptBlock(Me.GetType, "Close", ScriptClose)

In popup window button click. It will refresh the parent page. In the pageload, with the help of session(“var1”), you can load the new data in the parent gridview.

-Priya