ADO.NET:使用ADO.NET连接文本文件 -pc6资讯

您的位置：首页 → 技术开发 → ASP技巧 → ADO.NET:使用ADO.NET连接文本文件

ADO.NET:使用ADO.NET连接文本文件 时间：2004/11/7 4:11:00来源：本站整理作者：蓝点我要评论(0): try

{

// create a new ADOConnection to the text file through ODBC and an existing Data Source

ADOConnection conn = new ADOConnection("Provider=MSDASQL;DSN=registrations;");

// create a DataSet Command that selects all the records from the registration.txt table (which in this case is a file)

ADODataSetCommand AdoCmd = new ADODataSetCommand("SELECT * FROM registrations.txt", conn);

// fill the dataset with the registration.txt table

AdoCmd.FillDataSet(dataSet1, "registrations.txt");

DataTable ContactTable = dataSet1.Tables[0];

int count = 0;

// loop through each row of the table and fill 15 rows of the listview

foreach (DataRow dr in ContactTable.Rows)

{

listView3.ListItems[count].Text = dr["LastName"].ToString();

listView3.ListItems[count].SetSubItem(0, dr["FirstName"].ToString());

listView3.ListItems[count].SetSubItem(1, dr["Company"].ToString());

listView3.ListItems[count].SetSubItem(2, dr["Address"].ToString());

count++;

if (count > 15)

{

break;

}

}

}

catch(ADOException ae)

{

Console.WriteLine(ae.Message.ToString());

}

That's all there is to it. This should also give you an idea of how to connect to databases through ODBC such as Oracle, Informix, Sybase, or Interbase. All you need to do is set up the appropriate Data Source through the Administration tools and use the code above to access your tables.

文章评论

查看所有0条评论>>

热门文章 没有查询到任何记录。