Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data;
- using System.Data.OracleClient;
- public partial class _Default : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void Button1_Click(object sender, EventArgs e)
- {
- String mycon = "DATA SOURCE=mydatasource/example;USER
- ID=user;Password=mypassword;Unicode=True";
- String myquery = "Select * From DF_FORM_COMP_VALUE Where VALUE_STR =" +
- TextBox1.Text;
- OracleConnection con = new OracleConnection(mycon);
- OracleCommand cmd = new OracleCommand();
- cmd.CommandText = myquery;
- cmd.Connection = con;
- OracleDataAdapter da = new OracleDataAdapter();
- da.SelectCommand = cmd;
- DataSet ds = new DataSet();
- da.Fill(ds);
- if (ds.Tables[0].Rows.Count > 0)
- {
- Label1.Text = "Particular ID found successfully";
- Label2.Text = ds.Tables[0].Rows[0]["ID_TRANSACTION"].ToString();
- Label3.Text = ds.Tables[0].Rows[0]["ID_FORM_COMPONENT"].ToString();
- Label4.Text = ds.Tables[0].Rows[0]["ID"].ToString();
- }
- else
- {
- Label1.Text = "ID Not Found - Please Serach Again";
- Label2.Text = "";
- Label3.Text = "";
- Label4.Text = "";
- }
- con.Close();
- }
- protected void TextBox1_TextChanged(object sender, EventArgs e)
- {
- }
- }
Add Comment
Please, Sign In to add comment