Click here to Skip to main content
15,912,400 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionAdding nodes to a treeview control Pin
Raistlin21_459-May-06 7:25
Raistlin21_459-May-06 7:25 
AnswerRe: Adding nodes to a treeview control Pin
digicd19-May-06 16:22
digicd19-May-06 16:22 
GeneralRe: Adding nodes to a treeview control Pin
Raistlin21_4510-May-06 6:01
Raistlin21_4510-May-06 6:01 
AnswerRe: Adding nodes to a treeview control Pin
Hacknight949-May-06 20:37
Hacknight949-May-06 20:37 
GeneralRe: Adding nodes to a treeview control Pin
Raistlin21_4510-May-06 6:05
Raistlin21_4510-May-06 6:05 
GeneralRe: Adding nodes to a treeview control Pin
Hacknight9410-May-06 14:15
Hacknight9410-May-06 14:15 
GeneralRe: Adding nodes to a treeview control Pin
Hacknight9410-May-06 14:21
Hacknight9410-May-06 14:21 
Questionfrom ADO to ADO.NET 2.0 Pin
Gulfraz Khan9-May-06 6:11
Gulfraz Khan9-May-06 6:11 
Hi!


The following code selects a row from a table. If the row exists then it is updated otherwise a new row is added to the table.

How can I write this code using ADO.NET 2.0?

Dim rsRequest As New ADODB.Recordset<br />
rsRequest.Open "Select Form_No, User_ID, Status, Request_Date from tbl_ReExport_Info Where Form_No = '" & txtFormNo.Text & "' And User_ID = '" & txtUserID.Text & "'", cnnADO, adOpenDynamic, adLockOptimistic<br />
With rsRequest<br />
    If .EOF = True Then .AddNew<br />
    !Form_No = txtFormNo.Text<br />
    !User_ID = txtUserID.Text<br />
    !Status = 0<br />
    !Request_Date = Now<br />
    .Update<br />
End With<br />


Thank You

Gulfraz Khan
QuestionHandling Complex Numbers Pin
crtwrght_mrk9-May-06 6:09
crtwrght_mrk9-May-06 6:09 
AnswerRe: Handling Complex Numbers Pin
darkelv9-May-06 6:25
darkelv9-May-06 6:25 
QuestionRe: Handling Complex Numbers Pin
crtwrght_mrk9-May-06 9:34
crtwrght_mrk9-May-06 9:34 
Question&quot;load report failed&quot; error Pin
sarah_chandran9-May-06 5:05
sarah_chandran9-May-06 5:05 
AnswerRe: &amp;quot;load report failed&amp;quot; error Pin
penguin500011-May-06 20:05
penguin500011-May-06 20:05 
Questionhow to export crystal report from vb in pdf format Pin
virendra_sw9-May-06 3:48
virendra_sw9-May-06 3:48 
AnswerRe: how to export crystal report from vb in pdf format Pin
albCode9-May-06 4:07
albCode9-May-06 4:07 
GeneralRe: how to export crystal report from vb in pdf format Pin
virendra_sw9-May-06 19:33
virendra_sw9-May-06 19:33 
Questionneed help on programing methods Pin
Eleazer9-May-06 2:46
Eleazer9-May-06 2:46 
AnswerRe: need help on programing methods Pin
J4amieC9-May-06 3:36
J4amieC9-May-06 3:36 
Questiona simple question ? (how to use Raiseevent ?) Pin
cmpeng349-May-06 1:38
cmpeng349-May-06 1:38 
AnswerRe: a simple question ? (how to use Raiseevent ?) Pin
Daniel Grunwald9-May-06 8:26
Daniel Grunwald9-May-06 8:26 
QuestionWindow Service Pin
nitin_ion9-May-06 1:04
nitin_ion9-May-06 1:04 
AnswerRe: Window Service Pin
Rizwan Bashir9-May-06 1:37
Rizwan Bashir9-May-06 1:37 
GeneralRe: Window Service Pin
nitin_ion9-May-06 18:50
nitin_ion9-May-06 18:50 
GeneralRe: Window Service Pin
Rizwan Bashir9-May-06 21:43
Rizwan Bashir9-May-06 21:43 
Questionregarding Common Dialog Control Pin
Vijaya Krishnamoorthy8-May-06 23:37
Vijaya Krishnamoorthy8-May-06 23: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.