getting invalid identifer error when fetching the data from

Question

OracleConnection conn = new OracleConnection(oradb);

OracleCommand cmd = new OracleCommand();

conn.Open();

cmd.Connection = conn;

cmd.CommandType = CommandType.Text;

cmd.BindByName = true;

//cmd.Parameters.Add(new OracleParameter("BranchID",BranchId));

OracleParameter transdate1= new OracleParameter();

transdate1.OracleDbType = OracleDbType.Date;

transdate1.Value = TextBox1.Text;

cmd.Parameters.Add(transdate1);

OracleParameter transdate2 = new OracleParameter();

transdate2.OracleDbType = OracleDbType.Date;

transdate2.Value = TextBox2.Text;

cmd.Parameters.Add(transdate2);

cmd.CommandText = "select * from cust_details where transdate between transdate1 and transdate2";

OracleDataAdapter od = new OracleDataAdapter(cmd);

DataSet ds = new DataSet();

od.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

//Response.Write("Connected to Oracle" + conn.ServerVersion);

// Close and Dispose OracleConnection object

lblDisplay.Text = "connected";

conn.Close();

conn.Dispose();

Answer 1

You can use regular expression to get the file name. Here is an example: https://dotnetfiddle.net/DdzA3c

 

using System;
using System.Text.RegularExpressions;

public class Program
{
    public static void Main()
    {
        string file = @"C:\Users\xyz\Desktop\FYP\Animal\abc.jpg";
        string pattern  = @"[ \w-]+?(?=\.)";

        Regex regex = new Regex(pattern);

        Match match = regex.Match(file);

        Console.WriteLine(match.Value);
    }
}

Answer 2

Hi,

 

Refer This Code

 

private void timer1_Tick(object sender, EventArgs e)

{

counter++;

try // Get the tif file from C:\image\ folder

{

string path = @"C:\image\";

String filename = Directory.EnumerateFiles(path, "*.png").FirstOrDefault();

if (null != filename) {

// Load picture

pictureBox1.Load(filename);

// Show the file name

lblFile.Text = filename;

}

else {

//TODO: No *.png files are found

}

}

catch(IOException ex)

{

MessageBox.Show("No files or " + ex.Message);

}

}

 

Answer 3

and your question is?