I want to merge a software with a website.I have no source code of software, but i want to the database of online data and offline data will automatically synchronize. I have only control over website, online database and offline database.. Is it possible, if yes how?
[code]....
but when i feed data in offline database, online database automatically updated.
i have problem in connection strin i host my site and database is in DATA DIRECTORY my site run successfully in offline but an error of connection string in online pls give me an example of string for online i use asp.net, C# and sqlserver 2005
View 8 RepliesI have created a sdf database in a mobile application.Now I want to synchronize that database to a sql server database.
View 1 Replies me how create offline and on line application.like..
I need create an app.net application.This should works with or with out internet.
Here main requirement is some user will connects to internet and get data to local system.then whey will work on offline.Finally need update server all users updates to server.
so here..
1. user will connect to internet every morning at that time we need to synchorize local database from server database.
2.next user will do some operataions like adding some records or updating some records from his local database using application.
3.Finally end of the day we need to synchronize his local database with server.
I'm making a forum.
I need to show if a user is Offline or Online.
Like this:
Where is says Online i need it to say Offline when the user if offline.
Okay, now i think i got explained what i would like to do.
How i would like this to work:
When a user logs in i want his status to change to Online.When the user press Log Out i want the status to go Offline.
When the user haven't been active for 10 minutes i want the status to change to Offline, but he is still logged in.If he clicks on something he's active again, so i want the status to go to Online again.If the user browse away from the site or close the browser/site i want it to go to Offline status again.
i want to display the message for my website if its under maintenance or temp. closed for any updates
[IMG]http://i49.tinypic.com/a4omkg.jpg[/IMG]
how i can do that so that all user's can see that messages and all the link's should not work for that time interval
but the Maintenance staff and their id should be able to make changes and see
if anyone has any idea about this one please tell me how to do this in asp.net because this same thing can be done in any cms s/w
Language-ASP.NET C#
I am working on a web project, and here i want to display a label which will display how many user is online and open this site. What can i do
View 1 RepliesI want to develop a utility where user will insert new Records and also the same application should work if user is not connected with internet.When user wants to submit records only that time he required to connect internet.
We have created one sample application using excel where we use Dropdown, Textbox, Label.User will download excel file from website and filled up details. When user wants to submit all details only that time internet is required. Application will insert value from excel file to server using WebServices when user click on submit button.
Above is working file but it's increasing our work because we are creating website and also Excel project (Almost double work). I want something where we can utilize the code for online and offline application.
How to add image with all the ListBox items.Ex: I want to add a "green" circle icon image in front of all the items of ListBox.to to show the status of items in listbox.How to achieve it
View 1 Repliesi logged in to my sql server using remote server ip, user name and password,
then by mistake i set my database offline on server, by right clicking on database then tasks then take offline, it's taking time
then i cencel it, but after some time i seen that my database is offline,
now i trying to take it online, but i can't it giving error that
"Set offline failed for database 'mydbname' "
i also try to take it online using query but it's also giving error that "User not have permission to take database online or database does not exist"
everything is on server and it has lot of data, so tell me that how can i bring it online
In domain control panel it also showing error even i can't delete and restore it or backup it, because it's offline
How to Display online users as green and offline as grey using real time updates..
View 1 RepliesI am developing a simple online DBMS to browse my database online.... the main concern for me is to clear everything from the PC when the user disconnect so no body can go and click (Back) on the browser and see the pages if the user forgot to close it.. what I have done so far is :
[Code]....
I am sure this is not enough.. am I right? so what else I should include there?
My question is the same as my subject: how to put asp.net website with sql server database online.
I've never done this on my own before so can anyone explain it?
Where can i put it online and so on..
bob3s
I have a Gridview that is populated with and ObjectDataSource set up to allow anonymous users to populate it. After logging in, the database is filled with the Gridview's data using the following:
[Code]....
The database's primary Key is filled by the "lblItemID" string at the beginning of the loop.
deleting the item from the database keying on this primary key. The gridview deletes the proper row using it's DeleteMethod, but obviously I don't have it set up properly to delete the same PK row from the database.
I really don't want to mess with the DataSource's DeleteMethod (and I'm not sure if this would help at all anyway), so is there a way to look for these deleted ItemId's and remove them from the database while executing this Loop statement?
I'm using Content Management System, DotNetNuke for my dynamic website. DNN itself they have one database, I named it dnnDB. Inside the dnnDB they have the users table which have the list of users. I need to be able to pull this set of information or synchronize to my own database, myDatabase for development purposes. I do not want to incorporate my database into dnnDB, afraid that I may corrupt the system.
View 4 RepliesHere i want to export my data from local sql server 2000 DB to online sql server 2008 DB.
View 6 Repliesconnecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 RepliesI designed SqlExpress database for online store ( Asp.net).And these is tables
Department Table:
dep_Id (PK)
dep_name
dep_description
I'm a little frustrated here. I have turned the default database offline then used windows explorer to copy the database to another location but when I tried to take the database online again this error came out:
Cannot open user default database. Login failed. Login failed for user 'Zephere-pcephere(JuLian Yong)'. (Microsoft SQL Server, Error: 4064) The cause is that the default database is set offline, How do I bring it back online agian?
My website is working but when I host it up, the connection are all screw up. Is it because my connectionString are all linked via SqlDatasource and is for local files only? Whats the coding that I need to put in so that my site will connect to the database via accessing the web.config or server?
View 11 Replieswhat should be the database schema for online account opening form with joint account holders and every participants (in a joint account) have seperate contact and personal detials.
View 1 RepliesI have the following scenario:
A server with a number of different clients on different networks. Clients will have to synchronize data with the server.
Just imagine we have a simple data table on the server. The client has the same table schema and works locally but at a certain time of the day it must upload and synchronize with the server.
Was thinking maybe in doing the following. On the client have two extra columns:
Ej:
- synchronized (Boolean, default to false)
- Time it was synchronized (date time).
- Have a wcf service on the server.
Whenever it needs to synchronize it calls the service. The service then updates data on the server. The client will wait for a response which will inform whether the synchronization took place or not. If it did it updates its local table, setting synchronized to true and the time.
I have a website with a button.Everytime I press that button I want to multiply the number I have in the database by one.It works perfectly offline, but as soon as i upload it i get this error:
Code:
protected void btnthumbdown_Click(object sender, ImageClickEventArgs e)
{
int countdown = 1;
countdown += Convert.ToInt16(lblcountthumbdown.Text);
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/DataBase_J_Wall.mdb"));
con.Open();
OleDbCommand cmd2 = new OleDbCommand("update MAIN_TBL set Person_Thumbs_Down='" + countdown + "' where Person_Email='" + lblemail.Text + "'", con);
cmd2.ExecuteNonQuery();
con.Close();
Response.Redirect(Request.Url.ToString());
}
Sometimes we need to do maintenance in the web server.
In the period of time that this maintenance occurs, I want that a user-friendly page be displayed to anyone that tries to access our apps.
I know about the app_offline.htm file. But using this "trick" I would need to put a file per web application in the server, right?
We use IIS 6 and 7, running classic ASP, ASP.NET 1.1, ASP.NET 2.0 and ASP.NET 3.5 apps.
So the question is: Is there a better way of doing this?
This program used to work when I had VWD 2005 express and SQLSERVER 2005 express. Then we upgraded to VWD 2008 express and SQLSERVER 2008 express. Now it fails Error running adodb Provider cannot be found. It may not be properly installed. 3706 To clarify; I used to run variations of the following to create small offline cub files that I could email to remote Users:-
PROVIDER=MSOLAP;
DATASOURCE=C:TESTAMRunAdodbTestMyCube.CUB;
SOURCE_DSN=AMCubeData;
CREATECUBE=CREATE CUBE AMCubeData(
DIMENSION [Channels],
LEVEL [ALL Channels] TYPE ALL,
LEVEL [Channel Group Name],
LEVEL [Channelname],
MEASURE [Sales Val]
Function Sum
Format 'Standard');
INSERTINTO=INSERT INTO AMCubeData(
[Channels].[Channel Group Name],
[Channels].[Channelname],
MEASURES.[Sales Val])
SELECT [ChannelGroupName] AS Col1,
[channelname] AS Col2,
[Sales Val] AS Col23
FROM dbo_qryCubeDataExtra
;
in a VB6 program that ran them in a ADODB connection something like :-
Dim MyCnn As ADODB.Connection
On Error GoTo Err_ErrorHappened
Set MyCnn = New ADODB.Connection
MyCnn.Open (MyAdodbcmd)