Connect To SQL And Get Name , Mobile , Last Name , Deaprtment , Address Data From Table1 While Id = 5?
Oct 4, 2009it's simply connect to SQL and get name , mobile , last name , deaprtment , address data from table1 while id = 5?
View 10 Repliesit's simply connect to SQL and get name , mobile , last name , deaprtment , address data from table1 while id = 5?
View 10 RepliesI am developing an application which can connect to an ip address to transfer/receive data to the handheld device via gprs network.
View 2 RepliesI want to start a new project on PC and Mobile Phone. But i'm still have so many question about the communication between PC and Mobile.
My project List:
1) My idea is establish a connection between PC and Mobile through IP address in first, but my question is 'How to do it' ? izit same like PC to PC by using Winsock open a port to access? i'm using VB.Net 2005 for PC and Net60 for mobile.
2)My mobile phone Nokia 6220 Symbian OS is support GPRS/3G. Since the GPRS/3G can connect to the internet, izit means mobile itself have a IP address and service provider in order to surf the web? So, can i connect my mobile phone to PC through this gateway?
I want to connect my pc through mobile phone using bluetooth so that the mobile phone act as a remote of my pc.How can i do dat do you have any idea??.I have to make a project for final year using vb.net..
View 1 RepliesI need to connect a symbian mobile to my application to do a transfer of informationbetween my vb.net windows application and my mobilei'm looking to have a software on the mobile side to send the information
View 1 RepliesI am working on a project and i need to connect a mobile to a PC automatically through a known port No from (USB ports)
to get an IMSI No. by AT command " AT + CIMI "
Am using this code to connect to an SMS server to send sms to mobile phones but am getting stucked at the the bold like below:
[CODE]:.....................
I'm doing a project with vb.net (smart device) on visual studio 2008 and I need to connect to a database on the device itself (I do not have a physical device to test, only emulation). How should I go about doing it? I would like the database to be in the device on start up.
View 1 RepliesI started to setup a Server and a Client for personal purpose. When I try to connect the Server by a computer inside a shared network, with local IPs, works but when I try to connect an external IP, doesn't work.[code]
View 3 RepliesI want connect with other user through ip address and send them a message how it will don in vb.net
View 3 RepliesI've made a program of InfraRed which sends data from PC to InfraRed Mobile and from Infrared Mobile to PC. I don't why this doesn't detect any Infrared Mobile Where is mistake?
Imports System.IO
Imports System.Net.Sockets
Imports InTheHand.Net.Sockets
[CODE]....
When I try to start a USB Modem application, which was working normally by the way, it gives me this message.
[Code]...
SMS Sending application in vb.net using GSM Modem of Mobile & AT Command where mobile numbers are dynamically coming from sql server database.
View 1 RepliesI m trying to connect sql server to mobile device but dont know were to start
View 2 RepliesI would like to create a mobile application for Windows Mobile, how can this be done? I have Visual Basic Express edition.
View 4 Repliesi need to send datas to mobile application developed using java can i send datas from vb.net windows application to java mobile applications can anyone tell me what is the simplest and secure way to send data from vb.net windows app to java mobile app
View 1 RepliesIm using VB2005 express and the app im creating uses the web browser control.Basically I want to know if its possible to make the web browser control connect through a different ip address and port from your default web browser.
View 7 RepliesI'm trying to utilize two tables with SQLReader but it's not working as planned.This is a simple explanation:
Table1 has columns c1 and c2, both integer.
Table2 has column data that is string (numeric with hyphen separators).
A typical record has this: : 20123-456-9834-167
The user inputs two integer values in variables uf2 and uf3.I want to get records from table1 that match the criteria:
1. Column c2 equals uf2.
2. A table2 record is found that:
a. has "-" + c1 at the end. (e.g. If c1 value is 167, the record above matches.)
b. has "-" + uf3 elsewhere in the record. (e.g. If uf3 value is 456, the record above matches.)
There is no "relationship" between the two tables.
The pertinent SQL code I have tried is similar to this:
dim strQuery as string = "SELECT c1, c2, data FROM table1, table2 WHERE " & _
"c2 = @f2 AND data LIKE '%-' + c1 AND " & _[code].....
I need to find a solution or develop one for allowing employees to enter their "hours worked" at the end of the day and then easily and quickly "pushing" that data to Quickbooks Pro 2010.
I'm trying to formulate, in my mind, how to build this type of solution. With my understanding of QuickBooks integration I think it will look like the following:
Quickbooks Software on PC
|
|
[Code]....
Remember, the application on the PC will likely be on a consumer or small business network that doesn't even have static IP.
On a separate note, as near as I can tell nothing yet exists that will do what I'm looking for. The apps I have looked at require you to import iif files into your phone (specifically ReportAway). During an initial test of the app, the import failed to import anything but did not produce any error messages. It's unclear to me how the data gets input from the BlackBerry app to QuickBooks but it appears to simply be CSV files.
I'm creating my first software but I have a problem: I have two tables in my database and I managed to transfer data from table1 to table2. How can I just insert specific rows from table1 to table2. I don't want to copy all the data in table1 to table2; I just want to copy the selected rows.
Here's my code:[code...]
I have a listbox which has a sourcebinding which is borrow and I only want the selected items single row to be transferred to my table returns but I don't know how to do it. Whenever I click the button, everything in table borrow will be copied to table returns.
I have 2 databases.
-Table in database 1 has 5 fields
-Table in database 2 has 15 fields
I made 2 querys that retrieve the 5 fields from the first and 5 fields from the second that are the same from the first.I need to update data in Table1 with elements present in table2 that arent in table1 without deleting elements in Table1.
i am trying to write code to insert selected rows from Table1 to Table2 ,, so i find code do that with DataGradView and i try to Modifies it to work with Multi records " Without DataGradView"
Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersDellXPSDesktopDBtest.accdb"
Using connection As New OleDbConnection(connectionString)
[Code].....
I'm working on a mobile project, and I have this:
search textbox (fillby method)
combobox (bound to the data)
datagrid
[code].....
can any one re-edit this query to delete whole record from table1 using username from gridview cell 4 ... ?
Imports System.Data.SqlClient
Dim con As New SqlConnection
Dim cmd As New SqlCommand
[code]....
how to connect to a database and retrive data in a table using oledb data provider in Microsoft access?
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
I have datagridview1 binded to data Table1 (with binding source) . This data table1 is in relation with his child data table2.When I insert new record to table1 I want to refresh datagridview1.
If I use table adapter fill method I get error.TableAdapter1.Fill(Me.DataSet1.Table1) ' error error: Cannot clear table Table1 because ForeignKeyConstraint FK_Table1Table2 enforces constraints and there are child rows in Table2.
I had all my fields on a form. THey became to many for the one form, so i moved them to a Tabcontrol. I split the fields over 5 Tabs. I did not change the code.Now , when i load the form, it does not connect to the data until i click on the tab. How can i fix this.
View 2 RepliesI have address data that is surrounded by random text. Is there a way to extract this data either with a call to a web service or some vb.net function?
example: 1111 S WILSON ROAD APT B8 CITY STATE 55555 0 0 0 0 0 0 0
How am I able to send a data packet from my program, to an IP Address on a certain port (using Udp).
View 4 Replies