connectionstring

connectionStrings
add name ="Master1" connectionString ="Data Source=OKH;database=leave; user id =sa; pwd="/
/connectionStrings

Connection String

//Connection String

Fill DropDown

SqlConnection con = new
//Connection String



//Page Load Code here

SqlConnection(ConfigurationManager.ConnectionStrings["Master1"].ConnectionString);
SqlCommand cmd;
SqlDataAdapter adp;
DataSet ds;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
cmd = new SqlCommand("Select category_id,category_name from tbl_category order by category_id", con);
adp = new SqlDataAdapter(cmd);
ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
drpCategory1.Items.Add(ds.Tables[0].Rows[i]["Category_Name"].ToString());
drpCategory1.Items[i + 1].Value = ds.Tables[0].Rows[i]["Category_id"].ToString();

}
}
ds.Dispose();
adp=null;
con.Close();
}
}

Work with RSS

protected void Page_Load(object sender, EventArgs e)
{

Response.AppendHeader("refresh", "10");
// XmlTextReader reader = new XmlTextReader("http://cricket.ndtv.com/cricket/ndtvcricket/rssnews/ndtv/cat/news/rss.html");
DataSet ds = new DataSet();
ds.ReadXml(reader);
GridView1.DataSource = ds.Tables[3];
GridView1.DataBind();

}

Validate the contorl in java script

function Validate()
{
if (document.getElementById("Name").value == "") //"Name" == it is a control Id
{
alert("Please enter name");
return false;
}

if (document.getElementById("address").value == "")
{
alert("Please enter Address");
return false;
}
if (document.getElementById("contactno").value == "")
{
alert("Please enter contact no");
return false;
}
if (document.getElementById("query").value == "")
{
alert("Please enter Query");
return false;
}
return true;

}

// Show the salary sum according to the dept wise

SELECT Tbl_Emp.empname, Tbl_Emp.salary AS Amount, TBL_Dept.Deptname
FROM Tbl_Emp INNER JOIN
TBL_Dept ON Tbl_Emp.deptid = TBL_Dept.Deptid
order BY deptname desc
COMPUTE SUM(salary) BY deptname

Threading

public void ThreadJob()
{
for (int i = 0; i < 10; i++)
{
MessageBox.Show(i.ToString());
Thread.Sleep(1000);
}
}
public void ThreadJob1()
{
for (int i = 0; i < 10; i++)
{
MessageBox.Show(i.ToString());

Thread.Sleep(2000);
}
}
private void button2_Click(object sender, EventArgs e)
{
ThreadStart job = new ThreadStart(ThreadJob);
ThreadStart job1 = new ThreadStart(ThreadJob1);
Thread thread = new Thread(job);
Thread thread1 = new Thread(job1);
thread.Start();
thread1.Start();
}