c# sqlserver连接字符串

odbc：

string cnnstring = @"Driver={SQL Server Native Client 11.0};Initial Catalog = sxquadb;server=服务器ip;uid=账号;pwd=密码;app=hawk;wsid=D0r2";

cnnString = @"Data Source = 10.252.21.8; Initial Catalog = sxquadb; User ID = sx00052; password=Cw8569*";

 

public static bool ExportToExcel_ByQueryTable()

        {

            bool _bl = false;

            excel.Application xlApp = new excel.Application();

            excel.Workbook wk = xlApp.Workbooks.Add(excel.XlWBATemplate.xlWBATWorksheet);

            excel.Worksheet sht = wk.Worksheets[1];

            xlApp.Visible = true;

           // string cnnstring = @"Driver={SQL Server Native Client 10.0};Data Source = 191.251.21.2; Initial Catalog = pub; User ID =账号; password=密码;

            string cnnstring = @"Driver={SQL Server Native Client 11.0};server=191.251.21.2;uid=账号;pwd=密码app=hawk;wsid=ww";

            //OdbcConnection cnn = new OdbcConnection(cnnstring);

            //cnn.Open();

            cnnstring = "ODBC;" + cnnstring;

           try

           {

                string sqlstr = "select * from inspection_record";

                excel.QueryTable qt = sht.QueryTables.Add(cnnstring, sht.Range["A1"], sqlstr);

                qt.MaintainConnection = false;

                qt.SavePassword = false;

                qt.RefreshOnFileOpen = false;

                qt.SaveData = true;

                qt.BackgroundQuery = false;

                qt.EnableRefresh = false;

                qt.Refresh();

 

                //删除ODBC连接信息，不能刷新

                for (int i = 1; i <= wk.Connections.Count; i++)

                { wk.Connections[i].Delete(); }

 

            }

            catch(Exception ex)

            {

                Docmd.msgInfo(ex.Message );

            }

            return _bl;

        }

 

c# 用queryTable导出数据：

               string sqlstr = "select * from inspection_record";
                excel.QueryTable qt = sht.QueryTables.Add("ODBC;" + cnnstring, sht.Range["A1"], sqlstr);

 

转载于:https://www.cnblogs.com/3xin/p/8136446.html