in

C1 Community

ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
C1 Community » NET » True DBGrid for .NET » .NET beginner

.NET beginner

Last post 12-11-2007 1:08 AM by C1_JamesS. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next

  • 10-27-2007 3:50 AM

    • Compix
    • Not Ranked
    • Joined on 10-26-2007
    • Posts 2

    .NET beginner

    Reply Contact

    Good morning,

    Please, if it possible, I'd like to have a simple VB.NET 2005 example of how to bind a C1TDBGrid to a database, how to select the data using an SQL instruction and how to update back to the database the tables modified in the grid, but all this examples completely using code, I mean without any other control (except for the button used for the "Save data" function).

    Thank you very much for your help (if you prefer you can replay by e-mail at info@compix.it - Tx again)

    Paolo Ridolfo (Compix)
    Filed under: , ,

  • 10-29-2007 5:14 PM In reply to

    Re: .NET beginner

    Reply Contact
    Hello Paolo,
     
    Have you tried the sample tutorials from the link below:
     
    C:\Program Files\ComponentOne Studio.NET 2.0\C1TDBGrid\Tutorials\vb
     
    These samples are installed with the setup, they however uses MS Acess as a database files.
     
    Thanks,
    James Smith
    <Compix> wrote in message news:199297@10.0.1.98...

    Good morning,

    Please, if it possible, I'd like to have a simple VB.NET 2005 example of how to bind a C1TDBGrid to a database, how to select the data using an SQL instruction and how to update back to the database the tables modified in the grid, but all this examples completely using code, I mean without any other control (except for the button used for the "Save data" function).

    Thank you very much for your help (if you prefer you can replay by e-mail at info@compix.it - Tx again)

    Paolo Ridolfo (Compix)


    http://helpcentral.componentone.com/cs/forums/p/73412/199297.aspx#199297

  • 10-30-2007 1:44 AM In reply to

    • Compix
    • Not Ranked
    • Joined on 10-26-2007
    • Posts 2

    Re: .NET beginner

    Reply Contact

    Hi, may be I am not able to explain what I want (my english is soo poor)...

    All the examples that I have, are using other components for connecting the grid to the database and are not flexible... I'd like to have VB.NET examples that retrieves data to a C1tdbgrid where I can change the data or add or delete a record, and than write the data changed to the database, but all USING THE CODE, without other components (with VB6 was soo easy to do that... but now I feel lost with VB.NET 2005).

    Regards

    Paolo Ridolfo
    Filed under: , , ,

  • 11-19-2007 6:58 AM In reply to

    Re: .NET beginner

    Reply Contact

    Hello,

     

    “with VB6 was soo easy to do that... but now I feel lost with VB.NET 2005Best Regards,”

    You just need to use the same concepts to create a “ConnectionString” in code and then set the datasource property to an appropriate dataset.

    Let me know if you want me to create a small sample application for you.

    Best Regards,

    James Smith

    <Compix> wrote in message news:199317@10.0.1.98...

    Hi, may be I am not able to explain what I want (my english is soo poor)...

    All the examples that I have, are using other components for connecting the grid to the database and are not flexible... I'd like to have VB.NET examples that retrieves data to a C1tdbgrid where I can change the data or add or delete a record, and than write the data changed to the database, but all USING THE CODE, without other components (with VB6 was soo easy to do that... but now I feel lost with VB.NET 2005).

    Regards

    Paolo Ridolfo


    http://helpcentral.componentone.com/cs/forums/p/73412/199317.aspx#199317

  • 11-26-2007 11:11 AM In reply to

    Re: .NET beginner

    Reply Contact

    I am in the same boat as this guy.  This is doing my head in.

    I want to add records, update, edit etc but not the grid directly - in code and have the grid reflect the changes.

    Plus run queries and have the grid update. 

    There are NO examples anywhere - I have spent days looking for this now.

  • 12-11-2007 1:08 AM In reply to

    Re: .NET beginner

    Tutor02.zip
    Reply Contact

    Hello,

    Control documentation do have a reference on how you can execute SQL queries in TDBGrid.

    Please find attached a small sample application which achieves the desired scenario.

    Best Regards,

    James Smith

    <rcw8892> wrote in message news:199903@10.0.1.98...

    I am in the same boat as this guy.  This is doing my head in.

    I want to add records, update, edit etc but not the grid directly - in code and have the grid reflect the changes.

    Plus run queries and have the grid update. 

    There are NO examples anywhere - I have spent days looking for this now.


    http://helpcentral.componentone.com/cs/forums/p/73412/199903.aspx#199903
Page 1 of 1 (6 items)
Contact ComponentOne: 1.800.858.2739 ©1987-2008 ComponentOne LLC All Rights Reserved.