execute parameterized stored procedure from code behind

Add This to your Web.config file








SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConStr"]);
SqlCommand cmd = new SqlCommand("spCheckProjectStatus", conn);
cmd.CommandType = CommandType.StoredProcedure;

SqlParameter sqlParam = new SqlParameter();
sqlParam = cmd.Parameters.Add("@ProjectId",SqlDbType.VarChar);
sqlParam.Direction = ParameterDirection.Input;
sqlParam.Value = dtTemp.Rows[i]["Pid"].ToString();

SqlParameter sqlParam2 = new SqlParameter();
sqlParam2 = cmd.Parameters.Add("@BiderId",SqlDbType.VarChar);
sqlParam2.Direction = ParameterDirection.Input;
sqlParam2.Value = dtTemp.Rows[i]["Bid"].ToString();

conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
conn.Close();

hope this will help you....

Generate Random Key with integer and character

use
System.Security;
System.Security.Cryptography;

in the include section

private string GetUniqueKey()
{

int maxSize = 8;
int minSize = 5;
char[] chars = new char[62];
string a;
a = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
chars = a.ToCharArray();
int size = maxSize;
byte[] data = new byte[1];
RNGCryptoServiceProvider crypto = new RNGCryptoServiceProvider();
crypto.GetNonZeroBytes(data);
size = maxSize;
data = new byte[size];
crypto.GetNonZeroBytes(data);
StringBuilder result = new StringBuilder(size);
foreach (byte b in data)
{
result.Append(chars[b % (chars.Length - 1)]);
}
return result.ToString();
}

hope it will help you