bruce2424

Hi, My Crystal Report is using VB.NET and Sql server 2005. The report can be displayed but everytime it will prompt me to key in the Username n Password.. is there anyway to automatically pass the login information to reports? thanks =)

Hi, Does anyone have some good examples of ADO.NET code that demonstrates a coded connection to SQL Server such that bound controls bind to retrieve and update data. Thanks

Hi, i am biggener to VB.NET and ADO.NET. I have created a VB.NET form contains "Date From" and "Date To". i want to pass these two range parameters to crystal reports to manipulate the result. What is the way to do so using ADO.NET. Kindly some one explain Step by …

Enables DataView to DataTable conversion

Connection To Access Database and Save,Retrieve,Update D:\access\try.mdb=The Address of the Access database table 'Try'. Take a module as ModMain(Copy the code) table fields: idno,name,designation.(idno=auto number) textBoxes=TxtName,TxtDesignation And Combobox=CboRetrieve buttons=new,save,retrieve,exit

I need urgent help please!!!! This is my problem: I want to connect to a Access database with VB.Net. Here is my imports: [code] Imports System.IO Imports System Imports System.Data Imports System.Data.OleDb Imports System.Collections Imports System.ComponentModel [/code] Here is my connection string: [code] Public pDB As New OleDbConnection("Jet OLEDB:Global Partial …

how can I select which data I want on a report from code in vb.net? I've been trying to use a dataset but that isnt working.

an error is found on line: letters = input.Substring((count), 2) it says that the index must be within the string I don't see why it is an error can anyone help? Function DigramCount(ByVal input As String) 'takes two charcters at a time out of input 'string and determines their frequencies …

Hi.. I have a table: PROFESSOR in ms access, that has 2 fields: "Name" and "Location". The table has 10 records. And i have made a vb form with a combo box that will show a list of available locations from the database table, when it is dropped down. So, …

Okay heres the dilemna.... I have a Dataset("LineItems") that Stores information about so many records. To source to this DataSet("LineItems") is not its intended ouput. Meaning I pull this info in from one database and output to another. My problem is i have no idea on how to write an …

I fetch the data datafrom database in to a datatable and bind it to a datagridview.Now I want to edit the data shown in the datagridviewand also want to add new rows in dgv.The editing part is going ok but I m not able to add new rows in dgv.Also …

Hi All I have a select statement: [size=2]Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1 Now I want to store / retrieve the values of the field that I am querying without using dataset. Is this possible? If yes how can I do this? Is it possible that I declare …

Hi everyone, how can i get the updated number of rows from MySQL? Because i need the syntax to do the calculations on the number of inputs, thanks....

hi every one I have a lot of excel data sheets and I need to work with them . how can I connect my code with the excel files . is it the same as ADO.net while u do with access? please help me or send me a link about …

Hi, I receive this error "No default member found for type 'Guid'." when I run my application. [code] db = New SqlConnection(GetConnectionString()) db.Open() Dim strSQL As String strSQL = "SELECT GUID FROM MyLog WHERE MyID = '" & strID & "'" strGUIDTracker = GetSingleData(strSQL) .................. Function GetSingleData(ByVal sqlText As String) …

Hi i am importing a excel sheets using vb.net. my code is dependent on column sequence. but its as per user need the sequence is chaning again and again. For that i need to change my code ( which is huge ) need to change. :( plz help.

Hows it going everyone. Im pretty new to Crystal Reports, and I have been trying to create a report. The report that Im creating is loading a dataset and right now I am using 5 tables from it. Its loading the dataset at runtime, and the tables that Im loading …

Hi All, I urgently need help creating reports using vb.net 2008 build in reporting tool. I just want an example of how to pass a dataset to the report. I know how to do this using Crystal Reports, but I am clueless of how to do this using the build …

hi,i've read a lot of tutorial about how to make .rpt from VB.net Just use add new item menu..and the crystal report will appear at template... but my problem is when i click add new item, i cannot found crystal report in template..so how to add crystal report to template? …

I want to learn about [URL="http://www.daniweb.com/techtalkforums/thread77538.html#"]vb.[/URL]net but i dont know how to start it. Please give me some basic sample for a beginner of vb.net [URL="http://www.daniweb.com/techtalkforums/thread77538.html#"]codes[/URL] I am useing vs.net 2005. please help me

Hello All: Just wanted to inquire about Visual Basic. As I understand it, it is a tool to create GUI's on windows platforms. I would like to know where I could find an online tutorial for novices. Also, does VB, can VB interface with Sybase Databases using TransAct SQL....???? Thanks …

Hi I'm using MS Visual Basic 2005 Express Edition and need to open an Excel File. I'm using the following code [code] Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim xlTemp As Excel.Application xlTemp = New Excel.Application xlTemp.Workbooks.Open("C:\Documents and Settings\TAP\Desktop\Post\Test.xls") End Sub …

when i debug a program on my pc it works just fine. When i install my program on another pc i get exceptions during runtime like... "Cannot convert string ##100## to type decimal" when i try to input some data from a .txt file What is wrong with it?