C#

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace rtfTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            richTextBox1.Text = "[ID] = 0000\nlines\n[END]\n[ID] = 1234\nlines for 1234\n[END]";
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string beginTag = "[ID] = 1234";
            string endTag = "[END]";
            int startPosition = richTextBox1.Find(beginTag);
            if (startPosition >= 0)
            {
                startPosition = startPosition + beginTag.Length+1;// we start at the first line after beginTag
                int endPosition = richTextBox1.Find(endTag,startPosition,RichTextBoxFinds.MatchCase);
                if (endPosition > startPosition)
                    richTextBox2.Text = richTextBox1.Text.Substring(startPosition , endPosition - startPosition );
            }
                
        }
    }
}

<br />
//file Form1.cs<br />
<br />
public partial class Form1 : Form<br />
{<br />
 // many functions/events related to UI controls are here<br />
}<br />

<br />
//file Form1.cs<br />
<br />
public class MyPictureBox : System.Windows.Forms.PictureBox<br />
{<br />
  // some special code will be put here<br />
}<br />
<br />
public partial class Form1 : Form<br />
{<br />
 // many functions/events related to UI controls are here<br />
}<br />

<br />
One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes. <br />
<br />
The service System.Windows.Forms.Design.ISelectionUIService already exists in the service container. Parameter name: serviceType <br />
Hide     <br />
<br />
at System.ComponentModel.Design.ServiceContainer.AddService(Type serviceType, Object serviceInstance, Boolean promote)<br />
at System.ComponentModel.Design.ServiceContainer.AddService(Type serviceType, Object serviceInstance)<br />
at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IServiceContainer.AddService(Type serviceType, Object serviceInstance)<br />
at System.Windows.Forms.Design.ComponentDocumentDesigner.Initialize(IComponent component)<br />
at System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent component, String name, IContainer containerToAddTo)<br />
at System.ComponentModel.Design.DesignerHost.Add(IComponent component, String name)<br />
at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.CreateComponent(Type componentType, String name)<br />
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)<br />
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)<br />
at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, CodeTypeDeclaration declaration)<br />
at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager)<br />
at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)<br />
at System.ComponentModel.Design.Serialization.BasicDesignerLoader.BeginLoad(IDesignerLoaderHost host) <br />

<br />
//file Form1.cs<br />
<br />
public partial class Form1 : Form<br />
{<br />
 // many functions/events related to UI controls are here<br />
}<br />
<br />
public class MyPictureBox : System.Windows.Forms.PictureBox<br />
{<br />
  // some special code will be put here<br />
}<br />

monuSaini wrote:

SqlCommand myCommand = new SqlCommand("SELECT * from companyEmp where age < '50'");

TomiEdy wrote:

if u use query:

SELECT * FROM Your_Table Where age < 50

u got an output data age below 50, if u want to show the data where age is more than 50 than u must change your query into :

SELECT * FROM Your_Table WHERE age > 50

SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, conn);
DataSet ds = new DataSet();
DataTable dt = new DataTable("tablename");
adapter.Fill(dt);
ds.Tables.Add(dt);
ds.WriteXml("C:\text.xml");

SqlDataAdapter adapter = new SqlDataAdapter(yourQuery, conn);
DataSet ds = new DataSet("YourDataSet");
DataTable dt = new DataTable("tablename");
adapter.Fill(dt);
ds.Tables.Add(dt);

ReportDocument rd = new ReportDocument();
rd.SetDataSource = ds;
crystalReportViewer1.ReportSource = rd;