Windows Form Grid View

Question

Hi
I am new to programing and learing c#. I am trying to create a windows based form which find the record from data base. The data base have three form Repair, customer and machine. The search criteria is when user enter repair ID the result populate into three grides one with all customer inoformation against that repair Id and one is to show repaie information and last one is to show machine information. My problem is how can I show the records into three grids using one Join query.

Thanks

always gull · Answer

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

makando kabila · Answer

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; }

Lisa · Answer

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

always gull · Answer

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.

Lisa · Answer

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

always gull · Answer

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

Lisa · Answer

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

always gull · Answer

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 addtel email) Repair(RepId CusIdMachIdRedescription RepStatus RepCost) Machine(MachIdCusIdMakeModelSerielNo) 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

Bechir Bejaoui · Answer

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