Click here to Skip to main content
15,912,082 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralRe: adding a panel to a form. Pin
Luc Pattyn25-Sep-10 5:21
sitebuilderLuc Pattyn25-Sep-10 5:21 
GeneralRe: adding a panel to a form. [modified] Pin
bimbambumbum25-Sep-10 5:31
bimbambumbum25-Sep-10 5:31 
GeneralRe: adding a panel to a form. Pin
Luc Pattyn25-Sep-10 6:08
sitebuilderLuc Pattyn25-Sep-10 6:08 
GeneralRe: adding a panel to a form. [modified] Pin
bimbambumbum25-Sep-10 11:20
bimbambumbum25-Sep-10 11:20 
GeneralRe: adding a panel to a form. Pin
Luc Pattyn25-Sep-10 12:02
sitebuilderLuc Pattyn25-Sep-10 12:02 
QuestionsqlDataAdapter doest not refresh the query Pin
akosidandan22-Sep-10 5:20
akosidandan22-Sep-10 5:20 
AnswerRe: sqlDataAdapter doest not refresh the query Pin
Not Active22-Sep-10 7:42
mentorNot Active22-Sep-10 7:42 
GeneralRe: sqlDataAdapter doest not refresh the query Pin
akosidandan22-Sep-10 22:40
akosidandan22-Sep-10 22:40 
Hello,

Sorry bout not giving good info for my question, the problem came from my 3rd dataAdapter
at this part:

'update changes to quantity of book catalogue records when borrowing///////////////////
                    da3 = New SqlDataAdapter("Select * from BookCatalogueTable where txtAccessionNo='"  lvItems.Items(j).SubItems(0).Text & "'", con)                    
da3.Fill(dt3)                    
dt3.Rows(0).BeginEdit()                    
dt3.Rows(0).Item("intQuantity") = Val(dt3.Rows(0).Item("intQuantity")) - 1
dt3.Rows(0).EndEdit()                    
Dim cb3 As New SqlCommandBuilder(da3)                    
da3.Update(dt3)


My da3 suppose to load again the new query while its on a loop block so that I can Subtract those quantity value,but my da3 doesn't refresh the query that will load new records.
For example my da3 select query at first is "Select * from BookCatalogueTable where txtAccessionNo='1'". After I update the table the new da3 select query for example become "Select * from BookCatalogueTable where txtAccessionNo='2'".My da3 does not execute the next query instead it still using the first query.

Smile | :) If my question is not yet clear I can still clarify to the best I can.
I'm really confuse why my da3 doesn't load the new query.
All comments and suggestion are soo much appreciated.


Thanks,

Dan
GeneralRe: sqlDataAdapter doest not refresh the query Pin
Not Active23-Sep-10 1:08
mentorNot Active23-Sep-10 1:08 
QuestionHow to Show Specific Records in listview Pin
akosidandan22-Sep-10 1:38
akosidandan22-Sep-10 1:38 
AnswerRe: How to Show Specific Records in listview Pin
Luc Pattyn22-Sep-10 2:23
sitebuilderLuc Pattyn22-Sep-10 2:23 
GeneralRe: How to Show Specific Records in listview Pin
akosidandan22-Sep-10 2:29
akosidandan22-Sep-10 2:29 
GeneralRe: How to Show Specific Records in listview Pin
Luc Pattyn22-Sep-10 2:47
sitebuilderLuc Pattyn22-Sep-10 2:47 
QuestionFile recovery Pin
hammerstein0522-Sep-10 0:57
hammerstein0522-Sep-10 0:57 
AnswerRe: File recovery Pin
Pete O'Hanlon22-Sep-10 1:37
mvePete O'Hanlon22-Sep-10 1:37 
GeneralMessage Removed Pin
22-Sep-10 4:23
molesworth22-Sep-10 4:23 
GeneralRe: File recovery Pin
Pete O'Hanlon22-Sep-10 4:35
mvePete O'Hanlon22-Sep-10 4:35 
GeneralRe: File recovery [modified] Pin
molesworth22-Sep-10 4:38
molesworth22-Sep-10 4:38 
AnswerRe: File recovery Pin
molesworth22-Sep-10 4:48
molesworth22-Sep-10 4:48 
GeneralRe: File recovery Pin
hammerstein0522-Sep-10 5:39
hammerstein0522-Sep-10 5:39 
Question.NET code protection Pin
cherrymotion21-Sep-10 23:09
cherrymotion21-Sep-10 23:09 
AnswerRe: .NET code protection Pin
Kubajzz22-Sep-10 3:44
Kubajzz22-Sep-10 3:44 
GeneralRe: .NET code protection Pin
harold aptroot22-Sep-10 4:41
harold aptroot22-Sep-10 4:41 
GeneralRe: .NET code protection Pin
Luc Pattyn22-Sep-10 5:17
sitebuilderLuc Pattyn22-Sep-10 5:17 
AnswerRe: .NET code protection Pin
Eddy Vluggen22-Sep-10 9:37
professionalEddy Vluggen22-Sep-10 9:37 

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.