₦airaland Forum

Welcome, Guest: Register • Login • With Google • Trending • Recent • New

Stats: 3,346,017 members, 8,520,670 topics. Date: Wednesday, 18 November 2026 at 08:33 AM

Toggle theme

Guente02's Posts

Nairaland Forum › Guente02's Profile › Guente02's Posts

1 2 3 4 5 6 7 8 ... 39 40 41 42 43 44 45 46 47 (of 89 pages)

Romance › Re: Things You Need To Know About Emotional Intelligence by guente02(m): 6:27pm On Aug 21, 2014
softsparkyy: Eyaaah I was only trying to help a brother.
Do you know the definition of help? - I doubt
Go back and check your input after getting the meaning of help straight.
Cheers
Romance › Re: Things You Need To Know About Emotional Intelligence by guente02(m): 5:13pm On Aug 21, 2014
softsparkyy: By being emotionally intelligent tongue
For your mind now you dey emotionally intelligent.
Isoryt
Romance › Re: Must You Have Sex On Your Wedding Night? Let's Discuss.. by guente02(m): 4:39pm On Aug 21, 2014
I would have mine after our first child turns 3
Romance › Re: Dangers Of Too Much Sex by guente02(m): 4:36pm On Aug 21, 2014
Team #virgin
Romance › Re: What’s The Worst Thing Your Boyfriend/girlfriend Has Done To You? by guente02(m): 4:34pm On Aug 21, 2014
Going to cook for her ex when i was about having it.
Discontinued the relationship two days after.
Programming › Re: Update Statement Problem In Vb.net by guente02(op): 4:28pm On Aug 21, 2014
Your inputs are appreciated.
Thanks a Mill
Romance › Re: The Kind Of Self Confidence That Attracts Women by guente02(m):
Being Bold
Having Cash to Show Off not to Spend/Little to spend.
Be an african mandingo.
Dont give a fvck but be a lil nice.
Romance › Re: Naija Girls Mentality by guente02(m): 4:22pm On Aug 21, 2014
NiniArike: Just feel like quoting you. smiley
And i just felt like doing same.
Sup swedy
Nairaland General › Re: 5 Great Differences Between Guys And Ladies by guente02(m): 4:20pm On Aug 21, 2014
Hmmmm....
Really dont know what to type other than what i just typed.
Programming › Re: Update Statement Problem In Vb.net by guente02(op): 3:49pm On Aug 21, 2014
fretfingers: Hi,

I am not really into MS SQL but I think all u nid to do is read about accepting and storing the prices/amount of the cars in the same datatype as in ur database (interger/decimal lika said am not really an MS SQL guy. I use MySQL but its the same concept anyways). Then when retrieving the amount convert it to the appropriate type in ur code.. Somethin like CType() before performing the math operations that's should do it..


Addition: I think u shoud create a sub routine that handles ur connection states( closed/open) instead of u having to re-write them later, u would only need to call the subs..


Hope this helps...
I totally dig you bro but its a parameterized query so the issue of data type mismatch is handled because i already validated my form controls to behave properly (i.e the textbox that receives data for price only accepts numerals same goes to quantity).
The issue is that if i don't make the query parameterized every works smoothly but i just want to iron out the issue so that future project wont suffer such.
Maybe I'll have to run to stackoverflow or daniweb to search for answers that's if I'm eventually the last poster in this thread.

Addition: I think u should create a sub routine that handles ur connection states( closed/open) instead of u having to re-write them later, u would only need to call the subs..
Please show me how to go about this. The current way isn't giving problems though but would like to improve and lessen the codes.

Cheers
Romance › Re: 9 Things Men Notice First About Women by guente02(m): 3:32pm On Aug 21, 2014
[quote author=Eviel][/quote]Don't tell me you're just knowing that.
Programming › Update Statement Problem In Vb.net by guente02(op): 12:00pm On Aug 21, 2014
Yes Yes Y'All
Please im having problems with my update statement in a program in currently coding for a Poly student. Its a car management system and as a rookie im stuck.
In my OLE database i have a couple of tables but the ones concerned with my problem is:
tlbCar - This table holds all the cars registered with their corresponding stock.
tlbSales - This holds sales record in the company.
What i intend doing in this particular form is that when a customer comes to buy a car and the operator selects the model of any car (i've got a textbox which becomes automatically populated by the corresponding field in the tlbCar table showing the current stock of that car) and clicks the save button. I want two things to happen. One to actually save the record for the current transaction and to Update tlbCar (by subtracting amount the customer wants to buy from the amount in the database) with the result of the subtraction. And booom there is some sort of logical error that i just cant figure out. This is a code snipet. Someone should please be of help.
Thanks
...................................................................................................
Private Sub Create_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Create.Click
AddRec()
UpdateStock()
End Sub
Public Sub AddRec()
Dim cmdtext As String = "Insert Into tlbSales" & _
"(Ord_ID, Ord_Date, Cus_Name, Model, Qty, Price, Total, Mode)" & _
"Values (@OrdID,@OrdDate,@CusName,@CarModel,@OrdQty,@OrdPrice,@OrdTotal,@PayMode)"
Dim cmd As New OleDbCommand(cmdtext, con)
With cmd.Parameters
.Add(New OleDbParameter("@OrdID", OrdID.Text))
.Add(New OleDbParameter("@OrdDate", CDate(OrdDate.Text)))
.Add(New OleDbParameter("@CusName", CusName.Text))
.Add(New OleDbParameter("@CarModel", CarModel.Text))
.Add(New OleDbParameter("@OrdQty", OrdQty.Text))
.Add(New OleDbParameter("@OrdPrice", CarPrice.Text))
.Add(New OleDbParameter("@OrdTotal", OrdTotal.Text))
.Add(New OleDbParameter("@PayMode", PayMode.Text))
End With
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
Try
cmd.ExecuteNonQuery()
SalesDetails()
Clear.PerformClick()
MsgBox("Order Transaction Completed and Stock Updated" & " " & OrdID.Text, MsgBoxStyle.Information, "Sucessful Operation"wink
Catch ex As Exception
MsgBox(ex.Message)
End Try
con.Close()
End Sub
Public Sub UpdateStock()
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
Dim cmdtext As String = "UPDATE tlbCar SET Car_Quantity = @CQty, Date_Modified = @DMod WHERE Car_ID = @CID"
Dim cmd As New OleDbCommand(cmdtext, con)
With cmd.Parameters
.Add(New OleDbParameter("@CID", CarID.Text))
.Add(New OleDbParameter("@CQty", Stock.Text))
.Add(New OleDbParameter("@DMod", CDate(OrdDate.Text)))
End With
cmd.ExecuteNonQuery()
con.Close()
End Sub
..................................................
PS: This stuff works when using none parameterized query but im just trying to go by industry standards (lol) by using parameters but its not been funny.
Romance › Re: A Car Or Ring:which Would You Prefer Your Man Proposes With by guente02(m): 9:02am On Aug 21, 2014
jideomowunmi: Shey peter okoye no be Human Being huh huh huh..he gave both including flowers sef...very romantic dude..unlike some Nigga's here on NL...smh lipsrsealed lipsrsealed lipsrsealed
One ibo adage translated to English says:
Its only a foolish person that would ask for the haircut of Peter just because its decent forgetting that they have different head shape and size.
Romance › Re: What do you not like about your girl friend/boy friend? by guente02(m): 8:56am On Aug 21, 2014
I don't have. They sabi lie hence I've backed out for the main time.
Romance › Re: . by guente02(m): 2:32am On Aug 21, 2014
Abatemtem: dnt let past occurences get in d way of future pleasure/happiness.
Exactly.
I just keep pushing.
But Im selective and my type is not much available and i dont want to settle for less either. Wetin man go do?
Romance › Re: There Is This Girl I Love But I Do Not Know How To Express My Feelings by guente02(m): 2:29am On Aug 21, 2014
LOL.
Op just change your too soft attitude towards her and pour your feelings to her sharply. As someone above me said you'll either get a yes or no (happens most of the time) so get started.
My last three outings was -ve but your guy must move on.
Romance › Re: Why Do Naija Guys Thank Females On Facebook After Friend Request by guente02(m): 2:22am On Aug 21, 2014
Because they're lossers.
I see no reason why an achiever would thank a mere fvckin mortal for facebook acceptance. Thats utter Gabbage.
Romance › Re: . by guente02(m): 2:20am On Aug 21, 2014
Abatemtem: Tz either he's an introvert,or has low self esteem or maybe he had a pretty bad history wit girls while @ a younger age
The bolded is really making keep off them like german dogs though i tend to forget about the bolded when she has big bust size lol.
This happens when im really ready to mingle but for now i gat to CODE.
Romance › Re: 9 Things Men Notice First About Women by guente02(m): 2:15am On Aug 21, 2014
The first thing i notice to be very honest is her Bust size.
I dont know why but then thats just it.
Romance › Re: Ladies Tell Us, What Approach Did Your Worst Toaster Use? by guente02(m): 1:34pm On Aug 20, 2014
TROVERTOPICO: ....Incase he end up to truely be a neurosurgeon lolz.The truth is that females are weaker sex.whatever strenght they display is fake
Lol.
True say my guy. Girls Sha
Programming › Re: How Many Nigerians/Africans Are Using Facebook Zero (Zero Data Charges)? by guente02(m): 1:33pm On Aug 20, 2014
toshodei: Nice but are people still using it or have they quit?
Dont really know my guy.
Programming › Re: How Many Nigerians/Africans Are Using Facebook Zero (Zero Data Charges)? by guente02(m): 2:45am On Aug 20, 2014
Facebook zero + simple server = mega cheat
Our network providers have tried to allow thia and they got their fingers burnt.
I dont even know if that sh!t is still working. I think they even capped it but its free sha.
Warefa sha
Computers › Re: An Experienced Computer Instructor Should Help Out by guente02(m): 1:04am On Aug 20, 2014
Clinton594: My guy abeg do you have any website in mind for me to check
Ebay or Amazon dats all
Computers › Re: An Experienced Computer Instructor Should Help Out by guente02(m): 9:20pm On Aug 19, 2014
Maybe you should check online and try to see the feasibility of ordering one. Why have an external battery when the main reason for owning a laptop is because of its portability.
Cheers Bro.
Phones › Re: My Tecno Phantom AIII Has A Broken Screen And Won't Come On {photo} by guente02(m): 2:10pm On Aug 19, 2014
Mehn the money plenty o. 15k? CHOI
Education › Re: Plight Of A Grieving Nigerian Student. by guente02(op): 10:29am On Aug 19, 2014
Im into desk app development with c# and vb.net still learning web development and getting paid already.
Thanks for ya input.
Please mod help me get this to fb if possible.
Thanks
Education › Plight Of A Grieving Nigerian Student. by guente02(op): 3:19am On Aug 19, 2014
Hello World.
Im Guente (not real name) and a promising young Nigerian youth trying to build up a bright future for myself but is been marred by current state of the education system of our used to be accommodating country. I graduated from secondary school in 2008 and I've been struggling to gain admission into the University but for the number of times i tried i always suffered major setbacks. So in 2012 I gained admission into one of the polytechnics to study Comp. Sci. which I started and pursued with all dedication. While studying the course I bought Jamb for the fourth time and scored 225 after which i had to abandon my exams for the post utme which is to took place in far away southern Nigeria. It wasn't an easy task but since my mother always clamored for her son to be a university graduate i had to follow the last command and damn the consequences. I returned with new task of facing four carried over courses and during this time, the admission list came out for the uni I opted and my name wasn't there for the fourth time. To say my world crumbled like the current state of Gaza city after Isreal's offensive would be me joking, I've never been humiliated to such an extent added with my carry overs i had in school jeez i was mad, nobody told me to turn to God. Not like i prayed or fasted but i embraced a life close to that of His son and I was able to let go of my disappointments and see them as blessings. The exams for the carry overs came and i excelled with good grades and at the end graduated with Upper Credit. What comes to mind is to further and in no other place than a university but all my plans to secure a 200 level admission in UDUS (A federal uni in sokoto) through direct entry in the forth coming admission year has come to a screeching halt due to the fact that the last ASUU strike made the school to have batch a and b 100 level sthdents and hence no space for DE applicants.
Now whats pains me the most if not even the 5k+ which i hussled to pay but the added year i probably may just have to spend at home just because of one fvcked up system in one effed up country.
Please i would like members of this esteemed forum to advice me on what next to do. Im totally confused as i dont know whether to do a HND program or wait another year. I dont want to be caught in the dichotomy that exist between the University Honors and a Polytechnic Diploma.
Romance › Re: Nigerian Ladies Are Both Physically And Intellectually Lazy by guente02(m): 1:09am On Aug 19, 2014
norguy: Thank u for making dem understand try to make dem find out about things so dat d chat won't b boring remember dat we are all babies both male n female we nid to learn from ourselves to grow.
grin grin grin
Romance › Re: Nigerian Ladies Are Both Physically And Intellectually Lazy by guente02(m): 12:15am On Aug 19, 2014
I naturally have to stoop to their level to make dem understand me when in a conversation - too bad
Romance › Re: Y Do U Guyz Like Grabn Ur Gf Bottom? by guente02(m): 12:13am On Aug 19, 2014
Lol
It mustn't even be my gf, any babe im that in an unusual relationship with.

1 2 3 4 5 6 7 8 ... 39 40 41 42 43 44 45 46 47 (of 89 pages)