C#

Eliee wrote:

so pay attention to efficiency

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Goof around music jam with my brothers (with video)
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

private void btnBrowse_Click(object sender, System.EventArgs e)<br />
		{<br />
			OpenFileDialog ofd = new OpenFileDialog( ) ;<br />
			ofd.Filter = "Image files |*.jpg" ;<br />
			if ( ofd.ShowDialog( ) == DialogResult.OK ) <br />
			{	<br />
				txtPath.Text = ofd.FileName ; <br />
				try<br />
				{<br />
					FileStream f = new FileStream ( txtPath.Text, FileMode.Open ) ;<br />
					byte[ ] buff = new byte [ f.Length ] ;<br />
					f.Read ( buff, 0, ( int ) f.Length ) ;<br />
					MemoryStream ms= new MemoryStream(buff,0,buff.Length);<br />
					Image i = Image.FromStream ( ms ) ;<br />
					img.Image = i ; <br />
					f.Close();<br />
				}<br />
				catch(Exception ee) <br />
				{ <br />
					MessageBox.Show("An error has occured.\n" + ee.Message); <br />
				} <br />
			}<br />
		}<br />

<br />
string dbcon = "data source=ServerName;database=dbName;user id=sa;password=";<br />
		private void linklblInsertPicture_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)<br />
		{<br />
			FileStream st = new FileStream ( txtPath.Text, FileMode.Open ) ;<br />
			byte[ ] buff = new byte [ st.Length ] ;<br />
			st.Read ( buff, 0, ( int ) st.Length ) ;<br />
<br />
			try<br />
			{				<br />
				using(SqlConnection conn = new SqlConnection())<br />
				{	<br />
					conn.ConnectionString = dbcon;<br />
					conn.Open();<br />
					SqlCommand cmd = new SqlCommand();<br />
					cmd.Connection = conn;<br />
					cmd.CommandText = "insert into tableName(imageName) values(@pict)";<br />
					cmd.Connection = conn;<br />
					cmd.CommandType = CommandType.Text;<br />
					cmd.Parameters.Add("@pict",buff);<br />
					cmd.ExecuteNonQuery();<br />
				}<br />
			}<br />
			catch(SqlException sqle)<br />
			{<br />
				Console.WriteLine(sqle.Message);<br />
			}<br />
			st.Close();<br />
		}<br />
<br />
		private void linklblShowPicture_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)<br />
		{<br />
			try<br />
			{<br />
				using(SqlConnection conn = new SqlConnection())<br />
				{<br />
					conn.ConnectionString = dbcon;<br />
					conn.Open();<br />
					SqlCommand cmd = new SqlCommand();<br />
					cmd.Connection = conn;<br />
					cmd.CommandText = "select imageName from tableName where .... ";<br />
\\here u can use track id in datatabel to select, update or delete image<br />
					cmd.Connection = conn;<br />
					cmd.CommandType = CommandType.Text;<br />
					<br />
					SqlDataReader r = cmd.ExecuteReader();<br />
					if(r.Read())<br />
					{<br />
						byte[ ] b = ( byte[ ] ) r [ 0 ] ;<br />
						MemoryStream st = new MemoryStream( ) ;<br />
						st.Write ( b, 0, b.Length ) ;<br />
						Image i = Image.FromStream ( st ) ;<br />
						img.Image = i ; <br />
					}<br />
				}<br />
			}<br />
			catch(SqlException sqle)<br />
			{<br />
				Console.WriteLine(sqle.Message);<br />
			}<br />
		}	

Judah Himango wrote:

The throw keyword can only be used within a catch block. Throw will simply throw the exception that was caught within the catch block.

if (!File.Exists("test.txt")) {
   throw new FileIOException("File was not found");
}
else {
   ....
}

Graham N wrote:

Sorry to correct you, but throw can also be used outside of a catch block.

try
{
}
catch
{
   throw;
}

JelleM wrote:

So the data is EXACTLY the same (as far as I know).

JelleM wrote:

But the thing is I don't see the milliseconds (if I show the results in the database), so they must be hidden in some way or another.

JelleM wrote:

But can't I use some sort of * to add to the truncated date, so the query doesn't look at the milliseconds or something like that?