如何传递连接字符串的参数 [英] How to Pass Parameter for Connection String

问题描述

嗨！

我必须使用Diffrent Location中的Excel，而不是Fix Location.Like C:\ Details.xls.

Hi !

I have to use Excel from Diffrent Location not Fix Location.Like C:\Details.xls.

string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Details.xls;Extended Properties=""Excel 8.0;HDR=YES;""";

我正在尝试但没用---
字符串FPath ="C:\ Details.xls";

I am trying but not work ---
string FPath = "C:\Details.xls";

string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+ FPath  +";Extended Properties=""Excel 8.0;HDR=YES;""";

请更正.

当我在下面使用Paramereized Code时，它工作正常(从TextBox传递数据库路径)---
字符串str =插入测试SELECT * FROM OPENROWSET("Microsoft.Jet.OLEDB.4.0"，''Excel 8.0; Database ="+ txtPath.Text +"''，''SELECT * FROM [Details $] '');

Please Correct it.

As I am using Paramereized Code below, it is working Fine(Database path passing from TextBox) ---
string str = "INSERT INTO Test SELECT * FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=" + txtPath.Text + "'', ''SELECT * FROM [Details$]'')";

推荐答案

'')";

应该

Shouldn''t

string FPath = "C:\Details.xls";

be

be

string FPath = @"C:\Details.xls";

?

欢呼

?

Cheers

在双引号前加上一个"@"字符:

Stick an ''@'' character in front of the double quotes:

string FPath = @"C:\Details.xls";

假设"\ D"是一个转义字符，这将停止C#编译器...

That stops the C# compiler assuming "\D" is a single escaped character...

这篇关于如何传递连接字符串的参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！