I need your help with Getting MPEG-2 PSI Tables. Anyone can tell me what can i do to get MPEG-2 PSI Tables? I found some information here:[URL]... but there is nod said how to get MPEG-2 PSI Tables.
View 2 RepliesWhere I can found more Information how to use a mpeg.dll from microsoft to convert my AVI-movies to mp4?
View 2 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 RepliesWe are presently developing an application, let's call it APP1, which uses a SQL Database which have about 800 stored procedures, 600 tables, etc. APP1 was originally created in order to replace another application, APP0, from which we do not have source code but only SQL tables, Stored Procedures, views, etc. Previous programers of APP1 used some DB objects from this same database and added some other objects specific to APP1 because it becomes bigger than APP0. And we do not need APP0 anymore as APP1 does all what we want, and more.
So, now, we are thinking about a way to find out which objects are used by APP1 in order to remove objects which are ONLY used by APP0.What is the best approach to discover all objects used by APP1 without having to open every single class and form?
Once we will have a complete list of these objects, it will be easy to use a program we bought which detects all dependencies for all SQL Objects specified directly from SQL and remove objects which do not return from any dependencies. Any ideas of how I could get this list without having to go through all our program that have many, many, many classes and forms?
Note : I know, in a perfect world, all calls to PSs and tables should be in a DAL but in the case of the application we're presently working on ... this is not our case! Yippy! (sarcastic yippy) ;)
Note 2 : This application is not using any ORM. So all queries are directly using SqlCommand. So any call to any DB objects are in string format.
I have a 5 tables in my database and i want to access all my tables togather at a time.e.g.I have a code for one table i.e. rs.Open "select * from Group_info", con, adOpenDynamic, adLockBatchOptimistic. instead of Group_info table i want to access 5 tables also as Login_table,User_info table,group_name table etc. How i do that
View 11 RepliesSQL statements:
SQL = "SHOW TABLES;"
Try
conn.Open()
The remarked area works fine when I'm accessing a specific table. I've successfully inserted the products_model field into the combobox too. The datagridview does show the table names in the db using the SHOW TABLES sql statment, but I'm not understanding how to get this info into the combobox instead.
I am trying to make a database, fill it with tables and then fill the tables. I am having problems connecting to the server and am really not sure why. I have posted this thread in two areas of this site because I was not sure what was the best area to put it in. [code]
View 3 RepliesPrivate Sub frmReportExpenses_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim objDatasetExpence As New dSetExpences // dataset object named as dSetExpences
Dim objRptExpence As New rptExpences // Crystal report object
Dim MyCommand As New OleDbCommand()
[code]....
This code show error "Report has no tables"i want to show crystal report using Access 2003 Database pragmatically. blank report is added in project and trying to fill it DataSet object.
I signed up for a free 30 of Azure. I logged in, created a database. I am able to connect (=Test Connectivity). But that's it. I don't see anyway to create tables, etc. Also how can I connect this db to vb.net (I am using vs.net 2010)?
View 3 RepliesI've been programming an application for someone, and have run into various questions.
View 2 RepliesI really need assistance for this multiple problem am facing here. Let me take you to my hell: I've got three tables in my database that are:
1) tbAthlete (athleteID, nationID, gameID, fname, lname)
2)tbNation (nationID, nation)
3)tbGame (gameID,game)
I connected the database to vb and created a (form1) based on a query that use all fields except IDs. that form1 is just good as displaying and navigating throug records. Now i wanted to link that form1 to another form(2) which will allow me to update and add new record. in the form2, country and game need to be combobox as there is no need to enter new record for them. so when adding new record, only "tbAthlete" table get affected. form1 works as excpected. how do i go for the form2
How to check whether two tables in SQL are the same using vb.net? Would u mind giving me the code?
View 2 RepliesI would like to know how to compare two tables which are in a datagridview each one. I imported one from excel and the other one from sql, i want to add the info that is in each cell of excel's table in sql table..though i don't want to have duplicated data.I want to do something like this
'datagridview1=exceldv
'datagridview2= sqldv
for each item1 in exceldv
for each item2 in sqldv
[code]....
I want to track changes of a document which sits in a DB table like :
document starts
document continues 1
document continues 2
document continues ...
document ends
(Each line is a record but if needed I can combine them all to one record)I have the document before changes in one table and the document after the change in another table.My problem is that if I just compare them by ID then I'll get many more changes than actually occured. Ex: If a line (/record) was added between record 2 and record 3, instead of tracking 1 change I will see that all the records from 3 and on have changed (because they will be pushed off by one record). Can be also something which knows to compare documents and I'll take the information out to document for comparison.
I have a table called PARTS and table called PARTEXT.
PART has:
PartID
PartDescription
PartCostPrice
PartSalePrice
PARTEXT has:PartID
PartImagePath
For some reason (please don't ask me why) the designer of the database splitted the tables.I need a sql command to "combine" between the two tables by making new View, so it will show the content of the PART table and in each row it will get the PartImagePath of the same PartID that both tables have.
How to copy records from one table to another table?
View 1 RepliesI am trying to achieve this.
Public Enum Tables
customers
[code].....
how can I get all Tables from a Database, which I'm connected to. By the way, this is a MSDE Database.
View 3 RepliesI've got two different tables in my database. One is Class and other one is LAREACT and both of them have a key field of MAIN FACILITY USED. In the following part of my code a DataTable will be generated based on the sum of the records on both tables.Based on the bellow code ACTIVITYLOOKUP datatable is having "MAIN FACILITY USED","Description","TypeName","Type","Id" columns. The issue happens when there is a row with the same MAIN FACILITY USED entity. The datatable will not show it (filter it?). Do you know where the problem lies? and how it will be fixed without any modification in database?
[Code]...
what i need to do is to get information from 2 tables and show it to the listview. for example, i want to get the surname, first name and middle name from the student_info table and the Payment_Status from the accounting_system. i don't want to show the information that is already on the accounting system that has 'Paid' on the Payment_Status.[code]but the listview only showed the first data on the database
View 10 Repliesmy code: command1.CommandText = "INSERT INTO table1,table2(value1...,value2..)VALUES('" ...... "')" how to save multiple table is one query? i tried this thing but it didn't work
View 3 RepliesI've been using Java for a number of years, and now I'm at the beginning again with VB.NET.How would I go about joining two tables?- order doesn't matter, as long as i can print/display the order
Here's an example of what I'd like to do:
table 1
data 1 , data 2 , date time
12 , 23 , 2010/8/20 10:00:00
[code].....
im using dreamweaver and i have a table in which i have an image. When i add another table under the table existing it comes right at the bottom. What should i do to that table so i can move it and place it anywhere around the page. displaying my data wherever i want. And another problem is that, when i place something on the top it doesnt show up there it comes slighty away from where i had placed.
View 1 Repliesi have 2 sql database tables and one datagridview i want to fill those table in one datagridview like this
table 1
Column1 Column2 Column3 column4
1 INV total Balance
2 INV total Balance
[code]....
first table first Row then 2nd table first row ? its possible to fill table like this in datagridview?
I use Visual Basic 2008 Database is Mysql Three tables:
[Code]...
Dim LocationList =
From rows In db.Locations, clientRow In db.Clients, stateData In db.Ref_States
Where rows.State = stateData.ID
Select ClientName = clientRow.Name, rows.ID, rows.Address1, rows.Address2, rows.City, StateName = stateData.Name, ShortStateName = stateData.ShortName, rows.ZipCode Order By Address1
That's what I have and it is very wrong. Everything shows up, but the data displays incorrectly, displays more rows than exist.
Dim LocationList =
From rows In db.Locations, clientRow In db.Clients, stateData In db.Ref_States
Where rows.State = stateData.ID And rows.ClientID = ucClientID And rows.ClientID = clientRow.ID
Select ClientName = clientRow.Name, rows.ID, rows.Address1, rows.Address2, rows.City, StateName = stateData.Name, ShortStateName = stateData.ShortName, rows.ZipCode Order By Address1
I'm trying to do a join on two tables but i'm having a hard time. Here's the table schemes:
table1 : tbl_Trainees_IntentToParticipate
Scheme:
TraineeID (PK)
FName
LName
I want to select all TraineeID/FName/LNames from table1 where TakenTest (from table2)= false
heres the sql statement I have so far:
SqlJoinStatement = "SELECT tbl_Trainees_IntentToParticipate.FName, tbl_Trainees_IntentToParticipate.LName" _
& "FROM(tbl_Trainees_IntentToParticipate, tbl_Trainees_TabScores) " _
[code]....
I am having difficulty with a SQL query in my project.I have 3 tables.
T1:
- Date
- ID
- Location_ID
[code]....
From this I need the T1.Date and T3.Result based on Location in T2.So my I need a query to compare a known location, get the Location_ID. Then Use that Location_ID to get the Date and ID. Use the ID to get the Result from T3. (Value is a variable with the known Location)
This is what I have tried:
"SELECT T1.Date,T3.Result _
FROM T1,T2,T3 _
WHERE T1.Location_ID = (SELECT T2.Location_ID FROM T2 WHERE T2.Location = '" & Value & "') AND T3.ID = (SELECT T1.ID FROM T1 WHERE
T1.Location_ID = (SELECT T2.Location_ID FROM T2 WHERE T2.Location = '" & Value & "'))"
I get the error 'Sub query returns more than 1 value...'