Dot-Net Programming Tips

Thursday, August 16, 2012

dynamically POST the FORM to third party URL / Site

We want to POST FORM to third party URL or any other site. But in ASP.Net pages we cant do directly. so below customized function to send FORM dynamically.

private void ResponseToClient()
    {
        try
        {
            NameValueCollection data = new NameValueCollection();
            data.Add("Field1", "val1");
            data.Add("Field2", "val2");
            string ResponseURL = "responsesimulator.aspx";

            string strForm = ConstructInternalFormToPost(ResponseURL, data);
            this.Page.Controls.Add(new LiteralControl(strForm));
        }
        catch (Exception Ex)
        {


        }

    }

    private static String ConstructInternalFormToPost(string url, NameValueCollection data)
    {

        string tmpformID = "PostForm";

        StringBuilder strConstructForm = new StringBuilder();
        strConstructForm.Append("<form id=\"" + tmpformID + "\" name=\"" +
                       tmpformID + "\" action=\"" + url +
                       "\" method=\"POST\">");

        foreach (string key in data)
        {
            strConstructForm.Append("<input type=\"hidden\" name=\"" + key +
                           "\" value=\"" + data[key] + "\">");
        }

        strConstructForm.Append("</form>");

        StringBuilder ConstructScript = new StringBuilder();
        ConstructScript.Append("<script language='javascript'>");
        ConstructScript.Append("var v" + tmpformID + " = document." +
                         tmpformID + ";");
        ConstructScript.Append("v" + tmpformID + ".submit();");
        ConstructScript.Append("</script>");

        return strConstructForm.ToString() + ConstructScript.ToString();
    }

Tuesday, August 14, 2012

New Features of Visual Studio 2012 and .Net 4.5

Thanks to telerik team....

Monday, August 23, 2010

hiii

Saturday, August 21, 2010

Tuesday, August 17, 2010

HTTPException was unhandled by User Code?

HTTPException was unhandled by User Code?

Error executing child request for ~/page.aspx.

Ans: if page.aspx not exists in your current directory or renamed, so check the name.

Microsoft JScript runtime error?

Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.

Details: Error parsing near '

<!DOCTYPE html P'.

Ans: Server.Transfer or Response.write wont work in Ajax enabled pages.

Thursday, August 12, 2010

Sample LINQ Queries

DBDataContext objeDC =new DBDataContext();

1. How to check whether the UserID exist in the table using LINQ?

UserMst objUserMst =null;
objUserMst= objeDC.UserMsts.SingleOrDefault(Rec => Rec.UserMstID == "sample");
if(objUserMst !=null)
//exists
else
// Not exists

PwdHistory objHistory = new PwdHistory();
objHistory.UserName = "Sample";
objHistory.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile("password", "MD5");
objeDC.PwdHistories.InsertOnSubmit(objHistory);
objeDC.SubmitChanges();

FormsAuthentication.HashPasswordForStoringInConfigFile("password", "MD5");

4. use Transaction in LINQ (Roll and Commit)

DBTransaction objDBTrans=null;
objDBTrans = objeDC.Connection.BeginTransaction();
objeDC.Transaction = objDBTrans ;
try
{
       PwdHistory objHistory = new PwdHistory();
       objHistory.UserName = "Sample";
       objHistory.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile("password", "MD5");
       objeDC.PwdHistories.InsertOnSubmit(objHistory);
       objeDC.SubmitChanges();
       objDBTrans.Commit();
}
catch(Exception ex)
{
       objDBTrans.RollBack();
}

5. Simple where condition using LINQ

var Result = from objLogin in objeDC.LoginLogs
where objLogin.UserMstID == strLoginId && objLogin.LoginEventID == "02"
select objLogin;

objUserMst = objeDC.UserMsts.SingleOrDefault(Rec => Rec.UserMstID == "sample");
if (objUserMst != null)
{
objUserMst.eInsInd = true;
objeDC.SubmitChanges();
}

var Result = from objUserGroup in objeDC.UserGroups
select objUserGroup;
DropdownList1.DataTextField = "Dsc";
DropdownList1.DataValueField = "UserGroupID";
DropdownList1.DataSource = Result;
DropdownList1.DataBind();

var Result = from objNewsMast in objeDC.NewsMasts
orderby objNewsMast.TimeStamp
select objNewsMast;
gvNewsImage.DataSource = Result;
gvNewsImage.DataBind();

var Result = from objMenu in objeDC.Menus
select new
{
          MenuID = objMenu.MenuID.ToString().Contains(".aspx") == true?objMenu.MenuID :
           string.Empty ,
           Dsc = objMenu.Dsc,
};

UserGroups objUserGrp = null;
objUserGrp = objeDC.UserGroups.SingleOrDefault(Rec => Rec.UserGroupID == "stringval");
if (objUserGrp != null)
{
objeDC.UserGroups.DeleteOnSubmit(objUserGrp);
objeDC.SubmitChanges();
}

11. Delete multiple records based on condition using LINQ?

objeDC.MenuAccesses.DeleteAllOnSubmit(objeDC.MenuAccesses.Where(Tmpr => Tmpr.MenuID == strMenuID));
objeDC.SubmitChanges();

ex.. Convert Datetime column (MM/dd/YYYY) to dd/MM/yyyy

var objResult = from objTemp in
( from objNewsMast in objeDC.NewsMasts
   select new
   {
       Date = objNewsMast.TimeStamp,
      Title = objNewsMast.Title,
    }).ToList()
select new
{
    Date = objTemp.Date.ToString("dd/MM/yyyy"),
   Title = objTemp.Title,
});

13. convert LINQ Results to DataTable

var ResultProgram = from objProgram in objeDC.Programs
select objProgram;
DataTable dtProgram = LINQToDataTable(ResultProgram);

14. LINQ to DataTable

public DataTable LINQToDataTable<T>(IEnumerable<T> varlist)
{
      DataTable dtReturn = new DataTable();
       PropertyInfo[] oProps = null;
       if (varlist == null) return dtReturn;
          foreach (T rec in varlist)
         {
          if (oProps == null)
         {
            oProps = ((Type)rec.GetType()).GetProperties();
             foreach (PropertyInfo pi in oProps)
             {
                  Type colType = pi.PropertyType;
                   if ((colType.IsGenericType) && (colType.GetGenericTypeDefinition() == typeof(Nullable<>)))
                 colType = colType.GetGenericArguments()[0];
                        dtReturn.Columns.Add(new DataColumn(pi.Name, colType));
             }
         }
       DataRow dr = dtReturn.NewRow();
         foreach (PropertyInfo pi in oProps)
           {
            dr[pi.Name] = pi.GetValue(rec, null) == null ? DBNull.Value : pi.GetValue
            (rec, null);
           }
         dtReturn.Rows.Add(dr);
}
return dtReturn;
}

12. Format the retrieve column using LINQ) 10. Delete a record using LINQ?9. Check the column value having specified characters using LINQ?8. Bind into gridview using LINQ?7. Bind into DropdownList using LINQ?6. Update Single value to particular record using LINQ 3. Encrpted Password2. insert Values into table using LINQ?