Click here to Skip to main content
11,633,786 members (76,845 online)
   

ASP.NET

 
GeneralRe: ERROR while updating image in database Pin
Ani199110-Dec-12 21:15
memberAni199110-Dec-12 21:15 
GeneralRe: ERROR while updating image in database Pin
Richard Deeming11-Dec-12 0:54
memberRichard Deeming11-Dec-12 0:54 
GeneralRe: ERROR while updating image in database Pin
jkirkerx11-Dec-12 7:26
memberjkirkerx11-Dec-12 7:26 
Questionmaking a class with streamreader thread safe - perhaps using monitor or a singleton Pin
jkirkerx9-Dec-12 11:45
memberjkirkerx9-Dec-12 11:45 
GeneralRe: making a class with streamreader thread safe - perhaps using monitor or a singleton Pin
jkirkerx9-Dec-12 16:14
memberjkirkerx9-Dec-12 16:14 
QuestionDisplay Images from a database in a tile view Pin
Member 94655649-Dec-12 5:42
memberMember 94655649-Dec-12 5:42 
AnswerRe: Display Images from a database in a tile view Pin
Ali Al Omairi(Abu AlHassan)10-Dec-12 2:23
memberAli Al Omairi(Abu AlHassan)10-Dec-12 2:23 
Questionlinq connection in asp.net Pin
JonBrynjar8-Dec-12 3:58
memberJonBrynjar8-Dec-12 3:58 
AnswerRe: linq connection in asp.net Pin
@AmitGajjar11-Dec-12 7:00
member@AmitGajjar11-Dec-12 7:00 
QuestionChange root path Pin
John Simmons / outlaw programmer8-Dec-12 3:40
mvpJohn Simmons / outlaw programmer8-Dec-12 3:40 
AnswerRe: Change root path Pin
Richard Deeming10-Dec-12 1:35
memberRichard Deeming10-Dec-12 1:35 
GeneralRe: Change root path Pin
John Simmons / outlaw programmer10-Dec-12 1:42
mvpJohn Simmons / outlaw programmer10-Dec-12 1:42 
AnswerRe: Change root path Pin
@AmitGajjar11-Dec-12 7:10
member@AmitGajjar11-Dec-12 7:10 
QuestionUpdating the column using entity framework Pin
indian1437-Dec-12 12:46
memberindian1437-Dec-12 12:46 
Hi All,

I am trying to update a database table using entity framework, but some how I dont know why, but entity framework is updating the other column of the table which I am not setting up in my code. In my update statement after else statement, I am calling to update only column docid (rq.doc_id = doc_id) but I dont know why it is updating even the request_status column also. It is updating with 4 spaces and updating thats all.
I am actually not resetting the request_status value. It is very strange for me.

Can any body please help me in resolving this and getting rid of this problem.

I have my code as below

           Using _databasefactory As New DatabaseFactory()
                Dim context = _databasefactory.DatabaseContext
 
                If Not String.IsNullOrEmpty(temp_doc_id) AndAlso Not String.IsNullOrEmpty(doc_id) Then
                    Dim reqs = (From r In context.requests Where r.claim.claim_no.Equals(claim_no) AndAlso r.temp_doc_id.Equals(r.temp_doc_id)) 'r.empl_accnt_no.Equals(emplacctnumber) AndAlso _

                    Dim res = 0
                    If reqs Is Nothing Then
                        Dim rq = New request()
                        rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
                        rq.empl_accnt_no = emplacctnumber
                        rq.manual_claim_no = ManualClaimNo
                        rq.doc_id = doc_id
                        rq.temp_doc_id = temp_doc_id
                        rq.request_status = "OANEW"
                        rq.last_update_ts = DateTime.Now
                        rq.create_ts = DateTime.Now
                        rq.comments = String.Empty
                        context.AddTorequests(rq)
                        Return context.SaveChanges()
                    ElseIf reqs.Count() <= 0 Then
                        Dim rq = New request()
                        rq.claim = (From r In context.claims Where r.claim_no.Equals(claim_no)).FirstOrDefault()
                        rq.empl_accnt_no = emplacctnumber
                        rq.manual_claim_no = ManualClaimNo
                        rq.doc_id = doc_id
                        rq.temp_doc_id = temp_doc_id
                        rq.request_status = "OANEW"
                        rq.last_update_ts = DateTime.Now
                        rq.create_ts = DateTime.Now
                        rq.comments = String.Empty
                        context.AddTorequests(rq)
                        Return context.SaveChanges()
                    Else
                        Dim rq = reqs.FirstOrDefault()
                        'If Not rq.claimReference.IsLoaded Then
                        '    rq.claimReference.Load()
                        'End If
                        rq.doc_id = doc_id
                        res = context.SaveChanges()
                        Return res
                    End If
                End If
            End Using
Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Questionasp.NET composite control cannot raise an event Pin
michal.cerbak7-Dec-12 4:50
membermichal.cerbak7-Dec-12 4:50 
Questionhow to convert hex to rgb color code in asp.net Pin
Deenuji vellore6-Dec-12 23:14
groupDeenuji vellore6-Dec-12 23:14 
AnswerRe: how to convert hex to rgb color code in asp.net Pin
Richard MacCutchan7-Dec-12 0:32
mvpRichard MacCutchan7-Dec-12 0:32 
Questionasp.net threads, see if thread with same name is running to wait a couple of seconds Pin
jkirkerx6-Dec-12 10:45
memberjkirkerx6-Dec-12 10:45 
AnswerRe: asp.net threads, see if thread with same name is running to wait a couple of seconds Pin
Keith Barrow7-Dec-12 5:21
mentorKeith Barrow7-Dec-12 5:21 
GeneralRe: asp.net threads, see if thread with same name is running to wait a couple of seconds Pin
jkirkerx7-Dec-12 6:47
memberjkirkerx7-Dec-12 6:47 
QuestionPagination worries Pin
cizu6-Dec-12 5:12
membercizu6-Dec-12 5:12 
AnswerRe: Pagination worries Pin
deflinek7-Dec-12 1:40
memberdeflinek7-Dec-12 1:40 
AnswerRe: Pagination worries Pin
AnkitGoel.com10-Dec-12 17:33
memberAnkitGoel.com10-Dec-12 17:33 
QuestionHtml Mail Formate Error Pin
mukusingh5-Dec-12 18:49
membermukusingh5-Dec-12 18:49 
AnswerRe: Html Mail Formate Error Pin
jkirkerx6-Dec-12 10:41
memberjkirkerx6-Dec-12 10:41 
GeneralRe: Html Mail Formate Error Pin
mukusingh6-Dec-12 19:18
membermukusingh6-Dec-12 19:18 
Questionhow to set og tag at runtime Pin
Jassim Rahma5-Dec-12 9:12
memberJassim Rahma5-Dec-12 9:12 
AnswerRe: how to set og tag at runtime Pin
deflinek7-Dec-12 1:50
memberdeflinek7-Dec-12 1:50 
Questionis this a correct og prefix? Pin
Jassim Rahma5-Dec-12 7:36
memberJassim Rahma5-Dec-12 7:36 
Questionasp.net vb Pin
Nada ALsalami5-Dec-12 3:09
memberNada ALsalami5-Dec-12 3:09 
AnswerRe: asp.net vb Pin
ryanb315-Dec-12 4:34
memberryanb315-Dec-12 4:34 
GeneralRe: asp.net vb Pin
Nada ALsalami5-Dec-12 5:05
memberNada ALsalami5-Dec-12 5:05 
GeneralRe: asp.net vb Pin
ryanb315-Dec-12 7:17
memberryanb315-Dec-12 7:17 
AnswerRe: asp.net vb Pin
jkirkerx5-Dec-12 17:22
memberjkirkerx5-Dec-12 17:22 
GeneralRe: asp.net vb Pin
Nada ALsalami6-Dec-12 1:56
memberNada ALsalami6-Dec-12 1:56 
AnswerRe: asp.net vb Pin
jkirkerx6-Dec-12 7:32
memberjkirkerx6-Dec-12 7:32 
GeneralRe: asp.net vb Pin
jkirkerx6-Dec-12 11:36
memberjkirkerx6-Dec-12 11:36 
GeneralRe: asp.net vb Pin
Nada ALsalami12-Dec-12 5:03
memberNada ALsalami12-Dec-12 5:03 
GeneralRe: asp.net vb Pin
jkirkerx12-Dec-12 5:55
memberjkirkerx12-Dec-12 5:55 
GeneralRe: asp.net vb Pin
Nada ALsalami12-Dec-12 21:14
memberNada ALsalami12-Dec-12 21:14 
Question70-513 Video Tutorial Please Pin
silentspeaker5-Dec-12 2:45
membersilentspeaker5-Dec-12 2:45 
AnswerRe: 70-513 Video Tutorial Please Pin
Richard MacCutchan5-Dec-12 2:55
mvpRichard MacCutchan5-Dec-12 2:55 
GeneralRe: 70-513 Video Tutorial Please Pin
silentspeaker5-Dec-12 7:05
membersilentspeaker5-Dec-12 7:05 
QuestionDataList with Product Heads. Pin
Asif Rehman4-Dec-12 7:17
memberAsif Rehman4-Dec-12 7:17 
AnswerRe: DataList with Product Heads. Pin
Himanshu Yadav4-Dec-12 18:53
memberHimanshu Yadav4-Dec-12 18:53 
QuestionHI,how to do access sqlserver use windows domain user? Pin
xut24473-Dec-12 19:20
memberxut24473-Dec-12 19:20 
AnswerRe: HI,how to do access sqlserver use windows domain user? Pin
J4amieC3-Dec-12 22:24
memberJ4amieC3-Dec-12 22:24 
GeneralRe: HI,how to do access sqlserver use windows domain user? Pin
Andrew Stoute4-Dec-12 4:25
memberAndrew Stoute4-Dec-12 4:25 
Questionaspnet_wp process crash Pin
Kishore Hyd3-Dec-12 12:11
memberKishore Hyd3-Dec-12 12:11 
QuestionRe: aspnet_wp process crash Pin
ryanb315-Dec-12 4:36
memberryanb315-Dec-12 4:36 

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

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


Advertise | Privacy | Mobile
Web01 | 2.8.150728.1 | Last Updated 29 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid