Comments by Member 10454499 (Top 14 by date)

Utility ut = new Utility();

string xls = ut.UploadData(Constants.UploadData, fleData);

string absPath = Server.MapPath("~/Uploads/" + xls);
string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;";
connectionString += "Data Source=";
connectionString += absPath + ";";
connectionString += @"Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""";

using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname = dt.Rows[0]["Table_Name"].ToString();
string query = "SELECT * FROM [" + sheetname + "]";
OleDbCommand ocmd = new OleDbCommand(query, conn);
OleDbDataReader rdr = ocmd.ExecuteReader();

//*******************************************************
string conString = Constants.CONNECTION;
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
while (rdr.Read())
{
string name = Convert.ToString(rdr[1]);
string organization = Convert.ToString(rdr[2]);
string intrestedIn = Convert.ToString(rdr[3]);
string phone = Convert.ToString(rdr[4]);
string email = Convert.ToString(rdr[5]);
string address = Convert.ToString(rdr[6]);
string city = Convert.ToString(rdr[7]);
string comments = Convert.ToString(rdr[8]);
DateTime dateofEntry = Convert.ToDateTime(rdr[9]);

using (SqlCommand cmd = new SqlCommand("insert into tblTempData values(@Name,@Organization,@IntrestedIn,@Phone,@Email,@Address,@City,@Comments,@DateOfEntry)", con))
{
cmd.Parameters.AddWithValue("@Name", SqlDbType.VarChar).Value = name;
cmd.Parameters.AddWithValue("@Organization", SqlDbType.VarChar).Value = organization;
cmd.Parameters.AddWithValue("@IntrestedIn", SqlDbType.VarChar).Value = intrestedIn;
cmd.Parameters.AddWithValue("@Phone", SqlDbType.VarChar).Value = phone;
cmd.Parameters.AddWithValue("@Email", SqlDbType.VarChar).Value = email;
cmd.Parameters.AddWithValue("@Address", SqlDbType.VarChar).Value = address;
cmd.Parameters.AddWithValue("@City", SqlDbType.VarChar).Value = city;
cmd.Parameters.AddWithValue("@Comments", SqlDbType.VarChar).Value = comments;
cmd.Parameters.AddWithValue("@DateOfEntry", SqlDbType.DateTime).Value = dateofEntry;

cmd.ExecuteNonQuery();
}
}

}
}

all string columns only their in db table sir

am allowing null values in db table, even though it is showing error sir

Thank you very much sir, It solved my problem.

Hello Syed, If i call sp inside the loop it will call sp for every id, i think its a big process and takes lot of time, Instead of that i think xml parameter is best

Thank you Sankarsan, i tried with the tip you given, but am getting error converting datatype varchar to bigint, i tired convert that string in bigint in stored procedure but i takes only first value. Please help how to solve this.

Hello Kan,
what am doing is, before uploading data in database, am binding to repeater, so for this, i created on business object class and also list for the same class.

I'm binding the data to the business objects first and then to the list, at last the list am binding to repeater.

Now what the problem is for one record it is fine, but when am submitting more than one record, the list which already contains one record of data is getting cleared, i dont want that to get cleared i want all the records in list only, its because at the time of submitting data to the database, i will use this list to send data.

while selecting webform only, their is option of checkbox to place code in separate file or not, Please check that

Why don't you use varchar instead of nvarchar, its save memory