Click here to Skip to main content
       

Visual Basic

 
GeneralRe: VB.NET / APPLICATION SETTINGS PinmvpDave Kreskowiak29-Nov-12 16:50 
QuestionMouse Down Event and Flag setting Pinmemberbig_col28-Nov-12 20:53 
AnswerRe: Mouse Down Event and Flag setting PinmemberSimon_Whale28-Nov-12 23:46 
GeneralRe: Mouse Down Event and Flag setting Pinmemberbig_col29-Nov-12 3:09 
GeneralRe: Mouse Down Event and Flag setting PinmemberSimon_Whale29-Nov-12 4:06 
AnswerRe: Mouse Down Event and Flag setting Pinmemberbig_col29-Nov-12 21:19 
AnswerRe: Mouse Down Event and Flag setting PinmemberAlan N29-Nov-12 4:09 
Questionvb6 to .net Pinmemberdvdljns28-Nov-12 8:42 
AnswerRe: vb6 to .net PinmemberZaf Khan28-Nov-12 17:58 
GeneralRe: vb6 to .net Pinmemberdvdljns1-Dec-12 6:47 
GeneralRe: vb6 to .net PinmemberZaf Khan1-Dec-12 9:00 
AnswerRe: vb6 to .net PinmvpDave Kreskowiak28-Nov-12 19:04 
QuestionDeleting a datarow, creating a query to find the row. - ANSWERED, Thank yo [modified] PinmemberJRHibner28-Nov-12 0:30 
AnswerRe: Deleting a datarow, creating a query to find the row. PinmemberAndy_L_J28-Nov-12 23: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 8:21 
GeneralRe: Deleting a datarow, creating a query to find the row. PinmemberAndy_L_J1-Dec-12 21:27 
GeneralRe: Deleting a datarow, creating a query to find the row. PinmemberJRHibner9-Dec-12 15:55 
QuestionModified Registry Key Pinmemberalirezamansoori27-Nov-12 19:52 
AnswerRe: Modified Registry Key PinmvpRichard MacCutchan28-Nov-12 1:02 
GeneralRe: Modified Registry Key Pinmemberalirezamansoori28-Nov-12 1:39 
GeneralRe: Modified Registry Key PinmvpRichard MacCutchan28-Nov-12 2:15 
QuestionLooking for idea for learning book PinmemberNaZReD24-Nov-12 10:08 
AnswerRe: Looking for idea for learning book PinmemberEddy Vluggen27-Nov-12 13:58 
QuestionInstall SQL Server on Another Computer without reach there PinmemberUmesh Bachchani24-Nov-12 8:03 
AnswerRe: Install SQL Server on Another Computer without reach there PinmemberEddy Vluggen27-Nov-12 13:59 
Question8queen ga write in vb Pinmemberbakhshipoor21-Nov-12 10:42 
AnswerRe: 8queen ga write in vb PinmemberDavid Mujica21-Nov-12 11:16 
AnswerRe: 8queen ga write in vb PinmvpRichard MacCutchan21-Nov-12 23:13 
QuestionOnline handwriting recognition system using vector machine [modified] PinmemberHafiqWiselman21-Nov-12 2:39 
RantRe: Online handwriting recognition system using vector machine PinmemberRichard Deeming21-Nov-12 3:16 
GeneralRe: Online handwriting recognition system using vector machine PinmemberHafiqWiselman21-Nov-12 4:22 
QuestionControlling Monitor brightness from VB6 PinmemberMuhammed Niyas20-Nov-12 0:59 
AnswerRe: Controlling Monitor brightness from VB6 PinmemberSimon_Whale20-Nov-12 1:12 
QuestionExport Data from Gridview to Sql Server PinmemberNaga Raju Vutla18-Nov-12 19:22 
AnswerRe: Export Data from Gridview to Sql Server PinmemberEddy Vluggen19-Nov-12 1:01 
AnswerRe: Export Data from Gridview to Sql Server PinmemberBert Mitton19-Nov-12 9:21 
GeneralRe: Export Data from Gridview to Sql Server PinmemberEddy Vluggen19-Nov-12 10:48 
QuestionReading Complex Type from WSDL Pinmemberasv17-Nov-12 15:47 
AnswerRe: Reading Complex Type from WSDL PinmemberZac Greve17-Nov-12 17:56 
GeneralRe: Reading Complex Type from WSDL Pinmemberasv17-Nov-12 19:35 
QuestionSQL functions in VB PinmemberNaseerKhanPattan17-Nov-12 7:28 
AnswerRe: SQL functions in VB PinmemberEddy Vluggen17-Nov-12 10:36 
QuestionFinding a Row in a Datatable and putting the row to variables PinmemberJRHibner14-Nov-12 19:37 
AnswerRe: Finding a Row in a Datatable and putting the row to variables PinmemberAndy_L_J15-Nov-12 20:48 
GeneralRe: Finding a Row in a Datatable and putting the row to variables [modified] PinmemberJRHibner18-Nov-12 17:15 
AnswerRe: Finding a Row in a Datatable and putting the row to variables PinmemberAndy_L_J18-Nov-12 21:45 
GeneralRe: Finding a Row in a Datatable and putting the row to variables PinmemberJRHibner18-Nov-12 21:55 
GeneralRe: Finding a Row in a Datatable and putting the row to variables PinmemberAndy_L_J18-Nov-12 22:33 
GeneralRe: Finding a Row in a Datatable and putting the row to variables PinmemberJRHibner18-Nov-12 22:36 
GeneralRe: Finding a Row in a Datatable and putting the row to variables PinmemberJRHibner27-Nov-12 20:28 

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
Web02 | 2.8.141223.1 | Last Updated 21 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid