|
Ok, but how do I get this done?
I had lots of troubles working with access database and the dataset wizard to store querys (http://forums.microsoft.com/MSDN/showpost.aspx?postid=1121807&siteid=1), so I opted to run my queries with code.
I used one method with the Insert command, and if the result set is higher than 0, I call another method with a Scalar Command, to search for the ID. Then, with the retrieved ID, i call the third method to Insert the record ID on the second table....
The code described below worked well, everyonce in a while (no clue yet why sometimes i'm able to get the ID and sometimes I get 0, probably something going on with the query). So that's why I want a safer way to get this done.
I searched a little bit for "select @@identity" (http://support.microsoft.com/kb/816112), and I found out that it behaves as a Scalar command as well. So in theory, i should just change my query string to get it done.
It doesnt work at all. Does the "select @@identity" statement work only when you handle it on a OleDbDataAdapter.RowUpdated Event?
Thanks for the help!
<br />
<br />
string file = "......";<br />
<br />
private void InsertAudio()<br />
<pre>
<small>
{
OleDbCommand cmd = new OleDbCommand(sql, conexion);
int resultSet;
try
{
conexion.Open();
resultSet = cmd.ExecuteNonQuery();
if (resultSet > 0) SearchIDofCreatedRow();
}
catch (OleDbException ode)
{
MessageBox.Show(ode.ToString(), "Error de Conexion con base de datos");
}
finally {conexion.Close();}
}
</small>
</pre><br />
<br />
<br />
private void SearchIDofCreatedRow()<br />
<pre>
<small>
{
OleDbCommand cmd = new OleDbCommand("SELECT ID FROM audios WHERE file='" + file + "'", conexion);
try
{
conexion.Open();
int ID = Convert.ToInt32(cmd.ExecuteScalar());
AddCategoryList(ID);
}
}
</small>
</pre><br />
<br />
private void AddCategoryList(int ID)<br />
<pre>
<small>
{
}
</small>
</pre> <br />
<br />
daniel sovino
|
|
|
|
|
The @@identity variable is local to the database session, and if you create another connection you get a new database session. You have to get the id using the same database connection that you used to insert the record.
Why do you create a new connection in SearchIDofCreatedRow? When you call it you already have an open connection, pass that along in the call.
---
Year happy = new Year(2007);
|
|
|
|
|
hi all,
I have do a research how can i pass parameter in MouseEventHandler,but i can't get any answer on it.What i am trying to do is :
When double click on certain user control(my own user control) ,then will implement some action,as below:
trending1.MouseDoubleClick += new MouseEventHandler(enLargeChart1);<br />
.....<br />
private void enLargeChart1(object sender, EventArgs e){}
Now,i would like to pass the selected control name (or anything can indicate what is the control) to enLargeChart1() when i double clike on that control.
Can somebody guide me to solve it out?
Thanks in advance
cocoonwls
|
|
|
|
|
the sender parameter indicates which control was clicked,
so you could use ((Button)sender).Name or something similar to identify it.
Luc Pattyn
|
|
|
|
|
Hi, Luc Pattyn
Thank you very much!!!It work for me
cocoonwls
|
|
|
|
|
I Want Append 10000 row data in DataGridView.But,the speed of display is lower.In others windows control (ex. listview,listbox) have BeginUpdate and EndUpdate method.
I want to write a method like BeginUpdate that Prevents the control from drawing until the EndUpdate method is called.
|
|
|
|
|
how to write the method like BeginUpdate.
|
|
|
|
|
What is the easier way to write a program to run a method and while that methods is being performing to run another method. Is this possible to do?
|
|
|
|
|
Eddymvp wrote: Is this possible to do?
Yes. See the Thread class and examples of Thread.Start().
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|
|
hi all,
i ve a small question how is the following problem posible
Hashtable MyTable = new Hashtable();
MyObject myo = new MyObject()
MyTable.Add(1,myo);
How is the following posible
MyTable[1].FunctionFromMyObject();
greetings gigo
|
|
|
|
|
gigo2k6 wrote: i ve a small question how is the following problem posible
Are you asking how a hashtable works?
Or do you mean:
gigo2k6 wrote: How is the following posible
MyTable[1].FunctionFromMyObject();
MyObject mo2=(MyObject)MyTable[1];
mo2.SomeFunction();
BTW, look up generics, so you can avoid the cast back to MyObject.
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|
|
hi this was not what i want.
but the following works fine
((IP_cam)_Cams[1]).SomeFunction();
|
|
|
|
|
gigo2k6 wrote: this was not what i want.
Yes, it is. All you've done is turn it into one statement.
And, like Marc said, if you're in .NET 2.0. you should use the generic containers.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Man, you must have real patience to answer some of the questions (and their follow-ups) in this forum.
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|
|
*grin* the questions that could be regarded as frustrating, I prefer to regard as amusing.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian Graus wrote: the questions that could be regarded as frustrating, I prefer to regard as amusing.
Now there's a great attitude! One that I need to adopt more.
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|
|
By casting the return value to the correct type. If you're using .NET 2.0, you should use the specialised dictionary instead, which will return the right type to you.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
By casting the object to it's specific class:
((MyObject)MyTable[1]).FunctionFromMyObject();
---
Year happy = new Year(2007);
|
|
|
|
|
My current project requires that I build a Java project along side some C# projects using Nant. Is this possible? I am completely new to Nant, but didn't see anything about javac in the task list available.
Any help would be appreciated, and an example would be great
Thanks much.
|
|
|
|
|
NAnt is a port of Ant, which runs on Java. I doubt they talk to each other, but perhaps you can use Ant for the Java portion ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks Christian,
Sadly, the build team here at work insists on only using NAnt, and the program had to be in Java because of a legacy issue... so, we'll see where we go from here.
Keith
|
|
|
|
|
Hi all,
i want to call a sub form, but i really dont knwo how to achieve that.
I mean that when i start new project in C#.net, now with in the main form i want to drag few buttons and now when i click each buttons new form comes up with in that form....its like a parent and child form within same form with just a button click....
I hope i was not that confusing....
Pls help me out in this....
Thanks
|
|
|
|
|
Software_Specialist wrote: and now when i click each buttons new form comes up with in that form
Form newForm=new MyButtonActivatedForm();
newForm.ShowDialog();
[edit]Oh, you want the new stuff to be in the same form? Create a Panel in the form, put your controls in the panel and hide the panel. When the user clicks on a button, show the panel.[/edit]
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|
|
yeh i want that on the same form...
but i am bit confused here,
1.) ok i dragged the panel
2.) now with in that panel i can add whatever functionality i want in the sub form..
3.) now i add button in the main form outside the panel...
4.) and i hv to call the panel with that button press....
is that right wt i said above or i am taking it wrong way. also can you tell me what exact code should i write to call panel...
thanks for reply...
|
|
|
|
|
Software_Specialist wrote: is that right
Sounds about right. If your panel is called "panel1", then panel1.Hide() hides the panel, and your button click would call panel1.Show()
Marc
Thyme In The CountryPeople are just notoriously impossible. --DavidCrow There's NO excuse for not commenting your code. -- John Simmons / outlaw programmer People who say that they will refactor their code later to make it "good" don't understand refactoring, nor the art and craft of programming. -- Josh Smith
|
|
|
|