|
Member 4124915 wrote: Can you give me an idea for creating this.
Yes, ask it here[^]
While (true) { Human.isLearnable = true; }
|
|
|
|
|
I understand you can't just set the database to '' or null, but how can you do this when you dynamically generate the sql? Here is a example which I know does not work
SqlDateTime sqldatenull;<br />
<br />
if (tmpDate == "")<br />
tmpDate = sqldatenull;<br />
<br />
sqlQuery = "INSERT INTO Event (";<br />
sqlQuery += "Event_ID";<br />
sqlQuery += ", Event_Date";<br />
sqlQuery += ") VALUES (";<br />
sqlQuery += "'" + tmpID + "'";<br />
sqlQuery += ", '" + tmpDate + "')";
|
|
|
|
|
1st) Write your query this way:
sqlQuery = string.Format("INSERT INTO Event (Event_ID, Event_Date) VALUES ('{0}', '{1}')", tmpID, tmpDate);
2nd) Use System.Data.SqlTypes.SqlDateTime.Null;
While (true) { Human.isLearnable = true; }
|
|
|
|
|
Just don't insert the value...
sqlQuery = "INSERT INTO Event (";
sqlQuery += "Event_ID";
sqlQuery += ") VALUES (";
sqlQuery += "'" + tmpID + "'";
sqlQuery += ")";
Also, it would be neat to use a StringBuilder..
|
|
|
|
|
Why are you generating this SQL? This is a really, really, really bad idea. I can't stress enough, how bad this idea really is. By doing this, you've left your database open to SQL Injection Attacks.
|
|
|
|
|
Can you give me a example of the best way to stop sql injections? I am using SQL Server 2005 (Express) which the best option would be to use Stored Procedures?
|
|
|
|
|
Please read this[^] article.
|
|
|
|
|
Hi,
I have created a Webpage, and on the click of a certain link i want to run a unicast stream from VLC giving an output of RTSP.
Please help.
Regards
|
|
|
|
|
Head off to the ASP.NET forum.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - coming soon ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
In my C# editor space and Tab are filled by dots. How can I change this?
Can any one help me?
thanks to all.
|
|
|
|
|
Use Ctrl + R, Ctrl + W
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
|
Cool. I never knew this. Wonder what the point of it is 
Simon
|
|
|
|
|
It might help to get lines aligned. I have never used it though.
"If you had to identify, in one word, the reason why the human race has not achieved, and never will achieve, its full potential, that word would be 'meetings'." - Dave Barry
|
|
|
|
|
Go to the 'Edit' menu, select 'Advanced' and then 'View white space'. This enables and disables the dots.
|
|
|
|
|
Hi all,
I have created one windows services in C#. In OnStart method i want to start external exe at particular given time by user.
For that i need to keep comparing time of system and user given time.
But OnStart method calls only one time when starting that service.
Is there any other event or methods which will call continuosly when service in Started condition.
I feel happy when will get alternative solution for the problem.
Thanks guys......
|
|
|
|
|
Create a global Timer instance like System.Timers.Timer or System.Threading.Timer in your service class that you enable and start in your OnStart() event. Then every time the timer event fires you can perform your logic you need to. And you can set it to fire as often as you like.
Hope this helps.
|
|
|
|
|
Hi,
You could place a timer control on your service and do your programming logic in timer elapse event. Set the timer elapse time say 10 seconds or what ever you want and launch your exe.
cheers
|
|
|
|
|
Use a BackgroundWorker object. Timers are okay, but they send the lowest priority message Windows has, and it's not guaranteed to be handled in a busy system. So, to avoid the issue, use a BackgroundWorker.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Hi All,
I have developed a formbased application.
In which I need to use another dll which contains some callback.
For using the callback inside the DLL from C# application what should be done??
In dll there is a struct which stores the callback pointers and one function uses to register this callback.
Please help
Regards
San
|
|
|
|
|
Have you tried the obvious, i.e. registering a callback method and then calling the method?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
hi guys! what's up
here is my question..
hi!! i made an application and i want to save into my databae the datas from some textboxes. when i click the save button the datas are being normally or at least that's what i thought...
sometimes tha datas are being displayed sometimes not. for example, i run visual studio 2008 c# at 8 pm. and i can see the datas which i inserted before, i close studio,,, after a while i run again studiio and tha datas have gone....
the code is correct..
Please help me guys, i really need your help.
sorry for my english
|
|
|
|
|
Can we get some sample code so we can try to help?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
sakis24 wrote: the code is correct..
Obviously its not.
From the very poor information you have supplied its impossible to say what is wrong. Do you get any errors when you save your data, do you reload it when your application starts? There are just so many things that could be wrong.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
here is the comands
private void InitializeCommands()
{
//INSERT
dataAdapter.InsertCommand = conn.CreateCommand();
dataAdapter.InsertCommand.CommandText =
"SET IDENTITY_INSERT Producer ON insert into Producer(Pid,AFM,LastName,FirstName,City,ZipCode,Adress) values(@Pid,@AFM,@LastName,@FirstName,@City,@ZipCode,@Adress)";
AddParams(dataAdapter.InsertCommand, "Pid", "AFM", "LastName", "FirstName", "City", "ZipCode", "Adress");
//UPDATE
dataAdapter.UpdateCommand = conn.CreateCommand();
dataAdapter.UpdateCommand.CommandText =
"update Producer set AFM=@AFM, LastName=@LastName, FirstName=@FirstName, City=@City, ZipCode=@ZipCode, Adress=@Adress where Pid=@Pid ";
AddParams(dataAdapter.UpdateCommand, "Pid", "AFM", "LastName", "FirstName", "City", "ZipCode", "Adress");
//DELETE
dataAdapter.DeleteCommand = conn.CreateCommand();
dataAdapter.DeleteCommand.CommandText =
"delete from Producer where Pid = @Pid";
AddParams(dataAdapter.DeleteCommand, "Pid");
}
the add paremateres method
private void AddParams(SqlCommand cmd, params string[] cols)
{
foreach (string col in cols)
{
cmd.Parameters.Add("@" + col, SqlDbType.NVarChar, 0, col);
}
}
the insert button
private void btnAdd_Click(object sender, EventArgs e)
{
insertRec = true;
DataRow row = dt.NewRow();
dt.Rows.Add(row);
//MessageBox.Show(totalRec.ToString());
totalRec = dt.Rows.Count;
curRec = totalRec-1;
row["Pid"] = totalRec;
txtpid.Text = totalRec.ToString();
txtAFM.Text = "";
txtln.Text = "";
txtfn.Text = "";
txtCity.Text = "";
txtZip.Text = "";
txtAdr.Text = "";
btnSave.Enabled = true;
}
and the save button
private void btnSave_Click_1(object sender, EventArgs e)
{
DataRow row = dt.Rows[curRec];
//MessageBox.Show(totalRec.ToString());
//MessageBox.Show(curRec.ToString());
row.BeginEdit();
row["Pid"] = txtpid.Text;
row["AFM"] = txtAFM.Text;
row["LastName"] = txtln.Text;
row["FirstName"] = txtfn.Text;
row["City"] = txtCity.Text;
row["ZipCode"] = txtZip.Text;
row["Adress"] = txtAdr.Text;
row.EndEdit();
dataAdapter.Update(ds, "buffer");
ds.AcceptChanges();
CreateDir();
ToggleControls(true);
insertRec = !true;
}
i havevreated the dataset,dataadapter, the conection string and the datatable of course
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
