.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

data-base synchronise

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :ASP.Net

I want to do an application for an opticals shop. There will be lots of branches across the city. I am planning to give a desktop application to all the branches.I want the branch employees to update the sales in an online database, because i want the owner(admin) to view the sales, orders, other info through a web appilcation.

1) so is there a way so that the employees can update the online database?

2) If internet is not there in a store, how is it possible to update the online database once when the internet is back?

Please advise.

Thanks you

View Complete Post

More Related Resource Links

change calendar date backColor base on data from db


I want to  change calendar date backColor base on data from db,  I only have vistual 2003 !

on mean time I have

<asp:DataGrid id="DataGrid1" style="Z-INDEX: 102; LEFT: 23px; POSITION: absolute; TOP: 271px"
		    runat="server" Font-Size="XX-Small" Font-Names="Verdana" AutoGenerateColumns="False" Visible="False">
           <asp:BoundColumn DataField="subject" HeaderText="Title"></asp:BoundColumn>
           <asp:BoundColumn DataField="posttimestart" HeaderText="Post date"></asp:BoundColumn>


Sub DayRender(ByVal source As Object, ByVal e As DayRenderEventArgs)
        Dim i As Integer
        For i = 0 To DataGrid1.Items.Count - 1
            If (DataGrid1.Items(i).Cells(1).Text = e.Day.Date) Then
                e.Cell.BackColor = Color.DarkOrange

            End If

    End Sub

when I click the day wich have data in db it change  color , but I want the page load it change color !

Thank you!

SSAS 2008 Metadata Repository data - User Knowledge base

Hello, We have the SQL Server 2008 Analysis services instance with some databases, cubes, Dimensions, Measure groups, partitions, etc. The business users are find difficulty to search for a particular measure. I mean, it is difficult for them locate a measure from the available cubes; again finding the respective Measure Group/ Folder is not an easy task for them. Also, they need to know the source system of a particular attribute in a dimension, formula for the calculated measure and etc. So, we have planned to develop a knowledge repository, which needs to store the business metadata for the SSAS databases. The user needs to be access this information using the SharePoint site and should help them locate and understand the data. The User Interface needs to be user friendly too. I need your valuable suggestions for the design of this system. Note: I have referenced the below articles http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/ http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/c610850f-16b4-4eaf-9b91-a2d32816f40e

error in attach data base

I got a full backup from my sql server (CTP 2008) and I uninstalled it, and after that I installed ent version. I want to attach the old backup  files to the new SQL. Once I go to Database--->attach (or even click on restore or new database) I get : TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (SqlMgmt) ------------------------------ BUTTONS: OK ------------------------------ any advice? Thanks  

Read from and write to Data Base an Image

Hi guys. How can I show a saved picturs from data base into a Image control? And how can I save an Image from my web page into data base? (with less code pleeeaaase.)

Problem in "Upload a picture into data base" because is in

Hi guys. I can upload a picture into database by this code correctly in a web page without "UpdatePanel": ******************************** SqlConnection connection = null; try { Byte[] imgByte = null; if (FileUpload.HasFile && FileUpload.PostedFile != null) { HttpPostedFile File = FileUpload.PostedFile; imgByte = new Byte[File.ContentLength]; File.InputStream.Read(imgByte, 0, File.ContentLength); } // Insert the employee name and image into db string conn = "Data Source=PC5;Initial Catalog=LaptopStore;Integrated Security=True"; connection = new SqlConnection(conn); connection.Open(); string sql = "INSERT INTO test(image) VALUES(@image) SELECT @@IDENTITY"; SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@image", imgByte); int id = Convert.ToInt32(cmd.ExecuteScalar()); lblResult.Text = String.Format("Employee ID is {0}", id); } catch { lblResult.Text = "There was an error"; } finally { connection.Close(); } ******************************************** But when I want to use this code in a

Using WCF unable to transfer bulk data in windows base application

Hi, I am testing bulk data transfer over WCF service and my project structure is as follows. Project Structure: 1> One Console application that have the WCF service reside of it. 2> One Class library that contain the interface and a class file that implement the interface. 3> Another Windows Application type project act as a client interface that call the service using proxy. Now the scenario I have is as follows: 1> Inside of the console application their is a module that have the (following server side code) .This service is hosted in the Console app programmatically (No config file). Server Code: Dim x As New NetTcpBinding(SecurityMode.None)         With x             .TransactionFlow = False             .TransferMode = TransferMode.Streamed             .MaxReceivedMessageSize = Integer.MaxValue             .CloseTimeout = New TimeSpan(0, 10000, 0)             .OpenTimeout = New TimeSpan(0, 10000, 0)             .ReceiveTimeout = New TimeSpan(0, 10000, 0)       &n

saving a text file in ms access data base

i have to read a text file in a text box then have to save it into ms access data base in column format how could i do this....

Search Multiple Data Base

Hi,I am working on a Large Database application .  I have 5 Product catalog database   with atleast 5+ million product information on each .  database is deployed in multiple servers. . when the user performs a search it should search in 5 different database and combine the  results to show in the search results.product row has a priority key and based on the priority i need to show the results. In case if same results is found  in all the five  database then we need to group the result and shows the count in result column.For exampleIf Product1  is exist inn all the five database database  then i need to show Product1 - count=5and also we have priority index for showing the result . default search should be sort by priority  .Can any body let me know what will be the best approach to do the search on this multiple  database and  process this data to find the duplicates and sort accurding to the sort index..(we are also planing to restrict the max result from each data base) . Thanks

Cannot access a SQL data base since a .net application usin ODBC and/or one by one instructions


At the time when we try to access a database the followin message is showed: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'Mid' is not a recognized function name.

I created an ODBC and when the database connection is tested there is no problem, the problem is when I try to access since the program.

DataTable to a binary field on data base



Is it possible to convert a datatable into binary data and save it into on a binary field on database?

How to get table value and output save in data base using jquey ajex


how to get value this table output is
row 1, cell 1
row 1, cell 2
row 2, cell 1
row 2, cell 2

and save automatically in database no any where click

<table border="1">
<td>row 1, cell 1</td>
<td>row 1, cell 2</td>
<td>row 2, cell 1</td>
<td>row 2, cell 2</td>

how to Display data from data base?

Please help me how to display data in textbox control using Class in Asp.net
Ravi Chaudhari Blog: http://ravichaudhari.blogspot.com

Data Base Properties column Identity value will not accept value change


In the tutorial I am doing I have been requested to change a field in the colums properties of a table.  The ID column is currentl displaying NO and NO again for "is aIdentity.  I can Highlight the values but cannot change to yes.  either in the properties talbe or in the properties window on the right hand side of IDE interface.  How do I change that value?


how to asp.net Data serach Ajex jquery and show in a table from data base


how to asp.net Data serach Ajex jquery  and show in a table from data base

Save/Update/Delete Sql Server data base table using Sharepoint Designer


Can some one help me to achieve below task

Save/Update/Delete Sql Server data base table using Sharepoint Designer.

excel to SQL-Server Data Base, Problem


Hi Friends,
I have used following code,

Hi Friends,

if (this.FileUploadPanelToExcel .HasFile  )
                    BusinessModel.Client newClient = CreateClientFromExcel();
                     string connectionString = ConfigurationUtility.GetConnectionString();
                    ClientDataAccess.Add(newClient, connectionString);

 private BusinessModel.Client CreateClientFromExcel()
             BusinessModel.Client newClient=new BusinessModel.Client();
             string path = FileUploadPanelToExcel.PostedFile.FileName;
             OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0");
              OleDbCommand command = new OleDbCommand("select *from [sheet1$]", connection);

To Access Oracle Data Base


I have written two diffirent application using ASP.NET (used C# as server side scripting language in both applications) against Oracle Data base.

 In the first applicaton I am going to use Microsoft Library (System.Data.OracleClient) to access Oracle data base. 

In the second application I am using ODP.NET. The first application will call the second application with a link on a page then the second applicaton will get control. Both the application having there own web.config files.

By Now both of these applicaton are in the development phase. I want to deploy it on the same server machince.

My question is, is it possible for both of these application to co exists. Will there be any problem/conflict as am using System.Data.OracleClient in the first, where as uses ODP.NET in the second to access the same oracle data base.


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend