News about SEO: February 2013

Thursday 21 February 2013

First Application with MVC pattern in form submit app

First of you create mvc application
then you create view, controller, model class

<table style="width: 100%">
<tr>
                            <td style="width:50%; text-align: right;">
                                Flying From</td>
                            <td style="width:50%;">
                                <%=Html.TextBox("txt_flying_from")%>
                                <%=Html.ValidationMessage("txt_flying_from", "Shold Not Blank")%></td>
                        </tr>
<tr>
                            <td style="text-align: right">
                                Flying To</td>
                            <td>
                                <%=Html.TextBox("txt_flying_to")%>
                                <%=Html.ValidationMessage("txt_flying_to", "Shold Not Blank")%>
                                </td>
                        </tr>
<tr>
                            <td style="text-align: right">
                                Depart Date</td>
                            <td>
                                <%=Html.TextBox("txt_D_Date")%>
                                <%=Html.ValidationMessage("txt_D_Date", "Date is Required")%>
                                </td>
                        </tr>
<tr>
                            <td style="text-align: right">
                                Return Date</td>
                            <td>
                                <%=Html.TextBox("txt_R_Date")%><%=Html.ValidationMessage("txt_R_Date", "Date is Required")%></td>
                        </tr>
<tr>
                            <td style="text-align: right">
                                Class</td>
                            <td>
                                <% %></td>
                        </tr>
<tr>
                            <td colspan="2" align="center">
                                <div style="float:right; width:600px;">
                                <span style="float:left; width:150px;">Adults<br /></span>
                                 <span style="float:left; width:150px;">Infants <br /></span>
                                 <span style="float:left; width:150px;">Children <br /></span>
                                </div>
</td>
                        </tr>
<tr>
                            <td style="text-align: right">
                                Preference</td>
                            <td>
                                 </td>
                        </tr>
<tr>
                            <td>
                               </td>
                            <td>
                                <input type="submit" value="Search" /></td>
                        </tr>
</table>
</div>
<%} %>">

then go the view page see the code in form submit

then go the model class
create you database class and property

then go Controller page create your logic

3

put into the controller class

Monday 18 February 2013

Fetch data using database in JSON form and populated with Dropdown lis

first of create you asp.net application then attach the database

then create default.aspx page then define your code fetch the data in databse in Json format

using System.Web.Script.Services;
using System.Collections.Generic;
using System.Web.Script.Serialization;
using System;
using System.Collections;
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.Web.Services;
using System.Data.SqlClient;

[WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public static string str()
    {
        
        SqlConnection con = new SqlConnection("XXXXi");   //Your connection string
        SqlCommand cmd = new SqlCommand("XXXXX", con);  // Add your query
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        List<contact> AddJson = new List<contact>();
        string JsonFormat ="";
        Contact[] contacts ={} ;
        string[] arrayCreate = { };
        loading load = new loading();
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
         
            AddJson.Add(new Contact { Name = ds.Tables[0].Rows[i]["username"].ToString() });
         
          //  AddJson.Add(JsonFormat);
        }
        
    
        return new JavaScriptSerializer().Serialize(AddJson.ToArray());

}
}

then add your aspx page using jquery

Add you jquery in header then call in function in body onload then work perfectelly