Select the data from database using Linq to SQL

Simple query in Linq to SQL for selecting the data: try { DataBaseDataContext ZCLS = new DataBaseDataContext(new OdbcConnection(strConnection)); //execute query var result = from s in ZCLS.GroupAddresses select s; /* select new (s.ChannelNo,s.ChannelPhone,s.IPNo,s.ComputerName,s.UserName);*/ for selecting some of the fields. } catch (Exception ex) { // code yours }

Insert Data into database

Inserting data into a database is a simple process in ASP.NET.As compared to PhP and JAVA in ASP.NET there is no need to write all connection stuffs, instead only just map the connection string to application and here's the connection created,

Now today i am going to show you a demo of how to Insert Data in database using ASP.NET & SQL Server.

Consider you have a Table named Employee in database: And the form you designed is some what like this :

Employee Name:
Employee Contact:

Html Source :

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString);

     protected void Page_Load(object sender, EventArgs e)
    {
       
    }
 protected void insrtbtn_Click(object sender, EventArgs e)
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("Select EmployeeName from Employee where EmployeeName='"+txtName.Text+"'",con);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            Response.Write("Data already exist");

        }

        else
        {
            con.Close();
            con.Open();
            SqlCommand insrt = new SqlCommand("insert into Employee(EmployeeName,EmployeeContact) values('"+txtName.Text+"','"+txtcontact.Text+"')",con);
            insrt.ExecuteNonQuery();
            con.Close();
            Response.Write("Data inserted");
           
        
        }
    }
      

Hope you like this inserting data for any query regarding ASP.NET just contact me.

Instead of using Cascading Dropdown list in AJAX use LINQ

I've seen many of them are using Ajax "Cascading DropdownList" for selecting countries and states and other all .....
But the far better way is to use LINQ(Language Integrated Query) ....
Today i am going to share with you the linq query for selecting state on selection of Country dropdown....:)

Front end Image:

Developing :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    DataClassesDataContext data = new DataClassesDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            var fetch = from m in data.CountryTabs select new { m.C_ID, m.CountryName };
            DropDownList1.DataTextField = "CountryName";
            DropDownList1.DataValueField = "C_ID";
            DropDownList1.DataSource = fetch;
            DropDownList1.DataBind();
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
      
        
        var fetch = from m in data.StateTabs where m.Cntry_ID==Convert.ToInt32(DropDownList1.SelectedItem.Value) select new {m.StateName};
        DropDownList2.DataTextField = "StateName";
        DropDownList2.DataValueField = "StateName";
        DropDownList2.DataSource = fetch;
        DropDownList2.DataBind();



    }
}

Instead of using Cascading Dropdown list in AJAX use LINQ

I've seen many of them are using Ajax "Cascading DropdownList" for selecting countries and states and other all .....
But the far better way is to use LINQ(Language Integrated Query) ....
Today i am going to share with you the linq query for selecting state on selection of Country dropdown....:)

Front end Image:

Developing :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    DataClassesDataContext data = new DataClassesDataContext();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            var fetch = from m in data.CountryTabs select new { m.C_ID, m.CountryName };
            DropDownList1.DataTextField = "CountryName";
            DropDownList1.DataValueField = "C_ID";
            DropDownList1.DataSource = fetch;
            DropDownList1.DataBind();
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
      
        
        var fetch = from m in data.StateTabs where m.Cntry_ID==Convert.ToInt32(DropDownList1.SelectedItem.Value) select new {m.StateName};
        DropDownList2.DataTextField = "StateName";
        DropDownList2.DataValueField = "StateName";
        DropDownList2.DataSource = fetch;
        DropDownList2.DataBind();



    }
}

Understanding C#

Before going towards ASP.NET the use of C# or VB.NET is important.Because as i said that ASP.NET is compiled using VB.NET/C# compiler. That means these are the code behind file, in which the logic would be sustained and the ".aspx" (Active Server Page Extension)is the Source file which contains Desigining part.