I have one ASP.Net Proj. in this I am using Sql Server as a database . I need the same functionality like facebook( Auto Update). is it possible to use WCF for this. I am copying my code also .
[Code]....
how to edit data in grid view manually without auto generate in gridview + ajax.
View 4 RepliesI have a DetailsView (DV) control, an ObjectDataSource (ODS) control, and a button on a page. I have 2 classes in the App_Code directory (Customer and CustomerDAO). The DAO class provides static methods for the ODS control and simply hack values in (ie...no real database selects/updates). The Customer class has 2 properties (Id and Name) and a default constructor. The page takes an ID on the querystring and determines if the DV control is in insert or edit mode. If in edit mode, it sets the SelectParameter on the ODS (id field), calls ODS.Select(), and then calls DV.DataBind(). The existing (although fake) customer is loaded and display properly when this happens. I then change the name of the Customer in the DV and click the Button to save the new data.
Everything seems to be wired up correctly as the UpdateMethod that is specified in the ODS control is called and succeeds (even in my real example with my database). The problem is that the BoundFields in the DV control have not been updated with the new values and therefore the existing values are updated in the database and my changes are lost. I have handled the OnUpdating event of the ODS and the values are still the old values. I have also handled the OnItemUpdating event of the DV control and the NewValues IOrderedDictionary still has the old values in it also. In looking at the MSDN article for the UpdateMethod, it states the following:
Parameter Merging
Parameters are added to the UpdateParameters collection from three sources:
From the data-bound control, at run time.
From the UpdateParameters element, declaratively.
From the Updating event handler, programmatically.
I am using the BoundField classes in my DV control so I would have assumed that the first bullet above would have handled the updating of values, but it doesn't appear to work with the way I am doing it. If I set the values explicitly in the OnUpdating event that is fired by the ODS control (the 3rd bullet) the right values are updated (again...even in my real database situation). It seems like my only issue is that the automatic binding that I expect from the DV control isn't working as I would expect it to. Here is the code that I have in my fake example:
[Code]....
I have a page setup that displays a datagrid connected to a access database file. I setup a timer to compare the last write time of the access db file and current time (with in 4 seconds). Once the times are with in 4 seconds of each other it requests a refresh of the data. The webpage is displayed on 4 thin client PC's with 0 user involvement so the WebPages need to update themselves. Due to the fact I'm limited to Access I'm trying to limit the # of times a day they are accessed by the auto-update.
The problem I'm having is when the timer ticks it POSTs to the web server. I have 3 WebPages setup watching 3 DB's for different location where I work but they all run of an IIS server in my office. So this creates a lot of unneeded traffic and log files. (Currently 5-6megs per day)
I was wondering there is a better way to compare the files on the clients machine and only post back for an update when they are with in 4 seconds of each other.
The site is built with MS visual web dev 2010 express written in Aspx and code lang is VB. I'm using system.io.file.getlastwritetime to get the file information for comparing.
I'm a little bit confused as to what the 'M' in MVC stands for. Sometimes I see a domain-model in it (eg Customer, Order, ... POCO classes and respository classes: persistence logic classes) and sometimes I see viewmodel/presentation model classes, is a representation of the data of a particular View (the V of MVC) Compare it to data transfer objects. Are both approaches correct? Or since MVC is a presentation pattern is in fact the 'M' when you apply it to this notion only meant as the data representation of a particular View?
View 3 RepliesI'm trying to implement automatic lockout after 3 password failure attempts and then to auto unlock after 3 mins. But it does not auto lockout, I can still login if i use the correct password within the 3 mins.
Here is the Web.Config file
[Code]....
Here is the Login Control Logic.
[Code]....
I have a "database explorer" page that is desgined to be pointed to an unknown database and allow users to browse the data, so it basically uses the SQL system tables to develop its queries and pull in data to tables using auto-generate columns.The problem that I have is that I would like certain types of columns to have certain formats and I'm wondering the best way to go about it. I could format the column in code in the RowDataBound event I assume, but I'm wondering if there some better standard way to do this? Is there a setting of any kind that I can use? For example I want all of the datetime fields to be formated for short date, like {0:d}, I want decimal fields to have 4 decimal places, etc.
View 2 RepliesI have a simple online web system where it possible for the visitors to "play around" with the system. They can like create categories and products and so forth. Everything they create are stored into a database.
What I want is to be able to reset this database with my default values (table data) every n hours.
So for example if we have a bunch of users that have played with the system and created new things. Then I want to be able to make some kode that deletes all data in the tables in this database and fill it with default data. The default data can come from a backup file, or another database with same tables structure or whatever.
I want this task to be done every day at 12 pm or every n hour.
Is this possible (by forexample scheduled webservice tasks or just something as long as it is simple).
i have a data list control and i have bind it dynamically now i want to add a new serial no column and also display serial no's
View 1 RepliesCurrently, I am programming a web-based application with Visual Studio.NET 2003, and having a problem with an err below :
An error has occurred because a control with auto-generated id 'dgPreventiveMaintenanceSchedule:_ctl5:_ctl3' could not be located to raise a postback event. To avoid this error, explicitly set the ID property of controls that raise postback events.
That err occurs while I am rendering my datagrid for certain data. In the other words, it occasionally happens.
I've been trying to debug one by one, but I still don't any clues for this kind of err.
I have create one SQL Database table. Columes are Longitude and Latitude.User manually enter Longitude and Latitude.then how to auto check every few days entire data will correct or not.If some data will wrong then auto update nearest Longitude and latitude
View 1 RepliesI have a gridview and when i click on the edit button i will get the modalpopup window which is having a popup window i want to update the data in that details view and refresh the data into gridview also.
View 2 RepliesI searched a lot of threads but still couldn't get my problem fixed. I have to update the "regform" table with two fields: session_ and session2. These two fields are inside the detailview edititem template which bounded to dropdown list drpsession1, drpsession2 separately. I wanted to pass the update parameters to the update sql UPDATE dbo.regform SET session_=@session_, session2=@session2 where id=@id
the @session_ is bounded to a drpsession1 and @session2 is bounded to drpsession2. I used
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession1" to access the dropdown list within the detailview, but still couldn't do the updates. What's wrong with my code? Do I have to use the code behind to specify the update parameters? and How to do it? TIA.
<
"
asp:DetailsView
ID="DetailsView1"
runat="server"
AutoGenerateRows="False"
DataSourceID="SqlDataSource2"
Height="50px"
Width="544px"
DataKeyNames="id"
ondatabound="DetailsView1_DataBound">
<Fields>
<
asp:TemplateField
HeaderText="Session -Part I"
SortExpression="session_">
<
EditItemTemplate>
<asp:DropDownList
ID="drpsession1"
runat="server"
DataSourceID="SqlDataSource3"
DataTextField="session_time"
DataValueField="session_id"
SelectedValue='<%# Bind("session_") %>'
AppendDataBoundItems="True"
Width="229px">
<asp:ListItem
Text="Please select"
Value="-1"
/>
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource3"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
SelectCommand="SELECT dbo.sessions.* FROM dbo.sessions"></asp:SqlDataSource>
</EditItemTemplate>
<
asp:TemplateField
HeaderText="Session - Part II"
SortExpression="session2">
<EditItemTemplate>
<asp:DropDownList
ID="drpsession2"
runat="server"
DataSourceID="SqlDataSource4"
DataTextField="session_time"
DataValueField="session_id"
SelectedValue='<%# Bind("session2") %>'
AppendDataBoundItems="True"
Width="234px">
<asp:ListItem
Text="Please select"
Value="-1"
/>
</asp:DropDownList>
<asp:SqlDataSource
ID="SqlDataSource4"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
SelectCommand="SELECT dbo.sessions2.* FROM dbo.sessions2">
</asp:SqlDataSource>
</EditItemTemplate>
</Fields>
</asp:DetailsView>
<
asp:SqlDataSource
ID="SqlDataSource2"
runat="server"
ConnectionString="<%$ ConnectionStrings:Connstr %>"
UpdateCommand
where regform.id=@id">
="UPDATE dbo.regform SET session_=@session_, session2=@session2 where id=@id">
<UpdateParameters>
<asp:ControlParameter
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession1"
Name="session_"
PropertyName="SelectedValue"
Type="String"
/>
<asp:ControlParameter
ControlID="ctl00$ContentPlaceHolder1$DetailsView1$drpsession2"
Name="session2"
PropertyName="SelectedValue"
Type="String"
/>
<asp:ControlParameter
ControlID="DetailsView1"
Name="id"
PropertyName="SelectedValue"
/>
</UpdateParameters>
</asp:SqlDataSource>
i am using asp.net chart control, problem i am facing is that it automatically generates values in Y-Axis.
As you can see in image , values 0, 3 and 4 are automatically generated. how to hide these automatic generated values.
I am working on private chat application like facebook & orkut. I am facing problem doing auto open aspx or div if any user send message to their friends.
View 3 RepliesI have project in asp.net with sql server backend.i want to auto generate a number for particular column.with the auto generated number i want to insert some other data in the same row same table. on button click event.details
railway PNR no.:- want to autogenerat
passenger details:- want to inserted simultaneously
When i create a new class on data layer,i can access that on business layer by creating object of that class.
but when i create a new "public class" on business layer i cant access that on presentation layer.
another thing is, after building business layer if copy Business.dll,Business.pdb,Data.dll and Data.pdb from business layer to presentation layer "BIN" i can access that class
I want to know how to use auto refresh continuously in ajax update panel..What I want is,I've more than 6 update panels on my page and I want to all the panel to refresh toghether,continuously till I close the page.
View 7 RepliesWhen I try to run the following code it always spits out the hex representation, not the integer representation. Most of the examples I found on MSDN said this should work. What am I missing?
var stringBuilder = new StringBuilder("8");
int j = 0;
foreach (char item in stringBuilder.ToString())
{
j = Convert.ToInt32(item); //returns 38, need return to be 56
}
edit I should have made clear that I know the difference it's returning the hex value. I'm outputting the value to a file, and in that file, it still shows the hex value, not the integer, so I don't think it has anything to do with the debugging environment. edit2 Looks like a PEBKAC problem. Looked at the code that was writing to the file, and it was using a .toString("X") method, changing it to a Hex value. The fact that it was hex in my debug environment was what confused me.
Is there a way I can automatically update a 'Date' column in my database table to the current date whenever any cell in that record is updated?I've started looking into table triggers a little bit and I'm wondering whether I can do it using this?
View 1 RepliesI use AJAX tab panel for my web site (ver.1.0.2) with VS2005. Previously I use large page and now i it change to tab panel. The problem is when I change the source view to design view it automatically update the content of tab panel and show the 'error creating control' and sometimes it not. So I'm having difficulty on designing that page because always I have to keep the backup of the page.
View 1 Repliesas part of a project I am working on, I need to output the alphabetical 'name' of the number. This is better illustrated with an example.960Nine Hundred and SixtySo it'd convert '960' to 'Nine Hundred and Sixty'. Is there an easy way to do this in C#.NET? Also, if so, how easy would it be to apply the same function to a decimal number? I'm assuming if I can figure out how to convert a integer as above, I can just split the decimal number... so I'd have something like this 960.23 Nine Hundred and Sixty (units) andTwenty Three (units)
View 2 Replieswant to know if linq to sql auto updated the id column of a class (table row object) after SubmitChanges is called inserting a new row to that table, that would be fantastic, would anyone be able to confirm this?
View 2 RepliesBefore I get too far down the road I just want some advice. I'm building a web app using VWD2008 and MySQL 5. I've got the membership provider stuff working fine and have an odbc connection setup which works "fine". what I've noticed is that when I configure a new sqldatasource (that will be used to provide data to a listview or something) the Advanced -> generate Insert,Update..... option is disabled. I'm assuming its because of the sql syntax difference of the square brackets issue between MS SQL Server and MySQL.
Before I start writing all my own insert and update statements does anyone know if there is a way to get MySQL and VWD to talk the same language, maybe a different connector or something. I'm using mysql-connector-odbc-3.51.15
I was creating my new webforms application and testing it. Now I added a new textbox to the form and when pressing F5 to test, it doesn't show. None of the changes show when I try to test it.
View 1 Replies