Re: SQL Script - C# Discussion Boards

Re: SQL Script

kibromg15-Apr-09 1:07

kibromg

15-Apr-09 1:07

Thanks very much for your reply.It runs on a database.

Re: SQL Script

Dino Mulahusic15-Apr-09 1:09

Dino Mulahusic

15-Apr-09 1:09

Select distinct(cli) from Table1 where cli not in (select Cli from table2)

try this with small c in second cli Smile | :)

Re: SQL Script

kibromg15-Apr-09 1:13

kibromg

15-Apr-09 1:13

Still the same.I have tried that also.

Re: SQL Script

Ashfield15-Apr-09 1:24

Ashfield

15-Apr-09 1:24

Have you got nulls in your fields? That would cause it.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL Script

kibromg15-Apr-09 1:57

kibromg

15-Apr-09 1:57

Yes Please.when i select distinct(cli) there is one record NULL.

When i try to remove it delete from Table1 where cli like NULL it does nothing.

Can you please advice how can i remove it?

Re: SQL Script

Ashfield15-Apr-09 9:44

Ashfield

15-Apr-09 9:44

You cannot do like null (or = null either), you have to do

where cli is not null (or cli is null depending on whic you want)

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: SQL Script

a.hamidy15-Apr-09 1:26

a.hamidy

15-Apr-09 1:26

this can help
select table1.cli from table1 left join table2 on table1.cli=table2.cli
where table2.cli is null

Re: SQL Script

Christian Graus15-Apr-09 1:27

Christian Graus

15-Apr-09 1:27

This is a SQL question. I would suggest you break it down to try to work out why it doesn't work.

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Re: SQL Script

kibromg15-Apr-09 1:58

kibromg

15-Apr-09 1:58

Yes Please.when i select distinct(cli) there is one record NULL together with other records

When i try to remove it delete from Table1 where cli like NULL it does nothing.

Can you please advice how can i remove it?

Re: SQL Script

kibromg15-Apr-09 2:22

kibromg

15-Apr-09 2:22

Hi Christian,

Can you help me with a script on how to check and remove any Null script from a table.

Many thanks

Re: SQL Script

tom57200715-Apr-09 2:30

tom572007

15-Apr-09 2:30

You should try IS NULL instead of LIKE NULL

CursorAdapter Equivalent

BabyCSharp15-Apr-09 0:45

BabyCSharp

15-Apr-09 0:45

What is C#'s equivalent to VFP's CursorAdapter?

Re: CursorAdapter Equivalent

Christian Graus15-Apr-09 0:54

Christian Graus

15-Apr-09 0:54

Depends, what does it do ? You can set the cursor with Cursor = Cursors.xxx

Re: CursorAdapter Equivalent

monstale15-Apr-09 1:34

monstale

15-Apr-09 1:34

Hi,

I think you want to open a database cursor, aren't you? Then you're search for class:

System.Data.Common.DbDataReader

or if you're searching e.g. for MS SQL Server:

System.Data.SqlClient.SqlDataReader

or OleDb:

System.Data.OleDb.OleDbDataReader

or Odbc:

System.Data.Odbc.OdbcDataReader

king regards

Re: CursorAdapter Equivalent

BabyCSharp15-Apr-09 1:44

BabyCSharp

15-Apr-09 1:44

Thanks.

Connection

BabyCSharp15-Apr-09 0:43

BabyCSharp

15-Apr-09 0:43

How to connect to MS Access Database and display result to grid?

Re: Connection

musefan15-Apr-09 0:47

musefan

15-Apr-09 0:47

do a google search and ill bet you will get loads of examples.

try looking at the System.Data.OleDb classes, its very straight forward from a programmers perspective

Life goes very fast. Tomorrow, today is already yesterday.

Re: Connection

BabyCSharp15-Apr-09 0:50

BabyCSharp

15-Apr-09 0:50

Thanks. Your answer guided me to the right trajectory.

Re: Connection

Dino Mulahusic15-Apr-09 0:50

Dino Mulahusic

15-Apr-09 0:50

It's very easy, maybe you should try it before you ask

or ask Mr. Google
or search here at CP Simple Movie Database in C# using Microsoft Access[^]

Re: Connection

BabyCSharp15-Apr-09 1:16

BabyCSharp

15-Apr-09 1:16

it's easy for you because you already know Poke tongue | ;-P

But the link that you gave me is very helpful so I will vote 1 for you. Smile | :)

Upload Data using c#

a.hamidy15-Apr-09 0:40

a.hamidy

15-Apr-09 0:40

I have asked this question several times in Code Project.
I am looking to upload my data with resume feature.
Is there any .Net Class or namespace or any algorithm to provide me a feature where i can upload my data in different segments and with resume feature?

Operator[] index overload in C#

al3xutzu0015-Apr-09 0:24

al3xutzu00

15-Apr-09 0:24

Hi Guys,
I need to make an overload for the index operator[int x] for an System.Collection.ArrayList, to use the get/set methods on it to return/set the specific item in that list.
How do i declare it ?
i tried :

public static explictit operator[int x]<br />
{<br />
}

It doesn't work. Help.

Kind regards,
Alex

“Be the change you want to see in the world.”

Re: Operator[] index overload in C#

Colin Angus Mackay15-Apr-09 0:28

Colin Angus Mackay

15-Apr-09 0:28

al3xutzu00 wrote:
I need to make an overload for the index operator[int x]

It isn't an operator. It is an indexer. You can read about how to create them here: Using Indexers (C# Programming Guide)[^]

*Developer Day Scotland - Free community conference Delegate Registration Open

How does the SharpStunt Library work?

softwarejaeger15-Apr-09 0:05

softwarejaeger

15-Apr-09 0:05

Hello,

can somebody tell me how the SharpStunt Library works? I want to initiiate a P2P Connection between two clients behind different NAT-Routers. That should be possible with this Library, but i don't know how to use it. Has somebody experience with this Library?

Kind regards

the type initializer fror "Myproject.Myclass"threw an exception?

dec8214-Apr-09 23:31

dec82

14-Apr-09 23:31

what is the meaning of this error?
Thanks

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