handling InvalidOperationException

See more:

VB

SQL-Server

In the following code I got the sql server exception.

dad = New SqlDataAdapter(str, ConnectionString)
dtbl = New DataTable("Circular")
dco = New DataColumn("no", GetType(Integer))
dco.AutoIncrement = True
dco.AutoIncrementSeed = 1
dtbl.Columns.Add(dco)
ds = New DataSet()
ds.Tables.Add(dtbl)
con.Open()

//in following line I got exception.. as follows
ExecuteReader: CommandText property has not been initialized

dad.Fill(ds, "Circular")

  DataGrid1.DataSource = ds
  DataGrid1.DataBind()
  con.Close()