ALL kind of coding material related to software development. Microsoft Visual Studio. HTML VBA SQL
Thursday, August 16, 2012
Wednesday, July 11, 2012
SIMPLE oledb FILL Gridview connectionstring
Imports System.Data.OleDb
Imports System.Data
Dim cn As New oledbConnection
Dim ds As New DataSet
Dim da As New oledbDataAdapter
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|bupdate.mdb")
Dim cm As New OleDbCommand("select * from bupdate", cn)
da = New oledbDataAdapter(cm)
da.Fill(ds)
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
Imports System.Data
Dim cn As New oledbConnection
Dim ds As New DataSet
Dim da As New oledbDataAdapter
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|bupdate.mdb")
Dim cm As New OleDbCommand("select * from bupdate", cn)
da = New oledbDataAdapter(cm)
da.Fill(ds)
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
Monday, June 18, 2012
Friday, June 15, 2012
.Net SQLExpress ConnectionString
Imports System.Data.Sql
Imports System.Data.SqlClient
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data
Dim cn As New SqlConnection
Thursday, May 24, 2012
ASP.NET Web Services
click window key and + to enlarge otherwise use the link below to see a clear view....
A Simple Web Service in ASP.NET
Tuesday, May 15, 2012
VB.NET SQL Connection fill GridView
Imports system.data.sqlclient
Imports system.data
Dim cn As New SqlConnection
Dim sql As String
Dim ds As New DataSet
Dim da As New SqlDataAdapter
cn = New SqlConnection("server=localhost;database=NLAB 2012-2013;integrated security=true")
sql = "select * from mainmaster"
Dim cm As New SqlCommand(sql, cn)
da = New SqlDataAdapter(cm)
da.Fill(ds)
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
Imports system.data
Dim cn As New SqlConnection
Dim sql As String
Dim ds As New DataSet
Dim da As New SqlDataAdapter
cn = New SqlConnection("server=localhost;database=NLAB 2012-2013;integrated security=true")
sql = "select * from mainmaster"
Dim cm As New SqlCommand(sql, cn)
da = New SqlDataAdapter(cm)
da.Fill(ds)
GridView1.DataSource = ds.Tables(0)
GridView1.DataBind()
Subscribe to:
Posts (Atom)