|
What you did?
You have create a class library. Build that library. From another project Add that dll as Reference. Now you want to use it?
Did you add using exception ?
|
|
|
|
|
No i din't added using exception..
How to do that ?? i din't get add using exception?
Could You Expalin me in Detail..
|
|
|
|
|
what is the namespace name of your class library?
|
|
|
|
|
Hi,
I need to import data from a CSV file to an SQL table i have used tohe following in the past to import an excel file but wondered if/how i can adapt it to import from a CSV.
Also, it would be a great help if you could show me how to convert it to use column mapping.
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\qs_upload.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand("Select * FROM [quality_standard$]", connection);
connection.Open();
using (OleDbDataReader dr = command.ExecuteReader())
{
string sqlConnectionString = "Data Source=wibblewobble.com;Initial Catalog=comfound;Persist Security Info=True;User ID=##########;Password=##########";
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "tbl_QualityStandard";
bulkCopy.WriteToServer(dr);
}
}
}
Thanks!
|
|
|
|
|
Hi,
I want to read an xls file and import data in dataset. This xls file is a system generated tab delimited file. Using below code I am getting "External table is not in the expected format" exception.
If I open the same file in excel and save it in correct excel format this piece of code works fine.
public static void ReadExcelFileData()
{
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='Excel 8.0;HDR=Yes;IMEX=1;FMT=TabDelimiter'";
// Establish Connection
_connExcel = new OleDbConnection(connectionString);
_cmdExcel = new OleDbCommand();
_cmdExcel.Connection = _connExcel;
try
{
//Accessing Excel Sheet
_connExcel.Open();
//Code to read excel file
}
catch (Exception ex)
{
throw ex;
}
}
}
}
}
I tried to modify the connectionstring as given below,But it also gave me "c:\Test.xls is not a valid path" error
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\Test.xls;Extended
Properties='text;HDR=Yes;IMEX=1;FMT=TabDelimiter'";
If anybody had faced such problem earlier, Please let me know the solution implemented by you.
Thanks & Regards,
Deepak
|
|
|
|
|
A tab delimited file is NOT an excel spreadsheet, whatever you use for an file extension, so it will be in the wrong format. You can read it in many ways, its just a series of fields delimited by a tab.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hello
is there such thing as 32bit or 64bit Visual Studio? I know there're two version of ASP.NET - 32bit and 64 bit. But are there two versions of VS?
Alternatively, is there ... a build or compile option that lets you decide whether you intend to build targeted 32 bit or 64 bit ASP.NET?
Thanks
dev
|
|
|
|
|
devvvy wrote: a build or compile option that lets you decide whether you intend to build targeted 32 bit or 64 bit ASP.NET?
like this[^]
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
devvvy wrote: STEP 2. deploy binary to a Windows 2003 64bit with IIS registered to 32bit ASP.NET
No, for 64bit OS you have to registered with 64 bit Framework.
|
|
|
|
|
hum... for some reason Xenapp Web Interface actually worked on 64 bit Windows with IIS registered against 32 bit ASP.NET (I think you can actually do that but I'm ... contradicting my earlier statement am I not?)
dev
|
|
|
|
|
|
devvvy wrote: check this out
http://aboutmeadows.com/articles/how-to-enable-32-bit-asp.net-on-windows-server-2003.aspx[^]
Devvy,Thanks for the link.
|
|
|
|
|
no problem
but I'm still confused..
See the link I sent, you can in fact run 32bit ASP.NET under 64 bit Windows (but ASP.NET tab missing on IIS/MMC snapin - not sure if this means there could be problem ...)
Can you use /platform:x86 (does this means 32bit?) to compile your asp.net project to 32bit and run on 64bit windows with 32bit asp.net registered with IIS?
dev
|
|
|
|
|
|
devvvy wrote: is there such thing as 32bit or 64bit Visual Studio? I know there're two version of ASP.NET - 32bit and 64 bit. But are there two versions of VS?
There are two version of .NET Framework one for 32 Bit and another for 64 Bit OS. If you have both the version installed in your system and your OS is 64 bit then 64bit Framework should be used. As for example if you want register IIS with asp.net the you have to run aspnet_regiis command from 64 bit folder.
|
|
|
|
|
Thanks - say if you have 64 Windows, 64 bit will be the default target platform if you compile your ASP.NET project under VS. Can you optionally compile to 32 bit platform though?
dev
|
|
|
|
|
these are not finding in my webpage..i am trying to add System.web.dll..i couldn't see that name...
i checked by rightclicking project and add reference..there also i din't find tht assembly..
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
The type or namespace name 'Security' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)
can anyone answer???
|
|
|
|
|
System.Security[^] is a seperate assembly which you need to add.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Manas, how does System.Security will add the namespace System.Web.Security??
|
|
|
|
|
Belive me I wasn't drinking while posting this.
Somehow, only read Security and came to conclusion. My ignorance.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Manas Bhardwaj wrote: Belive me I wasn't drinking while posting this.
|
|
|
|
|
Add System.Web.dll from Add References . You will find the dll at the Framework Directory.
If your .NET 2.0 installed in C:\Windows\Microsoft.NET\Framework\<V2.0.X.X>
add that dll, then try
|
|
|
|
|
hey i can find System.Web.dll in C:\Windows\Microsoft.NET\Framework\..how to add to my project..i have to copy tht dll file and paste it somewhere in my project..
|
|
|
|
|
mahichandu wrote: hey i can find System.Web.dll in C:\Windows\Microsoft.NET\Framework\..how to add to my project..
In your project. Right click and select "Add Reference..."
A dialog will pop up (usually after some seconds - It is quite slow at starting)
In the .NET tab look in the list for System.Web or System.Security (what ever you are trying to add) and hit Okay.
Man who stand on hill with mouth open wait long time for roast duck to drop in
|
|
|
|