take a look at vb.net substring in detail.

http://vb.net-informations.com/string/vb.net_String_Substring.htm

bruce.

You can retrieve data from database without using dataset .

cnn.Open()
cmd = New SqlCommand(sql, cnn)
Dim count As Int32 = Convert.ToInt32(cmd.ExecuteScalar())
...

try this

http://vb.net-informations.com/dataadapter/dataAdapter-dataset.htm

http://vb.net-informations.com/ado.net-dataproviders/ado.net-dataproviders-tutorial.htm

bruce.

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

You can pass login parameter to crystal reports dyanmically .

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_load_dynamically.htm

bruce.

for int i=0 to dataset.tables(0).rows.count -1
adapter.InsertCommand = New SqlCommand(insertSQL, connection)
adapter.InsertCommand.ExecuteNonQuery()
next i
...

connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdatabasename.mdb;"
connection = New OleDbConnection(connetionString)

full src code
...

use this

http://vb.net-informations.com/dataset/dataset-count-rows-oledb.htm

bruce

follow the url, it explain how to ExecuteScalar

http://vb.net-informations.com/ado.net-dataproviders/ado.net-executescalar-sqlcommand.htm

you can connect excel file through vb.net with the help of oledb. check the following link.

http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm

bruce.

Your question is not clear yet. Refer the following link so see more help on excel automation in vb.net.

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutorials.htm

bruce.

try this crystal report tutorial.

http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

bruce

Here one step by step Crystal reports in vb.net.

http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

try this link

http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

thanks.

Just follow the link , you will get a step by step crystal reports creation in vb.net

http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm

bruce

try this one

http://vb.net-informations.com

Vb.net tutorials , help and source code

bruce.

try this one

http://vb.net-informations.com

Vb.net tutorials , help and source code

try this tutorials.

http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutorials.htm

bruce

Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldDefinition As ParameterFieldDefinition
Dim crParameterValues As New ParameterValues
Dim...

If u use exception handling , you can find the problem very easily.

use try .. catch ststements .

http://vb.net-informations.com/language/vb.net_exceptions.htm
...