Dim conNorthwind As SqlConnection
Dim daNorthwind As SqlDataAdapter
dsStore = New DataSet
conNorthwind = New SqlConnection("Server=localhost;user id=sa;password=xxx;database=Northwind;")
daNorthwind = New SqlDataAdapter("Select CategoryID,categoryName from Categories", conNorthwind)
daNorthwind.Fill(dsStore, "Categories")
DataList1.DataSource = dsStore.Tables("Categories")
DataList1.DataBind()
Dim daNorthwind As SqlDataAdapter
dsStore = New DataSet
conNorthwind = New SqlConnection("Server=localhost;user id=sa;password=xxx;database=Northwind;")
daNorthwind = New SqlDataAdapter("Select CategoryID,categoryName from Categories", conNorthwind)
daNorthwind.Fill(dsStore, "Categories")
DataList1.DataSource = dsStore.Tables("Categories")
DataList1.DataBind()
解决方案 »
- aspnetpager 没有跳转
- 有没有好点的高亮代码显示组件?类似 CodeHighlighter
- C# 代码 转 vb 就一句,怎么都提示错误.
- 百分问两个有关经验的问题.
- 紧急求救~~关于 ArrayList
- 怎样设置才能让在人家的网页插入一个form提交到我的系统里?
- array未定义
- 提交一个表单到远程网站的同时本地数据库里再更新一条信息,这个问题要如何做!
- asp.net如何通过后台代码把地点标记在百度地图上显示?
- MVC3.0(组件池)
- 急!!怎样把在aspx页面里的服务器控件textbox的值赋给html控件的textbox上呢??还有怎样把html控件的textbox给隐藏掉呢??
- VB.net 怎样显示指定位数的浮点数??
看下面这段代码
————————————————————————————————————
Dim conNorthwind As SqlConnection
Dim daNorthwind As SqlDataAdapter
dsStore = New DataSet
conNorthwind = New SqlConnection("Server=localhost;user id=sa;password=xxx;database=Northwind;")
daNorthwind = New SqlDataAdapter("Select * from Categories", conNorthwind)
daNorthwind.Fill(dsStore, "Categories")
datagrid1.datasource=dsStore.Tables("Categories")
datagrid1.DataBind()
以上代码是将Northwind数据库中Categories表中的数据(的内容查询出来填充到DataSet中,并将数据显示在DataGrid控件中
比如,你想在PageLoad中进行数据邦定就放在PageLoad中,总之,放在你需要绑定数据的地方!
VB.NET写的应该是放在.aspx.vb中恩放在比如Page_Load事件或者Button_Click之类的事件中
SqlConnection myconn;
放在前面声明哪里
private void button7_Click(object sender, System.EventArgs e)
{
try
{
SqlConnection myconn=new SqlConnection(strcon);
string strsquer="select car_id as 车牌,car_type as 车型, start_place as 始发站,end_place as 终点站,start_time as 发车时间, time1 as [所用时间(小时)],distance as [距离(米)], price as 票价,seats as 座位 from carmain ";
SqlCommand mycom=new SqlCommand(strsquer,myconn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand=mycom;
myconn.Open();
DataSet ds = new DataSet ( );
da.Fill(ds,"carmain");
dataGrid1.DataSource =ds;
dataGrid1.SetDataBinding(ds,"carmain");
myconn.Close ( ) ;
da.Dispose ( ) ;
}
catch(Exception ee)
{
MessageBox.Show("出错了"+ee.ToString());
}
}
<appSettings>
<add key="ds" value="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Hospital;connect timeout=120" />
</appSettings>
在.aspx.cs中连接数据库using System.Data.SqlClient;
using System.Configuration;
protected System.Data.SqlClient.SqlCommand cm;
protected System.Data.SqlClient.SqlConnection cn;
#region 向数据库中插入新记录 InsertNewUser()
private void InsertNewUser()
{
cn = new SqlConnection(ConfigurationSettings.AppSettings["ds"]);//连接数据库操作。
string strInsert="insert into user_info(user_id,username,pwd,user_truename,Mobile,Address) values('"+UserID.Text+"','"+UserName.Text+"','"+Pwd.Text+"','"+TrueName.Text+"','"+Mobile.Text+"','"+Address.Text+"')";
cm = new SqlCommand(strInsert,cn);
cn.Open();
try
{
cm.ExecuteNonQuery();
message.InnerHtml="<b>注册成功!请记住你的ID已备下次使用!</b>";
}
catch(Exception ee)
{
message.InnerHtml=ee.ToString();//捕捉错误信息。
}
cn.Close();
}
#endregion
来晚了
说一下两种连接方式吧
1。Connection-DataAdapter-DataSet-DataGrid
2. Connection-Command-DataReader
第二种速度快,不占用内存,
第一中用于显示多数据时,很方便。方法看上面的就行了