(winform)c# 怎么将datagridView1中所显示的数据导到txt文件中 我是想把从数据库查询出的数据导到txt 文件中,数据是显示在datagridview1中的。和导入txt到datagridview1中显示。不知道代码要怎么写,还请高手帮帮忙! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 关datagridview什么事?数据库查询到什么,就直接写到TXT上就是了 对数据库的,我真是一点都不懂!只知道selsect.......要怎么将查询出来的数据直接写到txt中去呢???? 二、从物理文件里读取列值到数据库表中Create table tmp_Test (ColumnName nvarchar(1000))bulk insert tmp_Test from N'C:\ttt.txt'Select * from tmp_Test Drop table tmp_Test 习惯性做法是把数据导入到excel里的 public void ExportExcel(DataSet ds) //以DataSet- 导出Excel文件 { if (ds == null) return; Microsoft.office.Interop.Excel.Application xlApp = new Microsoft.office.Interop.Excel.Application(); if (xlApp == null) { MessageBox.Show("无法创建Excel对象,可能您的机子未安装Excel", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Microsoft.office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks; Microsoft.office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.office.Interop.Excel.XlWBATemplate.xlWBATWorksheet); Microsoft.office.Interop.Excel.Worksheet worksheet = (Microsoft.office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得Sheet1 Microsoft.office.Interop.Excel.Range range; long totalCount = ds.Tables[0].Rows.Count; long rowRead = 0; float percent = 0; //worksheet.Cells[1, 1] = "报表标题"; //写入字段 for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { worksheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName; range = (Microsoft.office.Interop.Excel.Range)worksheet.Cells[1, i + 1]; range.Interior.ColorIndex = 15; range.Font.Bold = true; } //写入数值 for (int r = 0; r < ds.Tables[0].Rows.Count; r++) { for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { worksheet.Cells[r + 2, i + 1] = ds.Tables[0].Rows[r][i]; } rowRead++; percent = ((float)(100 * rowRead)) / totalCount; } xlApp.Visible = true; }贴个dataset导入到excel的代码 FileStream fs = new FileStream(@"d:\abc.txt" , FileMode.OpenOrCreate, FileAccess.Write); StreamWriter m_streamWriter = new StreamWriter(fs); m_streamWriter.BaseStream.Seek(0, SeekOrigin.End); //开始循环表格的内容for(int i=0;i<drv.rows.count();i++){m_streamWriter.WriteLine("drv[0,i]"); m_streamWriter.WriteLine("drv[n,i]"); m_streamWriter.WriteLine("\n"); }m_streamWriter.Flush();m_streamWriter.Close();fs.Close(); 我用了.....结果提示“........意外出EOF....”请问这是怎么回事啊? 可以使用数据绑定的private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e){Text1.DataBindings.Add("Text", dataGridView1.DataSource, "dataGridView1上显示的列名");或者是Text1.text=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();//e.RowIndex也获取你选中的行} C# UDP 异步接收消息 在本地添加商品添加到淘宝网上 Datagridview的一个简单问题,先到先得分 数值型数组转换成DataTable时的0处理问题。 请教,网页链接出错 关闭父窗口的问题 vs2005中如何读取gridview中选中的行的列值? 如何对结构体赋值 c# 快速马赛克处理,哪有最好的例子,如图这么快的 往水晶报表传值问题。 stuSex varchar(15)not null add constraint ck_stuSex check(stuSex like '男'or '女' ''附近有语法错误
数据库查询到什么,就直接写到TXT上就是了
要怎么将查询出来的数据直接写到txt中去呢????
bulk insert tmp_Test from N'C:\ttt.txt'
Select * from tmp_Test
Drop table tmp_Test
public void ExportExcel(DataSet ds) //以DataSet- 导出Excel文件
{
if (ds == null) return;
Microsoft.office.Interop.Excel.Application xlApp = new Microsoft.office.Interop.Excel.Application(); if (xlApp == null)
{
MessageBox.Show("无法创建Excel对象,可能您的机子未安装Excel", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Microsoft.office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
Microsoft.office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
Microsoft.office.Interop.Excel.Worksheet worksheet = (Microsoft.office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得Sheet1
Microsoft.office.Interop.Excel.Range range;
long totalCount = ds.Tables[0].Rows.Count; long rowRead = 0;
float percent = 0; //worksheet.Cells[1, 1] = "报表标题"; //写入字段
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
worksheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName;
range = (Microsoft.office.Interop.Excel.Range)worksheet.Cells[1, i + 1];
range.Interior.ColorIndex = 15;
range.Font.Bold = true;
}
//写入数值
for (int r = 0; r < ds.Tables[0].Rows.Count; r++)
{
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
worksheet.Cells[r + 2, i + 1] = ds.Tables[0].Rows[r][i];
}
rowRead++;
percent = ((float)(100 * rowRead)) / totalCount;
}
xlApp.Visible = true;
}贴个dataset导入到excel的代码
FileStream fs = new FileStream(@"d:\abc.txt" , FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter m_streamWriter = new StreamWriter(fs);
m_streamWriter.BaseStream.Seek(0, SeekOrigin.End);
//开始循环表格的内容
for(int i=0;i<drv.rows.count();i++)
{
m_streamWriter.WriteLine("drv[0,i]");
m_streamWriter.WriteLine("drv[n,i]");
m_streamWriter.WriteLine("\n");
}
m_streamWriter.Flush();
m_streamWriter.Close();
fs.Close();
我用了.....结果提示“........意外出EOF....”请问这是怎么回事啊?
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
Text1.DataBindings.Add("Text", dataGridView1.DataSource, "dataGridView1上显示的列名");
或者是
Text1.text=dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();//e.RowIndex也获取你选中的行
}