How i can fill 2-way array (integer type) of records from my tabel from file data base. Tabel is also integer type ?? i try many way but i can solve this problem . Pls help me .
ok question was not clear i wona copy all records from one of table from db in file (mdf) to 2 way array but only 6 from 9 columns of this tabel .
I have been programming in VB6 for a while now and am gradually trying to get to grips with .Net (VB 2005)I am tryng to transfer some of my programs from VB6 to .Net with some success but have got a little stuck on trying to transfer what was a control array to .neto try to sort this i have set up a form in VB6 with 4 Vscroll bars and 4 Text boxes.Vscroll1(*) & Text1(*) where * is 0-4when you change the value in any scroll bar then the associated text box value changes.
Private Sub VScroll1_Change(Index As Integer)
Text1(Index).Text = VScroll1(Index).Value
End Sub
[code].....
I've been trying to create my own backup system by sending specific files to a server running on my desktop, and then having those files copied to an external. So far, I'm trying to send files using a tcp network. Unfortunately, for soem reason, tcp cannot send more than 9kb at a time, so when i tried to send a 30kb image, it recreated 1/3 of it. My fix to this problem was to send data by chunks of 8kb, then reconstruct the file chunk by chunk. For some reason, when I run the server and client, the client says it sends all the data, however the server seems to be stuck. Here is my code;
[Code]...
I have 2 arrays X(n) and Y(n). I would like to pass them between subroutines:
Sub sub1()
...
call sub2(X,Y)[code]...
The problem comes when n can be changed in sub1 say a textbox. How do you transfer an array of variable length between subroutines?
i was wondering how am i going to transfer a photo from database to vb. it there possible to do that??
View 7 RepliesI using Visual Studio 2010.My problem is; I can not transfer all data in a listbox to SQL Database. codes are as follows.
Dim builder As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(adaptor4)
Dim insert_komut As New SqlClient.SqlCommand
[Code]....
I have two tables namely BankAccount and MoneyTransfer to be used in a single form. Here lies my form: Attachment 72574
In the BankAccount table I have got the AccountNo,BankName and CurrentBalance columns.I am fetching the data of these columns during the form load event and filling up the combobox's of the From and To part as shown in the form snapshot. So I did this below code in the form load event:
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
con = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:UsersGautamDocumentsVisual Studio 2005ProjectsEtech_TransferEtech_TransferBankAccount.mdb")
con.Open()
[Code] .....
Now I have a Date and Amount field in the form and I have both the columns present in the TransferMoney table. The user will first select the BankName and AccountNo. from their dropdown list,then enter an amount in the Amount field and ontransfer button click the money will be transfered from the FROM part to the TO part and the BankAccount table will get updated by the current balance of both the FROM and TO part and the Transfer money table containing the Amount and Date column will also get updated by the Amount transferred and the date in which the money is transferred.
I will use the Background Intelligent Transfer Service (BITS) to transfer files from a client (laptop) to a shared folder on a server within our local network.The problem is a very slow network bandwith, if we transfer a file, the other clients canīt work, all requests to other clients (application) or viewing internet pages needs a long time.My idea is to use BITS in my tool to copy/transfer a file from client to server, also I hope to get more performance for the internet requests.
View 2 RepliesI have created a simple window forms application which link to microsoft access 2007 database.
I build the application exe file already. The exe file is run well on my computer, but when i transfer it by copy and paste the whole folder to another computer it cannot run. I am wondering why this happen? the error is as below :
"selected collating sequence not supported by the operating system".
Will it cause by the different .NET Framework version? How can i solve this? Or any others way to transfer the exe file to another computer?
The form1 has a listbox which contains a list of student names.If i select any one of the student name in the listbox and i click the button,the form3 should be open & listbox in form3 should be loaded with the corresponding scores of the student name that is being selected in listbox of form1.The condition i used here is if the value of textbox in form1 is 1 then the dr(4) value alone should added to the listbox in the form3 and ;likewise it depends on the value in textbox of form1. ...FOR THIS I USED THE BELOW CODE
[Code].....
When i tried to run this code it is showing an error "Index was outside the bounds of the array" on the line that i highlighted in the above code.
The situation is this. I have an application written in vb.net. it consists or two parts. One on a PC and the other on a handheld windows mobile 6 device . The desktop program transfers a SQLServer compact database to and from the handheld device using activesync via USB. Potentially we want to look into having android handheld devices also supported by this application. Now I know I can use SQLite with .net. I know I can use ADB to push and pull data (and therefore the database files) to and from the device.
What I need to know is can I access ADB directly from VB.NET as an API or SDK rather than having to do it manually.
Unless of course I'm missing something and I can copy databases to and from the device in some other way?
I want to transfer multiple items selected from a listbox to an access 2007 database using a parameterized query.When I select certain items from the listbox, only first item selected gets stored in the database.Other values selected are not written to the database.My code is as follows.Is my approach towards transferring multiple values correct?Someone
[Code]...
How will I transfer deleted record into another table instead of deleting it permanently? I think it is what we call "history"..somehow..For example I have 2 tables. 1 is Original_Record the other is Deleted_Record. If I deleted one record in Original_Record, the deleted record will be transfered into Deleted_Record table.
View 6 RepliesSource: DataTable
Destination: Access Database Table
I should mention that the DataTable contains data resulted by an SQL SELECT query and it's not related to the "targeted" Access Database Table.
I'm using server.transfer to transfer execution of a URL to a dummy page which fetches information from the database. The trouble is that the master page interacts with the session.
global.asax:
Sub Application_BeginRequest(ByVal sender As Object, ByVal e As EventArgs)
' Fires at the beginning of each request
If Not (System.IO.File.Exists(Server.MapPath(Request.Url.LocalPath))) And Request.Url.LocalPath.ToLower
[CODE]...
Master page:
If String.IsNullOrEmpty(CStr(Session("SessionId"))) Then
Session.Add("SessionId", Guid.NewGuid().ToString)
End If
Page declaration: <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="utilityCMS.aspx.vb" Inherits="utilityCMS" MasterPageFile="~/MasterPages/main.master" EnableSessionState="True" %>
Web.config snippet:
<httpModules>
<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add name="HttpModuleAggregator" type="XPIdea.Web.HttpModuleAggregator,xpidea.web.common" />
</httpModules>
I'm getting an error :
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration><system.web><httpModules> section in the application configuration.
I should also mention that this same master page works elsewhere in the site. Session is used throughout the site as well (not just in the master page).
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
i have to populate data from mysql table into an array. I have a table which stores the x-coordinate and y-coordinate of a node. I got to retrieve all the x and y's into an array. I am having difficulty doin that as i am now
Below is the code i've been trying:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
So i have some data in an 1 dimensional array, is it possible to dump this data into a database?
View 4 RepliesI am writting an application in VB using VS2008 and SQL2005. I would like to save an array to my database and later retreive it. I understand that I need to serialize the array to do this but don't understand the process. I have looked at various resources on the Internet but seem to be missing something.
View 2 RepliesProblem storing value in array from database
View 3 RepliesMy Task Background :I have list of data items and have to calculate/aggregate details about each data item and populate that to SQLServer database.I can do 1 by 1 insert [Traditional method]But, the application needs to perform good.Is it possible to aggregate the data in a 2d array and dump into database @ once ?' Populate this and insert it to database.
Private data(100, 100) As Object
So, how to do that ?Also, is it possible to use dataset in some way ?
Im trying to add values stored in an array to a database. Here's a little piece of the code.
[Code]...
I'm already connected to the datasource in my program, and I already have the information in an one dimensional array. I want the array to be put into the first empty row of the database table, and obviously it will keep all the data and just keep appending to the database, I don't want anything in the database re-written.
View 9 RepliesI'm attempting to setup a search function from a string a user types. (ex: "John Doe" or "Doe, John") I was thinking I would use Replace(SearchString, ",", "") to get rid of the commas the user might enter, and then use Split(SearchString, " ") to get all the words into an array. Once they're in the array I would execute a Stored Procedure on each of the terms and build a DataTable with the results.
Below is what I'm wanting to use for executing my stored procedure.
oCommand = DataAccess.GetSQLCommand("MyStoredProcedure", CommandType.StoredProcedure, SourceServer.ConnectionLocal)
oCommand.Parameters.AddWithValue("@MySearchString", SearchString)
[Code]....
Now I'm thinking the "SearchString" I will assign while looping through my array of words... but this doesn't seem like the right way to do this. Maybe it is but I don't know how to append my next result to the previous DataTable either.
Okay here is a short video that shows exactly what I want to do. I'm a beginner with databases so I'm not that good at it. [url]...
View 12 RepliesI need to scan database and insert its values into an array. But I'm having some difficulties in handling null values and array.
The database looks like this:
0 1 2 3 4
30 31 32
33 34
36 37 38 39 40
38 39 47 48
I want to make array rr_item which gonna looks like this:
arr_item(1)={0,1,2,3,4}
arr_item(2)={30,31,32}
arr_item(3)={33,34}
arr_item(4)={36,37,38,39,40}
arr_item(5)={38,39,47,48}
Every code I've tried result in error everytime I tried to insert null value into any kind of c=variable, including array which I want to use. And I'm not quite sure with what I'm doing in jagged array I want to build.
sql_list = "SELECT * FROM retail"
oledbCnn = New OleDbConnection(connetionString)
Try
oledbCnn.Open()
[Code] .....
I have a code which retrieves values from database
[Code]....
i want to store all the values in a array for further processing.
I've got a program I'm working on and I've been entering all the data manually but want to move it to a database.I've constructed the database and have it in the program but cannot get access to the individual cells so that I can use them in computing the results..I have a database named DFTL.mdb with a couple tables, including one query that I'm trying to get data from. The query has 10 records each with 5 unique numbers that attatch to the records.I've tried every way I can think of of pulling this data so I can use it in my program.
View 28 RepliesI have a program that creates an array of part numbers. I also have a database that holds part numbers and all associated information I need for other calculations. How can I search an MSAccess database table against all of the part numbers in the array? The Array will never have more than 100 items in it, the table has over 7000 records to search from. I've posted my nonworking code hoping someone can point me in the tight direction.
Dim rs2 As New ADODB.Recordset
Dim Test1(7000) As String
Dim Test2(7000) As String
[code].....
First time I've had occasion to do this, but how would you represent the data in a SQL database table in a multidimensional array? I've heard tell of multidimensional arraylists but have no idea how to use them.
Here's what I have -
The table is 15 columns across and a varied amount of rows depending on the query.
rawData is an arraylist. finalData is an array.
Dim myReader As SqlDataReader = sqlcom.ExecuteReader
While myReader.Read()
[Code].....
Obviously, this gives me a long list of all the data from the query. I want to break it in rows.