sriniinnsoft

 Profile Answers by sriniinnsoft 

• Jan 7th, 2009

 

dim con as sqlconnection

con=new sqlconnection("server=visuall;database=urdbname;uid=sa;password=urpassword")

con.open()

dimquerycommand as sqlcommand

dim reader as sqldatareader

querycommand=new sqlcommand("select * from emp",con)

reader=querycommand.executereader()

while(reader.reader())

listbox1.items.add(reader(0).tostring() & " " & reader(1).tostring() )

end while

jsubha2009

 Profile Answers by jsubha2009 Questions by jsubha2009

• Dec 7th, 2009

 

Create a connection object in OLEDB or SQL and set the possible parameters.Create a OLEDB DataAdapter or SQL Data Adapter and populate a dataset through the data adapter object.Then set the values of the Datasource and Display member property with the desired datasource and column.Here is the sample code for SqlConnection.

Dim con as new SqlConnection("server='localhost';uid='sa';pwd='password'; database='Employees')
con.Open()
dim ada as new SqlDataAdapter("select * from empdata",con)
Dim ds as new Dataset
ada.Fill(ds,"Empdata")
ListBox1.DataSource=ds.Tables("Empdata").DefaultView
ListBox1.DisplayMember="Empname"
con.Close()

SunilDadaDbms

 Profile Answers by SunilDadaDbms 

• Jan 5th, 2011

 

Get the data from db in list of strings or key value pair

finaldatesource=db calll

With listbox

.datasource=finaldatesource
.datatextfield="EmplyeeNAme"
.datavaluefield="EmplyeeNumber"
end with
EmplyeeNAme, EmployeeNumber are coloumns in DB