C#

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

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

mostafa_h wrote:

strSQL ="update mytable set name='"+txtName.Text+ "',mydate='"+DateTimePicker1.Value+"'";

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

mostafa_h wrote:

Any guid is very appereciated

Michel Prévost wrote:

{DB618332-94FC-4171-BFCC-BA654F5EED58}

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

		[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 />
		}