C#

afjepoifesahie wrote:

there C# code that will take an image and a list of RGB values and make the image out of the RGB colors with floyd steinberg dithering?

• create a class that represents a table with properties such as table name, create statement, to be created bit (which defaults to true)
• create an instance for all of your tables
• place the created instances to a generic dictionary (Dictionary<string,>), place the table name to the key of the dictionary item
• after this get the schema
• loop every row found from schema and set the corresponding item in the dictionary to not to create the table
• after this you can loop the dictionary and execute every create statement from the instances where create bit is still true
• the instances can be created based on for example a xml file if you want to add tables without modifying the code (in this case take good care for the seurity issues)

bool create = false;
            for (int j = 0; j < NATables.Length; j++) // loop through tables to be created
            {
                create = true;
                for (int i = 0; i < rows.Length; i++) // loop through the records searching for tables and set flag for tables that need to be created
                {
                    string r = rows[i]["TABLE_NAME"].ToString();
                    if (r == NATables[j])
                    {
                        //don't create table
                        create = false;
                        return;
                    }
                }
                if (create == true)//create Table if true
                {
                    string strQuery = CTquery[j];
                    RunSQLQuery(strQuery);
                    create = true;
                }
            }

public class MyDataTag
{
    public MyDataTag(DataRowView dataRow)
    {
        itemID = dataRow["NodeId"];
        text = dataRow["EnNode"].ToString();
        otherInfo = dataRow["OtherInfo"].ToString();
    }

    public object itemID;
    public string text;
    public string otherInfo;
}

TreeNode node = new TreeNode();
MyDataTag dataTag = new MyDataTag(dv[i]);
node.Text = dataTag.text;
node.Tag = dataTag;

MyDataNode itemData = e.Node.Tag as MyDataNode;
if (itemData != null)
{
    string test = string.Format("ID: {0}  Other Info: {1}", itemData.itemID.ToString(), itemData.otherInfo);
    ListViewItem newItem = listView1.Items.Add(test);
    newItem.Tag = itemData;
}