|Have you got a link to the code you are trying?
I suspect that you require a Stored Procedure on the Database:
CREATE PROCEDURE SelectByGeneName(
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
WHERE Gene = @genename
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) Dim cmd as New SqlCommand
Dim dt as New DataTable("PlazimorphGenes")
.Connection = cn
.CommandType = CommandType.StoredProcedure
.CommandText = "SelectByGeneName" .Parameters.AddWithValue("@GeneName", name) Dim da as New SqlDataAdapter(cmd)
da.Fill(dt) End With
Catch ex as Exception
If cn.State <> ConnectionState.Closed Then cn.Close()
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
General News Suggestion Question Bug Answer Joke Praise Rant Admin
Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.