C#

DollieBSP wrote:

i hav jst joined wat is txtspk

var cnnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\file.xls;Extended Properties=\"Excel 8.0;HDR=No;IMEX=1\"";

select * from [Data Source=Zach-PC;Initial Catalog=master;Integrated Security=True]

select * from [SheetName$Range]

static DataTable LoadExcelSheet(string fileName, int worksheetNumber, bool headers)
{
    if (string.IsNullOrEmpty(fileName)) throw new ArgumentNullException("fileName");
    if (!File.Exists(fileName)) throw new FileNotFoundException(null, fileName);

    var cnnStr = string.Format(
        "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR={1};IMEX=1\"", 
        fileName, 
        headers ? "Yes" : "No");
    
    using (var cnn = new OleDbConnection(cnnStr))
    {
        cnn.Open();

        var schemaTable = cnn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
        
        // NB: The schema table often contains two rows per sheet;
        // you need to ignore any which end with "$":
        var sheetRow = schemaTable.AsEnumerable()
            .Where(row => !((string)row["TABLE_NAME"]).EndsWith("$"))
            .Skip(worksheetNumber).FirstOrDefault();
        
        if (sheetRow == null) throw new ArgumentException("The worksheet number provided cannot be found in the spreadsheet");

        string sql = string.Format("SELECT * FROM [{0}$]", sheetRow["TABLE_NAME"]);
        var da = new OleDbDataAdapter(sql, cnn);

        var dt = new DataTable();
        da.Fill(dt);
        return dt;
    }
}

Member 10306797 wrote:

Any suggestions?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

void fill_listbox2()
           {
           SqlConnection connection = new SqlConnection(@"Data Source=****");

           try
           {
               connection.Open();
               string Query = "SELECT * FROM myTable"
               SqlCommand command = new SqlCommand(Query, connection);
               SqlDataReader dr = command.ExecuteReader();
               while (dr.Read())
               {
                   string name = dr.GetString(1);
                   listview2.Items.Add(name);

               }
               connection.Close();
           }
           catch (Exception ex)
           {
               System.Windows.MessageBox.Show(ex.Message);
           }

       }