How to create datatable in c#

Posted on 2018-10-21 02:03:45

Download Source Code / File

It's very easy to use. You can use this datatable as a search filter. You can load all data in to your dataGridView then you can search the correct result quickly using this code.

using system;
using system.collections.generic;
using system.componentmodel;
using system.data;
using system.drawing;
using system.linq;
using system.text;
using system.threading.tasks;
using system.windows.forms;



namespace tutorial_22
{
    public partial class form1 : form
    {
        public form1()
        {
            initializecomponent();
           
        }


        void loadproductstogrid()
        {
            
            for (int i = 0; i < 10; i++)
            {
                datagridview1.rows.add(
                    "abc" + i,
                    "def" + i,
                    "ghi" + i,
                    "jkl" + i,
                    "mno" + i
                    );
            }
        }


        private void textbox1_keyup(object sender, keyeventargs e)
        {
            bool st = false;

            if (textbox1.text != "")
            {
                if (e.keycode.tostring() == "back")
                {
                    datagridview1.rows.clear();
                    datagridview1.refresh();
                    loadproductstogrid();
                }

                list<datagridviewrow> tobedeleted = new list<datagridviewrow>();

                foreach (datagridviewrow row in datagridview1.rows)
                {
                    for (int i = 0; i < datagridview1.columns.count; i++)
                    {
                         if (row.cells[i].value.tostring().tolower().contains(textbox1.text.tolower()))
                        {
                            st = true;
                        }
                    }

                    if (!st)
                    {
                        tobedeleted.add(row);
                    }
                    st = false;
                }

                foreach (datagridviewrow row2 in tobedeleted)
                {
                    datagridview1.rows.remove(row2);
                }
                tobedeleted.clear();
            
            }
            else
            {
                datagridview1.rows.clear();
                datagridview1.refresh();
                loadproductstogrid();
            }
        }

        private void form1_load(object sender, eventargs e)
        {
            loadproductstogrid();
        }

        private void textbox1_textchanged(object sender, eventargs e)
        {

        }
    }
}