DB Connection To WebConfig n Message Box

cheer · #1 (**permalink**) February 15th, 2009, 01:04 AM

2 questions here.

1) How to write code to call DB connection stored in the webconfig file in a codepage under ASP.Net 3.5?

2) How to write a message box alert under a button event to prompt at client?

Appreciate if there is any example to show the above.

thanks

Lee Dumond · #2 (**permalink**) February 15th, 2009, 03:14 AM

1)

Assuming your connection string in web.config is called "myConnectionString"

Code:

System.Web.Configuration.WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString

2)

Code:

<asp:Button ID="btnDelete" runat="server" Text="Delete" OnClientClick="return (confirm('Are you sure you want to delete this item?'));" />

cheer · #3 (**permalink**) February 15th, 2009, 09:19 PM

Quote:

Originally Posted by Lee Dumond

1)

Assuming your connection string in web.config is called "myConnectionString"

Code:

System.Web.Configuration.WebConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString

2)

Code:

<asp:Button ID="btnDelete" runat="server" Text="Delete" OnClientClick="return (confirm('Are you sure you want to delete this item?'));" />

Thanks for the advice. However, there are still some errors appear in the coding as shown in the red square box below

1)
http://i206.photobucket.com/albums/b...WebConfig1.jpg

http://i206.photobucket.com/albums/b...ctionError.jpg

Lee Dumond · #4 (**permalink**) February 15th, 2009, 09:42 PM

If you're using VB, you would want to use ( ) instead of [ ] there.

Code:

System.Web.Configuration.WebConfigurationManager.ConnectionStrings("oqConnectionString").ConnectionString

cheer · #5 (**permalink**) February 15th, 2009, 11:08 PM

Quote:

Originally Posted by Lee Dumond

If you're using VB, you would want to use ( ) instead of [ ] there.

Code:

System.Web.Configuration.WebConfigurationManager.ConnectionStrings("oqConnectionString").ConnectionString

<asp:Button ID="btnDelete" runat="server" Text="Delete" OnClientClick="return (confirm('Are you sure you want to delete this item?'));" />

How to convert this to the VB?

Lee Dumond · #6 (**permalink**) February 15th, 2009, 11:23 PM

That second example is server control markup with JavaScript, so that should work with any language.

cheer · #7 (**permalink**) February 16th, 2009, 12:06 AM

Quote:

Originally Posted by Lee Dumond

That second example is server control markup with JavaScript, so that should work with any language.

Thanks. How to call a VB written function under the XXX.ASPX.VB from the javascript?

Lee Dumond · #8 (**permalink**) February 16th, 2009, 12:17 AM

Your original question was about how to raise a messagebox alert on the client, wasn't it?

Anyway, if you have a VB function that runs on the server, you would call the function from the OnClick event instead of the OnClientClick event. Just like you have probably done a thousand times. That is pretty much the basic functionality of a button.

Umm. maybe you could tell us what you are trying to do, and we could point you in the right direction?

cheer · #9 (**permalink**) February 16th, 2009, 12:23 AM

Quote:

Originally Posted by Lee Dumond

Your original question was about how to raise a messagebox alert on the client, wasn't it?

Anyway, if you have a VB function that runs on the server, you would call the function from the OnClick event instead of the OnClientClick event. Just like you have probably done a thousand times. That is pretty much the basic functionality of a button.

Umm. maybe you could tell us what you are trying to do, and we could point you in the right direction?

Thanks, you have answered my question.

Need to download code?

Navigation