Farhan_B

In my datagrid my sql statement uses a have clause to get set information and i am having countless errors My code is as shown below, were am i going wrong ` con.Open() cmd.Connection = con Dim da As New SqlDataAdapter("SELECT MONTH(Head.SalesDate) AS Month, Detail.ProductID, Detail.Qty, SUM (Detail.Qty) AS TotalSold, …

`Inline Code Example Here` con.Open() cmd.Connection = con cmd.CommandText = "SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By MONTH(SalesDate), Detail.ProductID" Dim da As New SqlDataAdapter("SELECT MONTH(SalesDate) as MonthlySales,Detail.ProductID, Sum (Detail.Qty/30) as Qty FROM Detail INNER JOIN HeadON Detail.HeadID = Head.HeadIDGroup By …

Hey below is a table i created ProductId ----- Qty ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- 1 ----- 2 ------- 2 ----- 2 ------- 1 ----- 2 ------- Wat i am trying to do is get my sql statement select and display my …

Hi i was just wondering how i would do this task. It seems fairly simple but i dont no how to to do it. In my system i have a table where i have a total figure of the stock. what i am trying to do is when my saler …

ok what i am trying to do is i have two textboxs which have figues in them and need the 3rd textbox to display the figure the code i am using doesnt seem to be doing anything could anyone spot it and tell me why it is not working for …

Currently i am working and using a filter function for my search however i not sure how to do it using a query the sql statement is [CODE]cmd.CommandText = select * from tblcustomer where customerName like "'& textbox1.text &'"[/CODE] I no there is some bits missing but i am not …

Hey i am just a little confused. I am creating a system where customers order items and i have just realized that i cannot add more than one item per order how do i get around this i am using sql and vb thanks

[CODE]"UPDATE cg_security_user_right SET user_id, right_id ,enable_flag WHERE LastName= " & tuser.Text & " right_id = " & tright.Text & " enable_flag = " & CheckBox1.Enabled & ""[/CODE] How can i improve this code thanks in advance

I sence victory been battling the this code for 2 days now. the code i have generated is [CODE] strsql = "delete from cg_security_user_right where user_id= " & TextBox1.Text & " role_id=" & TextBox2.Text & ""[/CODE] it comes up with this error Syntax error (missing operator) in query expression 'user_id= …

hi i have a simple relationship which is shown in the link below [url]http://www.flickr.co...N06/6948010043/[/url] after doing much research i cannot find a proper way of deleting rows which are linked in all 3 tables. could someone guide me on the best way of doing this. This is the code i …

When Creating a query using the sear Criteria Builder . I keep getting the error : " The schema returned by the new query differs from the base query " I no this means that the error is due to the query attempting to return too little columns i have …

hi for my project what i am trying to do is: i have two listboxes and in between the two boxes i have two buttons. Btn1 is to send data from listbox1 to listbox 2 Btn2 is to send data from listbox2 to listbox1 below is my code could you …

hey im doing a project and am having problem getting this code correct could you please have a look at it and help me understand were i am making the mistake the code [CODE] Private Sub m_buttonAddUserRole_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles m_buttonAddUserRole.Click Dim roleIndex As Integer …

im trying to get the insert to work but the problem i am facing is i keep getting this error Can someone help please thanks in advance my code is [CODE]Dim strsql As String = "Insert into cg_security_user (user_name,user_pwd) values (@field1,@field2) " Dim acscmd As New OleDb.OleDbCommand ' the oledbcommand …

im working on this piece of code and for sum reason i cannot understand why i keep getting this message can you please advise me thanks in advance [CODE] 'sql statements strsql = "insert into c_security_user (user_name, user_pwd,) values ('" & txtuser.Text & "','" & txtpass.Text & "')" Dim acscmd …

Hey people hope you are well Could You please help me. I am designing a system which when users login i want the system recoginse who is a admin and a user ( option of deleting only to admin) Using mysql and vb.net Thank you in advance