|
I Wrote this :
try{<br />
strSQL ="update mytable set name='"+txtName.Text+ "',mydate='"+DateTimePicker1.Value+"'";<br />
cnSQL = new SqlConnection(Connectionstring);<br />
cnSQL.Open();<br />
cmSQL = new SqlCommand(strSQL, cnSQL);<br />
cmSQL.ExecuteNonQuery();<br />
cnSQL.Close();<br />
cmSQL.Dispose();<br />
cnSQL.Dispose();<br />
} <br />
catch(SqlException e)<br />
{<br />
MessageBox.Show(e.Message, "Error");<br />
} But I have this Error :
syntax error converting datetime from character string
the type of mydate field is datetime .
please guide me !
thanks
s_mostafa_h
|
|
|
|
|
mostafa_h wrote: strSQL ="update mytable set name='"+txtName.Text+ "',mydate='"+DateTimePicker1.Value+"'";
Don't do that. You're opening yourself up to SQL injection attacks[^]. I showed you the proper way to do it in my last reply (by using SqlParameter objects). If you follow that course of action, you won't get the error.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango
|
|
|
|
|
thanks of your guide !
REGARDS ,
s_mostafa_h
|
|
|
|
|
mostafa_h wrote: Any guid is very appereciated
{DB618332-94FC-4171-BFCC-BA654F5EED58}
--------
"I say no to drugs, but they don't listen."
- Marilyn Manson
|
|
|
|
|
Michel Prévost wrote: {DB618332-94FC-4171-BFCC-BA654F5EED58}
{DB618332-94FC-4171-BFCC-BA654F5EED58}
Any guide is very appreciated .
excuse me for my poor english .
s_mostafa_h
|
|
|
|
|
No problem, english is not my first language either. I just hope you are not angry at me, I couldn't resist doing the joke.
I guess you know what a GUID is...
--------
"I say no to drugs, but they don't listen."
- Marilyn Manson
-- modified at 13:26 Wednesday 22nd February, 2006
|
|
|
|
|
ofcourse , there are a lot of expression that i don't know the meaning it .
in any case , I'm always . Now it's 01:44:50 o'clock (midnight).
s_mostafa_h
|
|
|
|
|
Hi evry body
How I can Use Thread In my program to run a Methode Continual with a littel Sleep.?
Do Methode needs to delegate for using in Threading?
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
|
Areff,
If its a windows app use the backgroundWorker control, alternatively :
Using System.Threading;
Thread myThread = new Thread(new ThreadStart(myMethod));
Thread.Sleep(1000); //Sleep for 1 second
HTH
Jonny
|
|
|
|
|
Areff,
If its a windows app use the backgroundWorker control, alternatively heres a code snippet :
--
Using System.Threading;
Thread myThread = new Thread(new ThreadStart(myMethod));
Thread.Sleep(1000); //Sleep for 1 second
--
HTH
Jonny
Jonny
|
|
|
|
|
Jonny, thank you for help
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
Hi Evry body.
I want to Search a Struct in file .
for this problem i use a while loop and Seek Statment but i have a problem with Seek Origin ?
I want Information about Seek and Origin Please
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
What particular information about them do you want, that the documentation does not tell you?
Or, how about some code to show us where you are having problems in understanding how to use Seek on a stream?
|
|
|
|
|
[Serializable()]<br />
public struct Record<br />
{<br />
public string name;
public string Lname;
public int Id;
public int Lid;
public byte Grade;
public string Lsname;
}<br />
<br />
<br />
public static Record Load(string Fname)<br />
{<br />
Stream InStream = File.OpenRead(Fname);<br />
BinaryFormatter DeSerializer = new BinaryFormatter();<br />
<br />
<br />
Record LoadClass = (Record)(DeSerializer.Deserialize(InStream));<br />
InStream.Close();<br />
return LoadClass;<br />
}
I want search in file to find a special struct(record)
I hope you understand me.
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
Hi evry body
how i can download a web page from internet with a C# Application
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
|
Perhaps this[^] article will help? If you also want to parse the downloaded content, see this[^] article.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
string URL = "http://www.somepagegoeshere.com"; //the url
HttpWebRequest PageRequest = (HttpWebRequest)WebRequest.Ceate(URL); //some fun web stuff
WebResponse PageResponse = PageRequest.GetResponse();
StreamReader r = new StreamReader(PageResponse.GetResponseStream()); //here we go
string theDownloadedPage = r.ReadToEnd(); //and it's downloaded
r.Close();
I didn't test it but it looks right.
|
|
|
|
|
oh, and you are using System.Net;
|
|
|
|
|
Thank Guys for your help...
---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------
|
|
|
|
|
hai i want to check whether the given id exists in the data base ,if exists it should proceed if not it should give error message.its a window based c# application.iam using comand reader but its giving error.
|
|
|
|
|
Can we get the Edit,Delete,Add buttons in the grid of the windows application?
I mean, as soon as i am clicking on any of the buttons, it is getting redirected to another form.
But, I want the actions to be performed in the same grid.
If it is possible please send solution for my problem.
|
|
|
|
|
Hi.
i need to close an application if there is no user activity on it for an amount of time. (loop through the open applications and close the ones with no user activity)
I can do it with:
- a global variable in wich to put the time of the last keypress or mose move
- timer that checks to see if there are any new applications or that the open ones closed in the mean time, and to see if the difference between now and the last user access is greater than the configured value.
it looks simple, but I have a problem:
- how to get the last user input on a form FROM ANOTHER APPLICATION
Thanks in advance.
|
|
|
|
|
Hi
I wrote a web service in C#. Now I want to install it on another PC. How do I do that?
Here is what I have done:
a) From my development PC, I copied the WS folder to the other PC.
b) Went into Internet Information Services and created new a new Virtual directory that points to that folder.
Problem is I can't get the web service to work. When I open my internet exploer and browse to http://localhost/MyWebService/Item.asmx, I get just <%@ WebService Language="c#" Codebehind="Item.asmx.cs" Class="Retalix.StoreLine.WS.Item" %>
Thank you.
|
|
|
|