|
I found a number of articles regarding inserting into Databases but most of them I did not understand. I appologize if my question is too simple for you. No need to get nasty about it. Everybody needs to learn sometime...
But thank you for your inputs, I did manage to find the following though and got it to work:
SqlConnection conn = new SqlConnection(_connection);
SqlCommand cmd = new SqlCommand(_query, conn);
conn.Open();
object returnVal = cmd.ExecuteScalar();
conn.Close();
Regards
|
|
|
|
|
He didn't get nasty with you. He pointed out a basic fact that there are other things to learn about before you start with database issues. Believe me, you'd know if he'd got nasty.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
My apologies then for misunderstanding him.
Unfortunately I have to do the Database thing now, I have something that needs to be done in 2 weeks and is mostly db work and I have to learn it all in 2 weeks.
Thanks anyways
|
|
|
|
|
Is this a class, or paid work ?
Either way, you need to buy a book and get stuck into it. We can't really offer consistent help at the level that you're asking for it, it's just not possible.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
you have two text boxes
int x=int.parse(textbox1.text)
int y=int.parse(textbox2.text)
SqlConnection cn = new SqlConnection(//but here your connection string);
cn.Open();
cm = new SqlCommand("INSERT INTO teble_name VALUES(" + x + "," + y + " ) ", cn);
cm.ExecuteNonQuery();
and here you insert the record you want
If I HaD OnE sInglE wIsh IwIll gO back for thE fIrst tIme i sEE yOu
|
|
|
|
|
Islam9 wrote: int x=int.parse(textbox1.text)
int y=int.parse(textbox2.text)
SqlConnection cn = new SqlConnection(//but here your connection string);
cn.Open();
cm = new SqlCommand("INSERT INTO teble_name VALUES(" + x + "," + y + " ) ", cn);
cm.ExecuteNonQuery();
This has errors:
Parse has a capital P
Text has a capital T
Your insert statement is attempting to concatenate integers into a string.
Your insert statement is susceptable to a SQL Injection Attack. Please learn how to prevent them[^]
|
|
|
|
|
instead of telling me my errors
ihope ou tell us the right way to do the requier
thank you
If I HaD OnE sInglE wIsh IwIll gO back for thE fIrst tIme i sEE yOu
|
|
|
|
|
Islam9 wrote: instead of telling me my errors
ihope ou tell us the right way to do the requier
I did! I gave you a link to an article that tells you what you should be doing.
The other errors highlighted are sufficiently easy to correct I didn't think an explanation was necessary.
int x=int.parse(textbox1.text);
parse should be Parse
text should be Text
The other two errors can be corrected by reading, understanding and implementing the recommendations in the article that was linked: http://www.codeproject.com/cs/database/SqlInjectionAttacks.asp[^]
|
|
|
|
|
Hi
We are using Visual Studio 2005, C# and SQL Server 2005. We are developing a system that is a combination of some Windows Application modules and a Web application (intranet). We have a number of maintenance processes that we would like to schedule to run automatically a few times a day. What is good way of handling scheduling in this type of scenario?
Second questions is whether we could create Web Services to handle these maintenance processes and schedule the system to consume the web services at regular intervals.
Any advice will be appreciated.
Thanks
Kobus
|
|
|
|
|
Your second question answers for the first. That is a good method of creating webservice to handle schedule process. You need to create a windows application too, which request to the webservice frequently.
|
|
|
|
|
For First Question:
Yes we can execute maintenance processes that we would like to schedule to run automatically a few times a day. in sql server by providing a mechanism
SQL SERVER INTEGRATED SERVICE(DTS).
On which you do every code script on the FLY.
Thanks & Regards
Tarini Singh
Sr. Software Engineer. (IT)
tksingh@zentagroup.com
|
|
|
|
|
For First Question:
Yes we can execute maintenance processes that we would like to schedule to run automatically a few times a day. in sql server by providing a mechanism
SQL SERVER INTEGRATED SERVICE(DTS).
On which you do every code script on the FLY.
Thanks & Regards
Tarini Singh
Sr. Software Engineer. (IT)
tksingh@zentagroup.com
|
|
|
|
|
Start|Programs|Accessories|System Tools|Scheduled Tasks
|
|
|
|
|
Hello there,
I have a bunch of tables that must be created in oracle while installing my c# application, any idea how to make that happen?? currently I'm saving my tables ddl statements in a .sql file.
Many thanks![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Can you execute a query against an Oracle database from C# code? I guess you must be doing it in you app. Can't you execute the CREATE TABLE statements the same way?
|
|
|
|
|
Thank you chopeen
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
1. I had to put my DDL statements in a text document.
2. Make sure your statements are followed by /
3. Save it to YourScriptFile.sql
4. Create a batch file in which you are calling sqlplus YourScriptFile.sql
5. In your windows form, call that batch file using a process.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hi
I need to create a temporary unique id on a offline computer.
The item will get a unique id (in our server, not worldwide!) when it connects to the server. But how do i ensure that a temporary id is unique until i get access to the server?
The only decent solution i have come up with is to use DateTime.Now.Ticks. But that could go fubar if the clock is changed.
Is that another better way to do it?
The id doesn't have to be globaly unique, just unique for the active computer.
"Life would be alot easier if i only had the sourcecode!"
|
|
|
|
|
Why don't you use Guid.NewGuid()?
I know you don't really need GUID, but it won't hurt, will it?
|
|
|
|
|
Use a Guid. It is designed for this purpose. Sure it is globally unique, but creating an ID that is only locally unique is more complex so why bother.
|
|
|
|
|
Thanks for the help!
A guid is abit long but as you say it's to much of a bother to come up with another solution
|
|
|
|
|
Hi friends
I wrote a program that create a thread to listen a port in network. but in my thread I can't change my windows form element like lable.  What is the problem? 
|
|
|
|
|
Hello,
If you want to change the GUI from an other thread, you have to use Invoke[^] and InvokeRequired[^]!
All the best,
Martin
|
|
|
|
|
The problem is that form elements can only be manipulated from the thread that is running the UI. There is a method called Invoke on the form that you must use to do this from another thread. The docs for this method contain a reasonable example.
|
|
|
|
|
Another way to avoid using invoking and delegates...is to set the
CheckForIllegalCrossThreadCalls property to false, although it's better to use invoking
Do your best to be the best
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
