Click here to Skip to main content
       

Visual Basic

 
AnswerRe: Mouse Down Event and Flag setting Pinmemberbig_col29-Nov-12 20:19 
AnswerRe: Mouse Down Event and Flag setting PinmemberAlan N29-Nov-12 3:09 
Questionvb6 to .net Pinmemberdvdljns28-Nov-12 7:42 
AnswerRe: vb6 to .net PinmemberZaf Khan28-Nov-12 16:58 
GeneralRe: vb6 to .net Pinmemberdvdljns1-Dec-12 5:47 
GeneralRe: vb6 to .net PinmemberZaf Khan1-Dec-12 8:00 
AnswerRe: vb6 to .net PinmvpDave Kreskowiak28-Nov-12 18:04 
QuestionDeleting a datarow, creating a query to find the row. - ANSWERED, Thank yo [modified] PinmemberJRHibner27-Nov-12 23:30 
Hello,
 
I'm using:
Microsoft Visual Basic 2008, Professional Edition
 
I've run into a problem I can't figure out. I'm using VB 2008. I found the following sample code and was attempting to use it but am not understanding how to setup the query, I bolded it below.
 
I understand I need to go in and set up my own customer query in my database in order to use it like the example below.
Q) Do I setup the query on my table adapter or on the original table in the database (Maybe even some good info on how to setup these queries)?
 
Q)If I'm understanding this, once I setup the query correctly I should just have to put in a variable and it fill find all row(s) with that parameter that I can delete?
 
Q) When using the @XXXX in the query, do I have to then use that as my variable to pass the data I'm looking for or can I use and variable?
 
' Locate the row to delete.
Dim oldRegionRow As NorthwindDataSet.RegionRow
oldRegionRow = NorthwindDataSet._Region.FindByRegionID(5)
 
' Delete the row from the dataset
oldRegionRow.Delete()
 
' Delete the row from the database
Me.RegionTableAdapter.Update(Me.NorthwindDataSet._Region)
 
I was able to setup the following query on my database but per the example, I'm not sure I did it correctly:
 
SELECT        Gene, FindMethod, TDiscovery, TReplicate, AA_A, AA_T, AA_G, AA_C, ImageFileName, Description, SpxReplicationItem, IconFileName, Complete, Image, Icon, Type,
                         UniqueID, Chromosome, Rarity, ParentGene, Name
FROM            PlazimorphGenes
WHERE        (Gene = @genename)
 
I then tried using it as this:
 
tRow = PlazimorphDBDataSet.PlazimorphGenes.FillByGene(genename) 
 
and got an error that it is not a member of the database.
 
Thank you for all the help! I've been searching this forum and the web in general and have found the best help here!

modified 1-Dec-12 15:44pm.

AnswerRe: Deleting a datarow, creating a query to find the row. PinmemberAndy_L_J28-Nov-12 22:30 
GeneralRe: Deleting a datarow, creating a query to find the row. PinmemberJRHibner1-Dec-12 7:21 
GeneralRe: Deleting a datarow, creating a query to find the row. PinmemberAndy_L_J1-Dec-12 20:27 
GeneralRe: Deleting a datarow, creating a query to find the row. PinmemberJRHibner9-Dec-12 14:55 
QuestionModified Registry Key Pinmemberalirezamansoori27-Nov-12 18:52 
AnswerRe: Modified Registry Key PinmvpRichard MacCutchan28-Nov-12 0:02 
GeneralRe: Modified Registry Key Pinmemberalirezamansoori28-Nov-12 0:39 
GeneralRe: Modified Registry Key PinmvpRichard MacCutchan28-Nov-12 1:15 
QuestionLooking for idea for learning book PinmemberNaZReD24-Nov-12 9:08 
AnswerRe: Looking for idea for learning book PinmemberEddy Vluggen27-Nov-12 12:58 
QuestionInstall SQL Server on Another Computer without reach there PinmemberUmesh Bachchani24-Nov-12 7:03 
AnswerRe: Install SQL Server on Another Computer without reach there PinmemberEddy Vluggen27-Nov-12 12:59 
Question8queen ga write in vb Pinmemberbakhshipoor21-Nov-12 9:42 
AnswerRe: 8queen ga write in vb PinmemberDavid Mujica21-Nov-12 10:16 
AnswerRe: 8queen ga write in vb PinmvpRichard MacCutchan21-Nov-12 22:13 
QuestionOnline handwriting recognition system using vector machine [modified] PinmemberHafiqWiselman21-Nov-12 1:39 
RantRe: Online handwriting recognition system using vector machine PinmemberRichard Deeming21-Nov-12 2:16 

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.141022.2 | Last Updated 24 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid