|
Hello,
How do I bin and zero fill excel data in both C# and excel? For example below is a list of data. I want to bin the data as integers
120.337
121.041
124.111
So the above should be. I want to say 0 of the date is not between a certain range as shown below
120-121= 120.337
121-122 =121.041
122-123 = 0
123-124 = 0
124-125 =124.111
|
|
|
|
|
Not sure what you mean but maybe something like this?
float RangeCheck(int lower, int upper, float value)
{
return ((value >= lower) && (value <= upper)) ? value : 0;
}
|
|
|
|
|
to make mass data entry easier so i can put my add form over the top of my excel sheet that contains the data i wish to enter. Is there a way to do the following without it minimizing both.
I understand the whole parent/child relationship of the forms but i was wondering if i could somehow do this because I have noticed programs like yahoo and so forth allow one form to be minimized while the other is maximized. Anyway here is what I'm trying...
private void Add_Button_Click(object sender, EventArgs e)
{
AddRecord addRecordForm = new AddRecord();
addRecordForm.Owner = this;
this.WindowState = FormWindowState.Minimized;
addRecordForm.ShowDialog(this);
this.WindowState = FormWindowState.Normal;
LoadData();
}
it minimizes but they both minimize instead of only the parent minimizing. i even tried putting in the constructor of the addrecord this.windowstate = formwindowstate.normal; and that had no effect.
|
|
|
|
|
I have tried compile example into .NET 2.0/3.0/3.5. I am using Windows 7 and didn't encounter your problem.
Did you accedently changed windowstato of your AddRecord Form?
|
|
|
|
|
tonyonlinux wrote: addRecordForm.Owner = this;
this.WindowState = FormWindowState.Minimized;
tonyonlinux wrote: it minimizes but they both minimize instead of only the parent minimizing
Does it really? Have you read the documentation[^]. Which is what you always should do when running into a problem.
 Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
here's a working example:
In the Main form/container, on the add click do something like this:
this.WindowState = FormWindowState.Minimized;
this.ShowInTaskbar = false;
Form2 f = new Form2();
f.Owner = this;
f.Show();
and on the LoadDataForm on the form closing event do something like this:
private void Form2_FormClosing(object sender, FormClosingEventArgs e)
{
this.Owner.ShowInTaskbar = true;
this.Owner.WindowState = FormWindowState.Normal;
}
|
|
|
|
|
|
i was wondering something since the documentation states if the parent minimizes so does the child. (this was really my original question) because i had read this in the documentation BEFORE asking. is it possible to make the add form an owner of itself? i tried and it said I can't. Basically what I'm trying to achieve all of the parent/child stuff asside is the following. I guess what i want is the form to not be a child but simply another parent (per say).
I'm trying to make it where when i click on the addbutton up pops the addrecord form. and the main form minimizes. as documented and seen and so forth both will minimize. sure i can go down there and click on the thing to open it back up since the mainform is hidden until close(that part i like) but i want the child form return to normal state. is there some kinda method that you can use on the form like you do controls as form1.visible = false or hidden = true or something like that then change that on the form2 closeevent ?
|
|
|
|
|
sure you can trick the owner.
But a better solution is to not own the dataform. Something like:
private btn1Click(object sender, EventArgs e){
this.Hide();
DataForm df = new DataForm();
df.ShowDialog();
this.Show();
}
|
|
|
|
|
can a visual c# project connect to a remote mysql database and execute sql statements but w/out using mysql connector/net?
thanks in advance!
oh,and not just a yes/no answer...doh doh doh... if yes,how can you do it or if not, what is the simplest way of using mysql connector??
|
|
|
|
|
I'm not sure if you can do it without a MySQL connector, but using one is not that tough...
Download the MySQL data connector dll[^]. Register it in your project. Do something like below...
DataTable customerTable = new DataTable();
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection("server=serverName;uid=userID;pwd=password;database=databaseName"))
{
string validationQuery = "SELECT * FROM Table WHERE Contact_ID = '" + actNumber + "';";
MySql.Data.MySqlClient.MySqlDataAdapter odda = new MySql.Data.MySqlClient.MySqlDataAdapter(validationQuery, conn);
odda.Fill(customerTable);
}
Hogan
|
|
|
|
|
You can use .NET Connector or ODBC connector. However if you do not want dll, .NET connector is open source and you get source file, and you can include it inside your project (Not add project to existing solution. yust .cs files) to remove dependency. However connecting to MS SQL server, a connector is build in into .NET framework
|
|
|
|
|
If you do not want MySql connector, Create an ODBC connection to the server - Use OdbcConnection in your project.
|
|
|
|
|
Hi All,
I am having problem while creating a custom event. My aim is to fire "DataChnaged" event whenever property "SetData" is called in following class defination.
The problem is, I am getting a null event in this line "DataChanged(this, e);". Anyone can help me understanding where I am wrong,
public class DataChangedEventArgs : EventArgs
{
private String _strArgVal = "";
public DataChangedEventArgs(String Value)
{
_strArgVal = Value;
}
}
public delegate void DataChangedEventHandler(object sender, DataChangedEventArgs e);
public class MyUserControlOne
{
String DataString = String.Empty;
public event DataChangedEventHandler DataChanged;
public MyUserControlOne()
{
DataString = "";
}
protected virtual void OnDataChanged(DataChangedEventArgs e)
{
DataChanged(this, e);
}
public String SetData
{
set
{
if (value != DataString)
{
OnDataChanged(new DataChangedEventArgs("Event Fired !!!"));
} DataString = value;
}
}
}
Calling code,
class Program
{
static void Main(string[] args)
{
MyUserControlOne o = new MyUserControlOne();
o.SetData = "ABC";
}
}Thanks,
Arindam D Tewary
|
|
|
|
|
first you need to check if OnDataChanged DataChanged is not null, then throw event. NullReferenceException is thrown, because there isn't any method subscribed to that eventmodified on Monday, March 1, 2010 1:40 PM
|
|
|
|
|
Thanks Saksida. As per your comment I noticed I have not provided any method which subscribes to the event. Now after I have written a "MyUserControlOne_DataChanged" method and its working nicely. Thank you very much for poiting me the mistake.
Now this is working nicely !
public class DataChangedEventArgs : EventArgs
{
private String _strArgVal = "";
public DataChangedEventArgs(String Value)
{
_strArgVal = Value;
}
}
public delegate void DataChangedEventHandler(object sender, DataChangedEventArgs e);
public class MyUserControlOne
{
String DataString = String.Empty;
private bool isEventWorking = false;
public event DataChangedEventHandler DataChanged;
public MyUserControlOne()
{
DataString = "";
this.DataChanged += new DataChangedEventHandler(MyUserControlOne_DataChanged);
}
protected void MyUserControlOne_DataChanged(object sender, DataChangedEventArgs e)
{
isEventWorking = true;
}
protected virtual void OnDataChanged(DataChangedEventArgs e)
{
DataChanged(this, e);
}
public String SetData
{
set
{
if (value != DataString)
{
OnDataChanged(new DataChangedEventArgs("Event Fired !!!"));
} DataString = value;
}
}
public bool EventWorking
{
get { return isEventWorking; }
}
}
calling code:
static void Main(string[] args)
{
MyUserControlOne o = new MyUserControlOne();
o.SetData = "ABC";
o.SetData = "ABCD";
o.SetData = "ABCD";
Console.WriteLine(o.EventWorking);
}
Thanks,
Arindam D Tewary
|
|
|
|
|
It is worth changing your code slightly to cope with the case when you have no handler - if you think about it not handling an event is not an error, it is perfectly normal. As such, it should not throw an exception.
Arindam Tewary wrote:
protected virtual void OnDataChanged(DataChangedEventArgs e)
{
DataChanged(this, e);
}
If you change your code to:
protected virtual void OnDataChanged(DataChangedEventArgs e)
{
EventHandler eh = DataChanged;
if (eh != null)
{
eh(this, e);
}
}
Then a potential source of run time exception is removed. (The load of "eh" is to handle the admittedly rare case when the handler is removed between the test and the execution)You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
Hi OriginalGriff,
You are very much correct. I would be changing my code for sure. Thanks for your comment. Highly appreciate it.  Thanks,
Arindam D Tewary
|
|
|
|
|
I would use:
protected virtual void OnDataChanged(DataChangedEventArgs e)
{
if (DataChanged != null)
DataChanged(this, e);
}
I think this way it is easier to read and not declaring new variable
|
|
|
|
|
No, what Griff gave you is the correct way to do things; there is a (probably small) probability that another thread could remove the content of the event between your code checking it for null, and your code using it. A local copy fixes that.
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
tham. Now i see the problem. It was same example in a book i was reading. Maybe it is time to burn that book
|
|
|
|
|
Arindam Tewary wrote: if (value != DataString)
{
OnDataChanged(new DataChangedEventArgs("Event Fired !!!"));
} DataString = value;
furthermore it is wrong to throw the event BEFORE the data change has occurred. A delegate is likely to read SetData to find out what the new data value is, it should not get the old value instead.
 Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that. All Toronto weekends should be extremely wet until we get it automated in regular forums, not just QA.
|
|
|
|
|
Hi Luc,
Thank you very much for your valuable input. Its great to get some input from MVPs 
Thats surely bad design. I would change that immediately. As I was digged into that "NullException", so I overlooked that. Please if you want to provide any other input also, although origianl problem is solved, please provide.Thanks,
Arindam D Tewary
|
|
|
|
|
There are many articles and blogs that deal with events but most are a little overwhelming initialy.
I wrote this[^] article to provide a gentle tutorial which you may find useful.
|
|
|
|
|
Hi,
I'm trying to end 3 threads in a save way. I can get 2 threads to stop, but the last one doesn't seem to abort.
My try:
private volatile bool stopRequested = false;
this.stopRequested = true;
this.thdPageContent1.Join();
this.thdPageContent2.Join();
this.thdFileComparer.Join();
After the thdFileComparer thread, i got a messagebox that 'tells' me the threads are stopped:
MessageBox.Show("Threads stopped successfully");
Any idea what I might be doing wrong?
Thanks in advance!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
