private void Uploaddata(string strConn, string[] columnNames, string strProcedure)
{
try
{
DataTable dataTableForTheAdapter = new DataTable();
DataTable dtNew = new DataTable();
string commaSepColumns = string.Empty;
foreach (string strColumn in columnNames)
{
commaSepColumns = commaSepColumns + "," + strColumn;
dtNew.Columns.Add(strColumn, typeof(String));
}
commaSepColumns = commaSepColumns.Substring(1, commaSepColumns.Length - 1);
DataSet myDataSet = new DataSet();
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT " + commaSepColumns + " FROM [Sheet1$]", strConn);
myCommand.Fill(dtNew);
int j = 0;
if (dtNew.Rows.Count > 0)
{
string consString = getSqlConnectionstring();
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand(strProcedure))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@tblCustomers", dtNew);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
lblDispMsg.Text = "Master data uploaded successfully.";
}
}
}
else
{
lblDispMsg.Text = "Master data not uploaded as Data is not proper in Excel.";
}
}
catch (Exception ex)
{
lblDispMsg.Text = "Error in File Upload.<br/>" + Convert.ToString(ex.Message);
}
}
{
try
{
DataTable dataTableForTheAdapter = new DataTable();
DataTable dtNew = new DataTable();
string commaSepColumns = string.Empty;
foreach (string strColumn in columnNames)
{
commaSepColumns = commaSepColumns + "," + strColumn;
dtNew.Columns.Add(strColumn, typeof(String));
}
commaSepColumns = commaSepColumns.Substring(1, commaSepColumns.Length - 1);
DataSet myDataSet = new DataSet();
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT " + commaSepColumns + " FROM [Sheet1$]", strConn);
myCommand.Fill(dtNew);
int j = 0;
if (dtNew.Rows.Count > 0)
{
string consString = getSqlConnectionstring();
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand(strProcedure))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@tblCustomers", dtNew);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
lblDispMsg.Text = "Master data uploaded successfully.";
}
}
}
else
{
lblDispMsg.Text = "Master data not uploaded as Data is not proper in Excel.";
}
}
catch (Exception ex)
{
lblDispMsg.Text = "Error in File Upload.<br/>" + Convert.ToString(ex.Message);
}
}
No comments:
Post a Comment