Click here to Skip to main content
15,921,622 members
Home / Discussions / Visual Basic
   

Visual Basic

 
NewsRe: How can I trace an AddIn's startup error? Pin
Sonhospa30-Jun-10 0:01
Sonhospa30-Jun-10 0:01 
GeneralRe: How can I trace an AddIn's startup error? Pin
Dave Kreskowiak30-Jun-10 1:35
mveDave Kreskowiak30-Jun-10 1:35 
GeneralRe: How can I trace an AddIn's startup error? Pin
Sonhospa30-Jun-10 3:07
Sonhospa30-Jun-10 3:07 
GeneralRe: How can I trace an AddIn's startup error? Pin
Dave Kreskowiak30-Jun-10 3:27
mveDave Kreskowiak30-Jun-10 3:27 
GeneralRe: How can I trace an AddIn's startup error? Pin
Sonhospa30-Jun-10 6:26
Sonhospa30-Jun-10 6:26 
GeneralRe: How can I trace an AddIn's startup error? Pin
Luc Pattyn30-Jun-10 7:03
sitebuilderLuc Pattyn30-Jun-10 7:03 
GeneralRe: How can I trace an AddIn's startup error? Pin
Dave Kreskowiak30-Jun-10 7:13
mveDave Kreskowiak30-Jun-10 7:13 
QuestionDatagridview and Bindingsource Pin
Nielvh29-Jun-10 1:48
Nielvh29-Jun-10 1:48 
Hi All,
I have a userform (BinSheetForm) which I bind to a datasource as per the code below.
Private Sub BinSheetForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        BsCountIdLabel.Text = iCountId.ToString
        Dim Conn As New SqlConnection(CntString)
        conn.Open()
        adapter = New SqlDataAdapter("select * from zz_ST_Binsheets", Conn)
        adapter.FillSchema(dtset, SchemaType.Source, "zz_ST_Binsheets")
        adapter.Fill(dtset, "zz_ST_Binsheets")
        Conn.Close()
        bind.DataSource = dtset
        bind.DataMember = "zz_ST_Binsheets"
    End Sub


On this userform I have a datagridview that I fill with the follwing code.

Private Sub FillBinDataGrid()
        With Me.BsDataGridView
            .DataSource = bind
            .EditMode = DataGridViewEditMode.EditOnEnter
        End With
    End Sub


Up to this point it works fine, but now I want to do 2 more things.

First:
The database table zz_ST_Binsheets contains columns "iCountId" and "iBinNr". I have a label on the from that contains the value of "iCountId" and a textbox where the user can enter a value for "iBinNr". The user will then press a button and the datagridview must only be filled with the selection where "iCountId" = the label value and "iBinNr" = the textbox value.

Second:
I want the changes that the user make to be saved back to the database. The changes would include editing current data, adding new rows and deleting current rows.

I am using VS2005.

Thanks in advance.
AnswerRe: Datagridview and Bindingsource Pin
DaveAuld29-Jun-10 2:05
professionalDaveAuld29-Jun-10 2:05 
GeneralRe: Datagridview and Bindingsource Pin
Nielvh29-Jun-10 3:14
Nielvh29-Jun-10 3:14 
GeneralRe: Datagridview and Bindingsource [modified] Pin
DaveAuld29-Jun-10 3:28
professionalDaveAuld29-Jun-10 3:28 
GeneralRe: Datagridview and Bindingsource Pin
Nielvh29-Jun-10 4:06
Nielvh29-Jun-10 4:06 
AnswerRe: Datagridview and Bindingsource Pin
DaveAuld29-Jun-10 2:09
professionalDaveAuld29-Jun-10 2:09 
GeneralRe: Datagridview and Bindingsource Pin
Nielvh29-Jun-10 3:15
Nielvh29-Jun-10 3:15 
QuestionPinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip28-Jun-10 22:45
Hrizip28-Jun-10 22:45 
AnswerRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
freakyit29-Jun-10 0:15
freakyit29-Jun-10 0:15 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 0:35
Hrizip29-Jun-10 0:35 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 1:29
Hrizip29-Jun-10 1:29 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
freakyit29-Jun-10 2:34
freakyit29-Jun-10 2:34 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 2:41
Hrizip29-Jun-10 2:41 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 3:00
Hrizip29-Jun-10 3:00 
AnswerRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Luc Pattyn29-Jun-10 3:37
sitebuilderLuc Pattyn29-Jun-10 3:37 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 3:43
Hrizip29-Jun-10 3:43 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
freakyit29-Jun-10 4:00
freakyit29-Jun-10 4:00 
GeneralRe: Pinvoking a non WIN32 API under VB, cant get handle to printer Pin
Hrizip29-Jun-10 4:31
Hrizip29-Jun-10 4:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.