thx
-----------------------------------------------
public void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
OleDbDataAdapter dataadapt = new OleDbDataAdapter(); DataSet ds = new DataSet(); StringBuilder sbConn = new StringBuilder();sbConn.Append(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openFileDialog1.FileName);sbConn.Append(
";Extended Properties=");sbConn.Append(
Convert.ToChar(34));sbConn.Append(
"Excel 8.0;HDR=Yes;IMEX=2");sbConn.Append(
Convert.ToChar(34)); OleDbConnection cnExcel = new OleDbConnection(sbConn.ToString());cnExcel.Open();
string exle = "select * from ["+kokon+"]";dataadapt =
new OleDbDataAdapter(exle, sbConn.ToString()); dataadapt.Fill(ds, "symbol"); this.dataGridView1.DataSource = ds; this.dataGridView1.DataMember = "symbol"; } public void button2_Click(object sender, EventArgs e){
FileStream filestr = new FileStream("mlout.xml",FileMode.OpenOrCreate,FileAccess.Write);ds.WriteXml(filestr);
}
----------------------------
Krishnaraj LPosted Jul 3, 2006, 10:25 AM
Did you add the dataset by dragging it from the Data tab of the oolBox? Give it a name and start using that object, instead of Dataset.
It should work i believe.
Let me know.
Regards
Raj