Windows Form Grid View

Thanks that what i was looking for. That's solve my problem

Thanks

If you want to specify how the filtering occurs, then you could use a DataView. A BindingSource could also work.
This approach also could be useful if you select a row from one of the datagrids and then to only display the
corresponding ones in the other grids. There're various ways to do this.
Part of your code listing  could be something like this:

       DataView dvCustomers;
        DataView dvRepairs;
        DataView dvMachines;
        DataSet ds = new DataSet();
        private void Form1_Load(object sender, EventArgs e)
        {
            //Populate the dataset first
            //Then
            InitialiseDataviewsAndBind();
        }

        private void btnFindRecords_Click(object sender, EventArgs e)
        {
            string repairid = "your RepId comes here";
            //or string repairid = textBox1.Text;
            ApplyFilter(repairid);
        }

        private void ApplyFilter(string repairid)
        {
            string custfilter = string.Empty;
            string machinefilter = string.Empty;

            dvRepairs.RowFilter = "RepairId='" + repairid + "'";
            if (dvRepairs.Count > 0)
            {
                DataRowView drvrepairs = dvRepairs[0];
                custfilter = "Id='" + drvrepairs["CusId"].ToString() + "'";
                machinefilter = "MachId='" + drvrepairs["MachId"].ToString() + "'";
            }
            dvCustomers.RowFilter = custfilter;
            dvMachines.RowFilter = machinefilter;
        }
        private void InitialiseDataviewsAndBind()
        {
            /* Run after populating your dataset
            *You could use table names if you know them correctlt
             *instead of the index*/
            
            dvCustomers = ds.Tables[0].DefaultView;
            dvRepairs = ds.Tables[2].DefaultView;
            dvMachines = ds.Tables[3].DefaultView;

            dg1.DataSource = dvCustomers;
            dg2.DataSource = dvRepairs;
            dg3.DataSource = dvMachines;
        }

thats quite simple

say dg1 is your first datagrid

dg1.DataSource = ds.Tables[0]
dg2.DataSource = ds.Tables[1]
dg3.DataSource = ds.Tables[2]
 be sure which table goes to which datagrid.

Thanks,
Lisa

Thanks, but the problem is i have three grids in my form one to show customer data, one to show repair data and last one to show machine data. and if a put all the results in a single data set then how can i use it with three girds like i want that my customer grid only display data from customer table and repair gird only show data for repair, similarly for machine. how i will use this data set to display the specific table record for each grid.

well consider a query like

select * from table1
select * from table2
select * from table3 in a single procedure this will return 3 different results

you can then use a dataadapter to fill the dataset with 3 different tables in the same dataset

and assign individual tables to datagridviews.

Thanks,
Lisa

Thanks for the reply Lisa, can you show me any code example that how can i get three tables from one query and assign them to three data set.

Thanks Israr

you can create a query with actually returns 3 datasets or may be single dataset with 3 different tables and assign those values to the indivdual datagrid views.

Thanks,
Lisa

sorry i did not get you, about what you mean which kind of data. Its data base created in sql server have three table
Tables
customer(Id, name, add,tel, email)
Repair(RepId, CusId,MachId,Redescription, RepStatus, RepCost)  Machine(MachId,CusId,Make,Model,SerielNo)

Relation ships

1 Customer can have many repairs            many  Repair can have many customer
1 Customer can have many machine for repair Many machine can have many Cus

1 Machine can be repair many time   Many repair can have same machine for repair

Thanks

 

Would you tell me which kind of data base did you use or plan to use?