bruce2424

You can pass login parameter to crystal reports dyanmically . [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_report_load_dynamically.htm[/url] bruce.

connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password" connection = New SqlConnection(connetionString) [url]http://vb.net-informations.com/dataadapter/dataadapter-dataset-sqlserver.htm[/url]

[code]Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues Dim crParameterDiscreteValue As New ParameterDiscreteValue crParameterDiscreteValue.Value = TextBox1.Text crParameterFieldDefinitions = _ cryRpt.DataDefinition.ParameterFields crParameterFieldDefinition = _ crParameterFieldDefinitions.Item("Orderdate") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterValues.Clear() crParameterValues.Add(crParameterDiscreteValue) crParameterFieldDefinition.ApplyCurrentValues(crParameterValues) [/code] if want to know more detail about this check this link. [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm[/url] bruce

thsi is vb code Dim dTable As DataTable dTable = dv.ToTable for more details : [url]http://vb.net-informations.com/dataview/dataview-to-datatable.htm[/url] thanks.

try this [url]http://vb.net-informations.com/dataadapter/dataAdapter-dataset.htm[/url] [url]http://vb.net-informations.com/ado.net-dataproviders/ado.net-dataproviders-tutorial.htm[/url] bruce.

connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=yourdatabasename.mdb;" connection = New OleDbConnection(connetionString) full src code [url]http://vb.net-informations.com/ado.net-dataproviders/ado.net-oledbconnection.htm[/url] bruce

try this crystal report tutorial. [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm[/url] bruce

take a look at vb.net substring in detail. [url]http://vb.net-informations.com/string/vb.net_String_Substring.htm[/url] bruce.

plz check the link below , you can pass parameter to crystal reports [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_report_parameter_date.htm[/url]

for int i=0 to dataset.tables(0).rows.count -1 adapter.InsertCommand = New SqlCommand(insertSQL, connection) adapter.InsertCommand.ExecuteNonQuery() next i [url]http://vb.net-informations.com/dataadapter/dataadapter-insertcommand-sqlserver.htm[/url] [url]http://vb.net-informations.com/dataset/ado.net-dataset.htm[/url] bruce

you can add new row using dataview [url]http://vb.net-informations.com/dataview/dataview-new-row.htm[/url] 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()) cmd.Dispose() cnn.Close() [url]http://vb.net-informations.com/ado.net-dataproviders/ado.net-executescalar-sqlcommand.htm[/url] bruce

use this [url]http://vb.net-informations.com/dataset/dataset-count-rows-oledb.htm[/url] bruce

you can connect excel file through vb.net with the help of oledb. check the following link. [url]http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm[/url] bruce.

follow the url, it explain how to ExecuteScalar [url]http://vb.net-informations.com/ado.net-dataproviders/ado.net-executescalar-sqlcommand.htm[/url]

Your question is not clear yet. Refer the following link so see more help on excel automation in vb.net. [url]http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutorials.htm[/url] bruce.

Here one step by step Crystal reports in vb.net. [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm[/url]

try this link [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm[/url] thanks.

Just follow the link , you will get a step by step crystal reports creation in vb.net [url]http://vb.net-informations.com/crystal-report/vb.net_crystal_reports_tutorials.htm[/url] bruce

try this one [url]http://vb.net-informations.com[/url] Vb.net tutorials , help and source code bruce.

try this one [url]http://vb.net-informations.com[/url] Vb.net tutorials , help and source code

try this tutorials. [url]http://vb.net-informations.com/excel-2007/vb.net_excel_2007_tutorials.htm[/url] bruce

If u use exception handling , you can find the problem very easily. use try .. catch ststements . [url]http://vb.net-informations.com/language/vb.net_exceptions.htm[/url] [url]http://vb.net-informations.com/language/vb.net_languagebasics_tutorials.htm[/url] bru