Retrieve data insert into another table using C# Asp.Net

thank u both

I got the solution Pradeepa and Jenith Thakkar

Front End

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

ADD Employee

Name :

Place :

DOB :

Age :

Submit

Code behind

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

protected void Page_Load(object sender, EventArgs e)

{

gridbind();

}

protected void username_TextChanged(object sender, EventArgs e)

{

if (!System.Text.RegularExpressions.Regex.IsMatch(username.Text, "^[a-zA-Z ]"))

{

Response.Write(""); username.Text.Remove(username.Text.Length - 1);

username.Text = "";

}

protected void Place_TextChanged(object sender, EventArgs e)

{

if (!System.Text.RegularExpressions.Regex.IsMatch(Place.Text, "^[a-zA-Z ]"))

{

Response.Write(""); Place.Text.Remove(Place.Text.Length - 1);

Place.Text = "";

}

protected void DOB_TextChanged(object sender, EventArgs e)

{

DateTime agecal;

DateTime now;

int result;

now = DateTime.Now;

agecal = Convert.ToDateTime(DOB.Text);

result = now.Year - agecal.Year;

age1.Text = Convert.ToString(result);

}

protected void gridbind()

{

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

con.Open();

string query = "select * from gly";

SqlDataAdapter da = new SqlDataAdapter(query, con);

DataSet ds = new DataSet();

da.Fill(ds);

gridview1.DataSource = ds;

gridview1.DataBind();

}

protected void LinkButton1_Click(object sender, EventArgs e)

{

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

Dataset ds = new Dataset();

con.Open();

SqlCommand cmd = new SqlCommand("testing", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Name", username.Text);

cmd.Parameters.AddWithValue("@Place", Place.Text);

cmd.Parameters.AddWithValue("@Dob", DOB.Text);

cmd.Parameters.AddWithValue("@ag", age1.Text);

cmd.ExecuteNonQuery();

con.Close();

gridbind();

adddata.Visible = false;

griddata.Visible = true;

username.Text = ""; Place.Text = ""; DOB.Text = ""; age1.Text = "";

}

protected void createemp_Click(object sender, EventArgs e)

{

adddata.Visible = true; griddata.Visible = false;

}

protected void LinkButton2_Click(object sender, EventArgs e)

{

adddata.Visible = false; griddata.Visible = true;

username.Text = ""; Place.Text = ""; DOB.Text = ""; age1.Text = "";

}

create table emp

(

id int identity(1,1) not null,

name1 nvarchar(100),

place nvarchar(100),

dob nvarchar(100),

age nvarchar(100)

)

create procedure emp1

(

@name nvarchar(100),

@place nvarchar(100),

@dob nvarchar(100),

@age nvarchar(100)

)

as begin

insert into emp values (@name, @place,@dob,@age)

end

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Code Alone8y ago
Accepted answer
Hi Viru,
Apply the sql procedure or query to insert the data into table 2 without fetching table1 data on page. This is best approach. Use below query :
INSERT INTO Table2 (col1, col2, col3, col4, col5)
SELECT col, col2, col3, col4, '' FROM Table1
virupakshi jekin8y ago
thank u both
I got the solution Pradeepa and Jenith Thakkar

Front End

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

ADD Employee

Name :
Place :
DOB :

Age :

Submit
Close

Code behind

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

protected void Page_Load(object sender, EventArgs e)
{
gridbind();
}
protected void username_TextChanged(object sender, EventArgs e)
{
if (!System.Text.RegularExpressions.Regex.IsMatch(username.Text, "^[a-zA-Z ]"))
{
Response.Write(""); username.Text.Remove(username.Text.Length - 1);
username.Text = "";
}
}
protected void Place_TextChanged(object sender, EventArgs e)
{
if (!System.Text.RegularExpressions.Regex.IsMatch(Place.Text, "^[a-zA-Z ]"))
{
Response.Write(""); Place.Text.Remove(Place.Text.Length - 1);
Place.Text = "";
}
}
protected void DOB_TextChanged(object sender, EventArgs e)
{
DateTime agecal;
DateTime now;
int result;
now = DateTime.Now;
agecal = Convert.ToDateTime(DOB.Text);
result = now.Year - agecal.Year;
age1.Text = Convert.ToString(result);
}
protected void gridbind()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dd"].ConnectionString);
con.Open();
string query = "select * from gly";
SqlDataAdapter da = new SqlDataAdapter(query, con);
DataSet ds = new DataSet();
da.Fill(ds);
gridview1.DataSource = ds;
gridview1.DataBind();
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dd"].ConnectionString);
Dataset ds = new Dataset();
con.Open();
SqlCommand cmd = new SqlCommand("testing", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", username.Text);
cmd.Parameters.AddWithValue("@Place", Place.Text);
cmd.Parameters.AddWithValue("@Dob", DOB.Text);
cmd.Parameters.AddWithValue("@ag", age1.Text);
cmd.ExecuteNonQuery();
con.Close();
gridbind();
adddata.Visible = false;
griddata.Visible = true;
username.Text = ""; Place.Text = ""; DOB.Text = ""; age1.Text = "";
}
protected void createemp_Click(object sender, EventArgs e)
{
adddata.Visible = true; griddata.Visible = false;
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
adddata.Visible = false; griddata.Visible = true;
username.Text = ""; Place.Text = ""; DOB.Text = ""; age1.Text = "";
}
}
}

create table emp
(
id int identity(1,1) not null,
name1 nvarchar(100),
place nvarchar(100),
dob nvarchar(100),
age nvarchar(100)
)
create procedure emp1
(
@name nvarchar(100),
@place nvarchar(100),
@dob nvarchar(100),
@age nvarchar(100)
)
as begin
insert into emp values (@name, @place,@dob,@age)
end
Jenith Thakkar8y ago
Apply this kind of sql query on submit

INSERT INTO table2 (column1, column2, column3, column4, column5)
SELECT column1, column2, column3, column4, Null
FROM table1