Database

<code>
 Imports System
 Imports System.Data.OracleClient

 Public Class Driver
   Public Shared Sub Main()
     Dim conn as New OracleConnection
     conn.ConnectionString = "Data Source=[DBName]; User Id=[User Id]; Password=[Password]"

     Dim cmd as New OracleCommand
     cmd.CommandText = "SELECT * FROM USERS WHERE USER_ID = '[USER_ID]'"
     cmd.Connection = conn
     cmd.CommandType = CommandType.Text

     Try
       Dim odr as OracleReader
       odr = cmd.ExecuteReader()
     Catch ex As Exception
       Console.Writeline( ex.Message )
     End
   End Sub
 End Class </code>

<code> cmd.CommandText = "SELECT * FROM USERS WHERE USER_ID = '[USER_ID]'" </code>

<code>
 cmd.CommandText = "SELECT * FROM USERS WHERE USER_ID = :pUserId"
 cmd.Parameters.Add( new OracleParameter( ":pUserId", OracleType.VarChar )).Value = "[USER_ID]" ) </code>

private void btnOpen_Click(object sender, System.EventArgs e)<br />
{<br />
  try<br />
	{<br />
	       Stream myStream;<br />
	       OpenFileDialog openFileDialog1 = new OpenFileDialog();<br />
	        // set up file dialog properties<br />
		openFileDialog1.InitialDirectory = "E:\\" ;<br />
		openFileDialog1.Filter = "txt files (*.txt)|*.txt|Allfiles(*.*)|*.*" ;<br />
		openFileDialog1.FilterIndex = 2 ;<br />
		openFileDialog1.RestoreDirectory = true ;<br />
		openFileDialog1.Multiselect = true;<br />
<br />
		if(openFileDialog1.ShowDialog() == DialogResult.OK)<br />
			{<br />
				if((myStream = openFileDialog1.OpenFile())!= null)<br />
				{<br />
					// Insert code to read the stream here.<br />
		//					string strFileName = openFileDialog1.FileName;<br />
				DataSet ds = new DataSet();<br />
<br />
						foreach (string strFileName in openFileDialog1.FileNames)<br />
						{<br />
			<br />
							string connStr = <br />
								@"Driver={Microsoft Excel Driver (*.xls)};DBQ=" + strFileName;<br />
							<br />
							string sql = "SELECT * FROM [Sheet1$]";<br />
							OdbcDataAdapter adapter = new OdbcDataAdapter(sql,connStr);<br />
							adapter.Fill(ds,"[Sheet1$]");<br />
							<br />
						}<br />
						gridPorocila.DataMember = "[Sheet1$]";<br />
						gridPorocila.DataSource = ds.DefaultViewManager;<br />
<br />
						myStream.Close();<br />
					}<br />
				}<br />
				<br />
			}<br />
			catch (Exception ex)<br />
			{<br />
				MessageBox.Show(ex.Message.ToString());<br />
			}<br />
<br />
		}