Search the Community

I got it to open the application when I right click and clicked my app, but the picture didn't open. Same thing with Double clicking. I looked for code online with no success; Google only found how to open in Visual Studio, not what I wanted. Not to be mean, but if I don't get any answers again, I will be quitting for VB on this page and look for an alternate VB Forum. Twice, I ask for help here on this Forum about Visual Studio/Basic, and nobody answers, and can't change tags for better luck. Frustrating. However, I may still ask about other codes if I get answers. Anyhow, I want to use this highlighted "Open with..." command, or replace "Open (the app, and manually open file by drag-and-drop to the app)" and have it open. Automatic, not with open and drag-and-drop. I want to open when I double click. I need code to link the opened file like I did drag-and-drop to a picture tool to auto open, unless I opened the app alone... Let me know if you need the current code. Please, PLEASE give me help, thank you for the help. Any help WOULD BE APRECIATED.

I have a form that features a drop down list that uses sqldatasource1 to automatically have the user selected. I'm wanting to add linkbuttons (A-Z) so when the user selects the given linkbutton only users who's last name begins with that letter is visible in the drop down list. I have stored procedure written and created sqldatasource2 for this but I'm unsure of how to code it to reflect what I'm wanting it to do.

Hello I have this SQL Statement: de.SqlStatement = "SELECT A.Name, A.Catagory , COUNT(Patient_ID) AS PNO FROM PatientApplyToAssociation P INNER JOIN Association A on A.Association_ID = P.Association_ID WHERE A.Catagory='" & "health" & " '" & "' GROUP BY A.Name '" with this Exception: System.Data.SqlClient.SqlException was unhandled by user code class="16" ErrorCode=-2146232060 LineNumber=1 Message=Column 'Association.Name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. I had this exception when I added the where clause, It seems that the compiler cant see the Group By Section , because of the quotation ending before it, I tried to write it like this: de.SqlStatement = "SELECT A.Name, A.Catagory , COUNT(Patient_ID) AS PNO FROM PatientApplyToAssociation P INNER JOIN Association A on A.Association_ID = P.Association_ID WHERE A.Catagory='" & "health" & "' GROUP BY A.Name '" & " '" But it was an Incorrect syntax near ' '. p.s. I selected A.Catagory because I needed it in the WHERE clause, I need the category to be "health"Any ideas ? Please Help me..Thank you