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

.NET (Core and Framework)

 
GeneralRe: register component success, but can't find one of the controls, professor analyse it. Pin
coderormnger1-Apr-09 5:06
coderormnger1-Apr-09 5:06 
GeneralRe: register component success, but can't find one of the controls, professor analyse it. Pin
Pete O'Hanlon1-Apr-09 8:49
mvePete O'Hanlon1-Apr-09 8:49 
GeneralRe: register component success, but can't find one of the controls, professor analyse it. Pin
coderormnger1-Apr-09 16:30
coderormnger1-Apr-09 16:30 
GeneralRe: register component success, but can't find one of the controls, professor analyse it. Pin
Roger Wright2-Apr-09 19:18
professionalRoger Wright2-Apr-09 19:18 
GeneralRe: register component success, but can't find one of the controls, professor analyse it. Pin
coderormnger7-Apr-09 17:03
coderormnger7-Apr-09 17:03 
QuestionReceive data from RTD client excel on RTD server Pin
mmiller03930-Mar-09 1:06
mmiller03930-Mar-09 1:06 
QuestionRe: Receive data from RTD client excel on RTD server Pin
mmiller03928-Apr-09 1:30
mmiller03928-Apr-09 1:30 
QuestionCommandbuilder update problem Pin
nitin_ion30-Mar-09 0:12
nitin_ion30-Mar-09 0:12 
I have an issue with command builder
below is the code

Public Structure SearchandUpdateClaimDetail
Private cnConnection As System.Data.SqlClient.SqlConnection
Private cmdCommand As System.Data.SqlClient.SqlCommand
Private adAdapter As System.Data.SqlClient.SqlDataAdapter
Private ds As System.Data.DataTable

Sub New(ByVal ConnectionString As String)
cnConnection = New SqlClient.SqlConnection(connectionstring)
cmdCommand = New SqlClient.SqlCommand
adAdapter = New SqlClient.SqlDataAdapter
ds = New DataTable
End Sub

Public Function SearchClaimDetail(ByVal SearchQuery As String) As DataTable
ds.Clear()
cmdCommand.Connection = cnConnection
cmdCommand.CommandText = SearchQuery
adAdapter.SelectCommand = cmdCommand
adAdapter.Fill(ds)
cnConnection.Close()
Return ds
End Function

Public Function UpdateClaimDetail(ByVal DTTable As DataTable) As Boolean
Dim sqcmdb As New SqlClient.SqlCommandBuilder(adAdapter)
adAdapter.Update(dttable)
cnConnection.Close()
Return True
End Function

End Structure

this structure is in a class. i call this structure (function SearchClaimDetail) in another class (BLL) which exposes its function to GUI which binds the grid.

Now when i modify the datatable and sends it back (function UpdateClaimDetail)to update the database it goes smoothly but does not update the database nor it gives any error. There is one primary key in the table which is used in the select command.

How can i update the table. I do not want to insert the rows but to update existing rows.
Questioncopy embedded resources files to given folder wth vb.net Pin
shivamgupta29-Mar-09 1:28
shivamgupta29-Mar-09 1:28 
AnswerRe: copy embedded resources files to given folder wth vb.net Pin
Anubhava Dimri2-Apr-09 21:46
Anubhava Dimri2-Apr-09 21:46 
Questionrestrict access to MyNetworkPlaces and Network Connections on Click Pin
archananaresh29-Mar-09 0:41
archananaresh29-Mar-09 0:41 
QuestionTO make installer with vb.net without using setup and deployment project Pin
shivamgupta28-Mar-09 23:13
shivamgupta28-Mar-09 23:13 
AnswerRe: TO make installer with vb.net without using setup and deployment project Pin
Eslam Afifi29-Mar-09 0:09
Eslam Afifi29-Mar-09 0:09 
AnswerRe: TO make installer with vb.net without using setup and deployment project Pin
thyrith31-Mar-09 5:24
thyrith31-Mar-09 5:24 
QuestionForm is loading very hard, and I need a loader :( Pin
sodevrom27-Mar-09 14:59
sodevrom27-Mar-09 14:59 
AnswerRe: Form is loading very hard, and I need a loader :( Pin
Dave Kreskowiak27-Mar-09 18:04
mveDave Kreskowiak27-Mar-09 18:04 
GeneralRe: Form is loading very hard, and I need a loader :( Pin
Luc Pattyn28-Mar-09 6:45
sitebuilderLuc Pattyn28-Mar-09 6:45 
AnswerRe: Form is loading very hard, and I need a loader :( Pin
Eddy Vluggen28-Mar-09 1:12
professionalEddy Vluggen28-Mar-09 1:12 
QuestionError: Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' fai Pin
Member 419891427-Mar-09 7:42
Member 419891427-Mar-09 7:42 
AnswerRe: Error: Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' Pin
0x3c027-Mar-09 7:50
0x3c027-Mar-09 7:50 
GeneralRe: Error: Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' Pin
Member 419891427-Mar-09 7:58
Member 419891427-Mar-09 7:58 
Question[Message Deleted] Pin
andre1234527-Mar-09 7:37
andre1234527-Mar-09 7:37 
QuestionRe: DBusSharp Pin
led mike27-Mar-09 9:22
led mike27-Mar-09 9:22 
AnswerRe: DBusSharp Pin
andre1234530-Mar-09 0:56
andre1234530-Mar-09 0:56 
GeneralRe: DBusSharp Pin
led mike31-Mar-09 6:04
led mike31-Mar-09 6:04 

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.