C#

Bernhard Hiller wrote:

And I'd suggest to replace typeof(BunchOfISomeInterface) with bunch.GetType().

// Assume 'BunchOfStuff is of Type: Dictionary<string, List<Stuff>>
private static readonly Type BunchType = typeof(BunchOfStuff);

public static Dictionary<string, List<Stuff>> Read()
{
    using (FileStream reader = new FileStream(filepath, FileMode.Open, FileAccess.Read))
    {
        serializer = new DataContractSerializer(BunchType);
        
        // error 'field' but is used like a 'type
        // return (BunchType) serializer.ReadObject(reader);
        
        // error semi-colon expected
        // return (typeof(BunchType)) serializer.ReadObject(reader);
   
        // error semi-colon expected
        // return (BunchType.GetType()) serializer.ReadObject(reader);

        // only this works
        return (Dictionary<string, List<Stuff>>) serializer.ReadObject(reader);
}

public static BunchOfStuff Read()
{
    using (var reader = File.OpenRead(filepath))
    {
        var serializer = new DataContractSerializer(BunchType);
        return (BunchOfStuff)serializer.ReadObject(reader);
    }
}

myTextBox.Text = "Searching...";

• getRasm_ID1() returns an empty list in which case the statement would be
  SQL

  ... WHERE Rasm_ID IN ()

• getRasm_ID1() returns character data in which case the String.Join should be changed to
  C#

  ..."SELECT Rasm FROM rasmlar where Rasm_ID IN ('" + String.Join("','", getRasm_ID1()) + "')", con);

private void BindGrid()
{
    using (MySqlConnection con = new MySqlConnection(constr))
    using (MySqlCommand cmd = new MySqlCommand(string.Empty, con))
    {
        var sb = new System.Text.StringBuilder("SELECT Rasm FROM rasmlar where Rasm_ID IN (");
        
        foreach (var id in getRasm_ID1())
        {
            if (cmd.Parameters.Count != 0) 
            {
                sb.Append(',');
            }
            
            string name = "@p" + index;
            cmd.Parameters.AddWithValue(name, id);
            sb.Append(name);
        }
        
        sb.Append(')');
        
        cmd.CommandText = sb.ToString();
        
        MySqlDataAdapter da = new MySqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        da.Fill(dt);
        
        gvImages.DataSource = dt;
        gvImages.DataBind();
    }
}