Click here to Skip to main content
       

Visual Basic

 
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 
AnswerRe: Deleting a datarow, creating a query to find the row. PinmemberAndy_L_J28-Nov-12 22:30 
Have you got a link to the code you are trying?
 
I suspect that you require a Stored Procedure on the Database:
  USE BDNAME
GO
 
CREATE PROCEDURE SelectByGeneName(
  @GeneName VarChar(100)
)
AS
BEGIN
  SET NOCOUNT ON;
 
  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
 
  RETURN;
 
END
GO
 
I dont use the automatic binding etc...so I would retreive the data like this:
Public Function GetByGeneName(name as String) As DataTable
  Dim cn as New SqlConnection(ConnStr) ' Your connection string
  Dim cmd as New SqlCommand
  Dim dt as New DataTable("PlazimorphGenes")
  Try
    cn.Open()
    With cmd
      .Connection = cn
      .CommandType = CommandType.StoredProcedure
      .CommandText = "SelectByGeneName"             ' The StoredProcedure Name 
      .Parameters.AddWithValue("@GeneName", name)   ' Set the input parameter
      Dim da as New SqlDataAdapter(cmd)
      da.Fill(dt)                                   ' This fills your DataTable
    End With
Catch ex as Exception
  ...
Finally
  If cn.State <> ConnectionState.Closed Then cn.Close()
End Try
 
Return dt
 
End Function
I don't speak Idiot - please talk slowly and clearly
 
"I have sexdaily. I mean dyslexia. Fcuk!"
 
Driven to the arms of Heineken by the wife

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 
GeneralRe: Online handwriting recognition system using vector machine PinmemberHafiqWiselman21-Nov-12 3:22 

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