I recently switched to V.Studio 2008 and using VB. I can not find in the data toolbox the connection and data adapters. Should I do something else to make this appear so I can drag them in my form.
View 2 RepliesI have a basic application that allows pre-defined users to use the application.The Username & passwords along with some other basic user info is stored in a simple access dbIn my application I want a user to login, Username & PasswordI create a connection string, a data adapter and a dataset, I then need to validate the password the user has entered.Would it be best to query the access db directly, or the dataset?
View 5 RepliesI am working on a huge multiform project for my company, and one of the few issues I am having is that when I am on the Main Menu Form, then go into a specific form (i.e Sales Order, etc.), do updates, changes, or just view data then close the Sales Order Form, if I happen to go back into the Sales Order Form without closing the entire project, then the Sales Order Form will display data instead of opening a blank form like when I first opened it.
Is there something that I should be adding to the Form Close Event to dump all of the data or refresh the data adapters so that if I open the form again, it will display a blank form that is ready to be used like when I first opened it?
I have tried using;
Me.Dispose()
Me.Close()
when closing these subforms, but if I open them again, the data fields (combo boxes and text boxes) will have random data in them.
Hoping for some advice, probably an easy question for most people on here but I'm a mere learner. Basically, what would generally be the reason for using a Data Set via adapter rather than just connecting to the database directly using an SQL connection?
View 2 RepliesHow to create the data set, and data adapters in vb.net can any one illustrate with an example. I have used the SQL server, to create the tables.
View 2 RepliesI have just installed VB.Net 2005 to do my Uni project at home.Why cant I find the Data Control in the the tool box and nothing when I press CTRL and T..I need to define the ado control name but having no luck as yet.
View 3 RepliesI have a problem reading data from an RFID-reader. I connect to the reader by tcp and wait for DataAvailable to be true, then reading the data until I got a end of data character. Then I just go back and waiting for a new DataAvailable. This is done in a own thread for the function.
There seems to be some kind of timeout, If I don't got any data in a couple of minutes, then it just sits there in the do/loop waiting for DataAvailable. I hold the card to the RFID reader, it beeps, but there is no data available. I don't get any exeptions, and the information says that the clientsocket is still connected. Are there anything more I can check?
If I put the card to the reader in a minute-interval it seems as this will never occur. So 2-3 minutes idle:ing seems to do this.
Here are my code to read data from the socket, I have taken away some irrelevant code:
Sub test(ByVal ip As String, ByVal port As Integer)
' this sub is meant to run forever
[CODE]......................
I have inherited an application at work that someone else started creating, right now about 1/2 of it is functional and is in use. My problem is that it is all done in 2.5 ?? and I am trying to step through it all to figure out how it works. I have always created my own binding sources, adapters and data tables.
One of the things I need to do is add a field to the fm_fieldman_master data table. I add the field in the db (SQL Server 2005)table, I come into VS and refresh the datasource, I then add the field to the fm_fieldman_master data table and the Fill,GetDAta() query I go into the designer and create all the attributes for the combo box
[Code]...
I would like to know the best, or standard, way to accomplish real-time client updates in a small multi-user application using an access data table as a data source.Specifically, this application will be used by 3-4 people. It uses a datatable which is filled on form load and bound to a datagrid at design time. The datatable is stored on a shared drive. The data table on the shared drive is updated in two ways:
1) Users can update the datagrid which then updates the datatable on the shared drive via the data adapter's Update method.
2) A server application does some work on some text files, periodically updating the data table.
I need the clients to reflect the changes to the data table on the shared drive as closely to real-time as possible. I know that the data table stored in memory on the client is disconnected from the data table on the shared drive, so I must query again to get the updates.
1) Is there an alternvative model I can use which is connected, and which will automatically reflect the updates in the data table on the shared drive?
2) If not, what is the best way to check for changes in the data table (so I can know when to call the data adapter fill method)? I am planning to poll the drive for a change to the .mdb file, raise an event and then fill the data adapter when the event is triggered. I am using this method successfully now to check for changes to a text file in another application, and I know how to implement it?
You can iterate the controls collection and me.components.components to find certain objects, but nowhere can I find where a form keeps a collection of its early-bound table adapters. When you add them in at design time and bind them to a control, it shows them on the design window, and it creates them in the design.vb file, and they're available as a property of your form object... but I can't find a way to browse through them and pick one in code, like you can with the control collection (I.E. me.controls.Item("controlname")).[code]...
View 1 RepliesI am currently using vb 2008 and access 2003 as back end database. I am trying to import excel data to a data table. my excel and access table header & columns are same. I was trying to do this.........
[Code]...
I tried this code to check if the data in textbox1 not equal to any data in column name, so insert the data that in the textboxes to the table1. Esle.. do another thing. But it didn't success with me.
Code:
Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source =" & Application.StartupPath & "DataBaseName.mdb "
[Code].....
If you are creating a new adapter, drag a data adapter object from the Toolbox onto a form or component.
I cannot find Data Adapter object anywhere in the toolbox. I assume it would be under the Data grouping, but it is no where.I also "Reset ToolBox" and it is still not there.
I've written a very simple program that writes a tiny "config.cfg" (text) file to the computer (using StreamWriter), and a second program that is supposed to read that data back.
Unfortunately, it appears you can't save to the same folder as your program under Win7 ("Program Files (x86)" is a restricted folder.) So instead, VB automatically saves my data to the "C:Users(myname)AppDataRoaming..." folder. This is annoying, but tolerable.
PROBLEM IS: How does my second app then FIND my data file (without doing a time-wasting drive search every time the program is run?)
My code:
' Program #1:
Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim FileWriter As New StreamWriter("config.cfg")
[Code].....
There are few steps to find out the half slopes of the graph.
Step 1: Rank the data The independent variable is required to rank it from the lowest to the highest.
Step 2: Divide the data Divide the sample size into 3 roughly equal parts, which is the lowest, middle and the highest parts. If n/3 has remainder of 1, +1 into the middle part. If n/3 has remainder of 2, +1 into the lower part.
Step 3: Find the median The size of each part = n, find the ((n+1)/2)^th value for both dependent and independent variables. If the ((n+1)/2)^th is not an integer, sum up the 〖n/2〗^th value and ((n+2)/2)^th value and divide the total by 2 to make it as median. The median, m1 for independent variable in lower part indicate as XL , middle part median, m2 as XM and the highest part median m3 as XH. For the dependent variable the median is indicate as YL, middle part as YM and the highest part as YH . Figure 3.2 Example of median m1, m2 and m3
Step 4: Find the half slope Find the half slope for the lower half, b_L=(Y_M-Y_L)/(X_M-X_L ) and for the upper half, b_H=(Y_H-Y_M)/(X_H-X_M ) .
Step 5: Find the half slope ratio, b_0=b_L/b_H . If the ratio is negative, the dependent variable need to add with a constant, c in order to make the slope same direction.
Step 6: Identify transformation. Depend on the graph pattern pick one type of transformation which is nearest to the original of the variable.
Step 7: New half slope Find out the new half slope ratio, b1 by repeat step 4 and 5 with the transformed variable.
Step 8: Repeats steps Repeat step 6 and 7 with choose the transformation which is nearest to previous transformation and find the new half slope ratio, b2, b3,�, bn. Repeating this step until |1-b_i |≤|1-b_j |, for i<j, i and j = 1,2,3,
Step 9: Result bi is chosen. The data transformation used in bi is the most closest to be normality.
How to make it into visual basic and let it run by the program?
I have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[code]....
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesI just looked like 10 times, I can't find it.
View 4 RepliesI have a program that sends some data on a networkstream through a tcp connection.
[Code]...
I wasn't sure whether to post this here or in the VB Express forum, so sorry if I picked the wrong place.where I can find the icons that are used in the toolbox in this IDE?
View 4 RepliesI am trying to get a heads up on converting a vb6 project to vb.net. I can not find the sstab control in the toolbox, does it have a different name ?
View 9 RepliesIs there anything like shapes control of VB 6.0, in Vb.Net? I need to draw lines etc. at design time. But I could not find any shapes control in the toolbox.
View 2 RepliesDoes anyone know an easy way to produce a "Common Tasks" menu similar to the one in My Computer, Control Panel etc..I can't seem to find a control in the toolbox and it would be insanely useful for the app I'm currently writing.
View 4 RepliesI can't find FileListBox,DirListBox inside the toolbox
View 2 RepliesI am making report form. I want to display data which is rendering from data MS Access. I could not find the gridview in toolbox. I found datagridview for this req. but this controls displaying header like button format. I want to display just simple data and print.
View 3 RepliesI got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
i am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 RepliesDoes anybody know where to find a toolbox for Visual Basic 2005 or 2008 that allow to create level, button, display or other special box used on a bridge of a ship? I want to simulate a small bridge of a ship and I need something that allow me to display engine power, rotation speed, level of pressure, compass and so on.
View 6 RepliesI'm developing a VB.Net and SQL Server 2005 Express application.Q: How to encrypt string values in the database to secure them from the one using my software and from DBAs (people who have access to the DB Server)? Here is what I tried:First, I used a Symmetric Encryption provided by the .Net Framework. But I noticed that I could not make partial searches (LIKE keyword). So, this is not working.
Then, I used a logic similar to the ROT13 to hide text. Although this logic works fine from VB.Net, once data has been stored in the database, the logic fails to decrypt data correctly. After some tries, I thought that the reason the logic failed was the Collation of the database (I do not know much about Collation topic).So, the first way doesn't allow partial searches, and the second way is not secure and also does not work because of the Collation or maybe another reason.I want to encrypt data. I've successfully hidden the schema by giving meaningless names to tables and columns.
I have vb 2008 and I have RSLinx classic, and a Allen Bradley PLC. I knwo there is a way to have vb call through linx to the PLC, I just don't know how. There are about 90 different tags in the PLC I would like to have logged into a csv/excel file. My thought on doing this was to have a very simple vb program to just collect that data and every day at midnight have it save it to a excel file. My problem comes when I try to talk to linx, I have no idea how to get them to communicate. I am just looking for some ideas on how to get that to work. I have tried link...whatever, and it seems that was for vb 6.
View 1 Replies