ds.tables(0).rows.count

janet.

cnn.Open()
cmd = New SqlCommand(Sql, cnn)
cmd.ExecuteNonQuery()
cmd.Dispose()
cnn.Close()

janett.

do like this.

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"
connection = New SqlConnection(connetionString)

jannet.

if you find difficulty in printing from Crystal report , u can export it as PDF or Excel format and print it.

its very easy.