Re: Save with date format - C# Discussion Boards

22-Feb-06 7:13

If you're asking how to automatically get scrollbars to some control, look at System.Windows.Forms.ScrollableControl. When some control added to a ScrollableControl extends beyond the visible portion of the ScrollableControl, scrollbars will automatically appear.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango

Save with date format

mostafa_h22-Feb-06 3:29

22-Feb-06 3:29

hi !
I want to save the value of date with the using DateTimePicker Control in a sql table with the date Format .

...<br />
try{<br />
strSQL ="update mytable set name='"+txtName.Text+  "',mydate='"+DateTimePicker1.???? ......

Any guid is very appereciated.
Regards

s_mostafa_h

-- modified at 9:30 Wednesday 22nd February, 2006

Judah Gabriel Himango22-Feb-06 4:03

22-Feb-06 4:03

string commandText = "UPDATE mytable SET name = @name, mydate = @date";
SqlCommand command = new SqlCommand(commandText, myConnection);
command.Parameters.Add(new SqlParameter("@name", txtName.Text));
command.Parameters.Add(new SqlParameter("@date", dateTimePicker1.Value));

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango

mostafa_h22-Feb-06 4:45

22-Feb-06 4:45

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

Judah Gabriel Himango22-Feb-06 4:48

22-Feb-06 4:48

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

mostafa_h22-Feb-06 6:24

22-Feb-06 6:24

thanks of your guide !
REGARDS ,

s_mostafa_h

Le centriste22-Feb-06 6:28

Le centriste

22-Feb-06 6:28

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

mostafa_h22-Feb-06 7:25

22-Feb-06 7:25

Michel Prévost wrote:
{DB618332-94FC-4171-BFCC-BA654F5EED58}

{DB618332-94FC-4171-BFCC-BA654F5EED58}
Any guide is very appreciated . Confused | :confused:

excuse me for my poor english .

s_mostafa_h

Le centriste22-Feb-06 7:26

Le centriste

22-Feb-06 7:26

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. Blush | :O

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

mostafa_h22-Feb-06 11:12

22-Feb-06 11:12

ofcourse , there are a lot of expression that i don't know the meaning it .
in any case , I'm always Smile | :)

. Now it's 01:44:50 o'clock (midnight).
Rose | [Rose]

s_mostafa_h

Threading

Areff22-Feb-06 3:27

22-Feb-06 3:27

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
---------------------

Judah Gabriel Himango22-Feb-06 3:57

22-Feb-06 3:57

Have a look at the C# threading programmer's reference[^].

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango

StyleGuide22-Feb-06 4:08

StyleGuide

22-Feb-06 4:08

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

StyleGuide22-Feb-06 4:09

StyleGuide

22-Feb-06 4:09

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

Areff22-Feb-06 23:04

22-Feb-06 23:04

Jonny, thank you for help Smile | :)

---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------

Search In File

Areff22-Feb-06 3:17

22-Feb-06 3:17

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
---------------------

Re: Search In File

J4amieC22-Feb-06 3:20

J4amieC

22-Feb-06 3:20

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?

Re: Search In File

Areff22-Feb-06 3:35

DownLoad A webpage with C#

22-Feb-06 3:35

		[Serializable()]<br />
		public struct Record<br />
		{<br />
			public string name;   // first name<br />
			public string Lname;   // last name<br />
			public int Id;   // student ID#<br />
			public int Lid;   // lesson ID#<br />
			public byte Grade; // lesson grade<br />
			public string Lsname;  // lesson name<br />
		}<br />
		<br />
		<br />
		// base load logic<br />
		public static Record Load(string Fname)<br />
		{<br />
			//open stream<br />
			Stream InStream = File.OpenRead(Fname);<br />
			BinaryFormatter DeSerializer = new BinaryFormatter();<br />
			<br />
// Here : while not End of file seek file to find my Struct(record)<br />
<br />
//  put serialized info to struct instance<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
---------------------

Areff22-Feb-06 3:07

22-Feb-06 3:07

Hi evry body
how i can download a web page from internet with a C# Application

---------------------
Areff Bahrami(KAVEH)
Areff.HB@Gmail.com
---------------------

J4amieC22-Feb-06 3:34

J4amieC

22-Feb-06 3:34

using the WebClient[^] class, amongst other ways.

Ravi Bhavnani22-Feb-06 7:12

Ravi Bhavnani

22-Feb-06 7:12

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

Somanova42022-Feb-06 8:20

Somanova420

22-Feb-06 8:20

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 Smile | :)

r.Close();

I didn't test it but it looks right.

Somanova42022-Feb-06 8:21

Somanova420

22-Feb-06 8:21

oh, and you are using System.Net;

Areff22-Feb-06 23:02