Click here to Skip to main content
12,075,066 members (65,182 online)

Visual Basic

 
GeneralRe: VB.NET / APPLICATION SETTINGS Pin
Dave Kreskowiak29-Nov-12 16:50
mvpDave Kreskowiak29-Nov-12 16:50 
QuestionMouse Down Event and Flag setting Pin
big_col28-Nov-12 20:53
memberbig_col28-Nov-12 20:53 
AnswerRe: Mouse Down Event and Flag setting Pin
Simon_Whale28-Nov-12 23:46
memberSimon_Whale28-Nov-12 23:46 
GeneralRe: Mouse Down Event and Flag setting Pin
big_col29-Nov-12 3:09
memberbig_col29-Nov-12 3:09 
GeneralRe: Mouse Down Event and Flag setting Pin
Simon_Whale29-Nov-12 4:06
memberSimon_Whale29-Nov-12 4:06 
AnswerRe: Mouse Down Event and Flag setting Pin
big_col29-Nov-12 21:19
memberbig_col29-Nov-12 21:19 
AnswerRe: Mouse Down Event and Flag setting Pin
Alan N29-Nov-12 4:09
memberAlan N29-Nov-12 4:09 
Questionvb6 to .net Pin
dvdljns28-Nov-12 8:42
memberdvdljns28-Nov-12 8:42 
AnswerRe: vb6 to .net Pin
Zaf Khan28-Nov-12 17:58
memberZaf Khan28-Nov-12 17:58 
GeneralRe: vb6 to .net Pin
dvdljns1-Dec-12 6:47
memberdvdljns1-Dec-12 6:47 
GeneralRe: vb6 to .net Pin
Zaf Khan1-Dec-12 9:00
memberZaf Khan1-Dec-12 9:00 
AnswerRe: vb6 to .net Pin
Dave Kreskowiak28-Nov-12 19:04
mvpDave Kreskowiak28-Nov-12 19:04 
QuestionDeleting a datarow, creating a query to find the row. - ANSWERED, Thank yo Pin
JRHibner28-Nov-12 0:30
memberJRHibner28-Nov-12 0:30 
AnswerRe: Deleting a datarow, creating a query to find the row. Pin
Andy_L_J28-Nov-12 23:30
memberAndy_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. Pin
JRHibner1-Dec-12 8:21
memberJRHibner1-Dec-12 8:21 
GeneralRe: Deleting a datarow, creating a query to find the row. Pin
Andy_L_J1-Dec-12 21:27
memberAndy_L_J1-Dec-12 21:27 
GeneralRe: Deleting a datarow, creating a query to find the row. Pin
JRHibner9-Dec-12 15:55
memberJRHibner9-Dec-12 15:55 
QuestionModified Registry Key Pin
alirezamansoori27-Nov-12 19:52
memberalirezamansoori27-Nov-12 19:52 
AnswerRe: Modified Registry Key Pin
Richard MacCutchan28-Nov-12 1:02
mvpRichard MacCutchan28-Nov-12 1:02 
GeneralRe: Modified Registry Key Pin
alirezamansoori28-Nov-12 1:39
memberalirezamansoori28-Nov-12 1:39 
GeneralRe: Modified Registry Key Pin
Richard MacCutchan28-Nov-12 2:15
mvpRichard MacCutchan28-Nov-12 2:15 
QuestionLooking for idea for learning book Pin
NaZReD24-Nov-12 10:08
memberNaZReD24-Nov-12 10:08 
AnswerRe: Looking for idea for learning book Pin
Eddy Vluggen27-Nov-12 13:58
memberEddy Vluggen27-Nov-12 13:58 
QuestionInstall SQL Server on Another Computer without reach there Pin
Umesh Bachchani24-Nov-12 8:03
memberUmesh Bachchani24-Nov-12 8:03 
AnswerRe: Install SQL Server on Another Computer without reach there Pin
Eddy Vluggen27-Nov-12 13:59
memberEddy Vluggen27-Nov-12 13:59 
Question8queen ga write in vb Pin
bakhshipoor21-Nov-12 10:42
memberbakhshipoor21-Nov-12 10:42 
AnswerRe: 8queen ga write in vb Pin
David Mujica21-Nov-12 11:16
memberDavid Mujica21-Nov-12 11:16 
AnswerRe: 8queen ga write in vb Pin
Richard MacCutchan21-Nov-12 23:13
mvpRichard MacCutchan21-Nov-12 23:13 
QuestionOnline handwriting recognition system using vector machine Pin
HafiqWiselman21-Nov-12 2:39
memberHafiqWiselman21-Nov-12 2:39 
RantRe: Online handwriting recognition system using vector machine Pin
Richard Deeming21-Nov-12 3:16
memberRichard Deeming21-Nov-12 3:16 
GeneralRe: Online handwriting recognition system using vector machine Pin
HafiqWiselman21-Nov-12 4:22
memberHafiqWiselman21-Nov-12 4:22 
QuestionControlling Monitor brightness from VB6 Pin
Muhammed Niyas20-Nov-12 0:59
memberMuhammed Niyas20-Nov-12 0:59 
AnswerRe: Controlling Monitor brightness from VB6 Pin
Simon_Whale20-Nov-12 1:12
memberSimon_Whale20-Nov-12 1:12 
QuestionExport Data from Gridview to Sql Server Pin
Naga Raju Vutla18-Nov-12 19:22
memberNaga Raju Vutla18-Nov-12 19:22 
AnswerRe: Export Data from Gridview to Sql Server Pin
Eddy Vluggen19-Nov-12 1:01
memberEddy Vluggen19-Nov-12 1:01 
AnswerRe: Export Data from Gridview to Sql Server Pin
Bert Mitton19-Nov-12 9:21
memberBert Mitton19-Nov-12 9:21 
GeneralRe: Export Data from Gridview to Sql Server Pin
Eddy Vluggen19-Nov-12 10:48
memberEddy Vluggen19-Nov-12 10:48 
QuestionReading Complex Type from WSDL Pin
asv17-Nov-12 15:47
memberasv17-Nov-12 15:47 
AnswerRe: Reading Complex Type from WSDL Pin
Zac Greve17-Nov-12 17:56
memberZac Greve17-Nov-12 17:56 
GeneralRe: Reading Complex Type from WSDL Pin
asv17-Nov-12 19:35
memberasv17-Nov-12 19:35 
QuestionSQL functions in VB Pin
NaseerKhanPattan17-Nov-12 7:28
memberNaseerKhanPattan17-Nov-12 7:28 
AnswerRe: SQL functions in VB Pin
Eddy Vluggen17-Nov-12 10:36
memberEddy Vluggen17-Nov-12 10:36 
QuestionFinding a Row in a Datatable and putting the row to variables Pin
JRHibner14-Nov-12 19:37
memberJRHibner14-Nov-12 19:37 
AnswerRe: Finding a Row in a Datatable and putting the row to variables Pin
Andy_L_J15-Nov-12 20:48
memberAndy_L_J15-Nov-12 20:48 
GeneralRe: Finding a Row in a Datatable and putting the row to variables Pin
JRHibner18-Nov-12 17:15
memberJRHibner18-Nov-12 17:15 
AnswerRe: Finding a Row in a Datatable and putting the row to variables Pin
Andy_L_J18-Nov-12 21:45
memberAndy_L_J18-Nov-12 21:45 
GeneralRe: Finding a Row in a Datatable and putting the row to variables Pin
JRHibner18-Nov-12 21:55
memberJRHibner18-Nov-12 21:55 
GeneralRe: Finding a Row in a Datatable and putting the row to variables Pin
Andy_L_J18-Nov-12 22:33
memberAndy_L_J18-Nov-12 22:33 
GeneralRe: Finding a Row in a Datatable and putting the row to variables Pin
JRHibner18-Nov-12 22:36
memberJRHibner18-Nov-12 22:36 
GeneralRe: Finding a Row in a Datatable and putting the row to variables Pin
JRHibner27-Nov-12 20:28
memberJRHibner27-Nov-12 20:28 

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.


Advertise | Privacy | Mobile
Web04 | 2.8.160208.1 | Last Updated 12 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid