One Textbox assign Multible Button value

i have created 10 Buttons. when i click 5th button the textbox value must be in 5.
this code will help...
in Design part Button Event Click event give btnTickets_Click

Web Application:
protected void lnkShowDate_Click(object sender, EventArgs e)
{
string str = ((System.Web.UI.WebControls.LinkButton)(sender)).ToolTip;
}

Windows:
private void btnTickets_Click(object sender, EventArgs e)
{
txtTicket.Text = ((System.Windows.Forms.ButtonBase)(sender)).Text;
}

Get Multi row in Single Coloum using C#.Net Code

Get Value from Dataset and assign to Gridview:

public string strTransactionNumber1 = "";
public string strTransactionNumber2 = "";
public string strSeatNo = "";

DataTable dtData = new DataTable();
dtData.Columns.Add("TransactionNumber");
dtData.Columns.Add("UserName");
dtData.Columns.Add("TransactionDate");
dtData.Columns.Add("ShowDate");
dtData.Columns.Add("ShowTime");
dtData.Columns.Add("MovieName");
dtData.Columns.Add("SeatName");
dtData.Columns.Add("TotalTickets");
dtData.Columns.Add("Per Seat Price");
dtData.Columns.Add("Limata Amount");
dtData.Columns.Add("Client Amount");
dtData.Columns.Add("Name");
dtData.Columns.Add("MobileNumber");
dtData.Columns.Add("EmailID");
dtData.Columns.Add("IDCardType");
dtData.Columns.Add("IDCardInfo");
DataTable dt = new DataTable();

DataSet dsReport = new DataSet();
OtherBLL objReport = new OtherBLL();
dsReport = objReport.GetTheatreReport(Convert.ToDateTime(txtStartDate.Text), Convert.ToDateTime(txtEndDate.Text), 146, ddlShowTime.SelectedItem.Text);
if (dsReport.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dsReport.Tables[0].Rows.Count; i++)
{

dt = dsReport.Tables[0];
DataRow dr;
dr = dtData.NewRow();
if (i > 0)
strTransactionNumber1 = dt.Rows[i - 1]["V_TransactionNumber"].ToString();
strTransactionNumber2 = dt.Rows[i]["V_TransactionNumber"].ToString();

if (strTransactionNumber1 == strTransactionNumber2)
{
strSeatNo += "," + dt.Rows[i]["V_SeatName"].ToString();
}
else
{
strSeatNo = dt.Rows[i]["V_SeatName"].ToString();
}
dtData.Rows.Add(dt.Rows[i]["V_TransactionNumber"].ToString(), dt.Rows[i]["V_UserName"].ToString(), dt.Rows[i]["D_TransactionDate"].ToString(), dt.Rows[i]["D_ShowDate"].ToString(), dt.Rows[i]["V_ShowTime"].ToString(), dt.Rows[i]["V_MovieName"].ToString(), strSeatNo, dt.Rows[i]["N_TotalTickets"].ToString(), dt.Rows[i]["C_SeatPrice"].ToString(), dt.Rows[i]["LimataAmount"].ToString(), dt.Rows[i]["F_TotalPrice"].ToString(), dt.Rows[i]["V_CardHolderName"].ToString(), dt.Rows[i]["V_MobileNumber"].ToString(), dt.Rows[i]["V_EmailID"].ToString(), dt.Rows[i]["V_IDCardType"].ToString(), dt.Rows[i]["V_IDCardInfo"].ToString());
// dtData.Rows.Add(dt.Rows[i]["V_TransactionNumber"].ToString(), dt.Rows[i]["D_ShowDate"].ToString(), dt.Rows[i]["V_ShowTime"].ToString(), dt.Rows[i]["V_MovieName"].ToString(), dt.Rows[i]["N_TotalTickets"].ToString(), dt.Rows[i]["F_TotalPrice"].ToString(), strSeatNo);
if (i > 0)
{
if (dt.Rows[i - 1]["V_TransactionNumber"].ToString() == dt.Rows[i]["V_TransactionNumber"].ToString())
{
int iCount = dtData.Rows.Count - 1;
dtData.Rows[iCount - 1].Delete();
}
}
dtData.AcceptChanges();
}

grdReport.Visible = true;
lblMessage.Visible = false;
Session["DataSet"] = dtData;
grdReport.DataSource = dtData;
grdReport.DataBind();

Get Multi row in Single Coloum using SQL Query & Check 2 value in same colume

Get Multi Row Seat Name in single colum:

(select (select TD.V_SeatName as col1 FROM Transaction T where TD.N_TransactionID=T.N_TransactionID
for xml raw, elements, type).query('for $col1 in (row/col1) return concat($col1, ",")')) as SeatName


Check 2 value in same colume:(Get Status for (1 or 4))

select * from testtable where N_Status in(1,4)

Negative to Postive Value

converting Negative Value to Pstive value in C#:
string s = "-123.45";
s = Math.Abs(Convert.ToDouble(s)).ToString();
//Output=123.45

Date Time Format

Convert Date Time:
string=strStartDate;
strStartDate = Convert.ToDateTime(strStartDate).ToString("yyyy/MM/dd");

.Net Short Cut Keys

Ctrl + KC - Commanted
Ctrl + KU - UnCommanted
Ctrl + KD - Allignment
Ctrl + G - Go To Line

Find Browser Using Java Script

Find Current Browser Using Java Script.........

<script type="text/javascript">

var browser=navigator.appName;
if(browser=="Microsoft Internet Explorer")
{

}
else if(browser=="Netscape")
{

}

</script>