Re: update query in windows application with ms access as database - C# Discussion Boards

Balaji Pawar24-Jun-09 0:53

24-Jun-09 0:53

I hav created a listview and added items to it. Now when i select one of those items and perform a rright click on the selected item i should get a dropdown menu as we normally get when we right click like refresh and all that. so plzzz help me out in this.....

balajipawar.8785@yahoo.com

Re: c#

Sk9324-Jun-09 0:55

Sk93

24-Jun-09 0:55

Add a ContextMenu control...
http://msdn.microsoft.com/en-us/library/aa984254(VS.71).aspx[^]

Re: c#

Balaji Pawar24-Jun-09 6:48

Balaji Pawar

24-Jun-09 6:48

first of all thanks 4 ur advise and yes ur answer was really helpful

......thanks once again

Re: c#

Sk9324-Jun-09 6:52

Sk93

24-Jun-09 6:52

pleasure $Shucks | :-\$

Re: c#

Manas Bhardwaj24-Jun-09 1:26

Manas Bhardwaj

24-Jun-09 1:26

Never ever give your email address in the public forums until and unless you want to be flooded with spams.

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.

update query in windows application with ms access as database

J.K.Sharma24-Jun-09 0:20

J.K.Sharma

24-Jun-09 0: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

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

Sk9324-Jun-09 0:26

Sk93

24-Jun-09 0: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 + "'";

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

Robert_Pan24-Jun-09 1:12

Robert_Pan

24-Jun-09 1:12

oledbparameter..... Sleepy | :zzz:

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

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

J.K.Sharma

24-Jun-09 22:41

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

Re: crystal report problem

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

J.K.Sharma

24-Jun-09 22: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.

Re: crystal report problem

Sk9324-Jun-09 22:53

Sk93

24-Jun-09 22: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 | :)

Re: crystal report problem

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

J.K.Sharma

24-Jun-09 23: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 23:36

Sk93

24-Jun-09 23: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 Graus24-Jun-09 0:42

Christian Graus

24-Jun-09 0: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

Sk9324-Jun-09 0:46

Sk93

24-Jun-09 0: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

KIDYA24-Jun-09 0:06

KIDYA

24-Jun-09 0: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

Sk9324-Jun-09 0:18

Sk93

24-Jun-09 0:18

this worked perfectly for me:
blog post[^]

hope it helps!

codes on data or text mining

awedreh23-Jun-09 23:51

awedreh

23-Jun-09 23:51

pls i need source codes on data or text mining

Re: codes on data or text mining

Simon P Stevens23-Jun-09 23:56

Simon P Stevens

23-Jun-09 23: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 Graus24-Jun-09 0:04

Christian Graus

24-Jun-09 0: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 Bhardwaj24-Jun-09 0:11

Manas Bhardwaj

24-Jun-09 0: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 4:40

OriginalGriff

24-Jun-09 4: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 23:36

Zeeshan Ahmed Memon

23-Jun-09 23: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 23:35

Tauseef A

23-Jun-09 23: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 10:30

ribe

23-Jul-09 10: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.

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