CVS to DB Insert

ok

i got it

but problme is your cvs file not on server thats why you cant insert to database
you need to upload on server then insert

i was provide full code its perfect work for you

thanks

OK Dear,

But I have not used .net.

I have used only sql server to insert data(Excel to DB).

hello ,

you this code ,this code is recently i use and work perfect

 protected OleDbCommand ExcelConnection(string file)
    {
        System.Data.DataTable dt = null;
        //Server.MapPath("~/excel/ClientDownloadExcel1.xls");
        string serverpath = Server.MapPath("~/excel/") + file;
        // Connect to the Excel Spreadsheet
        string xConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + serverpath + ";" + "Extended Properties=Excel 8.0;";

        // create your excel connection object using the connection string
        OleDbConnection objXConn = new OleDbConnection(xConnStr);
        objXConn.Open();
        dt = objXConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

        if (dt == null)
        {
            return null;
        }
        System.Data.DataRow dr = dt.Rows[0];
        string excelSheets = dr["TABLE_NAME"].ToString();

        OleDbCommand objCommand = new OleDbCommand("SELECT * FROM [" + excelSheets + "]", objXConn);
        return objCommand;
    }
void Import_in_Database(string file)
  {
  OleDbCommand objCommand = new OleDbCommand();
  objCommand = ExcelConnection(file);

  //  create a DataReader
  OleDbDataReader reader;
  reader = objCommand.ExecuteReader();


  //  create variables for the spreadsheet columns
  //int member_id = 0;
  //int category_id = 0;

  string Despatch_Date = "";
  string AWBNo = "";
  string Sender_Name = "";
  string Sender_Address = "";
  string Sender_Mobile = "";

  string Sender_City = "";
  string Sender_PinCode = "";
  string Reciever_Name = "";
  string Reciever_Address = "";
  string Reciever_City = "";
  string Reciever_Mobile = "";
  string Receiver_PinCode = "";

  string SMS_to_Reciever = "";
  string Weight = "";
  string Air_Surface = "";


  int counter = 0;
  // used for testing your import in smaller increments

  while (reader.Read())
  {
  counter = counter + 1;
  Despatch_Date = GetValueFromReader(reader, "Despatch Date");
  AWBNo = GetValueFromReader(reader, "AWB No.");

  Sender_Name = GetValueFromReader(reader, "Sender Name");
  Sender_Address = GetValueFromReader(reader, "Sender Address");
  Sender_Mobile = GetValueFromReader(reader, "Sender Mobile");
  Sender_City = GetValueFromReader(reader, "Sender City");
  Sender_PinCode = GetValueFromReader(reader, "Sender PinCode");

  Reciever_Name = GetValueFromReader(reader, "Reciever Name");
  Reciever_Address = GetValueFromReader(reader, "Reciever Address");
  Reciever_City = GetValueFromReader(reader, "Reciever City");
  Reciever_Mobile = GetValueFromReader(reader, "Reciever Mobile");
  Receiver_PinCode = GetValueFromReader(reader, "Receiver PinCode");
  SMS_to_Reciever = GetValueFromReader(reader, " SMS  to Reciever? (y/n)");
  Weight = GetValueFromReader(reader, "Weight (Gms)");
  Air_Surface = GetValueFromReader(reader, "Air (A)/Surface (S)");

  bool res = con.insert(Despatch_Date, AWBNo, Sender_Name, Sender_Address, Sender_Mobile, Sender_City, Sender_PinCode, Reciever_Name, Reciever_Address, Reciever_City, Reciever_Mobile, Receiver_PinCode, SMS_to_Reciever, Weight, Air_Surface, Convert.ToInt32(Session["fr_id"].ToString()), Convert.ToInt32(DropDownList1.SelectedItem.Value));
  // Notice the space in the "web site" column from the Excel Spreadsheet

  }


thanks