Multiple checkbox insert using Asp.net?

Hey guys,

 This blogs we explain how to insert multiple selected checkbox value into database using asp.net.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["123"].ConnectionString);

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

       string checkit = "";

       

       for (int i = 0; i < chk1.Items.Count - 1; i++)

       {

           if (chk1.Items[i].Selected == true)

           {

               checkit = checkit + chk1.Items[i].Text + ",";

           }

       }

      

        try

        {

            SqlCommand cmd = new SqlCommand();

            string ins;

            ins = "Insert into checkme values('" + txtId.Text + "', '" + checkit + "')";

            cmd = new SqlCommand(ins, con);

            con.Open();

            cmd.ExecuteNonQuery();

            con.Close();

            lblMsg.Text = "Successfully insert data";

        }

        catch (Exception er)

        {

            lblMsg.Text = er.Message;

        }

   

    }

}

Insert data using stored procedure in linq to sql query:-

Hey guys,

This blog we discuss how to write insert code in asp.net using stored procedure linq to sql query.

Create a table like

Id , Name, City three columns

Create stored procedure like:-

create procedure storedata

(@Id int,

@Name varchar(50),

@City varchar(50)

)

as

begin

insert into mydata(Id ,Name ,City)values(@Id,@Name,@City)

end

protected void btnSubmit_Click(object sender, EventArgs e)

    {

        try

        {

            using (storeDataContext mystore = new storeDataContext())

            {

                mystore.storedata(Convert.ToInt32(txtid.Text), txtname.Text, txtcity.Text);

            }

            lblMsg.Text = "Successfully insert data";

        }

        catch (Exception er)

        {

            lblMsg.Text = er.Message;

        }

    }

Difference between Datacontractserialization and xmlserialization in WCF:-

DataContractSerializer	XmlSerializer
Best when we want to serialize some of the properties in object. It uses Opt-In approach. It means we have to explicitly specify which properties need to be serialized	Best when we want to serialize most of the properties in object. It used Opt-out approach. It means we have to explicitly specify which properties you don't want to serialize
It can serialize not only properties but also fields. It can also serialize nonpublic members It can serialize properties with only Get Accessor	It can only serialize public properties which must have both Get and Set Accessor.
Faster	Slower compare to DataContractSerializer
It can only work in WCF	It can work for WCF and Webservices (asmx)

Left and right outer join using linq to sql query in asp.net?

Hi guys ,

 This blog we will explain how to write left and right outer join query using linq to sql.

// left outer join code --------------

var leftselect = from stu in dt.students

                         join cou in dt.Courses

                         on stu.SId equals cou.CId into jid

                         from cou in jid.DefaultIfEmpty()

                         select new

                         {

                             studentid = stu.SId,

                             sname = stu.SName,

                             Cname = cou.CName

                         };

        GridView1.DataSource = leftselect;

        GridView1.DataBind();

// right outer join code --------------

       // ........................................

        var rightselect = from cou in dt.Courses

                          join stu in dt.students

                           on cou.CId equals stu.SId into sturight

                          from stu in sturight.DefaultIfEmpty()

                          select new

                          {

                              cou.CId,

                              cou.CName,

                              cou.Duration,

                              

                              stu.SCity

                          };

Inner join using linq to sql query in asp.net?

Hi guys ,

 This blog we will explain how to write join query using linq to sql.

protected void Page_Load(object sender, EventArgs e)

    {

        selectjoinDataContext dt = new selectjoinDataContext();

        //inner join code

        //--------------------

        var selectme = from stu in dt.students

                       join cou in dt.Courses

                       on stu.SId equals cou.CId

                       select new

                       {

                           StudentID = stu.SId,

                           SName = stu.SName,

                           CName = cou.CName

                       };

        GridView1.DataSource = selectme;

        GridView1.DataBind();

Gridview update code using asp.net with c#?

Hey guys,

 This blog we discuss how to update Gridview data using asp.net.

First create a like table name here is sanemp

EmpId, Name,City

Gridgrid.aspx page code:-

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">

            <Columns>

               <asp:TemplateField HeaderText="EmpId">

                   <ItemTemplate>

                    <asp:Label ID="Empid" runat="server" Text='<%#Eval("EmpId") %>'></asp:Label>

                   </ItemTemplate>

                 

               </asp:TemplateField>

                <asp:TemplateField HeaderText="Name">

                    <ItemTemplate>

                        <%#Eval("Name") %>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:TextBox ID="txtname" runat="server" Text='<%#Eval("Name") %>'></asp:TextBox>

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="City">

                    <ItemTemplate>

                        <%#Eval("City") %>

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:DropDownList ID="ddlcity" DataTextField="City" DataSource='<%#Fetchdata("City") %>' runat="server"></asp:DropDownList>

                    </EditItemTemplate>

                </asp:TemplateField>

                <asp:TemplateField HeaderText="Edit">

                    <ItemTemplate>

                        <asp:ImageButton ID="editit" ImageUrl="~/Images/edit_it.jpg" runat="server" Height="30" Width="30" CommandName="Edit" />

                    </ItemTemplate>

                    <EditItemTemplate>

                        <asp:ImageButton ID="cancelit" ImageUrl="~/Images/cancel.jpg" runat="server" Height="30" Width="30" CommandName="Cancel" />

                    <asp:ImageButton ID="updateit" ImageUrl="~/Images/up.jpg" runat="server" Height="30" Width="30" CommandName="Update" />

                    </EditItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

Code behind page  page :-

Gridgrid.aspx.cs file code

public partial class gridgrid : System.Web.UI.Page

{

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["sai"].ConnectionString);

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            bindbind();

        }

    }

    protected void bindbind()

    {

        SqlDataAdapter sdr = new SqlDataAdapter("select * from sanemp", con);

        SqlCommand cmd = new SqlCommand();

        DataSet ds = new DataSet();

        sdr.Fill(ds);

        GridView1.DataSource = ds;

        GridView1.DataBind();

    }

    public SqlDataReader Fetchdata(string ss)

    {

        con.Open();

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = con;

        cmd.CommandText = "select * from sanemp";

        SqlDataReader sr;

        return

            sr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        Label lbl = (Label)GridView1.Rows[e.RowIndex].FindControl("Empid");

        int myid = Convert.ToInt32(lbl.Text);

        TextBox txt1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtname");

        DropDownList ddl12 = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlcity");

        SqlCommand cmd = new SqlCommand();

        cmd.Parameters.Add(new SqlParameter("@EmpId", SqlDbType.Int)).Value = myid;

        cmd.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar, 50)).Value = txt1.Text;

        cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.VarChar, 50)).Value = ddl12.SelectedItem.Value.ToString();

      

            con.Open();

            cmd = new SqlCommand("Update sanemp set Name ='" + txt1.Text + "' , City ='" + ddl12.SelectedItem.Value + "' where EmpId ='" + myid + "'", con);

            cmd.ExecuteNonQuery();

            con.Close();

            GridView1.EditIndex = -1;

            bindbind();

      

    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

    {

    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        GridView1.EditIndex = e.NewEditIndex;

        bindbind();

    }

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        GridView1.EditIndex = -1;

        bindbind();

    }

}