|
I want to insert a row in a table which has a PK in the first field. I make a INSERT and give parameters to the sql server for all fields except the id field which is set in the db as Autoincrement so i dont have to worry about.
ALL of this is working fine.
But now i want to work immediatly after the insert with the new id of this row, which was given to the row automaticly by the sql-server. My problem now is that i have no Idea how to get the id value into my code (sure I can make a select query questioning all the parameters which i still have from the insertcommand, and ask for the id but this way seems very complicated to me!!!)
So if any more experienced Programmer than me can help me, please!!!
10000 Thanks in advanced.
PS
Languages C#, ADO.Net, and Sql Server 2000
best regards helli
|
|
|
|
|
Typically, you add a SELECT statement after your INSERT statement when used with a SqlDataAdapter (fills a DataSet from a SQL Server database using Fill, or vice versa using Update). This makes sure that your DataSet is filled with what SQL Server assigned to the PK field.
To include both an INSERT and SELECT, separate your statements with a semi-colon (;):
sqlDataAdapter1.InsertCommand = new SqlCommand(
"INSERT INTO MyTable Name VALUES (@Name); SELECT ID, Name FROM MyTable",
sqlConnection1);
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I think you need to use "IDENTITY/IDENT_CURRENT or SCOPE_IDENTITY" method of SQL. But I don't know how you can use it. If you get full source code please let me know.
|
|
|
|
|
I've added a movieplayer to my application, using Interop.QuartzTypeLib.dll
First time I load and play a video it works fine, but when I reload or open a different video and play that, the picture is all scrambled, but the sound is OK
Anyone got an idè?
The code:
public void Play(string strVideoPath)
{
CleanUp();
m_objFilterGraph = new FilgraphManager();
m_objFilterGraph.RenderFile(strVideoPath);
m_objBasicAudio = m_objFilterGraph as IBasicAudio;
try
{
m_objVideoWindow = m_objFilterGraph as IVideoWindow;
m_objVideoWindow.Owner = (int) this.Handle;
m_objVideoWindow.WindowStyle = WS_CHILD | WS_CLIPCHILDREN;
m_objVideoWindow.SetWindowPosition(this.ClientRectangle.Left,
this.ClientRectangle.Top,
this.ClientRectangle.Width,
this.ClientRectangle.Height);
}
catch (Exception)
{
m_objVideoWindow = null;
}
m_objMediaEvent = m_objFilterGraph as IMediaEvent;
m_objMediaEventEx = m_objFilterGraph as IMediaEventEx;
m_objMediaEventEx.SetNotifyWindow((int) this.Handle,WM_GRAPHNOTIFY, 0);
m_objMediaPosition = m_objFilterGraph as IMediaPosition;
m_objMediaControl = m_objFilterGraph as IMediaControl;
m_objMediaControl.Run();
m_CurrentStatus = MediaStatus.Running;
}
private void CleanUp()
{
if (m_objMediaControl != null)
m_objMediaControl.Stop();
m_CurrentStatus = MediaStatus.Stopped;
if (m_objMediaEventEx != null)
m_objMediaEventEx.SetNotifyWindow(0, 0, 0);
if (m_objVideoWindow != null)
{
m_objVideoWindow.Visible = 0;
m_objVideoWindow.Owner = 0;
}
if (m_objMediaControl != null) m_objMediaControl = null;
if (m_objMediaPosition != null) m_objMediaPosition = null;
if (m_objMediaEventEx != null) m_objMediaEventEx = null;
if (m_objMediaEvent != null) m_objMediaEvent = null;
if (m_objVideoWindow != null) m_objVideoWindow = null;
if (m_objBasicAudio != null) m_objBasicAudio = null;
if (m_objFilterGraph != null) m_objFilterGraph = null;
}
Thanks
Thomas
|
|
|
|
|
Ummm... I really don't know, because I've never used that library before, but it *might* be a problem with the library.
For multimedia, I use The multimedia code found at http://www.mentalis.org/. Try it out, they've got source in both VB.Net and C#.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
For starters, don't just set the objects to null. Objects that encsapsulate native resources expose a Dispose method that cleans-up the unmanaged (and sometimes even the managed resources) when you call Dispose. Simply setting these objects to null will (if there are no other references) cause the objects to get garbage collected when the application is idle or when memory must be freed. The unmanaged resources will not be freed by the GC, which is why they're called "unmanaged". It's possible that some of these objects have alloc'd global memory or something similar that is being shared between videos, possibly leading to the corruption you've witnessed.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
It's seems that this code is working fine on another computer.
So it probably has to be something with my Grafic card,the driver, or some mitche mach with some of my codecs.
Thomas
|
|
|
|
|
In any case, you might want to take Heath's advice and modify your code so it's written properly. This is avoid any future problems you may have and eliminate your code as a possible cause of those problems.
RageInTheMachine9532
"...a pungent, gastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I set up the datasource
myDataGrid.DataSource= myDataSet.Tables[0].DefaultView;
When I scroll the cursor to next row, datagrid updates the dataset. It's ok. But without doing it, datagrid doesn't update the dataset. myDataSet.Tables[0].Rows.Count is 0 and
myDataSet.Tables[0].DefaultView.Count is 1.
For example user can enter some data to datagrid then after closes the window. Datagrid doesn't affect the dataset row.
I need to say "save data" to datagrid. How can I do this?
Thanks
|
|
|
|
|
Try to accept the changes in your datasource.
((DataSet)(myDataGrid.DataSource)).AcceptChanges();
or simply DataSet1.AcceptChanges();
Anfernius
|
|
|
|
|
It doesn't work.
Because data is in the datagrid. Datagrid has to send the data to dataset
Thanks for your interest.
|
|
|
|
|
All that does is mark the rows as unchanged so that if you passed the DataSet to DataAdapter.Update, no rows would be updated in your database (or other data store).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
This is just the way the DataGrid works (as well as other controls). The changes aren't commited until the control looses focus.
For a little bit more understanding, see the DataGridColumnStyle.Commit method documentation in the .NET Framework SDK.
If you want to force the text (or whatever) to be commited, then you could, for example, call DataGrid.EndEdit before your Form closing (like overriding the OnClosing method or handling the Closing event). See that method documentation in the .NET Framework SDK for more information.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
thanks. EndEdit works fine.
|
|
|
|
|
In the tree view if one node is clicked (when selected), can we change the background color of that perticular node?
pls guide
regards
|
|
|
|
|
You can change TreeNode.BackColor, if the node is clicked twice:
<br />
treeview_AfterSelect(...){
treeview.selectedNode.BackColor = SystemColors.Highlight;<br />
}<br />
<br />
treeview_Click(...){<br />
treeview.SelectedNode.BackColor = Color.Red;<br />
}<br />
|
|
|
|
|
This already happen by default. If you seem to be losing that background color when the TreeView doesn't have the focus, then set TreeView.HideSelection to false. The default is true.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanks your guidance.
Continuing the same topic; if I click nodes of the tree view, I want to add some runtime check boxes, radio buttons, numerical up down, combo box and text boxes that will be different for different nodes. For example, when I go to node 2 from node 1 I want to preserve the states of the controls corresponding to it so that when I again come back , I should get the earlier state. As I have more than 75 different controls and its not practical to have that much variables for each control. Is it OK if I use Hashtable in this situation or is there any other better way of dealing with such a situation.
moreover
How to select node of a TreeView Control by name in C#? i.e. is there any method that takes node name as a parameter and returns node?
please guide.
regards
|
|
|
|
|
Some of what you want to do is very difficult. The TreeView class encapsulates the Tree-View Windows Common Control, so everything comes down to sending messages, marshaling structs, and the like. Other things you want are impossible (like nodes having different check boxes, radio buttons, etc.
For that, look into a third-party control like UltraWinTree from Infragistics[^].
As far as selecting a node in C#, you should read through the documentation. It's really quite simple: set TreeView.SelectedNode to the TreeNode you want to select.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
oh !!
I am very sorry for the incomplete information, I did'nt mean to add controls to the tree view. I will divide the form in two parts, in the left half I will have tree view and in the right half i will add/remove at runtime according to the node that is selected. In this situation if corresponding to Node 1 if I add 3 check boxes in the right half of the form at runtime and check 2 of them, then I select Node 2, that will add a few controls check/uncheck them and go to some other node, I want to save the status of the corresponding controls such that when I come back to those nodes, I should know I did last time to them.
Shall I use Hash Table or resource file (as the total number of controls are above 70). I want to save the status even if I exit from the application, so that when I open it again I will get to know what I did last time.
please guide.
regards
|
|
|
|
|
We have an online mail application. What we want is to make this the default e-mail client so that if people right-mouse click a file in explorer and select send to mail receipt it will open up windows explorer and points to our mail address.
We read many acticles on the internet on how we have to change the registry settings from i.e. Outlook to Outlook Express which seems to work fine. But if we change the settings to our online application, nothing happens.
Our client can download a client application (written in C#) which automatically check whether e-mails arrives. We now want to give the client an option in this applicatoin to make the online mailsystem the default e-mail system.
Question: Is someone able to tell me whether I need to build a DLL for this (preferably in C# as all other code is written in C#) and how to get this to work as we don't seem to be able to figure this out?
Many thanks, Lieperik
|
|
|
|
|
The default mail client is typically a MAPI client. However, Windows XP and higher supports setting a web provider as the default. I'm not sure on the specifics (never cared to look) but you could browse the registry and look for information about the Hotmail provider, since Hotmail can be the default mail client on Windows XP. Maybe there's a small MAPI stub - I really don't know. At least digging through the registry entries you already know about after setting Hotmail as the default client might give you some insight.
As a potential user of your system (speaking hypothetically, of course), I deserve the right to set whatever I want as my default client. Forcing users to use something - unless your a domain admin or something - is a quick way to piss people off and loose them. You might look at how to register your web mail provider like Hotmail is and prompt them during installation to set you as the default mail provider.
[EDIT] Oh, this MAPI stub would have to be a native DLL that exports functions, though you could use this as a stub to a .NET assembly by exposing your components as CCW (COM-Callable Wrappers). [/EDIT]
In the worst case scenario, you will have to create a MAPI stub that basically interprets MAPI calls and forwards them to your web mail provider appropriately.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hello,
I have a Windows Service that needs to write to the event log. For security the service will not be running as system, but in an account that has less privileges so that it can't be forced to do things it shouldn't be doing.
The net result of this is that the EventLog no longer works. Can anyone point me in the right direction for creating and writing to an event log with less than administrator privileges. We are trying to trim the security back to the minimum required, and all it needs is to access a SQL Server and read and write files to specific directories.
Also, it will be installed on Win XP Pro and Server 2003 - If that makes any difference.
|
|
|
|
|
Create an acount with proper privilage , then in your service you can Impersonate() to that account. There is a sample code in MSDN for this method.
Mazy
"One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji
|
|
|
|
|
Thanks for your response.
I'd rather not have any accounts with Admin Privilege that the Windows Service uses. Also, assuming that this[^] is the sample you are refering to, I don't want passwords to be kept anywhere in the application or its config as that presents an additional security risk.
Is there any other solution?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
