C#

hg2705 wrote:

How many thread is alowed in app?

hg2705 wrote:

Iven if I remove the suspend command for the thread and just let it run one empty function. The processor is boosted to 100%

<br />
public app()<br />
{<br />
	mRun = true;<br />
	mThreads = new ArrayList();<br />
	for(int i = 0; i<10; i++)<br />
	{<br />
	        Thread t = new Thread(new ThreadStart(this.go));<br />
		t.Name = i.ToString();<br />
		t.Start();<br />
		t.Suspend();<br />
		mThreads.Add(t);<br />
	}<br />
}<br />
private void go()<br />
{<br />
	while(mRun)<br />
	{<br />
	        listBox1.Items.Add("run");<br />
		Thread.Sleep(10000);<br />
	}<br />
}<br />

KiTsuNeKo wrote:

if (conn.State == ConnectionState.Open) { conn.Close(); }

public class MyClass
{
    private SqlConnection conn = new SqlConnection(this.SQLExpressConnStr);
    public string SQL2KConnStr = "..(my connection string)..";
    public object ExecuteSql(string sql)
    {

        if (conn.State != ConnectionState.Open)
        {
            conn.Open();
        }
        switch(sql.Trim().Substring(0,6).ToLower())
        {
            case "select":
                try
                {
                    SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
                    ds = new DataSet();
                                            adapter.Fill(ds, "QueriedTab");
                }
                finally
                {
                    conn.Close();
                }
                return ds.Tables["QueriedTab"]; //Return a data table.
                break;
            default:
                SqlCommand cmd = new SqlCommand();
                //cmd.CommandType = CommandType.Text;
                cmd.Connection = conn;
                cmd.CommandText = sql;
                long rtn = 0;
                try
                {
                    rtn = cmd.ExecuteNonQuery(); //Return a number of affected rows.
                }
                finally
                {
                    conn.Close();
                }
                return rtn;
                break;
        }
    }
}