显示代码:
Public Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load DataGrid1.DataSource = createdataview()
DataGrid1.DataBind() '在此处放置初始化页的用户代码
End Sub
Function createdataview() As DataView
Dim strconnection, strsql As String
Dim mycommand As SqlDataAdapter
Dim ds As DataSet
strconnection = "server=rxy;uid=sa;pwd=sa;database=pubs"
strsql = "select * from titleview"
mycommand = New SqlDataAdapter(strsql, strconnection)
ds = New DataSet
mycommand.Fill(ds, "titleview")
createdataview = New DataView(ds.tables("titleview"))
End Function分页:
Private Sub datagrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataSource = createdataview()
DataGrid1.DataBind()
End Sub
注意设定AllowPaging="True"
Public Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load DataGrid1.DataSource = createdataview()
DataGrid1.DataBind() '在此处放置初始化页的用户代码
End Sub
Function createdataview() As DataView
Dim strconnection, strsql As String
Dim mycommand As SqlDataAdapter
Dim ds As DataSet
strconnection = "server=rxy;uid=sa;pwd=sa;database=pubs"
strsql = "select * from titleview"
mycommand = New SqlDataAdapter(strsql, strconnection)
ds = New DataSet
mycommand.Fill(ds, "titleview")
createdataview = New DataView(ds.tables("titleview"))
End Function分页:
Private Sub datagrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataSource = createdataview()
DataGrid1.DataBind()
End Sub
注意设定AllowPaging="True"
SqlDataAdapter--->adoconnection
-->strconnection="provider=microsoft.jet.oledb4.0;datasource="c:\mdb\aaa.mdb";...)
-->strsql=""select * from wen"
{
string myStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+@"\mydb.mdb";
myConn=new OleDbConnection(myStr);
myConn.Open();
}
//连接基础数据表
private void ConnectBase()
{
GetConnect();
string mySql="select * from base";
OleDbDataAdapter myCommand=new OleDbDataAdapter(mySql,myConn);
myCommand.Fill(myDataSet,"Base");
myConn.Close();
}
//连接temp1,并读取框架到数据集中
private void TempDataRead()
{
GetConnect();
string DataTemp="select mbox,mresistor,mcode,mclass,mnum,mcomment,child_class from temp1";
myCommandRead=new OleDbDataAdapter(DataTemp,myConn);
myCommandRead.Fill(myDataSet,"Temp1");
myConn.Close();
//myDataSet.Tables["Temp1"].Columns[0].ColumnMapping=MappingType.Hidden;
DataView dv=new DataView(myDataSet.Tables["Temp1"]);
dataGrid1.SetDataBinding(dv,null);
}
//nuptrxy(快乐)的代码是vb.net的吧?我不会改成C#。 private void TempDataRead()
{
string myStr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+@"\myTest.mdb";
OleDbConnection myConn=new OleDbConnection(myStr);
myConn.Open(); try
{
string DataTemp="select 标题,作者,分类 from temp1";
OleDbDataAdapter myCommandRead=new OleDbDataAdapter(DataTemp,myConn);
DataSet myDataSet=new DataSet() ;
myCommandRead.Fill(myDataSet,"Temp1");
myConn.Close();
//myDataSet.Tables["Temp1"].Columns[0].ColumnMapping=MappingType.Hidden;
DataView dv=new DataView(myDataSet.Tables["Temp1"]);
dataGrid1.SetDataBinding(dv,null);
}
catch (Exception f)
{
MessageBox.Show (f.Message,"程序发生异常!");
}
finally
{
myConn.Close();
}
}