|
Every morning, we receive an excel file from our client which needs to be opened and read by our application. The problem however, is the filename of this excel file differs every morning (the filename represents the exact time in milliseconds when our client generated their file on each day). If the filename was consistent, I would have no problem opening it, however since the name is never the same, I don't know how to programatically open it.
This file is stored in a directory by itself (the prior days file is moved to a different directory).
So does anyone know how to open this file without knowing the filename?
Thanks.
-Goalie35
|
|
|
|
|
Directory.GetFiles will tell you what is there.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Yes chris is right. You know all the prior files would be moved to different directory. so use that function to get the files in that directory,and open the file which is having .xls extension (i hope there will be one file in that directory)
Thanks
Srini
|
|
|
|
|
I'm new at this and am having a problem. I have a one dimensional array with a group of fields filled and need to extract the information in them and list how many times they were used. 
Example 1:
int[] numbers = new int[30] {1, 3, 5, 2, 4, 6, 6, 4, 9, 1, 5, 5, 3}
I need to be able to do the following:
Numb // Amount
used: // used:
1 // 2
2 // 1
3 // 2
4 // 2
5 // 3
6 // 2
9 // 1
Can anyone point me in the right direction for the information on how to do this. Any and All help will be appreciated.  ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
OK, I guess the way to do this, is to use for each to step over your array, and set up a counter for each number you want to track. There are a few ways of doing this, they would include:
create a new array that has the number of elements equal to the highest number in your list, it's an array of numbers, and you set them to 0, and for example, if you find the number 5, you set newArray[5] to be one greater than it was.
Create a struct like this
struct numbers
{
int value;
int times;
}
Then, you create an array of these structs and you find the right one to increment times by.
( the next one is the best )
Dictionary<int, int> times = new Dictionary<int, int>(); // A dictionary is an associative array, we are using numbers, but we can store anything
foreach(int n in numbers)
{
if (!times.KeyExists(n))
{
// Add a key to the dictionary
times[n] = 0;
}
++times[n];
}
Then you can iterate over the keys and use the values to see how many times each one exists.
I suspect this is homework. If it is, then you should do some reading on how the dictionary container works, so you fully understand it. Otherwise, you won't be able to turn the above into code that fully works, nor will you be able to withstand the scrutiny of your teacher when she asks why you did it this way.
-- modified at 18:59 Monday 2nd April, 2007
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I need to remove all comments ( between tags) from XML string.
I tried the following code but comments are still present.
How to remove comments ?
string RemoveComments(string sDoc) {
XmlDocument xDoc = new XmlDocument();
xDoc.PreserveWhitespace = false;
xDoc.LoadXml(sDoc);
StringWriter sw = new StringWriter();
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.IndentChar = ' ';
xtw.Indentation = 2;
xtw.Formatting = Formatting.Indented;
xDoc.WriteContentTo(xtw);
xtw.Close();
sw.Close();
return sw.ToString();
}
Andrus
|
|
|
|
|
Pseudo code but it should give you an idea
XPathNavigator nav = xDoc.CreateNavigator();
while(nav.MoveToNext(XPathNodeType.Comment))
{
}
only two letters away from being an asset
|
|
|
|
|
Thank you.
I tried the folowing code but comments are still present.
What I'm doing wrong.
string RemoveComments(string sDoc) {
XmlDocument xDoc = new XmlDocument();
xDoc.PreserveWhitespace = false;
xDoc.LoadXml(sDoc);
XPathNavigator nav = xDoc.CreateNavigator();
while (nav.MoveToNext(XPathNodeType.Comment)) {
nav.DeleteSelf();
}
StringWriter sw = new StringWriter();
XmlTextWriter xtw = new XmlTextWriter(sw);
xtw.IndentChar = ' ';
xtw.Indentation = 2;
xtw.Formatting = Formatting.Indented;
xDoc.WriteContentTo(xtw);
xtw.Close();
sw.Close();
return sw.ToString();
}
Andrus
|
|
|
|
|
How about opening the xml file with a StreamReader, read all the text inside and remove all the "" substrings?
|
|
|
|
|
Thank you.
Can you give example how to implement this ?
I'm bit new to C#
Andrus
|
|
|
|
|
Try this:
StreamReader sr = new StreamReader("myOldFile.xml");<br />
StreamWriter sw = new StreamWriter("myNewFile.xml");<br />
<br />
string theText = sr.ReadToEnd();<br />
sr.Close();<br />
<br />
theText = theText.Replace("<!--", "");<br />
theText = theText.Replace("-->", "");<br />
<br />
sw.Write(theText);<br />
sw.Close();
Have a nice day!
|
|
|
|
|
Thank you.
I'm sorry maybe my question was incorrect.
I need to remove comment tags including their contents.
Result must be valid XML.
Your code removes only comment tags.
Result is not valid XML.
How to remove comment tags contents also ?
Is it possible to use some strign function which removes also all characters between comment tags ?
Andrus
|
|
|
|
|
Thank you.
I'm sorry maybe my question was incorrect.
I need to remove comment tags including their contents.
Result must be valid XML.
Your code removes only comment tags.
Result is not valid XML.
How to remove comment tags contents also ?
Is it possible to use some string function which removes also all characters between comment tags ?
Andrus
|
|
|
|
|
I have a large datagrid which I can filter by changing the query and reloading the datagrid but this takes time as its a large amount of data. Is there a way to filter a datagrid without having to reload the data?
|
|
|
|
|
Use a DataView and filter that. So your code would be something like this, assuming you have a single table returned from your dataset.
DataView dv = dataSet.Tables[0].DefaultView;
dv.RowFilter = "ColumnName = 'value'";
dataGrid.DataSource = dv;
dataGrid.DataBind();
At least that should be pretty close to some code that would work.
Hope that helps.
Ben
|
|
|
|
|
Thanks worked like a charm.
|
|
|
|
|
Hi All,
I have deployed my project and people are having trouble because the link for the InstallUrl is one that redirects you.
http://go.microsoft.com/fwlink/?LinkId=9832
Under the launch conditions in the Microsoft .NET Framework it has a red exclimation point on it. How do I fix this? I programmed in Visual Studio 2005. Should I Allow Later Versions?
|
|
|
|
|
Hey all,
Could anyone help me in testing a stored procedure for a report? what could be the outcomes for that?
|
|
|
|
|
To test a stored procedure ensure you have a known set of inputs. That includes the contents of the tables as well as the parameters. Run the stored procedure and ensure the output is as you expect. There isn't a lot more to it than that. The difficulty is ensuring a consistent input set so you are not tracking down false failures in the stored procedure when the test data is at fault.
|
|
|
|
|
HI all,
i am developing a windows applicaiton,
here in between two controls i need to generate a Horizantal Line,
i couldn't get this, can u please suggest me to how to Draw a line Programatically
thnx in advance,
prashanth
prashanth,
|
|
|
|
|
form have an event which name is Paint.
in this event u can use :
e.Graphics.DrawLine(--,--,--)
|
|
|
|
|
Hello. I have a problem and I hope you can help me.
I have the two classes below.
public class MyObject
{
int _id;
public int Id
{
get { return _id; }
set { _id = value; }
}
string _name;
public string Name
{
get { return _name; }
set { _name = value; }
}
}
public class MyClass
{
MyObject _object;
public MyObject Object
{
get { return _object; }
set { _object = value; }
}
}
In my program I do that:
MyClass m = new MyClass();
private void Form1_Load(object sender, EventArgs e)
{
bindingSource1.DataSource = m;
}
and I create a comboBox and set his DataBinding to the "bindingSource1 - Object".
I populated the comboBox with Items.
My questions are: How can I populate the ComboBox with the Object, and when I select a Item from comboBox, that is a Name, he must give to me the Id for that Name.
10x
|
|
|
|
|
I have an application where the user(s) must only be able to open one copy of the application. I created a Mutex object that is created on startup to limit the number of possible copies on the computer that normally runs to software to just one, but it is possible at present for the customer to install this software on multiple machines. If someone opens a copy of this software on one machine while a user on another computer is running the software, that could create problems. Is there a way to check whether a process is running on another machine on the customer's network and, if so, to shut down the copy of the application the user tried to start up? Thanks.
|
|
|
|
|
This may seem like a difficult problem to solve, but what you need is a piece of server software that keeps track of the number of instances currently running. Then in your client software (the actual application being run), you need to have it first connect to the server software and find out how many instances are currently running. If greater than zero, display a message to the user, otherwise allow the program to continue.
Hope this helps.
Phil
|
|
|
|
|
Hi all,
i am making a windows based application, here i am using a DataGridView(of C#2.0)
here i wanna add a label control in my GridView,
i have to fill a colomn say(LabeledData) with a Label Control For each row,
hope u got me.
please help me solving this problem
bye byes,
thnx in advance
prashanth
prashanth
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
