Visual studio .net Recordset

Posted on 2005-04-15
Last Modified: 2013-11-25
How can I create a recordset into project
Question by:chouproute
    LVL 7

    Expert Comment

    what do you mean by creating a recordset into a project?

    Do you mean creating a DataSet inside an project?  
    LVL 5

    Expert Comment

    A record set is used in asp classic/vb etc. It has since been replaced by datatables, datasets (in memory results sets that can actually be a collection of more than one table, with relationships etc. - dumbed down explanation) and the datareader (not in memory, forward only). Benefits and drawbacks to all, but considerable improvement over the old way.


    Author Comment

    Can you explain how to work with Dataset,
    just an example of code to help me to start.
    LVL 7

    Accepted Solution

    ok...try this:

    //set your sql statement
    string sql = "SELECT * FROM Customers";

    //setting up your connection object assuming it's njot a trusted connection
    SqlConnection m_cn = new SqlConnection(@";Database=myDatabaseName;User  ID=userName;Password=yourPassword;Trusted_Connection=False");

    //setting up your dataAdapter
    SqlDataAdapter daCustomers = new SqlDataAdapter(sql, m_cn);

    //create your dataset here
    DataSet dsCustomer = new DataSet();

    //fill your dataSet with customers rec ords.
    daCustomers.Fill(dsCustomer, "Customers");

    check out this link below.  i found it to be really useful to get the in and out of in general

    Author Comment

    HOw thanks a lot,
    Is there any way with VB.NET to create a "browsable" datagrid(when we put the mouse over a line in the datagrid, she became on other color, and when we click on it,  a new page appear)


    LVL 7

    Expert Comment

    check this link out.

    there was one other site that had a dll file that one only needs to import it via "Add/Remove Items" and voila.  It's free too but can't seem to find it.  Gimme your e-mail and i'll sent it to you.

    hope i'm not breaking any laws... =)


    Author Comment

    I already read the first link it dooesn't seem to work.....

    my mail is

    Thanks again

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now