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;
        }
    }
}

News objNews = new News();

News objNews = null;

if (objDr.HasRows)
{
    objNews = new News();
    objDr.Read()
    objNews.NewsID = Convert.ToInt32(objDr["PKNewsID"]);
    objNews.CategoryID = Globals.CheckDBIntForDBNulls(objDr["FKNewsCategoryID"]);
    objNews.Title = objDr["NewsTitle"].ToString();
}

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious