I made a simple VB application has a database created by SSMS and attached to it.Here is my form
Imports System.Data.SqlClient
Public Class Form1
Private cs As New SqlConnection("Data Source=STARMAX-PC;Initial
[code].....
I made a simple VB application has a database created by SSMS and attached to it.Here is my form code:
Imports System.Data.SqlClient
Public Class Form1
Private cs As New SqlConnection("Data Source=STARMAX-PC;Initial Catalog=PRACTICE;Integrated
[code].....
I want to split this up into 3 side by side tables but have been unsuccessful in any of my attempts. Currently it prints one large table. The reader.Read is performing a really simple query that pulls a few names from a table.
Dim htmlString As String = "<table>"
While reader.Read()
htmlString = htmlString + "<tr><td>" + reader(1) + " " + reader(4) + "</td></tr>"
End While
[code].....
I have a big problem with a software I'm creating for my own use.I have code in my software that downloads the source code of a webpage into a .txt file and filters out information it's looking for. For normal HTML code this works fine.The problem is when I can't target specific parameters in the HTML code because they're too vague.I can download this kind of unique HTML code and pass the variable (Brown in this case) to Strings in my software because it's on the same line of code making it unique:
<div class="Performer_DataLabel">Hair Color:</div> Brown</div>
However I want to know how to search a specific table and its rows and cells (like this one below showing the code for 1 row and the 2 cells I'm interested in):
1. <tr>
2. <td class="paramname">
3. <b>Hair Color:</b>
4. </td>
[code]....
The question (Hair Color), regardles of how many hundreds of lines the full source code is, is always on the same line within the row of the table (line 3).The answer is also always on the same line (line 6) in the row of the table.However the question rows themselves are not always on the in the same place of the table.
I have two DDBBs, one table (basic table) with basic data and another one (city table) with a list of cities and a code for each city. I want to add the city code into the basic table. The problem is that I am showing on the webpage the name of the city, no the code... but I am not able to get the code that I want to save into the basic table.
[Code]...
Here is the:
Imports System.Data.OleDb
'Add reference to Access then
Imports Microsoft.Office.Interop
Imports Microsoft.VisualBasic
[CODE]...
I am using this to copy tables in an Access database(2003). the questions I have are:
1. How can I make this more 'obejct oriented'?
2. How can I copy just the structure of the tables and not the data?
(Currently both are occuring)
I do no know how to go about doing this. I have a view in the db. I have gatheredall the data in that view. Now when clicks a button, i want to transfer half column data in the view to header_table and the other half into the lines_table. Also once it is transgered, I want to display it in a grid view. This time all the fields from header_table and all from lines_lines. Can someone guide me how will I do that by an example of code that is not very complecated and does what I want to do?
View 1 RepliesI am working on a database application. I had used Dataset to link my VB programme to a database and selected specific tables. However, I created more tables in the database and I wanted to add the new tables to the dataset. I could not find a simple way to do this, so I deleted the existing dataset and created a new one. This move has broken my VB codes. I can no longer run them as errors are shooting up. In fact, I connot view the forms in my programme anymore. I have a backup of the codes to rerun, but then I need to add new tables to the dataset.
View 4 RepliesIs it possible to join a table from a SQL Server DB and an oracle DB?
View 1 RepliesHere is the error: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.When I click the save button, the system must update its 2 table PurchaseOrderTable and ReceiveOrderTable.
Here is my
For ct As Integer = 0 To stat.Rows.Count - 1
If CStr(stat.Rows(ct)("PO_Product_Name")) = dgvSalesEntry.Rows(ai).Cells(2).Value Then
[code].....
I have one DataSet and two forms, Customers and Efficiency. When I make changes to the Customers table (Delete a Customer for instance) It does not reflect the changes on the Efficiency table. The default form is Efficiency and I'm calling the Customers form from within the Efficiency form. I make the change in the Customer form, I then close the Customer form and call the Efficiency form back. The data is not updated on the Efficiency side until I close the application and re-open it. what code I need and where to inject this code?
View 14 RepliesIs it possible to insert/put a Timer inside the Database?Let say in my Database/Tables i have MemID, Name, Membership Date and Status (Active/Expired).for example MemID [ 1 ] Name [ Juan Paolo ] Membership Date [11-17-10] Status [ Timer ]in Status is it possible to save the time even while the program is close?..or code like if MemID 1 reach 2 Days all of the information of MemID 1 will be clear and Status will become [ EXPIRED ] , while timer is running the Status is Active, and if the Timer Reach 2 Days the Status will become [ EXPIRED ]
View 2 RepliesHow to fill a TreeView from two related tables (Customers 1 -> Products n)? I have seen the example of microsoft using Northwin Database and I do not understand this, I need something simpler.
View 2 RepliesI have the following database setupWhat I want to see is the tblOpponent.oppTeam when given a matchID in tblGameI tried the following SQL string in VS 2010
strSQLString = "SELECT tblOpponent.oppTeam FROM tblOpponent WHERE tblOpponent.oppID = tblOppBowler.oppID AND tblOppBowler.oppBowlerID = tblGame.oppBowlerID AND tblGame.matchID = " & MatchID.ToString
[code].....
Is there a way to modify the text of a primary key and not have it delete all the following rows in other tables related to it?
View 6 RepliesIm stuck to where to go from here. I have got a form (pictured sorry had to blank out names)Now each row has got its own table. Each table has about 8 columns, but the two important are "Tdate" & "Value1" Tdate - contains a date (dd/mm/yyyy)Value - contains the value of an expense what i need to get is the sum of all the expenses for the month for every month for all 12 tables.I don't how i would go about this, is there a quick and easy/best way to do this. otherwise its looks like im creating 144 queries.Im using Access 2010 and Visual Basic Studi0 2010.
View 7 Replieshave this code to show crystal report
Dim rptdoc As CrystalDecisions.CrystalReports.Engine.ReportDocument
rptdoc = New CrystalReport6
rptdoc.SetDataSource(table)
[code].....
First off I'm a newbie to VS but hopefully my question isn't terribly clueless. I've been searching endlessly for an answer but I don't find much relating to VS 2010 I'm running VS2010 Ultimate and I'm creating a Windows Form app in VB .net 4. I'm connecting to SQL Server 2005.
[Code]....
I've been searching all day about this and can't find a solution..I'm fairly new to VB and SQL Queries, so I apologize if I sound a little daft.Basically I'm working on a project in VB 2010 where a user can add new teams, players, also create matches between teams and record the score. I have done nearly all forms, but now I need to show data from 2 tables on one form and the method I used for 1 table doesn't work.I have 4 tables:team, player, match & matchdata and they are linked like this:
[Code]...
How will I combine 2 tables from my database? And show its data in my datagridview.
View 2 RepliesI have an Access 2003 DB and an SQL Server 2005 DB.
I have one datagridview where I want to present data from both databases.
My query would look like this:
SELECT
ACCESS2003.Resource_ID,
ACCESS2003.NAME,
SQL2005.Resource_ID
[Code]....
I have a database created using sql server express 2008. There I have two tables called tbl1 and tbl2, which are related as tbl1.CityNumber=tbl2.CityNumber.
I have created the programme using VB 2010; there, a form has three textboxes.
Tables: tbl1,tbl2 ; (related as tbl1.CityNumber=tbl2.CityNumber)
Columns to be updated:tbl1.CityName , tbl1.CityNumber, tbl2.StreetName
TextBoxes on the VB form: txtCityName , txtCityNumber, txtStreetName
[Code]....
But, now the problem is, the two tables have not get updated,after going to the database in MS.SQL Server Management Studio. I think I'm very closer to have my required result. I have tried my best to track place,where I've gone wrong.I have been trying to find a method for last five days.
I have 2 tables. I'm getting info from table1 which is loaded in an rtb.
vb.net
]Dim cmd_info As New MySqlCommand("SELECT kan_info FROM kan_info WHERE kan_id= '" & kt_id & "'", conn)
reader = cmd_info.ExecuteReader
While reader.Read
beslag_kanton_info.Text = _
"RB_REF: " & vbNewLine & _
"KT_REF: " & vbNewLine & vbNewLine & _
reader.Item("kan_info").ToString
End While
This works great, but I need to add extra info after "RB_REF:" and "KT_REF:" (e.g: RB_REF: 12345 / KT_REF:6789) Those values are located in another table. How do I change the code/query so it also get the necessarily records from that table? Obviously there is a column "kan_id" with same values. I can't merge the tables btw.
First of all, sorry for the last fail thread.So, as the title says, I want tables for RichTextBox. (vBulletin messes up ALL ASCII art by the way.)
View 3 RepliesI am using VS2008 and SQLite. I have created a database and several tables and am attempting to populate the tables with data from arrays.
The following code (example) works fine but stops after it inserts 30 to 50 records. I am running the VB code in debug mode and when it stops, I press pause to see where it is. It stops on "SQLcommand.ExecuteNonQuery()" and when I press continue (F5) it will insert another 30 to 50 records.
I do not get an error message. Is this a timeout issue? How do I keep the loop running to the end of the array?
Following is example code.
Dim
SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLiteCommand
CODE:.....................
have a datagridview containing 2 tables left joined, so that:table1 LEFT JOIN table 2 ON table1.id=table2.idI get an error whenever I try to edit my datagridview."invalidOperationException was unhandled by the user codeDynamic SQL generation is not supported against multiple base tables."The error points to this line:
da.FillSchema(dt, SchemaType.Mapped)
da.Update(dt) << This line
'da = dataadapter
[code].....
In my datagridview I was fill in using join tables (table1 = pr_employees, table2 = pr_employee_deduction). My problem now is during save button I want to update records from table2 only.[code]
View 3 RepliesI have written lots of code with the ADO Library in VB Excel and previous versions of Visual Basic. With the dissappearance of the recordset object, how do we perform data manipulation with an attached Access Database? It seems things could be a lot easier, and less complicated by now, however, the best methods appear to currently remain ellusive.
[Code]...
My project is about recipes. I want to automatically create table inside in mysql database when I hit the add button on my project through codes. First is when I input recipe name in the textbox1 then my input will be saved in the recipes table under recipe name column and also create a new table through codes on what i input in the textbox1
Example of my database in sql
texbox1 input will be save here
recipes - id, recipename
And then it will also automatically create a new table in mysql database, create newtable, with id, quantity ,unit, ingredients
Private Sub iadd()
Dim command As New MySqlCommand("insert into recipes (recipename) values ('" & TextBox1.Text & "')", connection)
Try
connection.Close()
connection.Open()
command.ExecuteNonQuery()
[Code] .....
I am trying to create a button on a form that will open a connection to a database and list all the tables in the database inside a listbox. Everything I have read indicates I can associate a single table to a form, and have no idea how to:
a. Create code for the button to access all the tables in the database.
b. Display that list in a list box.
The text that I am using is murach's ADO.NET 3 database programming with VB2010, and I am less that thrilled with it.