Comments by vidkaat (Top 148 by date)

Thanks but for some reason the numeric up down does not work I will paste the entire code.
public bool InsertIntoNewMigrateApp(DataSet ds, ref string ErrorMsg)
{

DataSet MercDetails = new DataSet();
string InsertErrorMsg = "";
using (SqlConnection c = new SqlConnection(newConn))
try
{

{
c.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = c;
if (ds.Tables[0].Rows.Count >= 1)
{

int rowcount = 0;


foreach (DataRow Dr in ds.Tables[0].Rows)
{

cmd.Parameters.Clear();

int output = 0;
String cmdText = "Insert into employees(";
cmdText = cmdText + "ID, FirstName,LastName,Company,Address1";
cmdText = cmdText + ")";
SqlCommand myCommand = new SqlCommand(cmd.CommandText, cmd.Connection);
cmd.Parameters.AddWithValue("@ID", Dr["ACCOUNTID"]);
cmd.Parameters.AddWithValue("@FirstName", Dr1["fname"]);
cmd.Parameters.AddWithValue("@LastName", Dr1["lname"]);
cmd.Parameters.AddWithValue("@Address1", Dr1["addr1"]);
try
{
output = cmd.ExecuteNonQuery();


//rowcount = rowcount + 1;

numericUpDown1.Increment = 1;
// MessageBox.Show(Convert.ToString(rowcount));





}
catch (Exception ex)
{
}
}
}

its a combo dropdowl list box.