Comments by ianshack - CodeProject

ianshack 8-Jan-13 20:19pm View

Okey I got it.

Cheers :)

ianshack 8-Jan-13 5:24am View

Okey, I try that one.

Thanks for your idea

ianshack 8-Jan-13 5:15am View

NO, sir
I want to display the datetimepicker value in crystal report parameter.

ianshack 18-Dec-12 21:16pm View

In Retrieving a data. Which is faster Binding a datagridview or calling a view?
Sorry for my english..

ianshack 18-Dec-12 20:16pm View

Thank you all for your appreciation.

ianshack 18-Dec-12 20:15pm View

Hi Sir, I obtained the query for remaining products.First step, I made a sql statement and made a view for the total_orders and calling a column from a view to subtract to my total numbers of product delivered.

ianshack 12-Dec-12 19:16pm View

Sir I made a new Data Table(fullname) in DataSet Designer and have a TableAdapter queries above.
And I bind LnameComboBox to Data Table(fullname) and it displays fullname. Sir is it okey?

ianshack 12-Dec-12 19:10pm View

SELECT EmpID, EmpLname, EmpFname, EmpMname, CONCAT(EmpLname, ', ', EmpFname, ', ', EmpMname) AS fullname, `E.CatID`
FROM employee

ianshack 12-Dec-12 19:04pm View

I got an error if I add an Item to a control that Bind to a datasource.

ianshack 12-Dec-12 19:03pm View

Sir, It still display the empid not the fullname.

ianshack 12-Dec-12 4:54am View

the displayed text in the combobox is still the empID not the fullname.

ianshack 30-Nov-12 22:42pm View

thank you all for your ideas.

ianshack 25-Nov-12 19:57pm View

Sir, how about the return products? where table I connect the return products table.

ianshack 25-Nov-12 19:55pm View

Thank you S

ianshack 24-Nov-12 3:25am View

Sir, my prodID is autoincrement if I add additional product that already exist; This product should have the same barcodeID. How can I handle this? thanks

ianshack 24-Nov-12 3:13am View

Sir, do I need a barcode table to connect with the product table?

ianshack 23-Nov-12 4:17am View

Deleted

Sir I need help on how product be uniquely identify using a barcode. What table do I need?

ianshack 16-Nov-12 23:58pm View

I add this query in Table Adapter where in where clause the value change each time.

ianshack 16-Nov-12 23:54pm View

Sir I used your query with my MS access database and it works. But when I change my database with MySQL I get an error on where clause;

ianshack 31-Jul-12 0:35am View

sir, can you give me example of update statement or revise my query statement to protect from SQL Injection attacks.

ianshack 29-Jul-12 21:52pm View

I only change the + 1 into the value of my textbox control.
Here is my query:
"update product set prodName ='" & prodNameTextBox.Text & "', Quantity = Quantity + '" & (qtyTextBox.Text) & "' where prodId ='" & prodIdTextBox.Text & "'"

ianshack 29-Jul-12 21:46pm View

thanks for the idea sir, I really appreciate it.

ianshack 24-Jul-12 0:54am View

Thanks for your reply Ashish
I'm a little bit confused about the dataSet and dataTable.

ianshack 24-Jul-12 0:38am View

Deleted

I don't have any book sir, but sometimes I borrow a book in our School library to study.

Thanks...

ianshack 24-Jul-12 0:34am View

thank you sir.

ianshack 23-Jul-12 4:04am View

Thank you sir Prasad_Kulkarni for your idea.

ianshack 23-Jul-12 3:56am View

Operator '>=' is not defined for types 'Char' and 'Integer'.
I got this message sir.

ianshack 23-Jul-12 3:53am View

sir, i get an error the code you gave.

ianshack 22-Jul-12 22:06pm View

Thank You sir

ianshack 22-Jul-12 22:02pm View

okay sir, thanks for your reply.

ianshack 22-Jul-12 21:44pm View

sir, I have already my sample products table(prod_id, prod_name, quantity) and I want to update the products table to add an addtional number of products. If I click the update button the number of quantity didn't update.

ianshack 22-Jul-12 21:29pm View

yes sir on how to insert it, but I want to know on how to add an additional number of quantity in my quantity column in my table. I'm working with inventorying products.

ianshack 22-Jul-12 21:25pm View

Deleted

I download a file from internet (ready made P.O.S system) and there is a report with a dynamic graph and I want to break this executable file to know what is the code for making this report, and it filters with date.

ianshack 22-Jul-12 21:01pm View

thanks for your reply sir, Cause I want to find out what is the code for making a dynamic graph/chart in vb.net .

ianshack 22-Jul-12 20:54pm View

yes sir, I try .net reflector. But there is any tool to break any executable file?

ianshack 21-Jul-12 7:09am View

thanks for the link. Is there any way to do this in Crystal Report?

ianshack 21-Jul-12 6:20am View

I want to be create the graph dynamically based on the data in my database. Where
I can filter the date and display the data.

Comments by ianshack (Top 37 by date)