Click here to Skip to main content
15,888,733 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Display Images from a database in a tile view Pin
Ali Al Omairi(Abu AlHassan)10-Dec-12 2:23
professionalAli Al Omairi(Abu AlHassan)10-Dec-12 2:23 
Questionlinq connection in asp.net Pin
JonBrynjar8-Dec-12 3:58
JonBrynjar8-Dec-12 3:58 
AnswerRe: linq connection in asp.net Pin
AmitGajjar11-Dec-12 7:00
professionalAmitGajjar11-Dec-12 7:00 
QuestionChange root path Pin
#realJSOP8-Dec-12 3:40
mve#realJSOP8-Dec-12 3:40 
AnswerRe: Change root path Pin
Richard Deeming10-Dec-12 1:35
mveRichard Deeming10-Dec-12 1:35 
GeneralRe: Change root path Pin
#realJSOP10-Dec-12 1:42
mve#realJSOP10-Dec-12 1:42 
AnswerRe: Change root path Pin
AmitGajjar11-Dec-12 7:10
professionalAmitGajjar11-Dec-12 7:10 
QuestionUpdating the column using entity framework Pin
indian1437-Dec-12 12:46
indian1437-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
michal.cerbak7-Dec-12 4:50 
Questionhow to convert hex to rgb color code in asp.net Pin
Deenuji6-Dec-12 23:14
Deenuji6-Dec-12 23:14 
AnswerRe: how to convert hex to rgb color code in asp.net Pin
Richard MacCutchan7-Dec-12 0:32
mveRichard 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
professionaljkirkerx6-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
professionalKeith 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
professionaljkirkerx7-Dec-12 6:47 
QuestionPagination worries Pin
cizu6-Dec-12 5:12
professionalcizu6-Dec-12 5:12 
AnswerRe: Pagination worries Pin
Deflinek7-Dec-12 1:40
Deflinek7-Dec-12 1:40 
AnswerRe: Pagination worries Pin
AnkitGoel.com10-Dec-12 17:33
AnkitGoel.com10-Dec-12 17:33 
QuestionHtml Mail Formate Error Pin
mukusingh5-Dec-12 18:49
mukusingh5-Dec-12 18:49 
AnswerRe: Html Mail Formate Error Pin
jkirkerx6-Dec-12 10:41
professionaljkirkerx6-Dec-12 10:41 
GeneralRe: Html Mail Formate Error Pin
mukusingh6-Dec-12 19:18
mukusingh6-Dec-12 19:18 
Questionhow to set og tag at runtime Pin
Jassim Rahma5-Dec-12 9:12
Jassim Rahma5-Dec-12 9:12 
AnswerRe: how to set og tag at runtime Pin
Deflinek7-Dec-12 1:50
Deflinek7-Dec-12 1:50 
Questionis this a correct og prefix? Pin
Jassim Rahma5-Dec-12 7:36
Jassim Rahma5-Dec-12 7:36 
Questionasp.net vb Pin
NadaSaif5-Dec-12 3:09
NadaSaif5-Dec-12 3:09 
AnswerRe: asp.net vb Pin
ZurdoDev5-Dec-12 4:34
professionalZurdoDev5-Dec-12 4:34 

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.