最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
ASP.NET mssql server连接数据库
时间:2010-11-19 编辑:简简单单 来源:一聚教程网
asp教程.net mssql server连接数据库教程
*/
public partial class _default : system.web.ui.page
{
protected void page_load(object sender, eventargs e)
{
}
protected void btn_sendmessage_click(object sender, eventargs e)
{
sqlconnection conn = new sqlconnection(@"sever = .sqlexpress;database=guestbook; trusted_connection=true");
string sql = "insert into tbguestbook (username,posttime,message,isreplied,reply) values ('test','2006-11-1 12:00','www.111com.net',0,'ac')";
sqlcommand cmd = new sqlcommand (sql, conn);
conn.open();
cmd.executenonquery();
conn.close();
}
//连接数据库后再查询数据
private void page_load(object sender, system.eventargs e)
{
if(!ispostback)
{
string myconnectstring = "server=localhost;uid=sa;database=manager ";
sqlconnection myconnection =new sqlconnection(myconnectstring);
string comstring = "select * from newstudent ";
sqlcommand mycommand = new sqlcommand(comstring,myconnection);
mycommand.connection=myconnection;
myconnection.open();
dataset ds=new dataset();
sqldataadapter mydataadepter =new sqldataadapter(comstring,myconnection);
mydataadepter.fill(ds, "newstudent ");
datagrid1.datasource=ds.tables[ "newstudent "].defaultview;
datagrid1.databind();
datalist.datasource=ds.tables[ "newstudent "].defaultview;
datalist.databind();
}
}
//方法三
在vs中的web.config文件里面可以设置的,
data source是连接的数据源,initial catalog是你要连接的数据库名,integrated security说明你连接数据库的方式为windows身份验证
%>
相关文章
- ASP.NET连接数据库代码(access,mssql) 07-23
- asp.net 连接access与mssql server数据库方法 06-11
- asp.net SqlConnection连接数据库详解 05-20
- Asp.net连接SQL Server2000数据库例程详解: 02-17
- C#复制数组的两种方式及效率比较解读 10-24
- ASP.NET Identity用法解析 10-24