Comments by Nebilo - CodeProject

Nebilo 24-Jun-14 8:53am View

No i don't want to read the calculation.I wanted to write the calculation in vb.net and apply that when a record is read.

Nebilo 4-Jun-14 10:12am View

It's showing me the logon prompt.I also used another code but didn't make a difference.Here's the link
http://msdn.microsoft.com/en-US/library/ms227750(v=vs.80).aspx

Nebilo 4-Jun-14 9:02am View

It's not working

Nebilo 21-May-14 3:55am View

Deleted

I tried using join statement,another condition in the statement.And it only worked for the first join.when i wrote the second join statement it raised an exception->Syntax error (missing operator) in query expression ''.

I removed the second join statement and it works fine.The error highlights on the 'AND' operator.

But what i want to know is why it is not working for the second join statement.Here's the code i used.
<pre lang="vb">SELECT pr.[project number],pr.[employee number],pr.[current month],pr.[net pay]," & _
"al.[net allowance],pda.[net] FROM [pay_roll] pr INNER JOIN [allowance] al ON pr.[project number]=al.[project number] AND " & _
"pr.[employee number]=al.[employee number] AND MONTH(pr.[current month])=MONTH(al.[current month]) AND YEAR(pr.[current month])=YEAR(al.[current month]) " & _
"JOIN [per_diem_accomodation] pda ON pr.[project number]=pda.[project number] AND " & _
"pr.[employee number]=pda.[employee number] AND MONTH(pr.[current month])= MONTH(pda.[current month]) AND YEAR(pr.[current month])=YEAR(pda.[current month])"</pre>

Nebilo 20-May-14 11:31am View

Deleted

I tried using join statement.And it only worked for the first join when it raised an exception->Syntax error (missing operator) in query expression ''.

I removed the second join statement and it works fine.And BTW i forgot one condition to put in the query then put it and it gave me the right result.

But what i want to know is why it is not working for the second join statement.

"INSERT INTO patempTable SELECT pr.[project number],pr.[employee number],pr.[current month],pr.[net pay]," & _
"al.[net allowance] FROM [pay_roll] pr INNER JOIN [allowance] al ON pr.[project number]=al.[project number] AND " & _
"pr.[employee number]=al.[employee number] AND MONTH(pr.[current month])=MONTH(al.[current month]) AND YEAR(pr.[current month])=YEAR(al.[current month])"

The above statement joins the two tables [pay roll] and [allowance]

"JOIN [per_diem_accomodation] pda ON pr.[project number]=pda.[project number] AND " & _
"pr.[employee number]=pda.[employee number] AND MONTH(pr.[current month])= MONTH(pda.[current month]) AND YEAR(pr.[current month])=YEAR(pd.[current month])"

When i add this statement to the previous code it raises an exception

Nebilo 20-May-14 5:58am View

No i didn't use that statement.I tried the first join statement and what it does is,it assigns the [net allowance] field's first result to all result set from the [pay_roll] table and continues like that.Is there a way to control that?

Nebilo 20-May-14 2:42am View

I've selected the columns from the tables,to be in the temporary table i created.And is it mandatory to explicitly use the join statement since I've come across such a statement on articles using this format.Anyway thanks.

Nebilo 19-May-14 11:00am View

Its raising an error like this -> Syntax error (missing operator) in query expression ''.
I tried to write the code separately and i get this error when i write the second inner join expression.Any thoughts?

Nebilo 30-Apr-14 5:05am View

Deleted

BTW does this work,the question i asked when a temp table is being created?And also if it does i kind of wrote this sql,can you comment on that?

"SELECT * INTO altempTable FROM [allowance]" & _
"WHERE [allowance number] NOT IN (SELECT * FROM [allowance] WHERE [allowance number]" & _
"IS NOT NULL"

"SELECT * INTO altempTable FROM [allowance] WHERE [allowance number] IS NULL"

Nebilo 30-Apr-14 4:56am View

Deleted

BTW does this work,the question i asked when a temp table is being created?And also if it does i kind of wrote this sql,can you comment on that? 
 
"SELECT * INTO altempTable FROM [allowance]" & _ 
"WHERE [allowance number] NOT IN (SELECT * FROM [allowance] WHERE [allowance number]" & _ 
"IS NOT NULL" 

"SELECT * INTO altempTable FROM [allowance] WHERE [allowance number] IS NULL" 
 
The second statement is which i'm using currently doesn't give me the result that i want.Please help me on this one.

Nebilo 14-Apr-14 5:33am View

i was using access db

Nebilo 11-Apr-14 10:40am View

@Richard C Bishop
I think it's not the spacing issue,i've tried it but still it doesn't work

Nebilo 9-Jan-14 9:01am View

It displays error saying,"Value required for one or more required parameters",should i give the value for each project number with a parameter?

Nebilo 3-Jan-14 9:16am View

BTW i'm using MS Access as a back end database,it works right?

Nebilo 21-Nov-13 6:37am View

You didn't give me the articles,plus are there any books that give you a detailed practical description.

Nebilo 21-Nov-13 6:03am View

There are articles telling you that application "x" is built with mvc,n-tier...
and i needed to change my coding fashion to one of those that are out there.

Nebilo 12-Nov-13 2:02am View

Thanks Mikey it worked

Nebilo 11-Nov-13 12:46pm View

I just corrected the code but i didn't see any thing.I put the procedure in another sub procdure that inserts items like this:
CheckDuplicates()
ListView1.Items.Add(payItem.ToString()).SubItems.AddRange({subpayItem.ToString(), subItem, unit, _
bridgeType, span, quantity.ToString(), rate.ToString(), amount.ToString()})

Nebilo 7-Nov-13 6:27am View

It still does that,no problemm with the calculation.When you click the calculate button,it displays the appended items,that is "Total Amount" along with the result.Don't forget that they are appended.So when a user wants to add another item to be calculated."Total Amount" and the latest result again are displayed.
That's what i want to solve

Nebilo 6-Nov-13 3:51am View

Thanks chris

Nebilo 4-Nov-13 9:27am View

can you help me create a function, this is the only problem i'm facing to complete this assignment

Nebilo 31-Oct-13 3:25am View

Thank you for the code,but a new exception arose.It says index out of range exception was unhandled.
Here's the code.

data_reader = cmd.ExecuteReader()
If data_reader.HasRows = True Then
Do While data_reader.Read()
payItem = CDbl(data_reader.Item("pay item"))
subpayItem = CDbl(data_reader.Item("sub pay item"))
subItem = data_reader.Item("sub item")
unit = data_reader.Item("unit")
bridgeType = data_reader.Item("bridge type")
span = (data_reader.Item("span").ToString())
quantity = CDbl(data_reader.Item("quantity"))
rate = CDbl(data_reader.Item("rate"))

Nebilo 21-Oct-13 5:44am View

how do i do that?

Nebilo 9-Oct-13 9:46am View

I've tried str to be double but it doesn't work,being pay item as double in the first place.

Nebilo 24-Sep-13 4:33am View

WorkItemNumber and Description are properties defined in the class using Get and Set methods

Nebilo 18-Sep-13 10:05am View

what do you suggest to use the list box as a container to hold data from the database?

Nebilo 24-Jul-13 8:59am View

Deleted

I wanted to access the data table in another form.But it doesn't fetch data.
//i defined it on a module inside a function
da = New OleDbDataAdapter(cmd)
result = New DataTable
da.Fill(result)
Then on another form i wanted to make my data source 'result' data table like this

If radmaterial.Checked = True Then
dtgResult.DataSource = Module2.result
dtgResult.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells
End If

Nebilo 24-Jul-13 3:46am View

Hi Maciej Los,

You've given me a simple but powerful code,and thank you for that.I've another question,i saw the site you've given me and i tried to load the copied items to datagrid,but i don't know how to use the databound property of the datagrid.
Can you help me on that?

Comments by Nebilo (Top 28 by date)