Skip to main content

Find Value in DataTable all Rows and Columns in C# | Search in DataTable



Find Value in DataTable all Rows and Columns in C# | Search in DataTable 


if you write program for find value in DataTable all rows and columns and get this row this program help you



        public static DataTable search_in_all_columns(DataTable dtobj, string searchpram)
        {
            DataTable dt = new DataTable();
            dt = dtobj.Copy();
            dt.Rows.Clear();
            if (!string.IsNullOrEmpty(searchpram) && !string.IsNullOrEmpty(searchpram.Trim()))
            {
                searchpram = searchpram.ToUpper().Trim();
                if (dtobj != null && dtobj.Rows.Count > 0)
                {
                    for (int r = 0; r < dtobj.Rows.Count; r++)
                    {
                        bool goin = false;
                        for (int c = 0; c < dtobj.Columns.Count; c++)
                        {
                            if (goin == false && (dtobj.Rows[r][c].ToString().ToUpper()).Contains(searchpram))
                            {
                                dt.Rows.Add(dtobj.Rows[r].ItemArray);
                                goin = true;
                            }
                        }
                    }
                }
            }
            int dtco = dt.Rows.Count;
            int dtobjco = dtobj.Rows.Count;
            return dt;
        }


If you like this blog so pls share and Write Comments about Your experience,
Thank You.
Labels:

Comments

Post a Comment

Popular posts from this blog

What is OOP (objects oriented programming) in C#

 What is OOP? in C# OOP is Object Oriented programming miens contain methods and data in objects it's called objects oriented programming(OOP) OOP Advantages Provides clear visibility and code for the programs easier to maintain, modify and debug Faster development easier and faster to execute create reusable code make your code neat and clean and easy to understand What is Class and objects in C# Class and object are the two main points of OOP (object oriented programming), when fruit is a class then Apple, Guava, Banana,  is object, when the individual objects are created they inherits all variables and method form the class, class is a template for the objects and object is instance of the class If you like this blog so pls share and  Write Comments  about Your experience, Thank You.
Post a Comment
Read more

Make api in DotNet Core in 10sec | Create universal api for SQL server

Make API in Dot Net Core in 10sec | Create universal API for SQL server Universal API is great concept for app and angular developer need only connect to data base add table name and access table crud operation using API's  If you like this blog so pls share and  Write Comments  about Your experience, Thank You.
Post a Comment
Read more

How to Optimize Your LinkedIn Profile as a Software Developer: Tips for Success

How to Optimize Your LinkedIn Profile as a Software Developer: Tips for Success To make your LinkedIn profile more attractive and discoverable as a software developer, you should focus on creating a compelling profile that showcases your skills, experience, and potential. Below are some specific strategies: 1. Professional Profile Picture Use a clear, professional photo where you look approachable and confident. A headshot with a neutral background works well. 2. Headline Your headline should be more than just your job title. Make it a powerful value proposition. Consider including: Your current role, tech stack, or specialization. Highlight key skills (e.g., "JavaScript | React | Node.js | Full-Stack Developer"). Optional: Include a personal tagline (e.g., "Building innovative web applications that solve real-world problems"). Example: "Full-Stack Developer | React, Node.js, Python | Passionate About Clean Code & Scalable Systems" 3. Summary (About Se...
Post a Comment
Read more