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

Question

hi how to get two texbox related values from sql table to crystal report in winform using c# language am having two text box and one button please suggest me.. thank u

fahad sheikhji · Answer

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

Satyapriya Nayak · Answer

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