By: John Kilgo Date: November 28, 2002 Download The Code.
Printer Friendly Version
Here we present an example of how to store a database connection string in the application's Web.Config file. Web.Config is a part of every asp.net application and provides a nice, central location for storing information that may be needed in many of .................... ..
<% 'Program: ConnString.aspx' By: John Kilgo 'Date: November 28, 2002' CodeBehind: ConnString.aspx.vb 'Purpose: Demonstrates using Web.Config to hold a connection string' and reading that string from a program% > <% @ Page Inherits = "Connstring" src = "Connstring.aspx.vb"%>
ConnString </ title> <meta name = "GENERATOR" content = "Microsoft Visual Studio.NET 7.0"> <meta name = "CODE_LANGUAGE" content = "Visual Basic 7.0"> <meta name = "vs_defaultClientScript" content = "JavaScript "<meta name =" vs_targetschema "content =" http://schemas.microsoft.com/intellisense/ie5 "> </ head> <body ms_positioning =" gridLayout> <form id = "Form1" runat = "server "> <asp: dataGrid id =" dataGrid "AutoGenerateColumns =" False "runat =" server "> <Columns> <asp: BoundColumn HeaderText =" Company Name "DataField =" CompanyName "/> <asp: BoundColumn HeaderText =" Contact Name "Datafield =" ContactName "/> <ask: boundcolumn headertext =" Contact Ti TLE "DataField =" ContactTitle "/> </ color> </ asp: DataGrid> </ form> </ body> </ html></p>
<p>Next is the code-behind page which accesses the Web.Config file to obtain the database connection string. Notice that we must Import the namespace System.Configuration in order to access the Web.Config file. Web.Config (shown after the .vb code) contains a key-value pair which specifies a key of "ConnectionString" with a value which is the connection string. We set a string variable ( "strConnection") equal to ConfigurationSettings.AppSettings ( "ConnectionString"). We have now captured the connection string for use in our program.Imports SystemImports System.WebImports System.Web.UIImports System.Web.UI.WebControlsImports System.DataImports System.Data.SqlClientImports System.ConfigurationPublic Class ConnString: Inherits Page Protected dataGrid As dataGrid Protected Sub Page_Load ( Byval e AS Object, BYVAL E as Eventargs DIM SQLCONN AS SQLCONNECTION DIM SQLCMD AS SQLCOMMAND DIM STRCONNECTION AS STRING TRY 'GET Connection String from Web.Config Strconnection = ConfigurationSettings.AppSettings ( "ConnectionString") sqlConn = New SqlConnection (strConnection) sqlCmd = New SqlCommand ( "SELECT * FROM Customers WHERE" _ & "(CompanyName LIKE 'A%') OR (CompanyName LIKE 'B%')", sqlConn) sqlConn.Open () dataGrid.DataSource = sqlCmd.ExecuteReader () dataGrid.DataBind () Catch ex As Exception Response.Write (ex.ToString & "<br>") Finally sqlConn.Close () End Try End SubEnd Class</p>
<p>.....................</p>
<p><? XML Version = "1.0" encoding = "UTF-8"?> <! - web.config configuration file -> <configuration> <appsettings> <add key = "connection" value = "server = localhost; database = Northwind; uid = sa; password = secret; "/> </ appsettings> <system.Web> <customerrors mode =" off "/> </system.Web> </ configuration> contusion: in this article you have seen HOW TO Store A Database Connection String in Web.config and To Access The Connection String from A Web Page. You May. You May Download The Code by Clicking Here.</p></div><div class="text-center mt-3 text-grey">
转载请注明原文地址:https://www.9cbs.com/read-110031.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>)
</div><div></div></div></div><ul class="postlist list-unstyled">
</ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="110031" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved
</div><div class="col text-right">Processed:
<b>0.053</b>, SQL:
<b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script>
var debug = DEBUG = 0;
var url_rewrite_on = 1;
var url_path = './';
var forumarr = {"1":"Tech"};
var fid = 1;
var uid = 0;
var gid = 0;
xn.options.water_image_url = 'view/img/water-small.png';
</script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script>
var forum_url = 'list-1.html';
var safe_token = 'jj7PD843Vn5EVZA9Wtz7okh6P_2B_2BHP3xPQ_2BhgUN8MB07CxGiwnP6nDB8jPwUGXO55Yi63lyKB9M5TA_2BM7_2BccHMA_3D_3D';
var body = $('body');
body.on('submit', '#form', function() {
var jthis = $(this);
var jsubmit = jthis.find('#submit');
jthis.reset();
jsubmit.button('loading');
var postdata = jthis.serializeObject();
$.xpost(jthis.attr('action'), postdata, function(code, message) {
if(code == 0) {
location.reload();
} else {
$.alert(message);
jsubmit.button('reset');
}
});
return false;
});
function resize_image() {
var jmessagelist = $('div.message');
var first_width = jmessagelist.width();
jmessagelist.each(function() {
var jdiv = $(this);
var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width();
var jmessage_width = Math.min(jdiv.width(), maxwidth);
jdiv.find('img, embed, iframe, video').each(function() {
var jimg = $(this);
var img_width = this.org_width;
var img_height = this.org_height;
if(!img_width) {
var img_width = jimg.attr('width');
var img_height = jimg.attr('height');
this.org_width = img_width;
this.org_height = img_height;
}
if(img_width > jmessage_width) {
if(this.tagName == 'IMG') {
jimg.width(jmessage_width);
jimg.css('height', 'auto');
jimg.css('cursor', 'pointer');
jimg.on('click', function() {
});
} else {
jimg.width(jmessage_width);
var height = (img_height / img_width) * jimg.width();
jimg.height(height);
}
}
});
});
}
function resize_table() {
$('div.message').each(function() {
var jdiv = $(this);
jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>');
});
}
$(function() {
resize_image();
resize_table();
$(window).on('resize', resize_image);
});
var jmessage = $('#message');
jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); });
jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); });
$('#nav li[data-active="fid-1"]').addClass('active');
</script>
