how to get two textbox related values from sql table to crystal report in winform using c#?

then how to get this records in crystal report??

this idea i know but how to get searched records details between two dates in crystal report

thanks

Hi Fahad,


Try this...


using System.Data.OleDb;

string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
OleDbCommand com;
string str;
       
private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from employee where name='" + textBox1.Text.Trim() + "'";
            com = new OleDbCommand(str, con);

            OleDbDataReader reader = com.ExecuteReader();
            if (reader.Read())
            {
                textBox2.Text = reader["address"].ToString();
            }

            con.Close();
            reader.Close();
        }


Thanks