Solved

BindingNavigator problem....

Posted on 2006-06-20
19
533 Views
Last Modified: 2008-09-13
Please....

I have a form with Bindingsource, Dataset, DataAdapter and BindingNavigator...

The problem is that bindingNavigator is not flexible...So..What I want is to implement the funcionality of add, Update, delete to my data, but using storedProcedures and using the possibility, for example, to ask the user before delete a Record... Anybody can help me ? Is it possible using the bindingNavigator, But modifiyng the standard behaviour of it  ?¿ ¿


Thanks in advance

 
0
Comment
Question by:franklinan
  • 10
  • 9
19 Comments
 
LVL 10

Expert Comment

by:vadim63
ID: 16943443
Of course, it is. You can remove all the standard buttons and create your own buttons, with your own queries (with Stor_proc, or whatever).
0
 
LVL 1

Author Comment

by:franklinan
ID: 16945790
please...a sample of how to call a simple stored procedure....just returning a value....
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16945848
Did you create your Dataset, DataAdapter at design time? Can you edit your DataSet with designer?
0
 
LVL 1

Author Comment

by:franklinan
ID: 16945872
I've got my Dataset and DataAdapter with Designer....I can Edit the Dataset...But I don't know how to "Include" the call to Stored Procedure.....please help ! Thanks for your fast answer !
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16945958
OK, go to designer > right click on your TableAdapter > Add query > Use Existing Stored Procedure > Select the Stored Procedure from the dropdown list >  click next > check "A single value" > click next > Assign the name > Finish.
0
 
LVL 1

Author Comment

by:franklinan
ID: 16946005
um....I'm sorry but something is not ok....

In my TableAdapter actually I've a Query that is a select, which result is used by BindingSource to link with several text boxes where the data is shown....

I don't want to loose this....

One more thing : If I use right click, I don't have any option of use a Stored Procedure...just can use a Query Generator..... (I'm using VS2005)....

I'm confused,....sorry
0
 
LVL 1

Author Comment

by:franklinan
ID: 16946577
Finally I've Drag and Drop the Stored Procedure (Add new Datasource) and now  a Dataset is created...My problem is...HOW I CALL THAT ? ? ? ? ?

Please...a sample....I'm totally lost !
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16946612
If you already have a Dataset, you don't need to create another one. You can add adapters, queries to existing Dataset.
0
 
LVL 10

Accepted Solution

by:
vadim63 earned 500 total points
ID: 16946794
Check this pictures:

http://www.treckamerica.com/ee.htm
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:franklinan
ID: 16951763
Can you put some code of how to access insert Stored procedure created ? I don't know how to do that...
0
 
LVL 1

Author Comment

by:franklinan
ID: 16951779
I can't find the stroed procedures created n the Database....Something I'm doing wrong maybe....
0
 
LVL 1

Author Comment

by:franklinan
ID: 16952295
One last question...Actually I have modified the add item on BindingNavigator with this :

Private Sub BindingNavigatorAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click
        T_NombreTableAdapter.SP_AddItem(NomTxt.Text, ApeTxt.Text)

    End Sub

Other Items on BindingNavigator are original....

On SAVEITEM is this :

Private Sub T_NombreBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles T_NombreBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.T_NombreBindingSource.EndEdit()
        Me.T_NombreTableAdapter.Update(Me.FrankDataSet.T_Nombre)

    End Sub

Why When I click ADD after put some Values, and CLICK on SAVEI to Update the Database, the changes are not visible till I close and open the aplication again ? ?


0
 
LVL 10

Expert Comment

by:vadim63
ID: 16952339
Because you have to refill your tableadapter.

        Me.Validate()
        Me.T_NombreBindingSource.EndEdit()
        Me.T_NombreTableAdapter.Update(Me.FrankDataSet.T_Nombre)

        Me.T_NombreTableAdapter.Fill(Me.FrankDataSet.T_Nombre)
0
 
LVL 1

Author Comment

by:franklinan
ID: 16952374
um...and I have to reload all Dataset ? ?  ?...Not possible to only reload the modified/added records ?
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16952411
I don't know the way you fill it Initially
0
 
LVL 1

Author Comment

by:franklinan
ID: 16952471
Finally Works, but I would like to reload only modified/added results....any idea ?

I've got this code :



Public Class Form1
    Dim AddRecord As Boolean = False

    Private Sub T_NombreBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles T_NombreBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.T_NombreBindingSource.EndEdit()
        '
        If AddRecord = True Then
            T_NombreTableAdapter.SP_Añadir(NombreTxt.Text, ApellidoTxt.Text)
        Else
            Me.T_NombreTableAdapter.Update(Me.FrankDataSet.T_Nombre)
        End If

        Me.T_NombreTableAdapter.Fill(Me.FrankDataSet.T_Nombre)
        AddRecord = False
    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
     
        Me.T_NombreTableAdapter.Fill(Me.FrankDataSet.T_Nombre)

    End Sub

    Private Sub BindingNavigatorAddNewItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorAddNewItem.Click
        AddRecord = True
        NombreTxt.Text = ""
        ApellidoTxt.Text = ""

    End Sub
End Class
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16952730
OK, as I can see, initially, you pull all records. So, I didn't understand, would you like to pull only one record after inserting/updating, or all records, but positioned on the last modified/added row?
0
 
LVL 10

Expert Comment

by:vadim63
ID: 16952814
And another question. What kind of control are you binding with your data? Datagridview? Textboxes?
0
 
LVL 1

Author Comment

by:franklinan
ID: 16955456
a) What I'm refering is : If I have a Dataset Loaded, why Do I need to read again all records each time I  add just one ? The best would be just to recover the new add record, because all the other are loaded on the Dataset and them have'nt been modified.


b) I have a lot of textboxes... Is it a fast way of write the call to StoredProcedure with all parameters ? Maybe I've 30 parameters to pass !  ! !
T_NombreTableAdapter.SP_Añadir(NombreTxt.Text, ApellidoTxt.Text,   [........  to 30 ! ! ! ! ])


Thanks again for your help..I appreciate soooo much !!!!!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

13 Experts available now in Live!

Get 1:1 Help Now