SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
解决方案 »
- 请【孟子e章】帮忙:发Email失败,发回执到指定的Email address
- 因为用到frameset框架 会对session有影响 从而添加page_unload事件!但不知从何添加?!请教!
- 在MVC 3.0下,用RAZOR写的页面,在FF下正常显示,IE不显示
- xheditor 上传图片时,IE有问题,火狐却可以,求高人救助啊
- 急救啊!动态添加按钮
- 如何让html按钮点击触发服务器方法
- 这局怎么写,单引号双引号?
- IIS中aspx页面正常,htm页面空白
- 在DataGrid里的Edit列,点一下,怎么控制出来的TextBOX的长度
- 关于ASP。NET的用户登录!!
- 别人访问我的网页有问题!
- 各位好,请问用DW2004和VS.NET2003编出来的asp.net是一样的吗?
no,你只是把链接数据库的连接字符串放在webconfig里了。
using System.Data;
using System.Data.SqlClient;
using System.Configurantion;然后string strConn = new System.Configuration.AppSettings["myConnection"];
这样才连上数据库了;
另外,要从数据库中取出数据,你可以参考:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlDataReaderClassTopic.asp
using System.Data.SqlClient;
using System.Configurantion;string strConn = new System.Configuration.AppSettings["myConnection"];然后就是写数据库查询的语句了:
strSql="SELECT 客户编号,公司名称 FROM 客户"
SqlConnection MyConnection = new SqlConnection(strConn);
strConn.Open();
SqlDataAdapter sda = new SqlDataAdapter(strSql,strConn);
DataSet ds = new DataSet("ds");
sda.Fill(ds);
初学asp.net……
在其他文件(1.aspx)中能自动加载其中的代码吗?
比如数据库的连接串.
imports System.ConfigurantionDim strConn as String=System.Configuration.AppSettings("myConnection");
然后,Create one SqlClient Connection Object and create one instance for it,and open it.Then create one Command Object,set Command Text(SQL String) to it,you can its ExecuteNonQuery function.
imports System.ConfigurantionDim strConn as String=System.Configuration.AppSettings("myConnection");
然后,Create one SqlClient Connection Object and create one instance for it,and open it.Then create one Command Object,set Command Text(SQL String) to it,you can its ExecuteNonQuery function.
imports System.ConfigurantionDim strConn as String=System.Configuration.AppSettings("myConnection");
然后,Create one SqlClient Connection Object and create one instance for it,and open it.Then create one Command Object,set Command Text(SQL String) to it,you can its ExecuteNonQuery function.
你不如另开贴问啊。