Visual Basic Multilingual Support - Picking Desired Resource - Visual Basic Discussion Boards

Re: Crystal Reports Custom Parameter Passing

JC.KaNNaN16-Jun-09 1:20

JC.KaNNaN

16-Jun-09 1:20

ya im asking about 3rd one...

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Re: Crystal Reports Custom Parameter Passing

Kschuler16-Jun-09 2:41

Kschuler

16-Jun-09 2:41

Do you still have a question or have you figured it out? The basic format is something like this:

Dim dtTable1 as New DataTable
Dim dtTable2 as New DataTable

<Insert code to set schema and fill the data tables here>

'This code declares a dataset and adds the tables:
Dim ds as New DataSet
ds.Tables.Add(dtTable1)
ds.Tables.Add(dtTable2)

'This code attaches the dataset to the crystal report:
reportDocument1.SetDataSource(ds)

Re: Crystal Reports Custom Parameter Passing

JC.KaNNaN16-Jun-09 3:38

JC.KaNNaN

16-Jun-09 3:38

sorry im new in crystal report..

plz write step by step...

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Re: Crystal Reports Custom Parameter Passing

Kschuler16-Jun-09 3:47

Kschuler

16-Jun-09 3:47

I'm not sure how much more step by step I can get than what I wrote before. Why don't you try reading some articles on the subject to get familiar with the concepts and then play with it a bit.

Here are a few articles I found on CP that might help you:
How to use Crystal Report in your project?[^]
Generate a Crystal Reports report without a database[^]
Crystal Report Basics and Integration with DataSet[^]

Hope this helps.

Re: Crystal Reports Custom Parameter Passing

JC.KaNNaN16-Jun-09 20:29

JC.KaNNaN

16-Jun-09 20:29

hi,
i know what u said..
but i need solution for only using morethan one tables in crystal report..

and

how to pass two different parameter field(ie. two diff table) in crystal report..

still now i didnt get anything...
very urgent..
plz

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Re: Crystal Reports Custom Parameter Passing

Kschuler17-Jun-09 3:00

Kschuler

17-Jun-09 3:00

What I gave you earlier IS the solution for passing more than one table:

In order to pass in two tables, you need to use a DataSet object. This is how you declare one named ds:
Dim ds as New DataSet

Then you have to add your tables to it. If your tables are called dtTable1 and dtTable2, this is how you would add them to the DataSet

ds.Tables.Add(dtTable1)<br />
ds.Tables.Add(dtTable2)

Then you pass the DataSet into the reportDocument object, like this:
reportDocument1.SetDataSource(ds)

If this code isn't working for you, you're going to have to give me more information about why it isn't working and what error messages you are getting.

Re: Crystal Reports Custom Parameter Passing

Aiman Farouk Mohamed15-Jun-09 22:07

Aiman Farouk Mohamed

15-Jun-09 22:07

Mr. Kannan:
your question is not clear .
Do you want to add these parameters in the report from the crystal report designer or what?
if so, you can do this using field explorer in the left part of the report you will find field explorer and inside it parameter fields right click on it and click new for adding new parameter.
Regards
Aiman Farouk

Visual Basic Multilingual Support - Picking Desired Resource

vhassan15-Jun-09 1:32

vhassan

15-Jun-09 1:32

Hi everyone!

I have 5 different languages string tables in resource file of my application. Now I want my application to pick my desired string table from resource file. How can I do that?

Thanks.

Re: Visual Basic Multilingual Support - Picking Desired Resource

Baran M15-Jun-09 4:35

Baran M

15-Jun-09 4:35

try this [^]

You are best person who knows about your problem.
-------------------------------------------------
More pain more gain

Datarepater Control (Winforms)

Alan Bates15-Jun-09 1:20

Alan Bates

15-Jun-09 1:20

Hi!

I am writing an application in VB.Net (2005) using the datarepeater control in bound mode using the bindingsource/tableadapter scenario. It's working fine but I would like to incorporate a search facility.

I have tried the example from help and this works fine for exact matches but not for partial matches similar to the partial match in SQL using the "LIKE" statement.

The code that I adapted from help is -

strSearch = txtSearch.Text<br />
      foundIndex = VwTasCompaniesBindingSource.Find("CompanyName", strSearch)<br />
      If foundIndex > -1 Then<br />
          DataRepeater1.CurrentItemIndex = foundIndex<br />
      Else<br />
          MsgBox("Item " & strSearch & " not found.")<br />
      End If<br />

I have looked just about everywhere but I cannot find an example of how this could be acheived.

Any help will be appreciated!

Regards,

Alan Confused | :confused:

DataGridView how to get items

alwinSCH15-Jun-09 0:31

alwinSCH

15-Jun-09 0:31

Hi, i have a question about DataGridView in VS2005!

So i bound my DatagridView with Data through a Stored Procedure in SQL
the last column of my grid is a checkbox!
The user scrolls through the gridview and checks everything he needs...

at the end of my form i have a button, when i click this button
i need the checked rows from the datagridview in my further program!
So i do not need to update my Database or tableAdapter, i only need the rows, which are checked!

Can anybody help me,
don't know where to start and don't do much of programming...

Thanks
A.

Re: DataGridView how to get items

Henry Minute15-Jun-09 0:39

Henry Minute

15-Jun-09 0:39

One possibile solution is to use the Rows property of the DataGridview.

Iterate over the collection and test if the column you are interested in is checked and if so, extract what data you need from that row, into a collection or whatever.

Look up the Rows property in MSDN.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

How to deploy dll before custom action

Mithun.Shitole14-Jun-09 23:58

Mithun.Shitole

14-Jun-09 23:58

Hi,
I have created a custom action which requires a reference to a dll say dll1, that dll in turn requires reference to another dll say dll2.
Now I have a deployment issue of how to install dll2 before custom action takes place.
I got the file not found exception for that dll from custom action.
I have tried manually copying dll2 in system32 folder and my installer worked fine.

Re: How to deploy dll before custom action

Kschuler15-Jun-09 9:00

Kschuler

15-Jun-09 9:00

any help you want with this issue is entirely dependent on what method you use to deploy your application. What do you use?

Re: How to deploy dll before custom action

Mithun.Shitole15-Jun-09 9:09

Mithun.Shitole

15-Jun-09 9:09

Sorry I forgot to mention, I am using vs 2008 deployment project. I have added a custom action to it. My main project is in vb.net.

Mithun Shitole
"Free Your Mind"
http://www.technoyaari.com

Vista like Sort,Group,Stack,Filter dropdown on Listview ?

saxgod14-Jun-09 23:34

saxgod

14-Jun-09 23:34

Hi,

We are looking for a way to order a lot of data the way you can do in Vista Explorer.
It looks like a listview (detail), but you can click the dropdown arrow in the header and you get a few options like Sort, Group, Stack, and have checkboxes to filter.

Since this component already exists in Vista it should be possible to add this to Visual Studio, or am I totally wrong here ?

I've been googling for a while now but am not able to find something like this. I've seen some vista_api libraries but this mostly just changes the looks of the listview to vista, but doesn't add the functionality of the sort, group, stack and filter dropdown in the headers.

Does anybody have an idea ? Or should this be developed in a custom component from scratch ?

Re: Vista like Sort,Group,Stack,Filter dropdown on Listview ?

Dave Kreskowiak15-Jun-09 4:01

Dave Kreskowiak

15-Jun-09 4:01

I doubt you'll find this as a seperate component in Vista. There may be third party companies that put out a control like this, but I have no idea if anyone does. The last option is to write it yourself. You may have to also come up with the custom collection to hold the extra data you need for the various display modes you want.

A guide to posting questions on CodeProject[^]

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

Re: Vista like Sort,Group,Stack,Filter dropdown on Listview ?

saxgod15-Jun-09 23:09

saxgod

15-Jun-09 23:09

Okay Thx,

I'll have to do that then.
A bit stupid rebuilding something that already exists.

Robbie.

Re: Vista like Sort,Group,Stack,Filter dropdown on Listview ?

Dave Kreskowiak16-Jun-09 12:01

Dave Kreskowiak

16-Jun-09 12:01

Yeah, but it has to exist in a usable form. AFAICT, it's not. There is no COM registration for it, nor a .NET assembly. Without either of those, it's pretty useless.

A guide to posting questions on CodeProject[^]

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

Windowstate

JaganBR14-Jun-09 23:09

JaganBR

14-Jun-09 23:09

I have an application in VB 2005 where in I have a data grid. The datasource of that datagrid is changed frequently. when I minimize the applicaton window, the window is restored as and when the datasource of datagrid changes. What I want to do is that, if I minimize the window then it should not be restored untill I restore it. how to keep the windiw state unchanged untill and unless user dose it.

Re: Windowstate

Christian Graus14-Jun-09 23:18

Christian Graus

14-Jun-09 23:18

I suspect we need to see your code to try to understand why this is happening, I doubt it is just something that happens automatically.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Windowstate

JaganBR14-Jun-09 23:52

JaganBR

14-Jun-09 23:52

you are correct Christian Graus. This is happening automatically.I can not put my code here, but I will explain what exactly I have done. I have a button "Get Data" on windows form. I have a list of job codes in by database. On cick of "Get Data" button I am getting data related to those job codes and writing them into an Excel file. Before writing the data into Excel I am displaying it in a datagrid so that user can check the data if he wants. For every record the datasource of the dategrid changes.
When I minimize the window so that this application writes data of all the job codes into excel and I can perform some other task, the window of this application is restored when ever the datasurce of datagrid changes. I want it to run with out restoring the window.

Re: Windowstate

Christian Graus15-Jun-09 0:48

Christian Graus

15-Jun-09 0:48

Well, the obvious thing to do, is check the window state, and not update the datasource if you're minimised. I mean, if the framework is showing the window, and it's not your code, then you need to stop doing the thing that causes the window to be shown. You can update the datasource on the event of the windowstate changing.

how to pass two different record from different table in crystal report?

JC.KaNNaN14-Jun-09 21:13

JC.KaNNaN

14-Jun-09 21:13

hi,
i am new developer in vb.net.
i have two table one is job,another one is party tables.
job
Id
jobNo
VechNo
joamt

party
id
VechNo
Name
Address
PhoneNo

both table common fields in Vechno.
i will pass both jobno and vechno fields.
when both fields same to display information of two tables to crystal report.
how will get information?

example for single field paramter,

cryRpt.Load(path1 & "\" & REP_NAME & ".rpt")
With crConnectionInfo
.ServerName = path
'.ServerName = path1 & "\SIMdb2003.mdb"
'.DatabaseName = "YOUR DATABASE NAME"
'.UserID = "YOUR DATABASE USERNAME"
'.Password = "YOUR DATABASE PASSWORD"
End With

CrTables = cryRpt.Database.Tables
For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next

crParameterDiscreteValue.Value = PARAM_NUMBER
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields
crParameterFieldDefinition = crParameterFieldDefinitions.Item(PARAM_NAME)
crParameterValues = crParameterFieldDefinition.CurrentValues

crParameterValues.Clear()
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues)

'crystal report viewwr CRV
CRV.ReportSource = cryRpt
CRV.Refresh()

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

printpreviewdialog Numeric up down button events

VB 8.014-Jun-09 20:50

VB 8.0

14-Jun-09 20:50

Hi CP ,

I want to handle the Numeric Up / Down events in the printpreview control i wnat to make the viceversa of handling hte pages in Up/ down control . Presently the Up one is used for next page access . I want to make the down button to work in that way .

Is it possible ??

and i am havign 5 pages i want to show the 3 page first and change the page number in Up down control

Is it possible ??

Regards

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.