Comments by WurmInfinity (Top 89 by date)

to obvious eh... THANKS :D

Fixed it, i was right im an idiot. Thanks for your time

I think it may be down to the code being (local) and me being a total tool and going through the server 'SQLExpress' im gunna try this out hopefully it works >.<

I've managed to switch the user back by unattaching all databases and reattaching god knows why that fixed it ... but it says 'Failed to log in with MASTER\Milton' anyway so now i fix it the bloody stored procedure just wont work... one thing after another xD

I've added a new user and everything, it still comes up with the same error. Honestly I have no idea why. "Login failed for user MASTER\MyName"

yes I am.

urrmmmmmmmm ok so I set it up with SQL authentication instead. What ADO do I use to connect in through that way?

Already tried this, as explain in the P.S bit at the bottom the user is already the database owner...

So basically it was going through it rather than doing it. RETURN has fixed it. Thank you so much, you have no idea how angry I was getting haha! You've made my day :)

I've just updated my question. I think it makes more sense now. I'm not sure what you are trying to achieve there doesn't look like what I'm after. But thanks for trying! Possibly take a look at the reviewed version for me please?

Well I have a front end which I've done in c# and used ADO.net to run the stored procedure. It works fine if I remove the top bit up to the rollback and just use the bottom update. So I guess its within the rollback itself. I feel like maybe because its not returning the RAISERROR anywhere its causing an issue, but it doesn't process the procedure.

I dunno if your still about, but I've been playing with it and it now won't work again. If you could take another look I'd be very grateful, I'll put it up in the question.

Your too awesome! Gunna throw it coz I don't want it popping up haha :D Good call THANKS!

I have another question if you'd be so kind to answer. All this is connected to a windows form in C#. Can I return the RAISERROR message to the program as a parameter?

Ok thats cool, thanks for that! :D

Thank you kindly.

Apologies. Its misleading the field is actually an integer. But thanks for the advice I'll keep that one for another day I'm sure it'll come in handy!

Thanks

Cheers

You Sir, are a God among men. Thanks a lot :)

Yeah that's awesome. Opens up loads of new possibilities too. Thanks a lot! x

Got it working now. I think since the procedure is considered in string format the key word wont effect it. Thanks anyway.

Fixed it, there was a menu on the right to set it to Identity true.

Yer its still greyed out.

Yeah I think I'll specify the details a bit more. I just needed the general jist of things to get me going :) Thanks again!

Thanks dude!. I knew it wasn't as complicated as I was trying to make it seem :D

The partial component makes it inaccessible. When I remove the partial I get the error as mentioned above "Missing partial modifier on declaration of type 'WCFWindowsF.Form1'; another partial deceleration of this type exists.". :/

So I've added the inheritance but now I get the problem "Missing partial modifier on declaration of type 'WCFWindowsF.Form1'; another partial deceleration of this type exists."

I see, thanks for the help but the problem is still persisting "Missing partial modifier on declaration of type 'WCFWindowsF.Form1'; another partial deceleration of this type exists.". I've read some stuff off google someone said make it 'public partial class Form1' but that didn't make a difference :(

So I changed the 'ClientPart' class to public. It gave me access to the txtBox however now it says 'Missing partial modifier on declaration of type 'WCFWindowsF.Form1'; another partial deceleration of this type exists.

fixed thanks

Ahh ok thats easy enough, I think I was just over complicating it. Thanks a lot :)

hmm ok so its got to be read in from the database? so essentially read in and put into the drop down.

Lesson learnt :) Many thanks again!

Holy *&%£ your a genius! Thank you :D

Holy S**T! It worked :D!!!!! Thanks man, for your patience and advice I have learnt a great deal :)

Ok woops, my bad I accidently changed the connection feild. Yeah it actually displays fine > Alpha (500 ,455 )
Beta (56 ,34 )
Gamma (90 ,95 )
Delta (34 ,34 )
Omega (64 ,6 )

So yeah the connections fine. But AlphaX = reader["X"].ToString(); is still not saving the value 500 to the variable.

Right thats cool. Ok it comes up with 'A first chance exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll' Hmmmmmm.

Sorry for being stupid, but im in visual studio and I do not see a console pane or any output pain that displays anything when im debugging. Is it under a menu im looking over?

Well when I run Console.WriteLine(currentGroupName + " (" + reader["X"].ToString() + "," + reader["Y"].ToString() + ")"); All the data thats in the database comes up properly. This is testing it in console, since my main program is windows form. So the connection to the database is fine, its just not storing the value thats in the X column into my variable AlphaX in the switch :S

There are 5 groups, Alpha, Beta, Gamma etc. Uhmmm basically the switch is saying case "Alpha" then the string AlphaX should = the value "X" from the database. However it does not store it since the messagebox at the bottom of the code still says null when displayed :(

Yeah I have debugged it, the code compiles aswell and when you run it the MessageBox just comes up empty and appears like 4 times which I dont get either :(

Ok unfortunatly im not very good with switch statements. The code compiles fine and I understand the logic however, it just wont store the information in the variables for some reason. Any suggestions?

Ok thats wicked. Thanks :D!!!

Ok. Thx

Yeah I realise what was wrong now. The site I got the code off dident explain that the second digit designated the amount of numbers to be removed. Thanks for the quick response :)

Yeah I realise what was wrong now. The site I got the code off dident explain that the second digit designated the amount of numbers to be removed. Thanks for the quick response :)

Yeah, that was what was confusing me. Thanks! :D

Ok cheers man.

Thanks for the help got it sorted now :) all down to my own stupidity.

I'm a total pillock xD. Thanks a lot! It works now, however I think my biggest issue was the fact the column for Username was called UserName and not user. Appended code was ""SELECT UserName, Password FROM [dbo].[User] where UserName = '" + tbxUserID.Text + "' AND Password = '" + tbxPassword.Text + "'". Thanks!!! :D

still not doing the trick. hmmmmmm

Ok it shows, Dbo, Guest. Which is not what I want to receive, so now i'm even more confused.

"Incorrect syntax near 'Password' :S

Still not working :(

Could you please elaborate on what I need to do please?

Could you please elaborate on what I need to do please?

Thank you so much :D

Yeah I had this.Hide before, However the problem is Im reading and writing XML files and when Form1 is still open but hidden its using the file and the new form cannot use it.

My friend has just suggested that in the Program.Cs file there is a peice of script called Application.Run(new Form1()); this shows wich form is run first however thats great but I now that would mean my Form2 needs to be my main form and I have no idea how to switch the two.

No I want it so that the focus dosent go away from the textbox. TapStop still pulls focus when the button is clicked. Any other ideas?

done and done :)

mmm since im new a lot of thats a bit fuzzy, however i'm pretty certain if i can work out how to set a buttons focus to false I can code it to work. Thanks for the reply tho.

The Focusable = False sounds like what I need, but i'm struggling with where I should place it / how I should write it. Should it be global in the class for example "btnS Focusable = False"? or should I place it in the buttons click code? Or dose Visual Studio have a property to set it to false? I can't see one but you never know.

Aha Estys has just highlighted my issue. The first code I was using works its just when you click the button of the keyboard the textbox looses focus, any ideas?. (This is very helpful stuff thanks). I would prefer it if the code could go around the button as exampled in my original post.

Ok thank you for that, thats given me some direction however, i've tried if(textBox1.Focused == true) and also if(textBox1.Focused) and neither work, am I missing something? (sorry im new thanks for the help :))

Dont get me wrong im greatfull for all the help, however you havent posted anything that has actually helped me you have just pointed out my downfalls wich I gather is usefull but as I said it was rushed as an example. Maybe you could correct it instead? So I can actually see where I went wrong. Thanks

It was an example, I wrote up quickly just to get a question answerd. My actual code is far longer and I dont want to paste it in because I want to learn not just have it alterd by someone else so I created a simular code that was far shorter. If you had read the previous answers you would know im a beginner so theres no need to be snide.

ok shall give it a go thanks

Yeah we've been told not to use them so im trying to work this out. Right so do I change the prototype from a void to a float? and then call it in final() as float one=up(one) ?

return it to where? if that returns it to main, its not what I want I want it in the final function. Sorry i'm new to this by the way.

seems to not really be what I want. I honestly dont think I can do what I want it too doooo but thanks anyways :D

Wow that looks good, but im afraid this is my first C++ assignment and we've been given a task and I don't think the tutor has quite comprehended how difficult this might be for us learners, but I do like a challenge sooooo ok basically the float will not be static it will be a cin >> and will later be displayed as a cout <<. So far 1 litre of paint covers 8 square meters. Inputs for area have already been done so i'm looking for basically wallArea/8 to give me how much paint is needed, then I want that number to be rounded up and stored as a variable to be displayed in cout <<. Sorry i'm not good at explaining :(.

WOOP it worked. I love you right now, been bothering me all day. Thanks so much dude.

cout << "Ceiling: "; cout << setprecision(3) << (ceilingArea/8)*3.50;

Just getting a undeclared error for setprecision :(

Ok thats awesome thats pretty much what I wanted. Urrm one question though my floats not static its cin << so would it be just.
float money ;
cin << money;
(person puts in 3.45673)
cout << "Money comes to: "; cout << money %.3f;
I don't really know :S sorry im a begginer :(

Ceiling will be a user input, I just exampled it as a static float. Also have no idea how to round down help? :D

No worries. Its all helpfull :D thanks

Cheers, it works.

Im actually retarded. Well I am a beginner so its all sorta falling into place, but yeah the autoscroll works wonders :D thanks

Hmmmm im gunna play with something and come back to you on that one

Already been trying to use that, cant make heads or tales of the bit where it says
First step to create a dynamic VScrollBar is to create an instance of VScrollBar class. The following code snippet creates a VScrollBar control object.

VScrollBar vScroller = new VScrollBar();

dunno were to place it

Got it to work. Thanks so much :)

Ok so i'm a small fish in a huge pond, but i'll give it a go thanks :)