Bold Specific item of drop down in c#

If we apply style on drop down for maiking specific item bold,it will work in Firefox but not in IE.

So for overcome this problem,we should make that item to bold before binding it to dropdown.

var item = new ListItem("MyItem");
item.Attributes.Add("style", "font-weight: bold");
var list = FindControl("DropDownList1");
list.Items.Add(item);

Querystring In item template of Gridview

<asp:TemplateField HeaderText="View details">
                    <ItemTemplate>
                        <a href = 'customerdetails.aspx?cid=<%#Eval("clientid")%>&custID=<%#Eval("CustID") %>' target="_blank">View Details</a>
                    </ItemTemplate>
                </asp:TemplateField>

Unique Random Number Generation in asp.net

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;

public partial class _Default : System.Web.UI.Page
{
    private static Random random = new Random((int)DateTime.Now.Ticks);
    protected void Page_Load(object sender, EventArgs e)
    {
        // get 1st random string
        string RandNum1 = RandomStringMehtod(4);

        // get 2nd random string
        string RandNum2 = RandomStringMehtod(4);

        // create full random string
        string FinalNum = RandNum1 + "-" + RandNum2;
    }

    private string RandomStringMehtod(int size)
    {
        StringBuilder sb = new StringBuilder();
        char ch;
        for (int i = 0; i < size; i++)
        {
            ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * random.NextDouble() + 65)));
            sb.Append(ch);
        }

        return sb.ToString();
    }
}

Calculating age from a given date or calander date in c#

using System.Globalization;
IFormatProvider ci= new CultureInfo("en-US", true); 


DateTime Dt = Convert.ToDateTime(txtDateOfBirth.Text,ci);


string test = String.Format("{0:MM/dd/yyyy}", Convert.ToDateTime( Dt ));
int age = DateTime.Now.Subtract(DateTime.ParseExact(test, "dd/MM/yyyy", ci,DateTimeStyles.NoCurrentDateDefault)).Days / 365;

Creating Virtual table and getting joined sql result

1.
SELECT A.CID,B.add1 ,B.add2,B.add3,B.add4,B.County,B.pcode ,B.street from
(SELECT CID from Claimant_Master where Claimant_Master.CID NOT IN(SELECT Cla_Id FROM Claimant_Address) AND Claimant_Master.WarrantID LIKE 'SPC%')  A ,
(SELECT add1,add2,add3,add4,County,pcode, street from Claimant_Address where Cla_Id IN (SELECT CID from Claimant_Master where WarrantID='SPC6748'))  B

2.Another query

select c.EnterBy,c.totalcalls astotal,c.reminder as rem,d.tot as blank from 

(SELECT A.EnterBy,A.tot as totalcalls,B.Tot as reminder FROM

(SELECT COUNT(custTicketNo) AS 'tot',EnteredBy As EnterBy FROM indiatimes_cust_complaint WHERE (TDate + 2

+ TTime BETWEEN '7/22/2008 00:00:00.000' AND '7/22/2008 23:59:59.999') 

and EnteredBy in(SELECT agentLoginID FROM indiatimes_agent_master WHERE (TType IN

('Admin', 'BackendAgent','FrontEndAgent'))) GROUP BY EnteredBy )A,

(SELECT EnterBy, COUNT(*) AS tot FROM IT_Reminders WHERE (entertime between '7/22/2008 00:00:00.000' and '7/22/2008

23:59:59.999' ) and Type='NT' GROUP BY EnterBy )B WHERE (A.EnterBy *= B.EnterBy))c ,

(SELECT EnteredBy, COUNT(*) AS tot FROM

Indiatimes_BlankCalls WHERE (tdate between '7/22/2008 00:00:00.000' and '7/22/2008 23:59:59.999' ) and EnteredBy in(SELECT agentLoginID FROM indiatimes_agent_master

WHERE (TType IN ('Admin', 'BackendAgent','FrontEndAgent'))) GROUP BY EnteredBy)d

where c.EnterBy *=d.EnteredBy

Adding double quotes("") in string and displaying like "Ajay""

simplest way to do this is:

string test ="You are very good \"person\" and want to meet you"

console.write(test );

You will get output like:

You are very good "person" and want to meet you

How get sql identity key value in ASP.net code behind page

1.Create stored procedure in SQL like this...



CREATE procedure test

@retval int output

As

Begin
insert INTO Testtable(abc,xyz) values('ajay','balwindar')

@retval=@@identity
return @retval
End

2 .In asp.net code behind page..on page load call this function written below


 protected void Page_Load(object sender, EventArgs e)
    {

Label1.Text= Convert.ToString(GetIdentityValue());
}




public int GetIdentityValue()
        {
              string S4CConString = ConfigurationManager.AppSettings["S4CConString"].ToString();
          SqlConnection _con = new SqlConnection(S4CConString);
            SqlCommand _cmd = new SqlCommand("test", _con);
            _cmd.CommandType = CommandType.StoredProcedure;
        _cmd.Parameters.Add("@subjectParam", SqlDbType.NVarChar);
      _cmd.Parameters["@retval"].Direction = ParameterDirection.ReturnValue;

_cmd.ExecuteNonQuery();

int i = (int)_cmd.Parameters["@retval"].Value;
return i;

}