2
Answers

C#

Photo of maliya rama

maliya rama
12y
1.5k
1
how to insert values into database using c#?

Answers (2)

0
Photo of Arun Kurmi
NA 104 105.5k 12y
hi,maliya rama
this is simple......
Note-suppose you want to add name and age in database in windows application.
follow following steps-


1.Create a database table having to columns as :name and age.
2.design a window form with 2 textbox(1 for name and another for age), 1 button and a lable.
3.add name space: using System.Data.SqlClient;
4.code on button :
            string strInsert = "Insert into insertTable([name],[age])values";
            strInsert = strInsert + "('" +textBox1.Text + "', "+textBox2.Text + ")";
            //MessageBox.Show("Query is:" + strInsert);


            SqlConnection con = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ArunDB;Integrated Security=True;Pooling=False");
//this is different for you.
//copy connection string form your database and paste here
//goto database >rightclick>property>copy connection string and paste here
            con.Open();
            SqlCommand cmd = new SqlCommand(strInsert, con);
            int x = cmd.ExecuteNonQuery();
            label1.Text = "Rows inserted are:" + x;
            con.Close();

----------------------------------------------
This is my first reply please give your feedback.
And also welcome suggestion from you and other members.

0
Photo of Satyapriya Nayak
NA 39.3k 13.3m 12y

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Radio_button_values._Default" %>

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <table align="center">

            <tr>

                <td colspan="2">

                    <h3>

                         Registraion</h3>

                </td>

            </tr>

            <tr>

                <td>

                    Name:</td>

                <td>

                    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    Email</td>

                <td>

                    <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    Gender</td>

                <td>

                    <asp:RadioButtonList ID="rbtGender" runat="server" RepeatDirection="Horizontal">

                        <asp:ListItem>Male</asp:ListItem>

                        <asp:ListItem>Female</asp:ListItem>

                    </asp:RadioButtonList>

                </td>

            </tr>

            <tr>

                <td align="center"  colspan="2">

                    <asp:Button ID="btn_register" runat="server"  Text="Register"

                        onclick="btn_register_Click" />

 

                </td>

            </tr>

            <tr>

                <td align="center"  colspan="2">

                    <asp:Label ID="lblmsg" runat="server"></asp:Label>

                </td>

            </tr>

        </table>

    </div>

    </form>

</body>

</html>

 

 

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.Data.SqlClient;

namespace Radio_button_values

{

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

    {

        string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        SqlCommand com;

 

        protected void btn_register_Click(object sender, EventArgs e)

        {

 

            SqlConnection con = new SqlConnection(strConnString);

            com = new SqlCommand();

            com.Connection = con;

            com.CommandType = CommandType.Text;

            com.CommandText = "insert into login values(@Name,@Email,@Gender)";

            com.Parameters.Clear();

            com.Parameters.AddWithValue("@Name", txtName.Text);

            com.Parameters.AddWithValue("@Email", txtEmail.Text);

            com.Parameters.AddWithValue("@gender", rbtGender.SelectedValue);

            if (con.State == ConnectionState.Closed)

                con.Open();

            com.ExecuteNonQuery();

            con.Close();

            lblmsg.Text = "Data entered successfully!!!";

 

        }

    }

}

Next Recommended Forum