Click here to Skip to main content
15,900,973 members
Home / Discussions / C#
   

C#

 
AnswerRe: Make a control invisible Pin
Gerry Schmitz31-Jul-21 17:03
mveGerry Schmitz31-Jul-21 17:03 
AnswerRe: Make a control invisible Pin
OriginalGriff31-Jul-21 19:19
mveOriginalGriff31-Jul-21 19:19 
GeneralRe: Make a control invisible Pin
Ismael Oliveira 20211-Aug-21 12:57
Ismael Oliveira 20211-Aug-21 12:57 
AnswerRe: Make a control invisible Pin
Mycroft Holmes1-Aug-21 12:17
professionalMycroft Holmes1-Aug-21 12:17 
GeneralRe: Make a control invisible Pin
Gerry Schmitz2-Aug-21 7:45
mveGerry Schmitz2-Aug-21 7:45 
GeneralRe: Make a control invisible Pin
Mycroft Holmes2-Aug-21 13:52
professionalMycroft Holmes2-Aug-21 13:52 
GeneralRe: Make a control invisible Pin
BillWoodruff20-Aug-21 6:50
professionalBillWoodruff20-Aug-21 6:50 
QuestionError handling when using Invoke method Pin
Alex Dunlop31-Jul-21 5:49
Alex Dunlop31-Jul-21 5:49 
AnswerRe: Error handling when using Invoke method Pin
Richard MacCutchan31-Jul-21 21:04
mveRichard MacCutchan31-Jul-21 21:04 
QuestionHow to pass a variable inside Try{} to outside of it? Pin
Alex Dunlop30-Jul-21 23:05
Alex Dunlop30-Jul-21 23:05 
AnswerRe: How to pass a variable inside Try{} to outside of it? Pin
OriginalGriff30-Jul-21 23:27
mveOriginalGriff30-Jul-21 23:27 
AnswerRe: How to pass a variable inside Try{} to outside of it? Pin
Victor Nijegorodov30-Jul-21 23:28
Victor Nijegorodov30-Jul-21 23:28 
QuestionitextSharp with C# Pin
Ismael Oliveira 202129-Jul-21 6:08
Ismael Oliveira 202129-Jul-21 6:08 
AnswerRe: itextSharp with C# Pin
Dave Kreskowiak29-Jul-21 6:33
mveDave Kreskowiak29-Jul-21 6:33 
GeneralRe: itextSharp with C# Pin
Ismael Oliveira 202131-Jul-21 14:50
Ismael Oliveira 202131-Jul-21 14:50 
GeneralRe: itextSharp with C# Pin
Dave Kreskowiak31-Jul-21 15:05
mveDave Kreskowiak31-Jul-21 15:05 
QuestionHow to create filtering for DataTable based on toggle switches? Pin
Alex Dunlop27-Jul-21 21:46
Alex Dunlop27-Jul-21 21:46 
AnswerRe: How to create filtering for DataTable based on toggle switches? Pin
OriginalGriff27-Jul-21 21:53
mveOriginalGriff27-Jul-21 21:53 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
Alex Dunlop27-Jul-21 22:03
Alex Dunlop27-Jul-21 22:03 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
OriginalGriff27-Jul-21 22:13
mveOriginalGriff27-Jul-21 22:13 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
Alex Dunlop27-Jul-21 23:35
Alex Dunlop27-Jul-21 23:35 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
OriginalGriff28-Jul-21 0:47
mveOriginalGriff28-Jul-21 0:47 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
Alex Dunlop28-Jul-21 20:11
Alex Dunlop28-Jul-21 20:11 
GeneralRe: How to create filtering for DataTable based on toggle switches? Pin
OriginalGriff28-Jul-21 22:00
mveOriginalGriff28-Jul-21 22:00 
Firstly, a DataView isn't a table - it is a filtered view of a table and that's quite different in reality.

Secondly, it works fine for me:
private void TwoDGVs_Shown(object sender, EventArgs e)
    {
    string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString(DBName);
    DataTable dt = new DataTable();
    using (SqlConnection con = new SqlConnection(strConnect))
        {
        try
            {
            con.Open();
            using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM MyTable", con))
                {
                da.SelectCommand.Parameters.AddWithValue("@SEARCH", "The text to search for");
                da.Fill(dt);
                }
            }
        catch (Exception ex)
            {
            Debug.WriteLine(ex.ToString());
            }
        }
    DataView dv = new DataView(dt);
    Source.DataSource = dv;
    }

private void Filter_TextChanged(object sender, EventArgs e)
    {
    if (Source.DataSource is DataView dv)
        {
        dv.RowFilter = $"Title LIKE '%{Filter.Text}%'";
        DataTable dt = dv.ToTable();
        Destination.DataSource = dt;
        }
    }
I get two DGV's, one looking a all rows, the other filtered.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

AnswerRe: How to create filtering for DataTable based on toggle switches? Pin
jsc4227-Jul-21 23:35
professionaljsc4227-Jul-21 23:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.