70 Posted Topics
 | Will you please let me know your working solution? I'm in need of the same. |
| | Hi all! I use VB.NET + Mysql. I have two tables (tblstudents & tblpayments). I want to view payments details of a selected student. Thus, I'd like to select some values (firstname,middlename,surname) from tblstudents and (all values from tblpayments WHERE class = @class -I know how to deal with @class, … |
| | Hi friends! I got one puzzle. I wonder if there is a way I can create a table but get a table name from a value of the textbox/combo box control. Does anyone have an idea? I mean something like "CREATE TABLE (TextBox1.Text) (".....)" I wonder if that is really … |
| | Hi! I want to move on from programming with Access database to MySQL. So I downloaded MySQL Workbenc 5.2CE from [here](https://www.mysql.com/products/workbench/), Installed it and I made my way into even creating a database and a table in it. I just want to know, will it be any different to connect … |
 | I find this to be useful tutorial to me, I've just come into a problem while inserting a person's name which has an ' in it. Will this code provided by Jim work in VB.NET + Access? or its just for SQL? Using VB.NET with Access, what should be wrong … |
| | Hi! I just learnt to use the "Parameters.AddWithValue" to prevent harm of sql injections.However, I have only been able to do this with the INSERT, but I have trouble using that with SELECT and UPDATE. Please Look at my code with UPDATE Try ConnectionSettings() con.Open() Dim SqlUpdate As String SqlUpdate … |
 | I also wonder why php came in here! Why not just from VB.NET to MySQL as G Waddell said? |
| | Sounds difficult for Access, well, I found this solution online, try it and see if it works: ` > Just Share your folder database and change path other user... like this... Collapse | Copy Code Dim MDBConnString_ As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\172.16.0.233\DatabaseFolder\DatabaseName.mdb;" Let us know what happens. |
| | Hi friends! I got an ePad (Model : zte180, Adroid 2.2) device. I want to connect an USB Modem (Airtel) so that I can use it to connect to the internet. I followed the following procedures: go to settings-->Wireless&Network--->Mobile networks --->Access Point Name --->Add new access point. Now, the problem …  |
| | Hi all! I have a table with (StudentID,Physics,Chemistry,Total,Average) I want to pull values of Physics,Chemistry and calculate Total and then Average for a specific StudentID. With the following code: "SELECT SUM (IIF(ISNULL([Physics]),0,[Physics])) As Phy, SUM (IIF(ISNULL([Chemistry]),0,[Chemistry])) As Chem, SUM([Physics])+Sum([Chemistry]) as Total FROM tblForm1 WHERE StudentID = '" & Trim(Me.txtSearch.Text) & … |
| | |
| | Why do I get an error creating a temporary table with something even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please? Thanks! |
 | You can go here:http://www.ehow.com/how_4590003_program-timer-control-vbnet.html to get a start, and you can also Google for that and read. When you start working with the timer and face any problems, I think that is when you should ask here at Daniweb. Happy programming! |
| | Hi all! I think I need some help moving data from one table to another. Here is the scenario: I have two tables, tblDetails (studentID,Name, Class.....) and tblPhysics (StudentID.....). Now, I want to SELECT StudentID from tblDetails WHERE Class = 1 (SELECT tblDetails.StudentID FROM tblDetails WHERE tblDetails.Class = '1') So … |
| | Hi friends! I have a piece of code that I think should be working just fine, but I wonder why it doesn't work, and I get an "Syntax Error in INSERT statement" error message. Here is the code to affect a table called "Users" in my Access database. Dim cmd … |
| | I think one approach is setting a group policy affecting that user, that will limit user's download to 10MB (there is one, just set it). What server are you using? 2006??? Give details. |
| | Hi friends! I'm looking for an easy way to enable a user of my app to print the contet of a GridView.However, I think an easy way will be to convert it into a Crystal Report or pdf (many people say to pdf is terrible), so, I'd like to convert … |
| | Hi friends! Look, I'm managing a Windows 2003 Server machine. I have logged in as Administrator (as always), I have been able to install few software that I have wanted to install, but I have a problem installing this Vodafone Mobile Broadband, a modem that I will use to connect … |
| | Hi friends, I'm developing an application for HR. I have two tables so far.One is tblDetails and the other is Academic. I have created a relationship (ID to AcademicID), I have been able to pull data to a form by this SELECT statement: sqlSearch = "SELECT tblDetails.ID, tblDetails.FirstName, tblDetails.Surname, Academic.AcademicID, … |
 | Hi, sorry, can you help me with this problem in this thread? http://www.daniweb.com/software-development/vbnet/threads/453595/trouble-passing-arguments-to-process.startstatement#post1968375 I will appreciate. |
The End.