注册 登录
编程论坛 → ASP.NET技术论坛

C#写代码需要从SQL中取出数据并存入TXT中并且存入的路径是网络参数，现在新建TXT都出错，望大神能帮忙解决

tatsuo 发布于 2016-11-01 12:47， 3429 次点击

C#中报错错误
1    应输入 class、delegate、enum、interface 或 struct    C:\Users\ndcsh_admin\Desktop\SAP\文档\SAP01\SAP01\MainWindow.xaml.cs    12    40    SAP01

2      应输入标识符    C:\Users\ndcsh_admin\Desktop\SAP\文档\SAP01\SAP01\MainWindow.xaml.cs    15    39    SAP01

3    应输入类型、命名空间定义或文件尾    C:\Users\ndcsh_admin\Desktop\SAP\文档\SAP01\SAP01\MainWindow.xaml.cs    16    14    SAP01
   
4    未能找到类型或命名空间名称“?Attribute”(是否缺少 using 指令或程序集引用?)    C:\Users\ndcsh_admin\Desktop\SAP\文档\SAP01\SAP01\MainWindow.xaml.cs    15    38    SAP01
代码如下
public static void ReadOrderData(string connectionString)
{
//要执行的Sql语句
　　string queryString = new SqlDataAdapter("sql查询语句", "server=服务器地址;database=数据库,user=用户名;pwd=密码");
　　using (SqlConnection connection = new SqlConnection( connectionString))
　　{
　　　　SqlCommand command = new SqlCommand( queryString, connection);
　　　　connection.Open();
    using (SqlDataReader sdr = cmd.ExecuteReader())
        {
         using (StreanmWriter sw = new StreamWriter("D:\\test.txt"))
            {
                while  (sdr.Read())
                sw.Write("\\qu" + sdr[0].ToString()):
             }   
        }
    }
}
4 回复
#2
tatsuo2016-11-01 16:11
居然需要我自问自答，这。。。。。。。。。。。。。。。。。。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace SAP01
{
    class Program
    {
        static void Main(string[] args)
        {
            //新建一个数据库连接  
            //得到一个数据库连接字符串  
            string GetConnectString = ""sql查询语句", "server=服务器地址;database=数据库,user=用户名;pwd=密码"";
            using (SqlConnection conn = new SqlConnection(GetConnectString))
            {
                conn.Open();//打开数据库  
                //Console.WriteLine("数据库打开成功!");  
                //创建数据库命令  
                SqlCommand cmd = conn.CreateCommand();
                //创建查询语句  
                = "select * from new_ecc_deliveryconfirm";
                //从数据库中读取数据流存入reader中  
                SqlDataReader reader = cmd.ExecuteReader();

                //从reader中读取下一行数据,如果没有数据,reader.Read()返回flase
                string new_name;
                //格式输出数据  
                sw = new ("D:\\Text.Txt");
                sw.AutoFlush = true;
                Console.SetOut(sw);
                while (reader.Read())
                {
                    //reader.GetOrdinal("id")是得到ID所在列的index,  
                    //reader.GetInt32(int n)这是将第n列的数据以Int32的格式返回  
                    //reader.GetString(int n)这是将第n列的数据以string 格式返回  
                    new_name = reader.GetString(reader.GetOrdinal("new_name"));
                    Console.Write("new_name:{0};\n", new_name);
                }
                sw.Close();
            }
        }
    }
}
#3
tatsuo2016-11-01 16:14
完成一半有大神能帮我解决指定路径吗
#4
tatsuo2016-11-01 21:17
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace SAP01
{
    class Program
    {
        static void Main(string[] args)
        {
            //新建一个数据库连接  
            //得到一个数据库连接字符串  
            string GetConnectString = "sql查询语句", "server=服务器地址;database=数据库,user=用户名;pwd=密码";
            using (SqlConnection conn = new SqlConnection(GetConnectString))
            {
                conn.Open();//打开数据库  
                //Console.WriteLine("数据库打开成功!");  
                //创建数据库命令  
                SqlCommand cmd = conn.CreateCommand();
                //创建查询语句  
                = "select * from new_ecc_deliveryconfirm";
                //从数据库中读取数据流存入reader中  
                SqlDataReader reader = cmd.ExecuteReader();

                //从reader中读取下一行数据,如果没有数据,reader.Read()返回flase
                string new_name;
                //格式输出数据  
                sw = new ("D:\\"+  +".Txt");
                sw.AutoFlush = true;
                Console.SetOut(sw);



                while (reader.Read())
                {

                    for (int i; i < reader.count; 1++)
                    {
                        
                         sw = new ("D:\\" + +".Txt");
                        sw.AutoFlush = true;
                        Console.SetOut(sw);
                        int flag = 0;
                        new_name = reader.GetString(reader.GetOrdinal("new_name"));

                        reader[i]
                        for (int i = 0; i < reader[i]["productid"]; i++)
                        {
                            Console.Write("new_name:{0};\n", reader[i]["productid"],flag);
                            flag += 10;
                        }
                        sw.Close();

                    }
                    //reader.GetOrdinal("id")是得到ID所在列的index,  
                    //reader.GetInt32(int n)这是将第n列的数据以Int32的格式返回  
                    //reader.GetString(int n)这是将第n列的数据以string 格式返回  
                    
                }
            }
        }
    }
}请大神能帮我继续完善吗
#5
tatsuo2016-11-03 14:27
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Threading;
using System.Data;

namespace SAP01
{
    class Program
    {
        static void Main(string[] args)
        {
            //新建一个数据库连接  
            //得到一个数据库连接字符串  
            string GetConnectString = "sql查询语句", "server=服务器地址;database=数据库,user=用户名;pwd=密码";
            using (SqlConnection conn = new SqlConnection(GetConnectString))
            {
                conn.Open();//打开数据库  
                //Console.WriteLine("数据库打开成功!");  
                //创建数据库命令  
                SqlCommand cmd1 = conn.CreateCommand();
                //创建查询语句  
                = "sql语句 ;";

                //从数据库中读取数据流存入reader中  
                SqlDataReader reader = cmd1.ExecuteReader();
                定义 需要字段1
                while (reader.Read())
                {
                    需要字段1 = reader.GetString(reader.GetOrdinal("需要字段1"));
                }
                reader.Close();

                = "sql语句2";
        定义 需要字段2
                //格式输出数据  
                SqlDataReader reader2 = cmd1.ExecuteReader();
                while (reader2.Read())
                {
                    //reader.GetOrdinal("id")是得到ID所在列的index,  
                    //reader.GetInt32(int n)这是将第n列的数据以Int32的格式返回  
                    //reader.GetString(int n)这是将第n列的数据以string 格式返回  
                    需要字段2 = reader2.GetString(reader2.GetOrdinal("需要字段2"));
                     sw = new (需要字段1+"\\" 需要字段2 ".txt");
                    sw.AutoFlush = true;
                    Console.SetOut(sw);               
                    Console.Write("{0}\t{1}\t", 需要字段1，需要字段2);
                    }
                    sw.Close();
                }
            }
            while (true)
            {
                Thread.Sleep(3000000);//每五分钟循环输出
            }
        }
    }
}
最新理解写的模板与大家分享欢迎指出错误
1
©2025, BC-CN.NET
电脑版