|
How can I auto-adjust the column width using Excel Automation?
I am extract a large dataset from a DataSet object to the Excep workbook.
|
|
|
|
|
We are beginning the development of applications in Visual Studio.Net and have a number of libraries written in C++. For a number of reasons we don't want to convert these to C#. Any recommendations/references as to how best to access the C++ code from C#?
Think globally act locally.....integrate by parts
|
|
|
|
|
Go to MSDN and do a search for "P/Invoke". I don't want to frighten you off but P/Invoke isn't exactly a beginner level topic and marshalling data types across can get hairy. You need to be sure you have your .Net and C# fundementals down first before you try to bridge to other language runtimes.
-- modified at 14:57 Thursday 6th October, 2005
|
|
|
|
|
How can I insert a table into rich text box please
Nana
|
|
|
|
|
AFIK There are no out of the box method you need to deal with RTF syntax to do this look at RTF [^]
MCAD
|
|
|
|
|
how can i read data from excell file?
|
|
|
|
|
If you would just search for Excel you would already have the answer...
|
|
|
|
|
read through a datafile store the information in primary memory and sort it in ascending order using selection sort According to course code
the data file contains a sequence of records
each record consists of several data fields stored sequentially in the order given
DATA FIELD DATA TYPE
Code String
Title String
Semester Integer
Credits Integer
Level Character
Short Description String
Previous Pass Rate Double
Must write a function char *read_string(File *fp)
to read a string from a file
|
|
|
|
|
School asignment?
---
b { font-weight: normal; }
|
|
|
|
|
Beside the fact that we are not here to do your school assignments you also posted in the wrong forum. 
|
|
|
|
|
 [^]
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
I have a List of objects of type Extension. I want to search through the list looking for an Extension e where e.name = ""
How do I do this in the .NET framework? I am confused on the proper syntax.
Thanks,
Lilli
|
|
|
|
|
Okay, so you've got a list that looks like this:
List<Extension> myExtensions = new List<Extension>();
Then you'd just iterate over it and find the one where e.name == "".
foreach(Extension e in myExtensions)
{
if(e.Name == "")
{
}
}
Picture a huge catholic cathedral. In it there's many people, including a gregorian monk choir. You know, those who sing beautifully. Then they start singing, in latin, as they always do: "Ad hominem..."
-Jörgen Sigvardsson
-- modified at 17:43 Thursday 6th October, 2005
|
|
|
|
|
Hi, if you like to experiment with some cool new features in C# 2.0 i'd propose the following:
class Extension
{
public string Name;
}
class ExtensionConsumer
{
List<Extension> extensionList = new List<Extension>();
Predicate<Extension> NameIsEmpty = delegate(Extension extension)
{
return extension.Name.Trim() == "";
};
public List<Extension> CheckExtensions()
{
return new List<Extension>(Array.FindAll<Extension>(extensionList.ToArray(), NameIsEmpty));
}
}
|
|
|
|
|
How can I get the currency symbol from just the ISO 4217 standard 3-letter code.
CAD = $<br />
USD = $<br />
GBP = £<br />
YEN = ¥
I tried creating a RegionInfo by stripping out the first two characters of the 3-letter code but is doesn't work for all cases.
Any ideas?
|
|
|
|
|
Stripping the first two chars of the code doesn't work because YEN => YE, but the country is JAPAN, code JP, BTW the ISO 4217 code for YEN is JPY, no YEN.
You can use a HashTable, and fill it at start of your application, this way:
HashTable ht = new HashTable();
foreach (CultureInfo ci in CultureInfo.GetCultures( CultureTypes.AllCultures ) )
{
RegionInfo ri = new RegionInfo(ci.LCID);
ht[ri.ISOCurrencySymbol] = ri.CurrencySymbol;
}
Later you access the symbol this way:
string sym = (string) ht[isocode];
Eduardo Diaz
site | english blog | spanish blog
|
|
|
|
|
|
There is many examples about blocking socket server.
However, the unblock examples is too little.
Please give me some hints.
Thanks!
|
|
|
|
|
OK, I'm just trying to learn how to use panels. I have a panel "pnlWorkArea" and I have a user control "uctrlNewCostTracker".
I just want to write a button action that will make the user control show up in the panel (the button and the panel are both on frmMain).
This should be easy, right?
The ends can never justify the means. It is the means that determine the ends.
|
|
|
|
|
Just add the user control to the panels ControlCollection using Panel.Controls.Add
|
|
|
|
|
I do this frequently.
UcInfo = new ucInfo(this);
UcInfo.Parent = pnl01;
UcInfo.ShowLookup = false;
pnl01.Height = UcInfo.Height + 8;
UcInfo.Dock = DockStyle.Fill;
pnl01.Dock = DockStyle.Top;
...
pnl01.Visible = true;
|
|
|
|
|
Hi
I have been asked to export data from a cvs file and enter it into MSSQL database table. This export needs to be performed using a webpage. So a person would visit the web page and select a cvs files from his local drive, press a button and export will start.
Now I have no idea how CVS works and how I can take some fields from a CVS file and put them into MSSQL table.
Can anyone guide me how I can achieve this
kind regrads
|
|
|
|
|
Do you mean CVS (Concurrent Versions System), or CSV (comma separated value)? I assume the later.
There is no official standard at all regarding the format of a csv file.
Here's briefly what I have found out:
Usually it's not comma separated at all, but semicolon separated. Each data line ends with a line break, but you can't read the data line by line, as the data may also contain line breaks. The first line may or may not be column headers, and there is nothing in the file that clearly tells if it does. If data contains semicolons, quotes or line breaks, it's surrounded by quotes. Quotes inside data is written as double quotes.
You will probably want to ask for an example file to examine.
If you have MS Excel, put text in some cells, containing quotes, semicolons and line breaks. Export it as a csv file, and you have a test file with all the tricky parts of the format. You might also notice that the format that Excel exports doesn't always contain the same number of columns on all the lines.
---
b { font-weight: normal; }
|
|
|
|
|
damnnnnn...I got my post wrong.
Ies, meant to say CSV and not CVS
|
|
|
|
|
I have an assembly that is in the GAC which is using Reflection code to call a second assembly located elsewhere.
This second assembly has various dependencies, and for various reasons I dont want to GAC it or any of its dependencies.
The problem I am having is that while I can load the second assembly fine (by providing the full path to the Assembly.LoadFile(...) function, when I Invoke one of its functions I get a exception indicating that one of the dependencies cannot be found.
Is there anyway I can solves this problem without adding the second assemblies and its dependencies to the GAC??
I think the key here is the intellisense comment on the Assembly.LoadFile(...) function :
"..loading the assembly into the domain of the caller..."
Considering that the reflection code is called from an assembly in the GAC, does this mean that a virtual copy of the loaded assembly is placed into the GAC directories behind the calling assembly
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
