Click here to Skip to main content
15,903,201 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Really Dim Question... Pin
Vasudevan Deepak Kumar21-Mar-12 6:55
Vasudevan Deepak Kumar21-Mar-12 6:55 
Questiondynamically creating aspx pages using xslt and xml Pin
kasakrajesh21-Mar-12 4:02
kasakrajesh21-Mar-12 4:02 
AnswerRe: dynamically creating aspx pages using xslt and xml Pin
Not Active21-Mar-12 4:14
mentorNot Active21-Mar-12 4:14 
Questionneed help with gridview and sql Pin
Dylan98821-Mar-12 3:43
Dylan98821-Mar-12 3:43 
QuestionRe: need help with gridview and sql Pin
ZurdoDev21-Mar-12 4:14
professionalZurdoDev21-Mar-12 4:14 
AnswerRe: need help with gridview and sql Pin
Dylan98821-Mar-12 4:29
Dylan98821-Mar-12 4:29 
GeneralRe: need help with gridview and sql Pin
ZurdoDev21-Mar-12 4:33
professionalZurdoDev21-Mar-12 4:33 
GeneralRe: need help with gridview and sql Pin
Dylan98821-Mar-12 4:45
Dylan98821-Mar-12 4:45 
thanks ryan.
for my search service i have the following code

VB
<WebMethod()> _
Public Function Search(ByVal searchName As String) As System.Data.DataSet
    Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
    Dim MyConnection As New SqlConnection(connectionString)
    Dim MyCommand As New SqlCommand()

    MyCommand.Connection = MyConnection
    MyCommand.CommandType = Data.CommandType.Text

    MyCommand.CommandType = "SELECT * From Book WHERE WineType like @prmSearchName"

    MyCommand.Parameters.AddWithValue("prmSearchName", "'%" & searchName & "%'")

    MyCommand.Connection = MyConnection

    Dim selectAdapter As New Data.SqlClient.SqlDataAdapter
    Dim ds As New Data.DataSet
    MyConnection.Open()
    selectAdapter.Fill(ds, "Wine")
    MyConnection.Close()

    Return ds

End Function


does the code looks good to you?
GeneralRe: need help with gridview and sql Pin
ZurdoDev21-Mar-12 4:51
professionalZurdoDev21-Mar-12 4:51 
GeneralRe: need help with gridview and sql Pin
Dylan98821-Mar-12 4:58
Dylan98821-Mar-12 4:58 
GeneralRe: need help with gridview and sql Pin
ZurdoDev21-Mar-12 5:04
professionalZurdoDev21-Mar-12 5:04 
AnswerRe: need help with gridview and sql Pin
Anudeep Jaiswal - MCA28-Mar-12 23:07
Anudeep Jaiswal - MCA28-Mar-12 23:07 
Questionread byte of saved picture Pin
comptech219-Mar-12 21:21
comptech219-Mar-12 21:21 
AnswerRe: read byte of saved picture Pin
Not Active20-Mar-12 22:47
mentorNot Active20-Mar-12 22:47 
GeneralRe: read byte of saved picture Pin
comptech221-Mar-12 9:04
comptech221-Mar-12 9:04 
GeneralRe: read byte of saved picture Pin
Not Active21-Mar-12 9:22
mentorNot Active21-Mar-12 9:22 
GeneralRe: read byte of saved picture Pin
comptech221-Mar-12 9:47
comptech221-Mar-12 9:47 
GeneralRe: read byte of saved picture Pin
Not Active21-Mar-12 9:50
mentorNot Active21-Mar-12 9:50 
AnswerRe: read byte of saved picture Pin
satalaj21-Mar-12 6:34
satalaj21-Mar-12 6:34 
GeneralRe: read byte of saved picture Pin
comptech221-Mar-12 9:13
comptech221-Mar-12 9:13 
GeneralRe: read byte of saved picture Pin
shreekar21-Mar-12 10:13
shreekar21-Mar-12 10:13 
GeneralRe: read byte of saved picture Pin
Not Active21-Mar-12 12:32
mentorNot Active21-Mar-12 12:32 
GeneralRe: read byte of saved picture Pin
Not Active21-Mar-12 9:28
mentorNot Active21-Mar-12 9:28 
QuestionGetting the access table into html page Pin
parthan pandian19-Mar-12 21:16
parthan pandian19-Mar-12 21:16 
AnswerRe: Getting the access table into html page Pin
Joshua Omundson20-Mar-12 6:20
Joshua Omundson20-Mar-12 6:20 

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.