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

Question

I have two table Table1 and Table 2 Table 1 I have 4 columns, Table 2 I have 5 columns when I insert 5 column data to Table2 that time I retrieve Table1 4 columns data and insert Table2 when I click the submit button. its like retrieve data from 1 table insert into another table Please Help me...

Code Alone · 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 jekin · Answer

thank u both I got the solution Pradeepa and Jenith Thakkar Front End function onlyAlphabets(e, t) { try { if (window.event) { var charCode = window.event.keyCode; } else if (e) { var charCode = e.which; } else { return true; } if ((charCode > 64 && charCode 96 && charCode return true; else return false; } catch (err) { alert(err.Description); } } 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 Thakkar · Answer

Apply this kind of sql query on submit INSERT INTO table2 (column1, column2, column3, column4, column5) SELECT column1, column2, column3, column4, Null FROM table1