ado.net中的dataadapter和数据集 [英] dataadapter and data set in ado.net

问题描述

我在sqldatabase名称记录中有一个表，其中有3列Id，Name，Address .....我想用数据集和dataadapter填充此表，但不知道如何??? PLZ帮我示例应该在控制台应用程序格式...？

i have a table in sqldatabase name records which has 3 columns Id,Name,Address..... i want to fill this table with entries using dataset and dataadapter but dont know how??? plz help me example should be in console app formate...?

推荐答案

Dim connectionString As String = "Data Source=Machine_Name;Initial Catalog=DB_Name;User ID=;Password="
     Private conn As SqlConnection = New SqlConnection(connectionString)
     conn.Open()

     Dim squery As String
     squery = "select * from tblName where Id=' "  & Id & "' ";
     Dim command As New SqlCommand(squery, conn)
     command.CommandType = CommandType.Text
     Dim data As New SqlDataAdapter(command)
     Dim dsData As New DataSet()
     data.Fill(dsData)
     conn.Close()

SqlConnection conn=new SqlConnection("Connection string Here");
            conn.Open();
            SqlCommand cmd=new SqlCommand("Command text here",conn);

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adapter.Fill(ds);

试试这个......

Try this.....

这篇关于ado.net中的dataadapter和数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！