DB Connection To WebConfig n Message Box

cheer · 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 · 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 · 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 · 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 · 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 · February 15th, 2009, 11:23 PM

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

cheer · 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 · 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 · 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.