Visual Basic

Colin Angus Mackay14-Jun-07 22:47

Colin Angus Mackay

14-Jun-07 22:47

Seriously, you need to give more information than that if you want help. We cannot see what you see so you have to describe the situation for us in sufficient detail that we can help.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

ozzyrocsdbn17-Jun-07 20:37

ozzyrocsdbn

17-Jun-07 20:37

I have a text box
and below the text box i have a listbox
eg I want to type "c" in the the text box. then the list box must show all stock items where there description begins with c
Please help

ozzyrocsdbn17-Jun-07 20:43

ozzyrocsdbn

17-Jun-07 20:43

Its vb.net

text from file.txt to web page ?

ozzyrocsdbn14-Jun-07 22:15

ozzyrocsdbn

14-Jun-07 22:15

Sorry
The program is in Vb.net 2005
and the Database is SQL DATABASE
I would love if my stock screen did the following
user clicks on textbox
Types "p"
Then the listbox that i have below it will scoll the product database and show the product with the closest description
Like how some sap programes Do that [ yet they have 500000 items]

porsti14-Jun-07 19:59

porsti

14-Jun-07 19:59

Hello
How to read text from file.txt into textbox on web page? I am using vb.net .

Re: text from file.txt to web page ?

Christian Graus14-Jun-07 20:11

Christian Graus

14-Jun-07 20:11

Reading text from a text file is as simple as File.ReadAllText. Passing it into a web page, is more complex, you'd have to host the browser in your app, and insert the text using the DOM.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

VB 6.0/Crystal Reports

Indrojeet_Bhattacharya14-Jun-07 19:55

Indrojeet_Bhattacharya

14-Jun-07 19:55

I am sick of using Data Environment for creating reports through VB 6.0 so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports.

Thanks & Regard,

Indrojeet

Indrojeet Bhattacharya

Re: VB 6.0/Crystal Reports

Dileep_Vickey14-Jun-07 20:58

Dileep_Vickey

14-Jun-07 20:58

Hi,
I dont know how to create crystal reports by using VB6. But i can help u for calling report from VB6. Here is a sample code

gtRptDsn = "DSN = " & ServerName & ";UID = **; PWD=****"

<report control="">.Connect = gtRptDsn
<report control="">.Destination = crptToWindow
<report control="">.Destination = crptToPrinter
in report function
<report control="">.ReportFileName = tcpath & "ReportName.rpt"
//stored procedure parameters
<report control="">.StoredProcParam(0) = GiSbuid
<report control="">.StoredProcParam(1) = iProjectId
<report control="">.StoredProcParam(2) = iVendorId
<report control="">.StoredProcParam(3) = ICategoryId
<report control="">.StoredProcParam(4) = IGroupId
<report control="">.StoredProcParam(5) = IMaterialId

//for header(like company name and addresss) use Fomula
<report control="">.Formulas(0) = "Company='" & GTEnterprise & "'"
<report control="">.Formulas(1) = "Add1='" & GTSbuAdd1 & "'"
<report control="">.Formulas(2) = "Add2='" & GTSbuADD2 & "'"

// to show report
RptQuotation.Action = 1
RptQuotationReport.PageZoom 100
// to make the report as a child of MDI form
<report control="">.WindowParentHandle = mdiFormMain.hwnd

By Dileep
I love my bug since she is my best friend.

Re: VB 6.0/Crystal Reports

Indrojeet_Bhattacharya15-Jun-07 2:52

Indrojeet_Bhattacharya

15-Jun-07 2:52

What all .dll references I need to add ?

Indrojeet Bhattacharya

Re: VB 6.0/Crystal Reports

Dave Kreskowiak15-Jun-07 3:53

Passing muti-parameters crystal report8.5

15-Jun-07 3:53

Indrojeet_Bhattacharya wrote:
so I wanted to know the exact method with full detail as to how can we make use of crystal reports through VB6.0 for the creation of reports.

If you want that much detail, read the documentation on Crystal Reports. Though I think all support has been dropped for VB6 in the lastest versions.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Flexgrid in VB

kankeyan14-Jun-07 18:58

kankeyan

14-Jun-07 18:58

Gud MOrning
can we use a Readonly property in Flexgrid.

we can means give me a syntax.

pls its urgent

kankeyan Smile | :)

Re: Flexgrid in VB

Sanjay Kunjam15-Jun-07 0:10

Sanjay Kunjam

15-Jun-07 0:10

which read only property in flexgrid you want to use??

Nine_14-Jun-07 18:56

Nine_

14-Jun-07 18:56

I'm using vb6 with Crystal Report8.5
I have sent a value to the "?text" field like this:
Dim rpt As New CrystalReport1
rpt.ParameterFields.GetItemByName("text").AddCurrentValue ("a")

How can I send the second value to the same field?
Thanks

Re: Passing muti-parameters crystal report8.5

Steven J Jowett14-Jun-07 23:13

Steven J Jowett

14-Jun-07 23:13

Surely, if you was to move a second value to the same field, that would replace the first value.

Steve Jowett
-------------------------
Sometimes a man who deserves to be looked down upon because he is a fool, is only despised only because he is an 'I.T. Consultant'

Re: Passing muti-parameters crystal report8.5

Nine_17-Jun-07 17:13

Nine_

17-Jun-07 17:13

what if I don't want to replace the first value? I mean I want send a second value to the same field but in the second row
Please help me,
thank

DataGrids and editing values

Geoff_300114-Jun-07 12:10

Geoff_3001

14-Jun-07 12:10

I have created a datagrid that has a coloumn which value is calculated from two other coloums.

so the data datagrid column Total = Column Amt * Column Price

I would like to capture theevent when a cell is edited and enter or down arrow is pressed.
Once the event is triggered I need to asertain the cell row and column details.
Then I will add some code to recalculate the data and refresh the grid.

So the question.

How do I capture the enter after edit of a cell.
How do I get the row and column details.

Any Help would be apreciated.

Thanks

How to get date from long number

vurugonda14-Jun-07 6:17

14-Jun-07 6:17

Hi
This is very urgent i have
if any one know about convert long number into date format
i have souce i java script but i want to convert into vb 6.0 code
1108508090 this is input number

var l =1108508090 *1000+86400;
var aDate = l; // miliseconds Since 1970;
theDate = new Date(aDate);
dd = theDate.getDate();
mm = theDate.getMonth()+1; // 0 based
yy = theDate.getYear();
if (yy < 1000) yy +=1900; // Y2K fix
alert (dd+'/'+mm+'/'+yy);

plz help me

Sathesh Sakthivel14-Jun-07 6:23

Sathesh Sakthivel

14-Jun-07 6:23

Get it[^]

Regards,

Satips. Rose | [Rose]

Dave Kreskowiak14-Jun-07 6:50

14-Jun-07 6:50

You have a problem. What does this input number represent?? Is this the number of seconds since a specified date?

Without knowning this, it's impossible to translate the code. Java's Date class starts at Jan 1, 1970. VB6 doesn't really have a Date class, but can handle dates in a much greate range, depending on the representation and the functions used.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

vurugonda14-Jun-07 8:22

14-Jun-07 8:22

Hi
i understand ur confusion ,
here they are taking millisconds

Dave Kreskowiak14-Jun-07 8:57

14-Jun-07 8:57

OK. Since Java's epoch starts at Midnight, Jan 1, 1970, add the number of seconds to this date/time:

newDate = DateAdd("s", (milliseconds / 1000), "01-Jan-1970")

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

vurugonda14-Jun-07 9:31

14-Jun-07 9:31

Hi thx ur reply but here i want display date like dd/mm/yyyy

plz give me reply

Dave Kreskowiak14-Jun-07 9:41

14-Jun-07 9:41

Nothing in the code I submitted displays the date in any way.

So, you have to supply the code to return a string with the formatted date yourself. Like using the FormatDateTime[^] function, or using your own custom format string in the Format[^] function.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

vurugonda14-Jun-07 11:35