Re: codes on data or text mining - C# Discussion Boards

J.K.Sharma24-Jun-09 22:08

J.K.Sharma

24-Jun-09 22:08

Thanks for your suggestion

I have used app.config file to store connection string for rest of my application but i am unable to create cyrstal report using that string.

Because when I create crystal report i need to use database field from field explorer which are present only when i establish connection at creation time of crystal report.

Is there any other way to generate crystal report so that i can use app.config connection string for that.

Re: crystal report problem

Sk9324-Jun-09 22:36

Sk93

24-Jun-09 22:36

Try something like this:

foreach ([forgot object name] tbl in CRReport.Database.Tables)
{
   tbl.SetLogOnInfo("",dbLocation,dbUser,dbPass)
   tbl.Location = dbLocation
   tbl.SetDataSource(dbLocation)
}

I've not got CR installed here, so can't double check the function and object names,
but I believe that will redirect your database source for you Smile | :)

The first parameter of "SetLogOnInfo" i think is a connection string, but I don't think you need this when reading from Access.. I've only ever used SQL Server, so I will say this is all just guess work WTF | :WTF:

Anyways, hope it works for you! Cool | :cool:

Re: update query in windows application with ms access as database

Christian Graus23-Jun-09 23:42

Christian Graus

23-Jun-09 23:42

If you let me use your application, I can erase your entire database. Try reading up on SQL injection attacks.

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: update query in windows application with ms access as database

Sk9323-Jun-09 23:46

Sk93

23-Jun-09 23:46

unless he's protecting against it in "onChange" events of the text boxes perhaps..
or maybe on the lines above these?

Assumption makes an.... Wink | ;)

Dynamically show images in crystal report

KIDYA23-Jun-09 23:06

KIDYA

23-Jun-09 23:06

Hello experts!!!

i am using c#.net and inbuilt crystal report.i want to show image in crystal report at run time from the database(sql).

is anybody have code for same???

Re: Dynamically show images in crystal report

Sk9323-Jun-09 23:18

Sk93

23-Jun-09 23:18

this worked perfectly for me:
blog post[^]

hope it helps!

codes on data or text mining

awedreh23-Jun-09 22:51

awedreh

23-Jun-09 22:51

pls i need source codes on data or text mining

Re: codes on data or text mining

Simon P Stevens23-Jun-09 22:56

Simon P Stevens

23-Jun-09 22:56

You need to explain exactly what it is you want to do, and what problem you are having. No one is going to just give you code, but we will help you if you get stuck.

Simon

Re: codes on data or text mining

Christian Graus23-Jun-09 23:04

Christian Graus

23-Jun-09 23:04

CP has a job board, if you want someone to provide you with code, you need to pay them.

Re: codes on data or text mining

Manas Bhardwaj23-Jun-09 23:11

Manas Bhardwaj

23-Jun-09 23:11

These [^]guys can provide you loads of code Poke tongue | ;-P

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: codes on data or text mining

OriginalGriff24-Jun-09 3:40

OriginalGriff

24-Jun-09 3:40

Codes as requested:

43727970746F48656C70657200000000DA1000009C4AF04BDF569227C10B896ABC2266453F3D4560E7350987F2C76B54D7D6DC95B5EA713281B98E699BF0E209C5C2AB46384A4F62BEE42972D314477D9C53DA75E78A1D3159F7A465F03E49890546D7A7CF275EF1E76581199B66B16FAE90579E7E06FF032C0F4FB86378A67CCB5438355E5E355ACD7F56E79F0D4A93A330551767E4E1E813D784C7D53AEC1EAAE1915587B288B45EF0A1B079A66495C86010255C8BD204212FB1A73A6BCA46B4F9B29DB3785F9544C3FBF9D686BFE916D73B3A43F14C8B6E95DB0E0BC0D546E753A8A5748A210A4CD8729D4D61F2F60D6AEB797CA5B1E0B4BFB3622FBE162116BAF5B3674A6A8B2357A70F2B95D5E482FB0648A639A87B6459CCB537C0735FD85BDB79A57559E919927171543B744728D15CCE043107E88373015BD1EC7163DD2B8C727C47C3AC7E26C51A0B1A03523FB0DD8586CD1E963517799CA17EBC3914D57849FEE354E6FFE6BDE628371656E6DE3917F1B744A85FDAE96228322FCBAE2219E43490AF9D2485379F1E3686F0CC546026CEB4A50888897B44C493C655BFEFD3768CB07812C33438110D2CE90D825E44836350DC3B9C966872DF466FACC282E6783AEDC08A0BDDFFC7C5D1CA7366013EDAF48A5D9D0F3362F595C766E3BC729EF5D6F1849F946F85BB095B92BBD1E11E5CBCA815AE32160151EA27BA4B326CD71888D47671F8D608AF8C6CA10831CC4D27EAA627E81A9EF214A9562063D3CAE85FEB1ACA32976BD044159308749C676EEF81B4281760ACA79CF9D0D55A2967774ED5F9E86C1AFAE1578642A97D47F446F4B2A35E9F8277CEC7322FA341873A1339EE339EAB873B3DFAAC84A3F6CAAC4325D896E2AF4A5D67DB9BE9D94B162D59F33D9717FC8CF29D68B5B63F4E51D390F6A58B628A211631EA41D95D45DF050AC71F35913D1DCCFB734716E1953C4A82B0232E05F25EA31416ABE7D489DB94F8900C6E9242A92C210AC7363B0CFD3E544B5F739064605B01E6145AEC0CE4290D87053F3967EBBCB6838CF7011AD688CC7A318
TripleDES encrypted. Guess the password, and it's yours!

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Heirarchy in DataGridView

Zeeshan Ahmed Memon23-Jun-09 22:36

Zeeshan Ahmed Memon

23-Jun-09 22:36

Dear Fellows,

I have an xml file
<subjects>
<publishers name="wrox">
<book>
Beginning c#
</book>

<book>
Beginning ASP.NET WITH C#
</book>
</publishers>

<publishers name="Masters">
<book>
master in c#
</book>

<book>
master ASP.NET WITH C#
</book>
</publishers>
</subjects>

First I only want to display its publishers name in datagridview. When a user press any publisher name he will be able to see name of books in datagridview below the publisher name on which he click.

You can say it as a tree view operations that I want to perform in datagridview.

I need your help to solve it.

I will be thankful to all those who help me.

Thank you.

Regards,
Zeeshan Ahmed.

hitachi 902

Tauseef A23-Jun-09 22:35

Tauseef A

23-Jun-09 22:35

hi guys i want to connect hitachi 902 device mwith my .net application via serial port

any body knows how to do that ? any idea ? thanks in advance .

regards ,

Tauseef A Khan
MCP Dotnet framework 2.0.

Re: hitachi 902

ribe23-Jul-09 9:30

ribe

23-Jul-09 9:30

I just got the same job. Plus I need to reed from 3 other machines.
E-mail me if you have some answers.
Is it posible to be done, did you have any success?
Thanks.
P.S. I'll continue working on the problem.

Re: hitachi 902

Tauseef A23-Jul-09 9:59

Tauseef A

23-Jul-09 9:59

yes, i done with architect, and for hotachi 902 i am working and i hope it will also be done .regards .

Tauseef A Khan
MCP Dotnet framework 2.0.

Re: hitachi 902

Tauseef A23-Jul-09 10:00

Tauseef A

23-Jul-09 10:00

from which machines you have to read ?

Tauseef A Khan
MCP Dotnet framework 2.0.

Re: hitachi 902

ribe23-Jul-09 10:08

ribe

23-Jul-09 10:08

Hitachi 902 - biochemical analizer
has serial port

Elexis 2010 - imuno analizer
I can't find info about it, I need to check if the name is correct.

Sysmex K800
has some port

Roche 9180 - elektrolit analizer
has serial portt

Re: hitachi 902

Tauseef A23-Jul-09 20:35

Tauseef A

23-Jul-09 20:35

i am working on hitachi 902 , if u need it i will give it to you ,i have done and tested with architect if some of your reference wants architech i can also provide it to you .

regards .

Tauseef A Khan
MCP Dotnet framework 2.0.

Re: hitachi 902

BalachandarD25-Jul-09 1:40

BalachandarD

25-Jul-09 1:40

Hi,
I have started integrating the Hitachi 902 Automatic Analayzer. i think u have allready completed the interfacing can u help me in doing that?

Thanks
Bala

DataGridViewComboBoxColumn

mjelten23-Jun-09 22:01

mjelten

23-Jun-09 22:01

Hi!

I am trying to add different values to a combobox in a datagridview.

|TEXTColumn      | |TEXTColumn    | |TEXTColumn |DataGridViewComboBoxColumn | 
|John            | |Svensson      | |1231421    |Cat                        | 
|                | |              | |           |Dog                        | 
|                | |              | |           |mouse                      | 
|Sarndra         | |Larsson       | |2344324    |horse                      | 
|                | |              | |           |Bird                       | 
|Adam            | |Jönsson       | |6587568    |dog                        | 
|                | |              | |           |mouse                      | 
|                | |              | |           |badger                     | 
|                | |              | |           |Tiger                      |

i set up a data grid view,

private void SetUpforDataGridView()
       {
           dataGridViewSearched.ColumnCount = 3;
           DataGridViewComboBoxColumn dataGridViewcombobox = new DataGridViewComboBoxColumn();
       }

And then set the values, it works dine for the textfields but not for the combobox, i get no values in it

public void BindUserList(List<User> userList)
        {

            object[] row = new object[3];
            foreach (User p in userList)
            {
                row[0] = p.LastName;
                row[1] = p.FirstName;
                row[2] = p.UserId.ToString();                             
                dataGridViewSearched.Rows.Add(row);
                
                foreach (var unit in p.UnitActivationPeriods)
                {
                    ((DataGridViewComboBoxCell)dataGridViewSearched.Rows[dataGridViewSearched.Rows.Count - 1].Cells[5]).Items.Add(unit.ToString());
                }

Any thoughts?

Mjelten

Re: DataGridViewComboBoxColumn

Henry Minute23-Jun-09 23:52

Henry Minute

23-Jun-09 23:52

You should set the DataSource of the DataGridViewComboBoxColumn to your list of options. Then use the DisplayMember and ValueMember properties to set what is displayed and what is stored.

For examples Google for datagridview lookup column. there are loads of 'em.

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.”

Re: DataGridViewComboBoxColumn

mjelten24-Jun-09 1:14

mjelten

24-Jun-09 1:14

So you cannot display items without using datasource?

Re: DataGridViewComboBoxColumn

Henry Minute24-Jun-09 1:20

Henry Minute

24-Jun-09 1:20

I am not aware of any way to do it, if it is possible.

Re: DataGridViewComboBoxColumn

mjelten24-Jun-09 2:00