Merge The Records From The Database On The Local Machine With The Records On The Remote Server?
Mar 31, 2010
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
I have data in database and that database is in the ip address .this ip address includes the data when i run the application it will give me all records but after the publish it will show me less data.
I have a project that must illustrate that connection to the database is not locally, so I have install VirtualBox and I intend to install SQL Server on it. So any one have the idea of how can I connect from the Host Machine to the SQL Server located on the Virtual Machine
im trying to transfer my database from local machine to server, im using the publish to provider wizard in visual web developer to generate a scrip, im then using the generated script on the serever database.
I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.
For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package which will be easy.
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
I have had a real nightmare with Server.MapPath(). When I call Server.MapPath("~") in my application that is running in ASP.NET Development Server it returns root directory that ends in a back slash like f:projectsapp1, but I call it in published version, installed in IIS, it returns root directory without any back slash like c:inetpubwwwrootapp1.
string mainRoot = HttpContext.Current.Server.MapPath("~"); DirectoryInfo di = new DirectoryInfo(mainRoot); //added to solve this problem with Server.MapPath if (!mainRoot.EndsWith(@"")) mainRoot += @""; FileInfo[] files = di.GetFiles("*.aspx"); foreach (FileInfo item in files) { string path = item.FullName.Replace(mainRoot, "~/").Replace(@"", "/"); //do more here }
I have a table which stores records about a promotion programs. For each record, there are different status such as Begin, Successful, Unsucessful, Expired and there are PromotionDate and PromotionExpiredDate. I am just wondering how I can set each promotion to auto expired (auto change the status of each promotion status to Expired) when the current date is bigger than the PromotionExpiredDate.
My team working asp.net File manage project. In our project we need to export database contents to csv formats The Database table contains 6 fields. We are using LINQ.
How do I get the smtp server address for the local machine? I want to my email address on a windows form and have the user send me an email and I need to be able to get their smtp server address programatically to do this. I tried this:
System.Net.Mail. SmtpClient smtpc = new SmtpClient("127.0.0.1"); smtpc.Send(email);
I would like to create a database where users can search for multiple fields. For example: if the record is personal details info like name, address, phone number and email id i would like to generate link for this automatically with the fields using stored procedure.. Is that possible.? If so can anybody provide me with the line of code or guideline on how to do that?
I have a web portal designed in ASP.NET in which we ask customers to enter the data. On the click of submit button all i have done is, just read the data and called a stored procedure which inserts that into a table. There seems to be a problem in SQL Server 2005 while inserting the data from multiple computers at the same time. We have tested in our lab with three computers, result is that we get the data inserted successfully in only one machine and on the other two machines we get error on page. I have used transactions in the stored procedure and also tried setting the isolation levels to READ_UNCOMMITTED, SERIALIZABLE and SNAPSHOT. Nothing seems to work properly.
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
i have a question regarding grid view. i have done almost all work i needed. but one thing i want to do is i have set 4 of page size of grid. so when i show records on the web page i want to set a iframe after first two records then iframe and then two more records like i have shown in the example image. i have used LINQ with C#.how to do it. if you people want i can show you my code.
I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
im tryin to create repeater from code behaind using C#. The data bind is working good, im tryin to put some pager. the pager is half working. i can see the pager links at the bottom, i can see the the code split the records to 10 lines each page as i set it but when i click the next link the records stay the same it wont changing for the next 10 records. my code
i have 500 records to show in webpage. i am using DataList in that webpage. if i use direct binding it is slowing down the performance of the page and is taking time to load. now i have used update panel and i want to append data records by records(i want to append as first 50records and then next 50 records something like)
