Kindly help in conversion of xls to grid

[cmrhema]

Hello,

I have converted reading xls to sqlserver successfully.


Here's the code. Now I want slight modification in the below lines, I do not want the values Created By and Created Date from excel sheet. I want to these values to be inserted from the textbox. I tried out replacing the createdby and creteddate by textbox values, but could not succeed.

bulkCopy.Column Mappings.Add("C reatedBy", "CreatedBy" );
bulkCopy.Column Mappings.Add("c reateddate", "CreatedDat e");



Kindly Help

Regards

cmrhema

{
try
{
mycon.Open();
if (chooseuser == "Single")

string fname = FileUpload.Post edFile.FileName .ToString();

string excelConnection String = @"Provider=Micr osoft.Jet.OLEDB .4.0;" "Data Source=" + fname + "; Extended Properties=Exce l 8.0;";
using (OleDbConnectio n connection = new OleDbConnection (excelConnectio nString))
{
OleDbCommand command = new OleDbCommand();
OleDbDataAdapte r dbcomm = new OleDbDataAdapte r();
string strSelectString = "Select * FROM [Sheet1$]";
command = new OleDbCommand(st rSelectString, connection);
dbcomm = new OleDbDataAdapte r(strSelectStri ng, connection);
connection.Open ();

using (IDataReader dr = command.Execute Reader())
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(myc on))
{
bulkCopy.Destin ationTableName = "ImportData ";
bulkCopy.Column Mappings.Add("C reatedBy", "CreatedBy" );
bulkCopy.Column Mappings.Add("c reateddate", "CreatedDat e");
bulkCopy.Column Mappings.Add("D ownloadDate", "DownloadDate") ;
bulkCopy.Column Mappings.Add("F ileName", "FileName") ;
bulkCopy.Column Mappings.Add("A ccountNo/ChartNo", "Acc_ChartN o");
bulkCopy.Column Mappings.Add("B illing/CaseNo", "Billing_CaseNo ");
bulkCopy.Column Mappings.Add("D OS", "DateOfService" );
bulkCopy.Column Mappings.Add("P rovider", "Provider") ;
bulkCopy.Column Mappings.Add("P atientName", "PatientNam e");
bulkCopy.Column Mappings.Add("C PT", "CPT");
bulkCopy.Column Mappings.Add("B illedAmount", "BilledAmount") ;
bulkCopy.Column Mappings.Add("C opay", "Copay");
bulkCopy.Column Mappings.Add("U sers", "Users");
bulkCopy.Column Mappings.Add("P ostingDate", "PostingDat e");
bulkCopy.WriteT oServer(dr);
}
dr.Close();
}
connection.Clos e();
}
}
}