Delete command with DataSet and DataAdapter - C# Discussion Boards

Delete command with DataSet and DataAdapter

23-Dec-05 3:52

A web service really isn't the best choice for this. And you're still very short on the details. A web service must be called from a client. It's not just running in the background all the time like a Windows service.

You have some problems with this.

First, where is the file comming from? (Remember those DETAILS you're not telling us about?) Is it comming from an upload from the client to a folder on the web service server? Is it being uploaded using a method of the web service?

Second, is the server that is going to receive this file from the web service part of a Windows domain? Are both the target server and the web service server in the same domain? Or are they seperate, usch as different domains or workgroups?

What type of target server are you sending this file to? Windows 2003 is fine, but what server type are you sending this file to? An FTP Server?, A Windows Share?, ..., ???

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

DirectX app crashing

Christian Graus22-Dec-05 16:18

Christian Graus

22-Dec-05 16:18

I wrote a video jukebox program in C# last year. I initially used the AudioVideoPlayback namespace, but it's really buggy, so I used the WMP control instead. However, we used DX to read ID3 tags in the manager program. Now, a year later, the client has changed the contact person, and every machine he tries to install on gives him this error :
The type initializer for "Microsoft.DirectX.DirentInput.Manager" threw an exception.

in the constructor for the class that uses DX. The machines are all XP SP2, which means that DX is installed, although I'm not sure if managed DX gets installed by SP2, the installer won't run as it's there already.

The real worry is, it works fine on my dev machine, and works fine on his machine at home. I've tried with a couple of dll versions ( I have several installed ).

My constructor looks like this :

public JukeboxDXJoystickController()

{

foreach(DeviceInstance di in Manager.GetDevices(DeviceClass.GameControl, EnumDevicesFlags.AttachedOnly))

{

device = new Device(di.InstanceGuid);

}

if (device == null)

{

MessageBox.Show("Unable to find attached joystick");

return;

}

device.SetDataFormat(DeviceDataFormat.Joystick);

device.SetCooperativeLevel(null, CooperativeLevelFlags.Background | CooperativeLevelFlags.NonExclusive);

device.Properties.AxisModeAbsolute = true;

deviceUpdated = new AutoResetEvent(false);

appShutDown = new ManualResetEvent(false);

device.SetEventNotification(deviceUpdated);

Thread threadLoop = new Thread(new ThreadStart(this.ThreadLoop));

threadLoop.Start();

device.Acquire();

}

I previously used joyGetPos, etc, but they proved to be unreliable in C#. We can still use them and the program runs fine. Any suggestions are most appreciated.

Christian Graus - Microsoft MVP - C++

Re: DirectX app crashing

mav.northwind22-Dec-05 21:56

mav.northwind

22-Dec-05 21:56

Hi Chris!

I'm pretty sure that Managed DirectX is not installed out of the box, so I'd try installing it first.

Regards,
mav

Re: DirectX app crashing

Christian Graus23-Dec-05 11:35

Christian Graus

23-Dec-05 11:35

I'm sure you're right, but as it's the latest version in SP2, trying to install over the top is not possible.

Christian Graus - Microsoft MVP - C++

Re: DirectX app crashing

leppie23-Dec-05 0:13

leppie

23-Dec-05 0:13

There has been many managed interface changes AFAIK in the Dirext 'refreshes'.

^{xacc.ide-0.1.1 released! :) Download and screenshots}

Stefan R22-Dec-05 13:45

Stefan R

22-Dec-05 13:45

Good evening ( although it's night time in Sweden)
I'm trying to delete all my records in a single table with a DataAdapter. The code I use is this:

odbAdapter = new OleDbDataAdapter();<br />
			odbAdapter.SelectCommand = new OleDbCommand("Select * from Bilder", odbConnection);<br />
			OleDbCommandBuilder cb = new OleDbCommandBuilder(odbAdapter);<br />
			<br />
			odbConnection.Open();<br />
			odbAdapter.Fill(ds, "Bilder");<br />
<br />
			DataTable dt = ds.Tables["Bilder"];<br />
			<br />
			DataRow[] dr = dt.Select();<br />
		<br />
			foreach(DataRow item in dr)<br />
			{<br />
				item.Delete();<br />
			}<br />
			<br />
			odbAdapter.DeleteCommand = cb.GetDeleteCommand();<br />
			odbAdapter.Update(ds,"Bilder");<br />

However, I get an error message saying :

Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information

I'm guessing this has something to do with a primary key or something, judging by info gathered at other places. The primary key in the table is not automatically generated or anything. What the heck am i doing wrong here?

Dave Kreskowiak22-Dec-05 15:52

22-Dec-05 15:52

Why are you using a DataAdapter for this? If all you want to do is delete all the records in a table, why have the database waste the time retrieving them all and send them to you, just so you can tag them all for delete (one at a time, very time consuming!), then have the Adapter run a delete command on them (one at a time again!)?

Just tell the database to delete them all yourself!

string sql = "DELETE Bilder";
OleDbConnection conn = new OleDbConnection(connectionString);
OleDbCommand comm = new OleDbCommand(sql, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

-- modified at 21:55 Thursday 22nd December, 2005

Dave Kreskowiak22-Dec-05 16:14

22-Dec-05 16:14

Stefan R wrote:
Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information

Since your SELECT command is returning all the columns of the Bilder table, this message means that your table doesn't have a Primary Key. DataAdapters will only work with tables that define a Primary Key.

This is because changes that are made you the DataSet are written back to the database one record at a time. The DataAdapter looks at each record in the DataSet and determines which SQL Command to execute against that record in order to properly update the database, wheather it be an INSERT, UPDATE, or DELETE command.

Now, if the DataAdapter is making changes to the tables in the DataSet one record at a time, how does it know how to tell the database which record to change? This is what the Primary KLey in each table is for. Without it, the DataAdapter has no consistant way of uniquely identifying every record in each tabel in the dataset.

For example, when you delete a record out of the DataSet, the DataAdapter executes a SQL DELETE command against that record. That command will look something like this:

DELETE FROM tableName WHERE PriKeyColumnName = DataSetPriKeyValue

This DELETE command is generated by the CommandBuilder object you created. It looks at the SELECT statement and the returned DataSet and uses the information in that set to generate the respective UPDATE, INSERT, and DELETE SQL statements, each with a WHERE clause that identifies which record in the database to execute the statement against.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Stefan R22-Dec-05 22:57

Stefan R

22-Dec-05 22:57

I know i can easily delete all records with "delete from biler" and i know the problem is not related to my SQL-statements or db schema. I'm just new to working with the DataSet. Since i want to learn how to work with the dataset i want to avoid using the method above. I want to be able to remove records one by one in the future...

The table has a primary key defined in my Access db, however it seems that the DataAdapter doesn't retrieve any meta data about primary keys and constraints from the table( as stated in msdn ). That's probably way the message says that i don't have a primary key. MSDN also states that i should specify which column is the key column somewhere in code and i have read something about MissingSchemaAction.AddWithKey...

The problem is that i can't seem to get it right. How do i make the DataAdapter fetch information about the primary key? Or how do i tell the DataAdapter that a certain column in the fetched table is actually a primary key column? This is really bugging me out

-- modified at 4:59 Friday 23rd December, 2005

Dave Kreskowiak23-Dec-05 4:24

Re: Delete command with DataSet and DataAdapter - RESOLVED!

23-Dec-05 4:24

There's go to be something wrong with your table then. There's no problem with using a DataAdapter with an Access table.

If your table is correct, then you really don't have a need to specify which column is the PK. I've never run into the problem. This code works just fine:

[EDIT]Sorry, wrong language for the forum...[/EDIT]

    string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\TestBlank.mdb"; 
    string sql = "SELECT * From MyTable"; 
 
    OleDbDataAdapter da = new OleDbDataAdapter(sql, connString); 
    OleDbCommandBuilder cb = new OleDbCommandBuilder(da); 
    DataSet ds = new DataSet(); 
 
    da.Fill(ds, "MyTable"); 
 
    foreach (DataRow row in ds.Tables("MyTable").Rows)
    { 
        Debug.WriteLine("ID: " + row("TestID")); 
        row.Delete(); 
    } 
    da.DeleteCommand = cb.GetDeleteCommand(); 
    da.Update(ds, "MyTable");

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

-- modified at 10:25 Friday 23rd December, 2005

Stefan R23-Dec-05 4:41

Stefan R

23-Dec-05 4:41

I tried changing primary key data type from "PM" to "Text" in the db and now it works just fine. I really did have a primary key though Sniff | :^)

, and after reading that thing about "...OleDbDataAdapter not fetching primary key constraints..." on MSDN i really thought i was in trouble.

But as always, the problem lies in something small and unsignificant to the eye

Dave Kreskowiak wrote:
[EDIT]Sorry, wrong language for the forum...[/EDIT]

I'm pretty fluent in VB syntax so i don't mind Smile | :)

Thanks a lot for the help!

Re: Delete command with DataSet and DataAdapter - RESOLVED!

Dave Kreskowiak26-Dec-05 5:53

[urgent] web browser, forms

26-Dec-05 5:53

Stefan R wrote:
I'm pretty fluent in VB syntax so i don't mind

Yeah, I changed the code becauseif you're caught posting VB code in the C# Forum, ... well, let's just say it makes the movie "Desparado" look like a Sunday Brunch. Big Grin | :-D

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Sam 200622-Dec-05 9:28

Sam 2006

22-Dec-05 9:28

if i create a webbrowser object, and there is a form (with name="something") on the page displayed, is there a way i can automatically submit it using c#?

thanks in advance,
sam kline

<a href="http://dying.about.com/gi/pages/poll.htm?poll_id=2068629450">YES</a>

Reports in c#

HolyGrandFather22-Dec-05 9:16

HolyGrandFather

22-Dec-05 9:16

Hi, Does anyone know a good way to make reports in c#? not in Crystal Reports(Money issue) ..

i'm lookin for a simple report, maybe something thats like access reports.. ..

any idea will do ..

thanks in advance ,.. Yosi.

Christian Graus22-Dec-05 9:45

Christian Graus

22-Dec-05 9:45

There is at least one free library that draws graphs, you could use that to create your own report, I guess. You'd have the data you need from your data source already.

Christian Graus - Microsoft MVP - C++

HakunaMatada22-Dec-05 17:19

HakunaMatada

22-Dec-05 17:19

I recently made reports using the GDI, PrintDocument and PrintPreview controls of .NET. Although its a lot of boring work when you use GDI to draw lines and such but I did it. Smile | :)

Bikash Rai

HolyGrandFather22-Dec-05 23:56

HolyGrandFather

22-Dec-05 23:56

Is there anychance you can post me the code?
i'm in a mess... i got this presentation on sunday, and i was counting on that crystal reports, but then i found out it need to be registerd...

anyhow,, if you could post me the code , i will the most grateful man on eatrh!

HakunaMatada23-Dec-05 0:35

HakunaMatada

23-Dec-05 0:35

I have sent you the code as a Zip attachment. Although the code is in VB.NET I think you won;t have any problems porting it to C#. I couldn't post the code here because the code's long...... really long..... Sigh | :sigh:

Happy Printing... Smile | :)

---
With best regards,
A Manchester United Fan

The Genius of a true fool is that he can mess up a foolproof plan!

why I get a weird exception when I call setFocus? The exception is called as &quot;Collection was modified; enumeration operation may not execute.&quot;

albCode23-Dec-05 0:46

albCode

23-Dec-05 0:46

http://www.codeproject.com/csharp/letaonarticle2.asp

jerryyag22-Dec-05 8:48

jerryyag

22-Dec-05 8:48

The code are looks like this:

Panel panel1 = new Panel();
if(panel1.CanFocus){
panel1.Focus();
}

Then it generated a exception at the run-time.

An unhandled exception of type 'System.InvalidOperationException' occurred in mscorlib.dll
Additional information: Collection was modified; enumeration operation may not execute.

Focus() has nothing to do with the collection, is that because of UIPermission fails? Frown | :(

Thanks

Re: why I get a weird exception when I call setFocus? The exception is called as &amp;quot;Collection was modified; enumeration operation may not execute.&amp;quot;

Stanciu Vlad22-Dec-05 10:12

Stanciu Vlad

22-Dec-05 10:12

Perhaps a handle of panel1 fires a method that generates that exception or that prepare the field for the exception.

protected internal static readonly ... and I wish the list could continue ...

Re: why I get a weird exception when I call setFocus? The exception is called as &amp;quot;Collection was modified; enumeration operation may not execute.&amp;quot;

Dave Kreskowiak22-Dec-05 15:40