Dear All,

I am using VB .NET 2003, I would like to store the fetched value in "SELECT " command. Please refer the following code.
dim sqlconn as sqlconnection = "............."
dim sql as string = nothing
sql = "SELECT itemname FROM ItemMaster where itemname='Book'"
cmd = new sqlcommand(sql,sqlconn)
sqlconn.open()
...
....
...
In the above code, it fetches the value but how to take that value into another variable. Please give me a complete code list so that I can try from my end here.
Expecting your reply.
venki.

VENKATESH

__________________
VENKATESH

This is how I do it using an MS Access database. It's easy to convert to MS SQL

        Dim Cmd As OleDb.OleDbCommand
        Dim Con As OleDb.OleDbConnection
        Dim Reader As OleDb.OleDbDataReader
        Dim Sql As String = Nothing
        Dim Book As String = Nothing

        Con = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OleD b.4.0;data source=" & Database & "")
        Sql = "SELECT [itemname] FROM [ItemMaster] where itemname='Book'"
        Cmd = New OleDb.OleDbCommand(Sql, Con)

        Con.Open()
        Reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection)
        If Reader.Read() Then
            Book = Reader("itemname").ToString
        End If
        Con.Close()

Please let me know how you get on with it.

Thanks
Pete*