I have a Windows web server already set up with a website (unlimited application pools) and I want to be able to access a database on that server via the Android app I'm developing. How can I do this? how this cross-platform (Android/Java to ASP.NET/C#) communication can be done?
(I'm trying to create a leader board or global scoreboard for my Android game on my server.)
[Code]....
this method i can access using asp.net but not by using a android.. i have checked for the headers etc.. the response is OK in android while debugging but the data is not inserted..
what is the equivalent of stringbuilder in android??
in android i use
StringEntity se = new StringEntity(json.toString());
//and post the data to my service...
post.setEntity(se);
what is the equivalent of stringentity in C# and what can i do for this prob?
I have a asp.net Webservice which returns me XML. What should i use in Android and how to parse?
View 3 Repliesi am facing some problem in update, edit and even create new data into my access database using data detail view. i am using microsoft visual web developer 2008, i can do the same when sql server database were to tore the data. but when i try to do the same using access database, an application error. may i know whats going wrong? and how to solve this problem?
View 7 RepliesI have a data type mismatch while inserting into a number field in an access database using a parameterized query.I think this should be pretty simple but I am still learning a lot.
[Code]....
I have some commented out as I am working one field at a time. The working fields are textboxes and the non working ones are dropdown lists. But I think it may be the field that the list is drawing from? Not sure.
I have one question here.I created a registration form using asp.net and c#.
when I entered all the fields in that form and hit the register button the data will be inserted in to the database table called xyz table
in that table I have an id field which is a text field in access database consists of guid starting with letter P
when I inserting the data from aspx form...the guid is not inserting into the table.
one of my datarecord in that table with the id field is like this.(.P11111111-1BBB-4444-A9D1-111111111111)
need to insert anoother record in that table that field must be generate with the ID starting with P..its an guid.. the creating guid in the aspx.cs page..??
I have a form wilh couple of Drop downs and text boxes and a Data Grid View which displays data from Access Table. When I hit add button on the form, I can see the data being added to the Grid View. But when I close the form and open the Access Database File (.mdb), the respective table is empty. The Access Table is not being updated. Second time if I open the form, the Grid View is also empty.I am pasting my code here.
Public Class Home
Shared OleDbConnection As System.Data.OleDb.OleDbConnection
Shared ExpensesDataAdapter As System.Data.OleDb.OleDbDataAdapter [code]....
Is there away to get data (like phone number or read text file) from android using aspx when page is loading?
Like parameters with android user load page ?
I am starting a new project in ASP.NET (With silverlight) - I would like to get expert opinion about how to design the data access.I can use DataAccess Layer with SQL helper, but the challenge is every new field that I add needs to be added in the sql helper.I am trying to see if there is a way to design the system, so that it appears in the front end when a new field is added. I don't want to have in the ASPX files (binding in controls) I want to have ability to change items in code. Essentially I am trying to see the best option to have a database application.
View 1 RepliesI am using the following code to insert data into an Access Database. Also this is the sqlcommand.
UPDATE TASKS Set Notes="bunch of html code" WHERE APPLICATION="SomeApp"
However I get an error. How can I input data regardless of what is in the command area?
'Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|AddCol.mdb"
So I have created a log-in screen that allows you to create a user at the same time. I wanted to make sure that if there was already a UserID registered that if a user tried to register with the same ID that an error message would show rather than my whole website crashing.
This is my code:
[Code]....
The code to place the data into the database works fine by itself but when I put it into this if statement the data no longer goes into the database.
If this the correct way to do this for making sure that a user cannot create a profile with a user id that is already present or is there a simpler way? I have tried to do it with a customvalidator but that did not work at all.
I'm creating an ecommerce site using asp.net and a Access Datasource, I have used the pre-defined logging in and registering controls provided by Visual Studio 2010 which stores the user data in a SQL server.
For my site the content of the shopping cart is uploaded to a table in the access database, I need to however save the contents of the cart to a specific user ID. For example if User number 1 orders book id's 4,7,2 this needs to be saved, but if user number 2 comes along and orders 4,1,7 this needs to be saved for them as well.
So a user can have many carts, this is sorted in access but with the user ID being saved to a different database is there anyway I can link the two databases so I can say
"Save bookid's 1,2,3 in tblcart where userID is the same as the logged in user"
Is there anything missing in IIS 6.0 that prevents me from (Insert into table) using MS-Access?
Explain: The application works fine under Visual Studio 2008 IDE the insert into table works fine with no error, Also I tested with hosting provider and works fine with no problem. but now I have published the same exact app in a dedicated server windows 2003 with
IIS 6.0 .NET framework 2.0 with latest service pack I gave IIS_WPG write/modify access to the folder where MS-Access database is located and database but at the time of insert an error pop-up. I need to install in the Server or settings in the IIS to recognize my MS-Access db is it some office runtime that I am missing. (BTW I am using OLEDB connection string in my C# )
Using System.Data.OleDb;
I can retrieve data off of it with no problem but when I try to insert is when it fails I thought the problem was Access Rights but I do not think is the case.
I want to transfer data from a access table to a sql table. Simple by clicking a button.
first off all i set up and OleDbConnection and a SqlConnection in my web.config file.
This is the code i use in a b button method for transfer data for 1 tab
le.
[code]....
I am using ASP.NET Search Form... LikeOrder No. Lorry NoInvoice NoFromToWhen I am enter the Value in the above text fileds... Query will be performed search operation and it will show Serach Result Matched Data's..I am usingfollwing quer
View 17 RepliesAndroid is not allowing this simple hyperlink: http://rentonlive.com/TandL.aspx?xid=106&xtitle=RED%LIGHT%CAMERAS%READER%SURVEYI get a web page not found error.Is there something wrong with the construction of the link in terms of Android?I downloaded an emulator, same problem. The phone says it has a browser, finding the 'rules' to this 'browser' is very difficult.And, all works fine in Google Chrome.Any pointers or sites that provide answers to Android issues appreciated.
View 1 RepliesI have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
View 1 RepliesI am using an SQL Express server hosted on a different machine and it is listed in my server explorer just fine. It is listed as my connection string in my web.config just fine as well and lastly it seems to sync just fine with my asp.net membership tables. My question is does it need to be listed in my app data folder of my site? Currently I have the ASPNETDB.mdf connection listed, which is apparently just a local sql express connection. The database I am using in my webconfig and other files is not listed so do I need to add it there?
Second question is about DAL, Data Access Layers. I have mostly been using presentation level SQL commands with my data presentation controls. Manually entering separate select, insert and update statements. I just went through a tutorial that stated the best way to interact with your database in asp.net is with DAL using table adapters. It mentioned that it gives you the ability to use strongly-typed references to each row. My question is can I use the same method multiple times on a single page. For instance a method inside an adapter named GetProductsByID(@ID) ? What if I want this bound to three different gridviews on a single page? Anyone have any other general things to point out about using DAL over presentation level commands?
I can't seem to access a label that is outside the DataList. I wish to add the data in the label into a database, aswell as data that is inside the datalist (this is already working though). My SQL-query with only the specific label looks like this at the moment:
[Code]....
The data is added to the database when pressing a button inside the datalist (using onItemCommand). If I write UserIDLabel.Text the regular way it doesn't work either. The label is in the MasterPage, while the datalist is in a .aspx-page. If it is possible to somehow access the data that is in this label and add it to the database I would be ever grateful. Or is it somehow possible to add data that is in a Session and add it to the database?
I have to create some code for my website which will bring data from a database into my specific boxes. I have a map on my site which on click of a hotspot, a page will pop up showing a smaller map and the data underneath it. The data will be in text boxes. How do I get the data from the database into these text boxes?
View 3 RepliesCan I export my Gridview data to an Access Database (MDB), like how we will export to Excel ?
View 6 RepliesI have an asp.net application that was working fine on my old dev machine that run XP pro and Access 2007. Although I did have problems getting the ACE OLEDB provider to work and so stuck with the old Jet provider.
I was given a new Windows 7 pro computer that also has Access 2007, I had no problems moving my app to the new dev machine. No problems that is until I had to add a new column to one of my database tables since then my app has been very weird when deleting rows (I am using the OleDbDataAdapter to access the database).
Existing data within the database deletes just fine, however if I add new data and then immediately try to delete it nothing happens, no error, no delete, nothing. This is the weird part; if I navigate away from the page I use to maintain the database (i.e. click my link back to the home page) and then revisit the database maintenance page the new data can be deleted just like old data. I add Response.Redirect() into my code to see if that would work but no, only navigating away from the page and then returning allows me to delete the data I had just added.
This problem did not occur until i added the new column to the database table. There is no problem with my code, the same code worked fine on the old machine and on the new machine right up until i added the new column to the database table. My thoughts are that it must be some combination of using Jet and IIS7. Oh and both the app and the database are on the same machine.
Heres my code:
[Code]....
I am wanting to build a asp.net page where the user is presented with drop down boxes.
The drop down boxes contain information from an access database.
The access database contains more than 5 tables.
For example, I am going to use a customer website database as an example:
Contained in the database is:
Server Name
Server Type (Shared web or Dedicated)
Customer name
Sites the customer has.
Funtionality:
Say user one wanted to view all records by the server name:
The user would select the relevent server name which is in a drop down box.
This will automatically filter the database results and in turn will display on the webpage all the customer sites associated with that 'server'
Next I want the user to be able to filter those results again, and say the user wanted to filter the sites by "server type", the user would then select the type in another drop down box and then the data will be refreshed to show the sites that are on that sever, and server type.
I am trying to populate (store) an access database with the information from a DropDownList.
At the moment i have a form where the user inputs data into a textbox and on sumbission it adds to the access database. I am unsure how to add data to the database from the selections choosen in the DropDownList. I have a DropDownList for Title e.g. Mr,Mrs,Ms,Miss.
I have provided the code that populates the database from the TextBox's
[Code]....
I have a database with two tables (tblPhotos and tblPhotoComments). My
tblPhotos tables has the following fields: pid, apid (albumID), title,
description, uploadDate. In the tblPhotoComments table I have the
following fields: cid (primary key), pid (foreign key), cname, comment.
Now, I have a webpage used to view a large version and details of an image
clicked on the gallery page. On the gallery page each photo is linked with the following address: viewp.aspx?pid={0}. On my view page I have two listviews. One to display the photo and the details and one for the comments, both with the pid = query string field pid. The comments listview allows for inserting records and the insert template is located on the first field.
How can I make it that when I fill out the information (Name and comment) the pid of the query is transfered to the tblPhotoComments table in the database, so that when the page refreshes, it will display all the comments that have the pid of the query. I tried doing something with the insert statement in my sql statement, but couldn't seem to get it to work.