Using the DataTable RowFilter Property in C#

This is a simple but pretty important property that filters data already existent in the dataTable according to dynamic values. Download the SQL database used in this video from www.innermotivation.com/database

[@math487]

I love you , seriously with your videos im wayyyg better you have no idea how it helped me to progress! Thank you x10000

[@K3LL0GS]

Thank you so much. I have spent days trying to find something like this to help with a search form.

[@andresfuentes9557]

first at all thanks for your videos, they are really helpfull and I can say that you are saving life with this tutorial. Currently I am programing C# a project to Filter united Tables. In you tutorial shows how to join 2 Tables and filter everytime that is a click in the first Table. Now I would like to do the same, but with a third table. So my idea is when I click the first table, filter the second table and when I click the second, filter the third. I did the program but it doesn't filter the third and doesn't show the information. I really appreciate if you can help me.

[@Coffeecupdev]

I C# you need to browse to the bin\debug folder of your build. The .exe file will be there. If you right click your project and choose "Open Folder in Windows Explorer" the bin folder should be the first one on the top.

[@avinashgupta2461]

you are so great ...please tell us about your blogs and please make your website so that we can ask u doubt about source codes..............

[@FemiOlayemi]

Nice video, it place me in better perspective on my current project. Thanx.

[@johntrites3387]

great video! I have an immediate application using this technique - much appreciated. In my application, I the VendorID is not a number but is a string name. How can I change the SelectionChange method to look for a string VendorID? Thanks, JT

[@xam517]

BablioBr u r amazing all your videos are very useful
thank u v

[@DankoHS]

Nice videos.
Q:
Why are you getting all records from Invoices table? I mean what if u have like 3-4 milion records? Wouldn't it be better to fetch records from Invoices depending on the selected row in Vendors. Something like SELECT * FROM invoices WHERE invoices.vendorid = (selected id in vendors datagrid) on dgVendor ChangeSelection event?

[@isuruthilina9280]

best on you tube tutorials...great helped a alot..
please i wanna know how to get a invoice print out using c#.can somebody show how to.?.

[@gordilloedwin]

yup, pure gold!!

[@mogsamful]

Very nice video...it helped me alot

[@kniranjansingh]

great job buddy !! keep it up .. you rock !!

[@Anton-Os]

Thanks

[@pacolopz]

hi
great job
sorry 4 my english
can you help me with a tuto about how to save changes that I make in a datagrid that is loaded first with databinding then I made a filter with a textbox and display the results in the same datagrid the thing is that when I make the search I want to update the results but when I click the update button it updates the original positions in the databinding not the selected row on the filter
note: information of the selected row is displayed in textboxes

[@ishakul777]

How to select data between two dates in C# windowsform using ms access ?

[@johntrites3387]

Now works using Customers and Orders tables in the Northwind DB. I modified your SelectionChange method:
private void dgOrders_SelectionChanged(object sender, EventArgs e)
{
string filterColumn = "CustomerID = ";
string colFilter = (string)dgCustomers.CurrentRow.Cells["CustomerID"].Value;
ds.Tables["tblOrders"].DefaultView.RowFilter = filterColumn + "'" + colFilter + "'";
dgOrders.DataSource = ds.Tables["tblOrders"];
}
Better way?

[@sonicclang]

How would you use the SqlDataAdapter with parameters?

[@Coffeecupdev]

hehehehe... true!! :) I am starting a new one.. I am not publishing it until it is ready...

[@babaktaba]

how can filter with textbox.text ? for example:
ds.Tables[0].DefaultView.RowFilter = "venderID=" + textbox.Text ????

[@karthikutg123]

Thank u

[@andresfuentes9557]

Hey Fabio, thank you so much for the tutorials. Are you available to give support about this topic? of course i will give remuneration. Thanks in advance.

[@Coffeecupdev]

Hey Andres shoot me an email, I'll try to help, no need for remuneration. Thank you.

[@andresfuentes9557]

​@@Coffeecupdev Thanks for your kind respond. I sent you an email that you have in your channel.Thanks for your time.

[@VijayaKumar-gc9es]

i frds can u please help me..
while i use same codings i get an error
missing operand after 'A' operator
can u please

[@melarevanco]

Thanks!

[@Coffeecupdev]

@ahzan100 Check out our Facebook group " Learn C# - The Right Way " Its steadily growing, and we are always helping each other... Come check us out! :) Thx for watching!

[@evancito2]

thanks!

[@paulsanchez5030]

what a mess man i cant find the videos before this one... any help?

[@kingofbaroda]

Give me your website link..

[@damarislorena]

Necesito un video que me explique como visualizar imagenes desde oracle en crystal SAP. Puedes?

[@ahzan100]

what is your webste

[@leowasif05]

your web is not working ...