C#

Billah wrote:

I want a popup notepad which will retrieve data from database.

Eliee wrote:

but unfortunately nobody happened to know the answer

Eliee wrote:

Well a set could be intstantialized and taken to be as an array of values.. so take it as in this perspective.. The sub values are the elements of an array..

Eliee wrote:

What is required is to look in S and to find the greatest value (s) and directly return it with a speed algorithm of O(n)..

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