C#

FirstPrevNext

Re: string searching?? Pete O'Hanlon7-Dec-07 11:18 Pete O'Hanlon 7-Dec-07 11:18  Honestly. This is a C# forum. Do you really think you are going to get ASP help in this forum? Deja View - the feeling that you've seen this post before. My blog | My articles event for adding item in listbox Xmen Real 7-Dec-07 5:59 Xmen Real 7-Dec-07 5:59  hi there, i want to know that which event is called when we add or delete items in listbox? i search around all events but didnt find, will i need to use any trick or i'm missing something? thanks Becoming Programmer... Re: event for adding item in listbox Anthony Mushrow7-Dec-07 6:22 Anthony Mushrow 7-Dec-07 6:22  I don't think there is one. But shouldn't you already know when something is being added or removed, as you will have to call listBox.Add() and listBox.Remove()? My current favourite word is: Bauble! -SK Genius Re: event for adding item in listbox Xmen Real 7-Dec-07 14:42 Xmen Real 7-Dec-07 14:42  yeah, but i'm calling these functions from lots of places and i want to do a big stuff when this happens, event is the best way to do that but i think here is no event for it Becoming Programmer... datagridview cell colour arkiboys7-Dec-07 5:29 arkiboys 7-Dec-07 5:29  Hi, I would like to change the background colour of a particular cell in the datagridview. Please note that I only would like to do this in the procedure I have created using the column and row position and not in the events such as cellformat or selected changed. What I am after is something like: datagridview[columnName][RowIndex].backgroundColor = blue Thanks Re: datagridview cell colour Giorgi Dalakishvili7-Dec-07 5:44 Giorgi Dalakishvili 7-Dec-07 5:44  Datagridview cell has a property called style which allows you to customize appearance of the cell. (BTW, it has a property called BackColor. Guess what it does ) #region signature my articles #endregion increment by 1 eyeseetee7-Dec-07 4:41 eyeseetee 7-Dec-07 4:41  Hi I have the following code basically it is meant to increment the database value by 1 however it is not doing that it doesnt add 1 to it any suggestions cheers string maxquery = "Select Max(activity_order) from roomactivitylk where room_code = '" + room_code + "'"; //cmd14.ExecuteScalar(); int max = 0; int max; SqlCommand cmd15 = new SqlCommand(); //SqlCommand cmd15 = new SqlCommand(test0001, con); cmd15.Connection = con; cmd15.CommandText = maxquery; max = (int)cmd15.ExecuteNonQuery(); max = max + 1; ++max; max++; Re: increment by 1 Guffa7-Dec-07 4:51 Guffa 7-Dec-07 4:51  Of course it does. All three ways of increasing the value that you have tried works just fine. How have you come to the conclusion that it doesn't work? How are you viewing the value? Experience is the sum of all the mistakes you have done. Re: increment by 1 eyeseetee7-Dec-07 4:58 eyeseetee 7-Dec-07 4:58  the value that comes out the database should be 4 but for some reason appear as 1 i dont know if thtas something to do with the in anyway when i run the same qeury in sql query analsyer it ocm4es out as 4 however running the query in c# it comes out as 1? any clues cheers tyhanks Re: increment by 1 Guffa7-Dec-07 5:04 Guffa 7-Dec-07 5:04  The problem is not at all in increasing the value, but where you read the value from the database. You are not getting the value that the database returns, but the number of records that the result contains. Use ExecuteScalar instead of ExecuteNonQuery. Experience is the sum of all the mistakes you have done. Re: increment by 1 eyeseetee7-Dec-07 5:10 eyeseetee 7-Dec-07 5:10  ExecuteScalar does not work it comes up with an error Re: increment by 1 Ian Shlasko7-Dec-07 5:21 Ian Shlasko 7-Dec-07 5:21  Guffa is right on target with ExecuteScalar... What error are you getting now? Re: increment by 1 eyeseetee7-Dec-07 5:26 eyeseetee 7-Dec-07 5:26  Specified cast is not valid. pointing at the exceutescalar Re: increment by 1 Ian Shlasko7-Dec-07 5:41 Ian Shlasko 7-Dec-07 5:41  Thought so... Try putting it in an object instead of an int (Without casting), just for debugging, and see what type it is (Set a breakpoint and take a look at it). If it's a different numeric type, just use Convert.ToInt32() instead of a direct cast. If you're getting a DBNull or a non-numeric type, there's something wrong with your query. Also, in light of the other branch of this thread, remember that this isn't going to modify the database. All you're doing is asking the database for a number, and incrementing your copy of that number. If you want to make a change to the database, that's a separate operation. Re: increment by 1 eyeseetee7-Dec-07 6:26 eyeseetee 7-Dec-07 6:26  Hi How would i set the int to the object, woudl i not declare an int at all? cheers sp far Re: increment by 1 Ian Shlasko7-Dec-07 7:27 Ian Shlasko 7-Dec-07 7:27  As I said, figure out what type you're getting back. If it's a different type of number (long, short, byte, float, etc), you can use Convert.ToInt32(x) to convert x into a standard int. If you messed up the query and are getting a date, a string, a DBNull, or something weird, well then you have another bug. Re: increment by 1 Ennis Ray Lynch, Jr.7-Dec-07 4:58 Ennis Ray Lynch, Jr. 7-Dec-07 4:58  If it is SQL Server you should use an identity and if it is oracle you should use a Sequence. The code you have is not updating the database because ADO.NET is disconnected from the database. "SELECT @maxValue = MAX(activity_order) FROM table WHERE clause; UPDATE table SET activity = @maxValue + 1 WHERE clause; " Will do what you want (make sure to add an output parameter to the command) but it is sloppy. Need a C# Consultant? I'm available. Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway Re: increment by 1 eyeseetee7-Dec-07 5:10 eyeseetee 7-Dec-07 5:10  can the above used in c#? e.g. string maxquery2 = "SELECT @maxValue = MAX(activity_order) FROM roomactivitylk WHERE room_code = 'v1106';UPDATE roomactivitylk SET activity_order = @maxValue + 1 WHERE room_code = 'v1106';"; cheers Yes Ennis Ray Lynch, Jr.7-Dec-07 5:13 Ennis Ray Lynch, Jr. 7-Dec-07 5:13  But you need to place a parameter in your command object. Need a C# Consultant? I'm available. Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway Re: Yes eyeseetee7-Dec-07 5:18 eyeseetee 7-Dec-07 5:18  Hi so this statement isnt working is it cos im using an insert string maxquery2 = "SELECT @maxValue = MAX(activity_order) FROM roomactivitylk WHERE room_code = 'v1106';INSERT INTO roomactivitylk (room_code, activity_order, instance_variant, activity_code, ignore_flag) VALUES ('" + room_code + "', @maxValue + 1, '1', '" + activity_code + "')"; ?? thanksoyu Re: Yes Ennis Ray Lynch, Jr.7-Dec-07 5:19 Ennis Ray Lynch, Jr. 7-Dec-07 5:19  What are the errors? Need a C# Consultant? I'm available. Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway Re: Yes eyeseetee7-Dec-07 5:21 eyeseetee 7-Dec-07 5:21  it just wont insert the appication is set to custom errors it wont insert into the database, does ythe syntax look correct? Re: Yes Xmen Real 7-Dec-07 5:54 Xmen Real 7-Dec-07 5:54  yeah, value for "ignore_flag" isnt exist Becoming Programmer... Re: Yes Guffa7-Dec-07 7:20 Guffa 7-Dec-07 7:20  That can't be used safely anywhere. As the select and insert are executed in separate transactions, there is no guarantee that the @maxValue is still the hightest value when you use it in the insert. Why aren't you using an identity field? It will increment automatically. Experience is the sum of all the mistakes you have done. Hiding a tabsheet Dewald7-Dec-07 4:38 Dewald 7-Dec-07 4:38  I have a tabcontrol with say, 5 tabsheets. I would like to be able to hide one or more of these tabsheets during runtime (and make it visible again at a later stage) but can't seem to figure out how. I was hoping for something like myTabSheet.visible = false; but there's no such property. Any tips? Thanks in advance.

Last Visit: 31-Dec-99 18:00     Last Update: 24-Jun-24 21:07 Refresh ᐊ Prev1...7976797779787979798079817982798379847985 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.