Re: MS Access identifing primary key. - C# Discussion Boards

First Prev Next

Re: Retrieve Antivirus Information.

banker_kiran12-Jan-09 0:09

banker_kiran

12-Jan-09 0:09

Like,
Name, Version and UpdateStatus

Kiran Banker

Re: Retrieve Antivirus Information.

Abhijit Jana12-Jan-09 1:16

Abhijit Jana

12-Jan-09 1:16

Have a look on Win32_Product Class .
Read This[^]
Hope this will helps you !!

cheers,
Abhijit
CodeProject MVP
My Blog :Abhijit's World of .Net

MS Access identifing primary key.

Nanda_MR11-Jan-09 23:17

Nanda_MR

11-Jan-09 23:17

Hi !!!

I done a program in C# that I can access all MS Access database file (Inside all table).
Know i can access all table values. know I m planning to update / delete/ and insert operation.
1.For that I want find Primary Key Value for delete and update.
2.In case Insertion find the Primary key to avoid duplication.
3.If any new method plz tel me.

I m new to C#.
Thanx's in advance.

Re: MS Access identifing primary key.

SeMartens11-Jan-09 23:40

SeMartens

11-Jan-09 23:40

Hi,

do you need help with your sql-statements?

1. Well, what do you want to delete/update? E.g. if you want to update data for a person, you normally have a row representing this person. If your user enters data in a form to edit this person, you have the primary key, since you loaded this person before.

2. If the primary key will be incremented automatically, you don't need to set one. If it is not, just do a select with the new primary key before inserting the new row.

3. Don't understand the question here. What do you mean by "new method"?

Regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

Re: MS Access identifing primary key.

Nanda_MR12-Jan-09 0:03

Nanda_MR

12-Jan-09 0:03

Thanx's for your Replay

Actually I m not use a single database.
My application can open any database(MS Access File).
So that i don't know content of file. After open the database it retrieve all data value and header name also.
Know I can view all the data but can't update, delete or insert b'coz
1. Don't know the Primary Key value. some time it gives error.
and Which base I can perform the delete / Update Operation.

Re: MS Access identifing primary key.

SeMartens12-Jan-09 0:53

SeMartens

12-Jan-09 0:53

Hmm, I think you are using odbc or something similar to access the database.

One possibility to identify the primary key column could be to use Automation (take a look here http://support.microsoft.com/?scid=kb%3Ben-us%3B317114&x=18&y=5[^].

Then you could open the file using access and find the primary-key column.

Some SQL-DBS offers the possibility to get information abouot the structure by sql statements, but I don't know if access can do this.

Hope this helps you a bit.

Regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

Re: MS Access identifing primary key.

Nanda_MR12-Jan-09 1:24

Nanda_MR

12-Jan-09 1:24

Sebastian I upload that file here check it and tel the solution plz....

http://www.codeproject.com/KB/cs/Access_file.aspx[^]

Thanks in advance.

Re: MS Access identifing primary key.

Pete O'Hanlon12-Jan-09 2:09

Pete O'Hanlon

12-Jan-09 2:09

Please don't abuse the articles system. We get enough crap posted in there without having to weed stuff like this out. Articles are places to post, well, articles which should give useful information and advice. They aren't there to post questions.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

My blog | My articles | MoXAML PowerToys

how to create tables in c#

lawrenceinba11-Jan-09 23:15

lawrenceinba

11-Jan-09 23:15

how to create tables in c#

pls tel me how to create tables and display output in tat for certain program

the quieter u become more u hear

Re: how to create tables in c#

SeMartens11-Jan-09 23:25

SeMartens

11-Jan-09 23:25

Hi,

what kind of tables do you mean exactly? Database-Tables, DataTables in memory?

You can use GridView-Controls to display data from tables.

Please be more specific what you want to achieve, so that we can help you a bit better.

Regards
Sebastian

It's not a bug, it's a feature!

Me in Softwareland.

Re: how to create tables in c#

lawrenceinba11-Jan-09 23:40

lawrenceinba

11-Jan-09 23:40

im asking data tables in memory dude

the quieter u become more u hear

Re: how to create tables in c#

benjymous11-Jan-09 23:50

benjymous

11-Jan-09 23:50

Look up "Collections" - there should be something in there that will suit your needs

Help me! I'm turning into a grapefruit!
Buzzwords!

Re: how to create tables in c#

SeMartens11-Jan-09 23:51

SeMartens

11-Jan-09 23:51

Okay, so what do you want to know exactly?

Something like this?

<br />
System.Data.DataTable table = new DataTable("MyTable");<br />
DataColumn column = new DataColumn("MyColumn");<br />
column.DataType = System.Type.GetType("System.String");<br />
table.Columns.Add(column);<br />
<br />
DataRow row = table.NewRow();<br />
row["MyColumn"] = "test";<br />
table.Rows.Add(row);<br />

Regards
Sebastian

P.S.: Please be so kind not to call me "dude".

It's not a bug, it's a feature!

Me in Softwareland.

Re: how to create tables in c#

lawrenceinba12-Jan-09 3:49

lawrenceinba

12-Jan-09 3:49

k........... thanks

the quieter u become more u hear

Re: how to create tables in c#

rah_sin11-Jan-09 23:29

rah_sin

11-Jan-09 23:29

i think u can go for DataGrid or DatagridView or ListView controls

rahul

Re: how to create tables in c#

lawrenceinba11-Jan-09 23:56

lawrenceinba

11-Jan-09 23:56

thank u friends

the quieter u become more u hear

SystemState - Windows Mobile Help

pfffffffff11-Jan-09 23:06

pfffffffff

11-Jan-09 23:06

Hi all,

I'm just wondering if there is a way around this problem:

Basically, when an incoming call comes in and then it is missed, the event fires and grabs the last name and number of the caller. The problem being is that there are two lines added that are identical to the listbox.

SystemState MySysState = new SystemState(SystemProperty.PhoneMissedCall);
MySysState.Changed += new ChangeEventHandler(MySysState _Changed);

void MySysState Changed(object sender, ChangeEventArgs args)
{
ListBox1.Add(SystemState.PhoneLastIncomingCallerName.ToString() + ": " + ListBox1.Add(SystemState.PhoneLastIncomingCallerNumber.ToString());

}

MySysState is being declared in the form load, btw.

Could anyone point me in the right direction?

Thanks in advance.

Re: SystemState - Windows Mobile Help

Deflinek12-Jan-09 4:01

Deflinek

12-Jan-09 4:01

Are you sure you need the nested ListBox1.Add()? Shouldn't the code look like:

void MySysState Changed(object sender, ChangeEventArgs args) 
{ 
ListBox1.Add(SystemState.PhoneLastIncomingCallerName.ToString() + ": "
 + SystemState.PhoneLastIncomingCallerNumber.ToString()); 
}

There is also one missing ")" in your code Smile | :)

--
"My software never has bugs. It just develops random features."

Re: SystemState - Windows Mobile Help

S. Senthil Kumar12-Jan-09 5:27

S. Senthil Kumar

12-Jan-09 5:27

Could it be that the event is being fired twice in quick succession? When I wrote a similar piece of code, I vaguely remember the event firing everytime the number of missed calls change. It fires when you get a missed call (missedcall count = 1) and fires when you go to the missed calls window (missedcall count = 0).

Regards
Senthil [MVP - Visual C#]
_____________________________
My Home Page |My Blog | My Articles | My Flickr | WinMacro

Game programming with C# - beatmania

Member 411849711-Jan-09 22:42

Member 4118497

11-Jan-09 22:42

Hi,

I'm writing a game program using C# for a school project, similar to that of beatmania / djmax games. Anyone has any idea how to go about writing it? Or is there any similar references? Cos I don't seem to be able to find any online. Thanks!

Cheers,
Lun

Re: Game programming with C# - beatmania

benjymous11-Jan-09 23:13

benjymous

11-Jan-09 23:13

Look for XNA tutorials - there are plenty of those out there
(XNA is Microsoft's managed wrapper around DirectX, and opens the door to the Xbox community games - i.e. if you get it good, you can get it released, and start earning money off it)

Help me! I'm turning into a grapefruit!
Buzzwords!

BitConverter?

dec8211-Jan-09 21:57

dec82

11-Jan-09 21:57

float Float1= BitConverter.ToSingle( tempByte,0)

with temByte[0]= 0
temByte[1]= 0
temByte[2]= 160
temByte[3]= 127

Why after execution, i got Float1= NaN?

Thanks

Re: BitConverter?

Guffa11-Jan-09 23:27

Guffa

11-Jan-09 23:27

Because that data is one of the codes that represent the value NaN.

Try for example { 0, 0, 128, 63 }.

Despite everything, the person most likely to be fooling you next is yourself.

Anyone having idea to read pdf in c# with images preserved [modified]

inzibharti11-Jan-09 20:30

inzibharti

11-Jan-09 20:30

Anyone having idea to read pdf in c# with images preserved

I had googled this for last 7 days without any sucess... Smile | :)

Thanks

Don't walk as if u rule the world,walk as if u don't care who tha Hell rules the world ...

modified on Monday, January 12, 2009 3:19 AM

Re: Anyone having idea to read pdf in c# with images preserved

Aman Bhullar11-Jan-09 21:11

Aman Bhullar

11-Jan-09 21:11

I don't think there is any way around for reading PDF in C#.

Last Visit: 31-Dec-99 18:00 Last Update: 28-May-24 21:41

Refresh

ᐊ Prev 1...5884 5885 5886 588758885889 5890 5891 5892 5893 Next ᐅ

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