1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
| using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace IMM.GridViews
{
public partial class Grid_view_for_test : System.Web.UI.Page
{
private string strcon = WebConfigurationManager.ConnectionStrings["MI_SLBConnectionString"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
}
private void EndEditing()
{
Response.Redirect("Grid_view_for_test.aspx");
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
public string Serv_OnHand { get; set; }
protected void testm_Text(object sender, EventArgs e)
{
}
protected void Gridview1_ItemUpdating(object sender, GridViewEditEventArgs e)
{
}
protected void Button2_OnClick(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(strcon);
SqlCommand cmd = new SqlCommand("Select * from Kits", con);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
con.Open();
adp.Fill(ds, "Kits");
con.Close();
foreach (DataRow r in ds.Tables["Kits"].Rows)
{
SqlConnection con2 = new SqlConnection(strcon);
SqlCommand cmd2 = new SqlCommand("Insert into TableSL (Part_No, Description, SL_No, Eq_Description, Serv_OnHand, Serv_Lev) values(@Part_No, @Description,@SL_No, @Eq_Description, @Serv_OnHand, float.parse(testm.Text)*int.parse(Serv_OnHand)", con2);
con2.Open();
cmd2.Parameters.AddWithValue("@Part_No", r["Part_No"]);
cmd2.Parameters.AddWithValue("@Description", r["Description"]);
cmd2.Parameters.AddWithValue("@SL_No", r["SL_No"]);
cmd2.Parameters.AddWithValue("@Eq_Description", r["Eq_Description"]);
cmd2.Parameters.AddWithValue("@Serv_OnHand", r["Serv_OnHand"]);
cmd2.Parameters.AddWithValue("@float.parse(testm.Text)*int.parse(Serv_OnHand", r["Serv_Lev"].ToString());
cmd2.ExecuteNonQuery();
con2.Close();
}
GridView2.DataBind();
}
}
} |
Partager