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

frommi24-Jun-09 0:15

24-Jun-09 0:15

Hi friends, I explain you my problem. I have my application installed on Vista 64bit, without Visual studio 2008 kit installed on the machine. Sometimes the application crash in particular situation, so windows doesn't start a debug to see the error line. Why?. Is it possible to install a free debugger on the machine without install Visual Studio 2008?
Thank you, wait some suggestions.
Bye Bye
Andrea

Re: Debugging

Manas Bhardwaj24-Jun-09 0:24

Manas Bhardwaj

24-Jun-09 0:24

You should rather log this somewhere in file, event log etc. This will give you an idea where it went wrong so that the code can be reviewed and possible problem can be understood.

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.

Balaji Pawar23-Jun-09 23:53

Balaji Pawar

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

Sk9323-Jun-09 23:55

Sk93

23-Jun-09 23:55

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

Re: c#

Balaji Pawar24-Jun-09 5:48

Balaji Pawar

24-Jun-09 5:48

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

......thanks once again

Re: c#

Sk9324-Jun-09 5:52

Sk93

24-Jun-09 5:52

pleasure $Shucks | :-\$

Re: c#

Manas Bhardwaj24-Jun-09 0:26

Manas Bhardwaj

24-Jun-09 0: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.Sharma23-Jun-09 23:20

J.K.Sharma

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

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

Sk9323-Jun-09 23:26

Sk93

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 + "'";

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

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

J.K.Sharma

24-Jun-09 21:41

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

Re: crystal report problem

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

J.K.Sharma

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.

Re: crystal report problem

Sk9324-Jun-09 21:53

Sk93

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

Re: crystal report problem

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.

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