Search results for query: *

Hi everyone! Sorry if this is a dumb question, I am very new to this. I have a Detailview on a page collecting and displaying data about clients for a company. It is used for both adding new clients and to edit existing ones. The person that use this site now wants a checkboxlist added in the...

New Problem. I'm trying to remove a node from a treeview via a button with this line of code. TreeView.Nodes.Remove(TreeView.SelectedNode) It is in a webform and I have tried so many different ways, none of them working. If anyone has any advice I would be most grateful. Fred

Thanks Jason. I gave the idea up and are now trying to put it on the site instead. Fred

Hi everyone! OK, this is my problem. I tried to find a way to easier update categories and sub-categories in a database for a friend of mine. She has a website that uses this db but has no way of managing the data so to speak. I created a small windows form which populates a treeview with the...

Hi both of you and thanks fro your help. I actually solved both of my problems with the like statement as you suggested Ryan. Thanks again for the help. Fred

Hi everyone! This time I'm trying to fill a C# tree view from a sql query. I have two functions to extract the nodes and in the first one I will have a simple select statement to capture the categories which, in my database are in upper case. I would like to use some statement that will only...

I'll look for it for sure. Thank you once again! Fred

Have to buy some basic books on how to join tables I think. Took you all of what, ten seconds to figure that one out Riverguy? It works like a charm and I'm down from two minutes to ten seconds for my query to execute. I'm very grateful you should know, but a little emberrased too. Thank you so...

Thanks for the quick reply guys! I tried the derived table and it executed much faster but the problem is that the people that does not have any future appointments scheduled does not show up. The reason I created the UDF was to still include people who had previous appointments. I'd like these...

Hi there! I have a query that uses two UDF's. When I included the first one with help of George (thank you) it slowed down my query just a little bit. Now that I tried to write my own it takes close to two minutes instead of a few seconds so I gather I didn't do such a good job. Any help is of...

George, you are a superstar. Not only have you explained in a way that I actually understand, you have me realized that I want to learn more about this stuff. Since I'm new to this it didn't even occured to me that there are more than one way to do things. I'll read the link that you provided...

Sorry George! You are of course correct that I should take it in and learn from your advice but I was so happy to get this solved. I have looked at the code now and it actually make sense to me. I have a few questions though if you do have a minute to help me out. Just a wee bit of background...

You guys are the best. Two minutes of copy and paste and you solved something I've been looking at for hours. My hat is off to the true pro's. Fred

Wow, you guys are fast. Thank you so much for your help. RiverGuy, you are of course correct, that is not the result from the table I was after in the first place. Thank you for that one and thank you George, I will try the drrived approach that you suggested. Once again, thank you both so much...

Hi y'all! I'm new to all of this so my question is probably dumb but I'll risk it anyway since I can't find my answer anywhere. I want to fill a Gridview from a sql query and all is well except for one field. The MAX function is needed (I think) to get the last date from a table but I cannot...