C#

<br />
namespace Val_Report<br />
{<br />
    public partial class Form1 : Form<br />
    {<br />
<br />
<br />
        public Form1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void Form1_Load(object sender, EventArgs e)<br />
        {<br />
            //Set up database and report path<br />
            ConfigureCrystalReports();<br />
            <br />
            //Set Report Dates Initially at first of month to current date<br />
<br />
            //Get first day of month<br />
            DateTime firstDay = DateTime.Now;<br />
            DateTime FirstDayInMonth = new DateTime(firstDay.Year, firstDay.Month, 1);<br />
            string strStartDate = FirstDayInMonth.ToShortDateString();<br />
            //Set the orderStartDate TimePicker to value<br />
            orderStartDate.Value = FirstDayInMonth;<br />
<br />
            //Get current date<br />
            string strEndDate = DateTime.Now.ToShortDateString();<br />
<br />
            //Set the orderEndDate TimePicker to value<br />
            orderEndDate.Value = DateTime.Now;<br />
<br />
            //Set up my report parameters (date, etc)<br />
            setReportParameters(strStartDate, strEndDate);<br />
        }<br />
<br />
        private void ConfigureCrystalReports()<br />
        {<br />
            //Set up sql connection<br />
            ConnectionInfo connectionInfo = new ConnectionInfo();<br />
            connectionInfo.ServerName = "xxx";<br />
            connectionInfo.DatabaseName = "xxx";<br />
            connectionInfo.UserID = "xxx";<br />
            connectionInfo.Password = "xxx";<br />
           <br />
            //Set report path<br />
            string reportPath = Application.StartupPath + "\\" + "CrystalReport1.rpt";<br />
            crystalReportViewer.ReportSource = reportPath;<br />
            <br />
            //Make sure we iterate through all the tables<br />
            SetDBLogonForReport(connectionInfo);<br />
<br />
        }<br />
<br />
        private void SetDBLogonForReport(ConnectionInfo connectionInfo)<br />
        {<br />
            TableLogOnInfos tableLogOnInfos = crystalReportViewer.LogOnInfo;<br />
            foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)<br />
            {<br />
                tableLogOnInfo.ConnectionInfo = connectionInfo;<br />
<br />
            }<br />
<br />
        }<br />
<br />
<br />
        private void crystalReportViewer_Load(object sender, EventArgs e)<br />
        {<br />
<br />
        }<br />
<br />
<br />
        private void setReportParameters(string strStartDate, string strEndDate)<br />
        {<br />
<br />
            // all the parameter fields will be added to this collection <br />
            ParameterFields paramFields = new ParameterFields();<br />
          <br />
            // the parameter fields to be sent to the report <br />
            ParameterField pfStartDate = new ParameterField();<br />
            ParameterField pfEndDate = new ParameterField();<br />
<br />
            // setting the name of parameter fields with wich they will be recieved in report <br />
<br />
            pfStartDate.ParameterFieldName = "StartDate";<br />
            pfEndDate.ParameterFieldName = "EndDate";<br />
<br />
            // the above declared parameter fields accept values as discrete objects <br />
            // so declaring discrete objects <br />
            ParameterDiscreteValue dcStartDate = new ParameterDiscreteValue();<br />
            ParameterDiscreteValue dcEndDate = new ParameterDiscreteValue();<br />
<br />
            // setting the values of discrete objects <br />
           <br />
            dcStartDate.Value = DateTime.Parse(strStartDate);<br />
            dcEndDate.Value = DateTime.Parse(strEndDate);<br />
<br />
            // now adding these discrete values to parameters  <br />
           <br />
            pfStartDate.CurrentValues.Add(dcStartDate);<br />
            pfEndDate.CurrentValues.Add(dcEndDate);<br />
<br />
            // now adding all these parameter fields to the parameter collection <br />
          <br />
            paramFields.Add(pfStartDate);<br />
            paramFields.Add(pfEndDate);<br />
<br />
            /* Set the modified parameters collection back to the viewer so that<br />
             the new parameter information can be used for the report. */<br />
            crystalReportViewer.ParameterFieldInfo = paramFields;<br />
        }<br />
<br />
        private void redisplay_Click_1(object sender, EventArgs e)<br />
        {<br />
<br />
           // ConfigureCrystalReports();<br />
            <br />
            string strStartDate = orderStartDate.Text;<br />
            string strEndDate = orderEndDate.Text;<br />
<br />
            string reportPath = Application.StartupPath + "\\" + "CrystalReport1.rpt";<br />
            crystalReportViewer.ReportSource = reportPath;<br />
<br />
            setReportParameters(strStartDate, strEndDate);<br />
        }<br />
<br />

FileStream fs = new FileStream(getDbPath(), FileMode.Open, FileAccess.Read, FileShare.Read))

class Example<t> where T : struct {
    T* p;
}</t>

DataTable dt = new DataTable("SomeTable");
string[] tokens;

dt.Columns.Add("ID",typeof(int));
dt.Columns.Add("Name",typeof(string));

StreamReader sr = new StreamReader("C:\\SomeFile.csv");

while (!sr.EndOfStream)
{
        tokens = sr.ReadLine().Split(',');
        if (tokens.Length == 2)
            dt.Rows.Add(tokens);

string strExpression = "ID = 1";
DataRow[] dr = dt.Select(strExpression); // <font color="#ee0000">--> Error: Cannot perform '=' operation on System.String and System.Int32.</font>
MessageBox.Show(dr[0].ToString());