30.7.10

RadAjaxManager alert telerik

RadAjaxManager1.ResponseScripts.Add("alert('Please select atleast one Recipient')");

Execute Reader and List:

int ret = 0;
SqlCommand objCmd = new SqlCommand("UspInsertUpdate_DashBoard", objCon);
objCmd.CommandType = CommandType.StoredProcedure;
#region Parameters Ordte Products
objCmd.Parameters.Add("@intDashBoardId", SqlDbType.BigInt).Value = objUI.DashBoardId;
objCmd.Parameters.Add("@intUserId", SqlDbType.BigInt).Value = objUI.UserId;
objCmd.Parameters.Add("@chvnModule", SqlDbType.NVarChar).Value = objUI.Module;
objCmd.Parameters.Add("@chvnExp", SqlDbType.NVarChar).Value = objUI.Exp;
objCmd.Parameters.Add("@chvnTitle", SqlDbType.NVarChar).Value = objUI.Title;

#endregion
try
{
objCon.Open();
ret = Convert.ToInt32(objCmd.ExecuteScalar());

}
catch
{
}
finally
{
objCmd.Dispose();
objCon.Close();
}
return ret;
=====================================

list:

SqlCommand objcmd = new SqlCommand("UspDisplayAccounts", objCon);
objcmd.CommandType = CommandType.StoredProcedure;
objcmd.Parameters.Add("@intUserId", SqlDbType.Int).Value = UserId;
List objList = new List();
SqlDataReader objDr;
objCon.Open();
objDr = objcmd.ExecuteReader();
try
{

while (objDr.Read())
{
Accounts objBol = new Accounts();
objBol.AccountId = Convert.ToInt32(objDr["crm_cust_info_pk"]);
objBol.Title = objDr["crm_cust_acc_title"].ToString();
objBol.CompanyName = objDr["Name"].ToString();
objBol.CreateDate = Convert.ToDateTime(objDr["crm_cust_create_date"]);
objBol.AddressId = Convert.ToInt32(objDr["crm_add_fk"]);
objBol.CreatedByName = objDr["created_by_name"].ToString();
objBol.AssignTo = objDr["assigned_to_name"].ToString();
objList.Add(objBol);
}
}
catch
{
}
finally
{
objDr.Close();
objCon.Close();
objcmd.Dispose();
}
return objList;

No comments: