i think i figured it out. the following serves my purposes: SELECT barcode, wellname, well.ph, proteinname, score, MAX(time) AS time FROM well INNER JOIN welldrop ON well.wellkey=welldrop.wellkey INNER JOIN imageset ON welldrop.dropkey=imageset.dropkey WHERE well.barcode=1111 GROUP BY barcode,wellname

hello, does anybody know how to write a query that returns the maximum value of a column? here is what i have so far: SELECT barcode, wellname, well.ph, proteinname, score, time FROM well INNER JOIN welldrop ON well.wellkey=welldrop.wellkey INNER JOIN imageset ON welldrop.dropkey=imageset.dropkey WHERE well.barcode=1111 this query returns several rows for each "wellkey". i only want to return one row for each wellkey, with the most recent date (found in the time field of the imageset table). i tried using MAX(time), but i got an error... thanks! RC -- modified at 17:20 Wednesday 28th June, 2006

it worked! Thanks for your help!

Hello, How do you get the actual point where the mouse clicked on a form during an onclick event. Here is what I have so far, but it doesn't work... private void split_Panel2_Click(object sender, EventArgs e) { Point clickPnt = new Point(); clickPnt = (Point)sender; } Thanks for your help! RC

Hello, I am drawing on a windows form using System.Drawing.Graphics. Is there a way to wire up an onclick event to certain regions of the drawing? Thanks in advance for the insight! RC

Hello, I am drawing a table in the OnPaint method of a windows form. I would like to add Rectangles to the page that will fire an onclick event when I click on them. Does anybody know how to accomplish this? As far as I can see, the rectangle object doesn't have that kind of functionality built in... I originally just tried using buttons, but since I need quite a few of them, it is taking too long to draw them. Thanks for your help! RC

hi ravi, i did have a breakpoint in the paint method, which i removed. but it still appears to be firing multiple times. i am trying to redraw a panel in a windows form when a particular button is clicked. here is part of the code... private void srchPlatesBtn_Click(object sender, EventArgs e) { getPlates(); split.Panel2.Invalidate(); } private void split_Panel2_Paint(object sender, PaintEventArgs e) { Graphics g = e.Graphics; drawPlateResults(g); } private void drawPlateResults(Graphics g) { // code to draw the table in the panel goes here } Do you know of any other way to force the panel to redraw? Thanks for all your help, RC

Sorry! I wasn't sure where to put that one... RC

Hi, I'm trying to use the paint method to draw a table on a panel in a windows form. For some reason, the paint method is being called over and over again (I don't even know how many times!) when the form is opened. Does anybody know why this is happening? I'm fairly new to all this, so any insight is much appreciated. Thanks! RC

Hi, I'm trying to use the paint method to draw a table on a panel in a windows form. For some reason, the paint method is being called over and over again (I don't even know how many times!) when the form is opened. Does anybody know why this is happening? I'm fairly new to all this, so any insight is much appreciated. Thanks! RC

Hi Alexander, The invalidate method worked! Thanks for your help!! RC

hello, does anybody know how to determine the pixel width of a string if given the font and font size? i would like to be able to do this using c#, but i have no idea where to start. thanks!!! RC

Hello, I'm making a windows form app using c#. In one form, I am "Painting" a table in a panel. When a button on the form is clicked, I would like to repaint the panel using specified parameters. Does anybody know how to do this? Here is some of the code: private void goBtn_Click(object sender, EventArgs e) { pltNum = pltList.SelectedIndex; tblPanel_Paint(object sender, PaintEventArgs e); } I guess I'm not sure what parameters I should pass to the tblPanel_Paint method. Thanks for your help! RC

that worked. thank you!!!

Hello, I am writing a windows form app using c#. I would like to create a new data row in a regular c# class using the following code. public void addWell() { DataRow row = new DataRow(); } But I keep getting this error: "'System.Data.DataRow.DataRow(System.Data.DataRowBuilder)' is inaccessible due to its protection level" Does anybody know how to change the protection level of the DataRow? thanks! rc

Double.TryParse() did the trick. I'm still quite new to all this stuff, so I had no idea about that function. Definitely better than trying to use regular expressions. Thank You! rc

hello, i'm using c# to create a windows app. i would like to validate the contents of a text box to make sure it is a floating point number. does anybody know how to use regular expressions to accomplish this? i've never used them before... here's what i have so far: private void startValBox_Validating(object sender, CancelEventArgs e) { if (Regex.IsMatch(startValBox.Text, "regular expression goes here")) { startVal = System.Convert.ToDouble(startValBox.Text); errorMsg.Hide(); //return true; } else { errorMsg.Text = "The start value is invalid."; errorMsg.Show(); //return false; } } thanks for your help! rc

hello, I am creating a windows form app using VS.Net and I am having a fundamental problem with window sizing. I would like to specify the exact size of each form programmatically. Despite my efforts, the forms seem to be resizing themselves sometime between when the constructor is run and the window is actually displayed. Does anybody know why or where in the code this is happening? Any insight would be much appreciated. Thanks!!! rc

hello, I am creating a windows form app using VS.Net and I am having a fundamental problem with window sizing. I would like to specify the exact size of each form programmatically. Despite my efforts, the forms seem to be resizing themselves sometime between when the constructor is run and the window is actually displayed. Does anybody know why or where in the code this is happening? Any insight would be much appreciated. Thanks!!! rc

hello, I am creating a windows form app using VS.Net and I am having a fundamental problem with window sizing. I would like to specify the exact size of each form programmatically. Despite my efforts, the forms seem to be resizing themselves sometime between when the constructor is run and the window is actually displayed. Does anybody know why or where in the code this is happening? Any insight would be much appreciated. Thanks!!! rc