Im just starting to develop an application using a SQL Database as the main datasource. Now im wondering is it better to use the in-built dataset adapters or write the querys yourself?
If its better to use the pre-generated scripts by using the Datasource UI, How can i use these datasets on a JOIN query?
Example Join
SELECT column_name(s)
FROM table_name1
JOIN table_name2
ON table_name1.column_name=table_name2.column_name
I have a taskfactory application that generates new tasks where a task is running a project exe file that involves a lot of classes. Part of the task process involves declaring a dataset and adding a single datatable to the dataset which is then populated with content from results of a sql query. This datatable is then used in the next class and involves iterating through the table and deleting the rows it has already used. When initiating a new task I assume that it will declare its own datatable and dataset but not sure if this will work.
View 2 RepliesI have 4 ComboBoxen and 1 DatagridView into one Form. I make a code, for binding with 5 tables, each is own dataSet and dataAdaptor Is it possible to use one DataSet and one DataAdaptor for 5 Tables, so my code become shorter.
I think the solution is a SQL SELECT query, but i dont no for sure.If it is a SELECT query, ore something else, cane anybody help with make the code i need.
[Code]...
Checked out the video on MS website by Beth Massi and downloaded the project.
One query she uses this statement,[code...]
I'm I missing a reference or something? This is an Access DB, does that make a difference?
i would like to know on how to recognize a written character using vb.net 2008. it's actual a simple drawing using paint or system.windows.drawing. i've been googling for days but i didnt find anything related tothe image that i had attach below.hat i need to used.based on my understanding, by defaults the "dot" value is zero.whenever the user write each connected "dot", it will give 1 value. itssimply binary code.let say. 1001101100 = b
View 4 RepliesSo I'm developing a program were, given some data by the user, the prorgam inserts some records into a database. To insert individual records in different tables I use either the standard INSERT method provided by the Table Data Adapter or a custom Insert Method when I want to insert something slightly differently.Sometimes the user would press a button and an operation where different records in different related tables are inserted. Since each Insert is handled individually for by the DataAdapters of each table, how can I manage to bring the whole thing to an atomic transaction way? I mean, let's say for example the User inserts a new Document in the system, the document has one or many Editions. How could i do something like: if the document was not created properly, then do not insert the editions.
View 2 RepliesI have an existing system that uses an ODBC connection to connect datasets to a SQL Server database. I want to conevrt these to use an OLEdb connection.
View 4 RepliesI am trying to create a program that will be able to recognize handwritten numbers in a picture. Right now, the program locates a rectangle that the numbers are in. The numbers will generally be in the range between 0 and 9000. I have found some stuff about ink recognition, but I dont think that is the same. Also, is there anyway to be able to make the program 'learn' from the style of the handwriting? I'm using VB.net 2008
"The world is round and the place which may seem like the end may also be the beginning"
Im currently making a program. It loads data from database fields into an combo box. Everything works so far, It just seems to be a mess. Do i need to have all the datasets and data adapters? or can i get away with just using 1 of each. It seems like im doing it wrong, and although it works it seems like a difficult and messy way of doing it.
Also i would like to assign the firshermenID to a variable depending on the fisherman name that is selected in the combo box. When button is pressed: id = fishermanID of the current fisherman (cmbFisherman.text)
[Code]...
I just read this post url...Post #2 by jmc states indicates the use of Entity Framework instead of typed datasets.when jmc says something I usually pay attention. I have a large app that I've been converting from VB6 to .Net and I've used mainly typed datasets.It's a single user app that uses an Access database. I'm have no problems retrieving the data from a table or multiple tables and I'm very happy with its preformance.Is it worth scapping what I've done and learn how to use Entity Framework? I should add that I'm near the end of my programming career not the beginning.
View 4 RepliesIn a typical session with the program I'm writing, the user needs to be able to access the data in 1 to 500 (maybe) tables (but always only one table at a time). Up to now I've been creating these single table datasets dynamically, as and when required.I've now come across the distinction between typed and untyped datasets (where typed seems to be the recommended option). It seems, though, that typed datasets are created at design time only and not dynamically. Is this correct? Are all of my dynamically created datasets therefore untyped?
View 12 RepliesI am trying to create a small windows forms application that demonstrates how a user can use pen-based input(ona Lenovo X220 tablet PC) to enter text (rather than typing on a keyboard) I am using Visual Basic in Visual Studio 2010.I think the control I want to add to my Visual Basic Project is the Microsoft InkEdit ControlThe instructions I see on other parts of microsoft websites refer to a .net framework componed called InkEdit. The instructions I found so far is to right-mouse click on the tool box, click 'choose items' and then select the Inkedit Control from the .NET Framework components.
View 12 RepliesI'm writing a program that need to use handwriting. I have mouse pen with USB interface(buy from Genius, MousePen i608). My idea is that I want to record employee's sign with picture box from my attended form. And then save in MS.access. But I have no idea how to connect my external device and vb.net 2005. how to connect those devices?
View 1 RepliesI am new to VB and am trying to write a program that will open cmd and execute commands when a button is clicked.[code]...
View 14 RepliesDim movie As String = TextBox1.Text
Dim subtitle As String = TextBox2.Text
Dim box As New Process
box.StartInfo.FileName = "MP4Box.exe"
[code].....
When i click a button this code is executed. But it wont execute the command "MP4Box.exe -ttxt " + """" + subtitle + """" Why?
I'm having trouble opening and running DOS commands through VB Express.I'm trying to have VB open a command console and enter path to a batch file. So far I have not been able to get VB to open a console and enter any text.[URL} Here is the code I am using right now (without success)
Private Declare Function GetShortPathName Lib "kernel32" Alias "GetShortPathNameA" (ByVal longPath As String, ByVal shortPath As String, ByVal shortBufferSize As Int32) As Int32
Private Sub des_date_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles des_date.Click
[code]....
I am currently in the process of writing a demonstrative program that will generate a string of 9 random numbers in a textbox. Now my basic knowledge of VB 2010 allows me to do this but my goal is to delay the generation of this number sequence until the my progress bar has progressed to the end. How can I insert a delay after my button activates my progress bar/timer without stopping all function and usability of the program all together. The basic wait function seems to lock everything up for the allotted time and then the number instantly generates and the progress bar begins.
View 8 RepliesI prefer having total control for data access, populating recordsets (now datasets) precisely via a connection string and SQL select (or stored procedure call), etc.Now I wonder whether I really should be using the Data Sources option which just popped up on my radar? From the little I've seen so far, it seems to bind an entire table to a control, whereas most of the time I only need a small number of records from large tables.Before I spend a lot of time investigating, I hope a quick word from you might help me feel happier continuing as I am, or whether I need a kick up the backside towards a Better Way.
View 12 RepliesI need to build an forms app that 'posts' or 'sends' text commands to an external console process, called Minecraft Server It is a java-based process, filename 'minecraft_server.jar'. Run by my computer via 'java -Xmx1024M -Xms1024M -jar minecraft_server.jar nogui'. The Process ID I assume would change each time it's run. This process can be downloaded here: [URL]
I am guessing that I need to:
1) find the Process ID for it, based on its process details, such as Command Line
2) figure out a way to 'post' these commands, commands such as "stop" into the console window
I cannot have this process launched by my VB project.
I write in VB2010, the software should work with the external hardware via RS232, the thing is when I send a command to the external hardware I have to wait for a reply from the device that command was received, just after I got the answer I want to continue send another command, I have a long sequence of commands i'm supposed to send, but I need to know for sure that the commands were received before I go on to the next command. I did the following code, but I think the code is not effective, because sometimes I do not get an answer and then the whole sequence commands destroyed. Maybe you can help me optimize the code? [Code]
View 1 Repliesim trying to send RCon commands to a Call of duty: Black Ops game server.I read a thread from a few years back about sending RCon commands to a CoD 4 server, and all look promising until the application kept crashing when I pressed connect.
[code]....
all I want is to be able to send a few commands to the server through an application.
I have an application, for sending SMS to mobile phones, using a GSM modem and AT commands. It works perfectly, except in one point. If the modem have some problem, for example doesn't have network, or even doesn't have a SIM card, I dont know if the message was sent or not. How can I test if the message was sucefully sent?
View 15 RepliesMy project involves making a table database that displays student number, surname, first name, homeroom, and grade avg. Through SQL commands, there must be functions to add, update, delete, search by field, and save records to the database.I have already set the database up just fine and displayed it in a DataGridView. Through the DataGridView, I was able to go to the "Add Query" area, and I successfully made the queries necessary for searching by field. However, when I try to do anything other than a search using the query builder (ie start my SQL command with INSERT INTO or DELETE FROM), I ultimately get the message "Failed to get schema for this query"For example, this SQL code (to add an entry to the database) worked when I was in the Query Builder (and the entry that it made is still in the database), but when I finally tried to confirm it, I got the "Failed to get schema for this query" message.Being unable to add entries to the database this way, I tried to do it with textboxes on a form. Each textbox will have one of the fields, and at the click of a button, they would be put into the table. My code is below. I do not know what is wrong withit. When I run it, my fields do not appear on the DataGridView immediately, but I must run the program again to see it. The time after, the entry is gone. So I am not sure how exactly such entries are to be saved.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Try
[code].....
What is the best way to resize & move a form using just VB commands? I have a form that I need to set the Height and Top props, problem is that takes two calls and there is a noticable flicker. I tried using SuspendLayout/ResumeLayout, DoubleBuffered, swaping the top and height calls around, etc, but nothing seems to help. The test forms only have one small listview and one or two buttons. [Code]
View 2 RepliesI'm trying to work with an ODBC driver for Interbase in VS2008 (vb). I succesfully inserted the data tables I want to use in the project datasource. Then I want to add some rows in one of the tables of the datasource. I used myDataSet.addTABLENAMErow(field1, field2, ...).The compiler gives me no error, but when I open the database with InterbaseConsole, the line I've add is not there. Do I do something wrong? Must I open/save the database (how do I do so). I've tried meDataSet.AcceptChanges whitout result.I'm not used to work with Datasets and tables...
View 1 RepliesAnyway to view the content of a dataset or datatable in debug? I don't mean looking up a specific element of the dataset but to view the hole thing.
View 4 Repliesdifference between the two statements given below
1. Dim ds as new DataSet
2.Dim ds as DataSet = New DataSet
I'm trying to combine two datasets, each with 1 datatable and each having the same schemas. Datatable 1 would have a list of records. Datatable two may, or may no, have some or all of the records from table 1 plus more records. I would like to remove all the records from table 2 that are present in table 1.
This is what I got so far:
For Each table1 As DataTable In ds.Tables
For Each row1 As DataRow In ds.Tables(0).Rows
ds.Tables(0).PrimaryKey = New DataColumn() {ds.Tables(0).Columns(0)} 'Where 0 is the index of the column that's your key
row2 = ds2.Tables(0).Rows.Find(row1("ID"))
'if its found, delete it
Next
Next
how to join two datasets together.
First Dataset
Dim sql As String
sql = "SELECT payment.Debtor, SUM(Value_invoice) AS before_this_month,debtor.nama FROM Payment INNER JOIN dbo.debtor ON Payment.Debtor = debtor.debtor" & _
[code]....
Now i just want to either inner join or left join PaymentBeforeThisMonth and PaymentThisMonth into another dataset?
I have a dataset that contains only employee ID's. I need to loop through that dataset and for each employee ID I need to loop through several other datasets and pull data. I need help with this looping syntax. Here is a sample of some code that I am receiving an error with:
Dim EMPID as Integer
Dim CommandEmpid As New OleDb.OleDbCommand
Dim EmpidDS As New DataSet
[code]....