Re: crystal report problem - C# Discussion Boards

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

23-Jun-09 23:20

Hi I have a problem in my windows application with ms access 2007 as database.
The problem is that the update query to change password is giving error.

the code i used is

string qry1 = "update log_in set password='" + txtnew.Text.Trim() + "' where userid='" + txtuser.Text + "'";
cmd = new OleDbCommand(qry1, con);
cmd.ExecuteNonQuery();
MessageBox.Show("Password changes Sucessfully");

the error is "Syntax error in UPDATE statement."

please answer. thanks in advance

J.K.Sharma

Sk9323-Jun-09 23:26

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

23-Jun-09 23:26

password is a reserved field name.

Try changing your code to read:

string qry1 = "update log_in set [password]='" + txtnew.Text.Trim() + "' where userid='" + txtuser.Text + "'";

Robert_Pan24-Jun-09 0:12

Robert_Pan

24-Jun-09 0:12

oledbparameter..... Sleepy | :zzz:

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

J.K.Sharma24-Jun-09 21:41

24-Jun-09 21:41

Thank you so much . It works as per you advice.

J.K.Sharma24-Jun-09 21:48

24-Jun-09 21:48

when i create crystal report the database is at some location.
but when i prepare setup of that windows application and deploy it on some other system then the path of database change and the crystal report does not load the correct database.

Please help..
Thanks in advance.

Sk9324-Jun-09 21:53

24-Jun-09 21:53

Consider using an application configuration file to store your database path / connectionstring.

take a look at one of my other replies:

http://www.codeproject.com/Messages/3093473/Re-XML-Call-me-stupid-LOL.aspx[^]

Hope this helps Smile | :)

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

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.

Sk9324-Jun-09 22:36

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

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:

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

Dynamically show images in crystal report

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 | ;)

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

codes on data or text mining

23-Jun-09 23:18

this worked perfectly for me:
blog post[^]

hope it helps!

awedreh23-Jun-09 22:51

awedreh

23-Jun-09 22:51

pls i need source 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

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.

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.

Heirarchy in DataGridView

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

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

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.

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.

Tauseef A23-Jul-09 9:59

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.

Tauseef A23-Jul-09 10:00

23-Jul-09 10:00

from which machines you have to read ?

Tauseef A Khan
MCP Dotnet framework 2.0.

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

Tauseef A23-Jul-09 20:35

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.