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)
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 |
softsparkyy: By being emotionally intelligentFor your mind now you dey emotionally intelligent. Isoryt |
I would have mine after our first child turns 3 |
Team #virgin |
Going to cook for her ex when i was about having it. Discontinued the relationship two days after. |
Your inputs are appreciated. Thanks a Mill |
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. |
NiniArike: Just feel like quoting you.And i just felt like doing same. Sup swedy |
Hmmmm.... Really dont know what to type other than what i just typed. |
fretfingers: Hi,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 |
[quote author=Eviel][/quote]Don't tell me you're just knowing that. |
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" ![]() 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. |
jideomowunmi: Shey peter okoye no be Human BeingOne 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. |
I don't have. They sabi lie hence I've backed out for the main time. |
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? |
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. |
Because they're lossers. I see no reason why an achiever would thank a mere fvckin mortal for facebook acceptance. Thats utter Gabbage. |
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 ageThe 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. |
The first thing i notice to be very honest is her Bust size. I dont know why but then thats just it. |
TROVERTOPICO: ....Incase he end up to truely be a neurosurgeon lolz.The truth is that females are weaker sex.whatever strenght they display is fakeLol. True say my guy. Girls Sha |
toshodei: Nice but are people still using it or have they quit?Dont really know my guy. |
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 |
Clinton594: My guy abeg do you have any website in mind for me to checkEbay or Amazon dats all |
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. |
Mehn the money plenty o. 15k? CHOI |
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 |
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. |
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. ![]() |
I naturally have to stoop to their level to make dem understand me when in a conversation - too bad |
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)


