i have the follow code:
public partial class _Default : System.Web.UI.Page
{
int myValue;
protected void Button2_Click(object sender, EventArgs e)
{
myValue = myValue + 1;
Label2.Text = myValue.ToString();
}
}
I can't seems to increase the value, the outcome will always be 1.....
I have an sproc which selects data out of my table. The column can return integer or NULLs.
I get the 'failed to enable constraints error' when databinding. If I go to my tableadapter and select my column there is a NullValue property which has 'Throw Exception, Null, Empty'. If I try and unset the exception option it tells me only strings are allowed this. However the 'AllowDBNull' option is set to TRUE.
What is the alternative and will this be fixed in 2010?
I need to validate integer within a specified range for English and French culture. The integer contains group separator ("," in English culture or " " in French culture). It seems I can't do it with RangeValidator on my machine.
I just want to make sure the RangeValidator can't do this kind validation for Integer before I'm going to write my own control.
I just feel curious because RangeValidator can actually do this kind of validation for Currency!
i am working on my master site, and i want to add an image that increases its lenght as the website's length increases...
but im not sure how to do that, i know it's possible because i've seen it done on banners, but im not completely sure how to do it.
For right now, the View Account for an individual user has the following setup on the aspx page.
[Code]....
In the MembershipUserODS file i have the following:
[Code]....
And in the code behind page i have this...
[Code]....
The page posts, when you click the update button, but the data never changes / updates.
I have a page that binds data from DB to a DetailsView.I want to use the auto-generated Update command.
Everything went OK, and also updating was successful, but if I remove any field that I don't want to have chance to update, then the Update command doesn't update! the old values retain!
I mean: if all of the fields are present in the detailsView, the update will be OK, otherwise, the update will NOT update any thing.I've tried to mark the fields that I don't want to view as "Visible = 'false'" but with no good results!
I have a vb.net page that has an optional parameter. If a user enters data for that field, and clicks save, it saves fine via the stored procedure. HOWEVER, if the user changes their mind, and wants to erase the data they entered, they go to the text field, and delete the characters, and click save, but no matter what, the stored procedure will not save the fact that they erased the data (it won't set it back to NULL). If the user enters a space, the stored procedure will save the space, and if they enter different data, it will save the other data. I can't figure out how to get it back to letting them set it to Null? I think this is because it's an optional parameter, and the stored proc is used by several forms (Some of those forms do not include this parameter), but this form utilizes that optional paramater.
Here's my stored procedure...
[Code]....
[Code]....
What's wrong with the following code?
[Code]....
After the SubmitChanges call, the Text field in data2 wasn't changed. According to the NerdDinner sample, I supposedly can just write to my data object and then call SubmitChanges.
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
[Code]....
I've a problem updating objects with the ADO.NET Data Services.
First I've create a service, which can load and store the data. Its a basic data context which implements the IUpdatable-interface.
After that, I've created a simple service-client. I just created it with the 'Add Service'-reference in Visual Studio. Basically this service seams to work. I can query for the objects and store new objects. However I cannot update objects.
This is my update-code on the client:
var ctx =
new TeamDataContext(new Uri("http://localhost:8637/TeamInfoService.svc"));
var team = ctx.Teams.First();
team.TeamName = "New Team Name";
ctx.UpdateObject(team);
ctx.SaveChanges();
What my main issue is, that IUpdatable.SetValue() isn't called for the object which I want to update. Only the IUpdatable.SaveChanges() is called without updating the objects on the server.
When I create a new object, the IUpdatable.SetValue is called on the server to set the property.
So what I am doing wrong? Are my expectations wrong? Is IUpdatable.SetValue supposed to be called when updating a object? Or do I need to do additional things to do updates?
Edit: I just watched the HTTP-requests between the client and the server. The client send a HTTP-Merge request with the changes. However I still don't know why the changes aren't stored.
I am trying to learn the ASP.Net AJAX and as project I decided to do a basic number guessing game. It works fine the first time a guess is submited but after the second time the number of guesses made does not update properly and I can not figure out why.
[Code]....
In my 2nd ASP.NET MVC project I'm facing a very weird problem: when I call the SubmitChanges method of the DataContext class, nothing updates in the database. It's weird because everything works fine with my first project. I'm using a remote database created in Sql Server Management Studio, I tried doing some queries there and in Visual Studio 2010 (where I have the connection to the database), they all work. Where might the problem be hidden?
DBDataContext DB = new DBDataContext();
var myuser = DB.Users.Single(u => u.ID == id);
myuser.Age = 45;
DB.SubmitChanges();
This is embarrassing :D Indeed I didn't have a primary key. Now it works!
I try and update my table with the following
[Code]....
I dont get an error or anything, nothing happens, and the date remains the same.
I have problem when i use UpdatePanel in ContentPage. In Updatepanel, I have DataGrid. Outside, I have a textbox and Button.
When i press button, I want to insert message in texttbox to Database and Select from Database for Showing in DataGrid (includes all message in past)
My MasterPage:
<ScriptManager>
<ContentPlaceHolder>
My ContentPage
<div> Have a textbox and button
<updatePanel> Have Datagrid
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="commentForm1.aspx.cs" Inherits="ChatApplication.commentForm1" %>
I have a simple table with 5 text boxes, above that i have a dropdown where you make a selection, if there are any records of associated with the selection, then i display in the fields..
A while back this was working, you could make a selection and the fields were within a update panel and they were populated. But im revisiting the pages to make some updates and changes and noticing that the page no longer populates the fields when a selection is made..
Is there anyway to debug the updatepanel? I put a breakpoint in my selectedindexchanged event and my Db call is returning values and the textboxes .TEXT values are being assigned the right values in the code behind, but the fields never show up..
This page hasnt been touched since it was wworking last, so need to see how i can test / debug the update panel to determine what coudl be causing it..
[Code]....
as seen from the title my sql doesnt update the data that has been inserted by my function. But in my function it works perfectly as it returns '1' when i executenonquery. however it only works when i insert a record which has a date later than today's date. which is weird as there is no validation in that page and if there were to have a validation, it would not run the function.
View 10 RepliesI have a Shopping Cart Summary User Control that doesn't update without a full browser refresh.
The scenario is:
I have a DataList in one User Control that displays Product data with an ItemCommand event for an 'Add To Cart' button.
[Code]....
When the 'Add to Cart' button is clicked, the page reloads and another User Control containing the Shopping Cart Summary should be updating. However, the Cart summary doesn't fully update until a full page refresh occurs.
I should add, that the Cart Summary is "located" on a master page whereas the Product List is in the Content Placeholder of a web form based on the same master page.
I can provide more of my code if required but I'm initially reluctant incase I'm making a noobish error!
I have my ReorderList setup, and it seems to work. It doesn't give me any errors, and it allows drag/drop of the entries.
BUT, it never updates my datasource. I have tried putting breakpoints on the update events, both on the reorder list, but also on the datasource, none fires.
What could i possibly do wrong, to achieve this?
Here's my code, just in case:
[Code]....
[Code]....
I use ADO.net Entity Data model for work with database.
In my program, I want to update a record of user table, so I use the code below to do this.
In this function I send changed user info and then overwrite the information with the current user information.
After I run objUser = _user; and then call objContext.SaveChanges(); to save the changes.
But when I do this, the changes are not persisted to the database. I use this code for another programs but in this case the code does not work!
public void Update(tbLiUser _user)
{
LinkContext objContext = this.Context;
tbLiUser objUser = objContext.tbLiUsers.First(u => u.tluId == _user.tluId);
objContext.Attach(objUser);
objUser = _user;
objContext.SaveChanges();
}
I am using C# for my programming. I am facing issue, that my hidden variable value is not being updated when it is in update panel. Please see below code for aspx:
<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
<asp:Timer ID="Timer1" runat="server" Interval="10000" OnTick="Timer1_Tick">
</asp:Timer>
<input type="hidden" runat="server" id="hidCurrentDate" value="" />
<input type="hidden" runat="server" id="hidTripIds" value="" />
<input type="hidden" runat="server" id="hidTripDetails" value="" />
<asp:UpdateProgress ID="uprogTrips" runat="server">
<ProgressTemplate>
<span style="display: block; text-align: center">
<p style="font-family: Verdana; font-size: larger; font-weight: bold;">
<img src="../../Images/ajax-loader.gif" alt="Processing..." /><br />
<br />
Processing...</p>
</span>
</ProgressTemplate>
</asp:UpdateProgress>
<asp:UpdatePanel ID="upTripsGrid" runat="server" UpdateMode="Always">
<ContentTemplate>
<asp:GridView ID="gvAllTrips" runat="server" OnRowDataBound="gvAllTrips_RowDataBound"
OnPageIndexChanging="gvAllTrips_PageIndexChanging" AllowPaging="true" AutoGenerateColumns="false">
<PagerSettings Mode="NumericFirstLast" PageButtonCount="35" Position="TopAndBottom" />
<PagerStyle CssClass="GridPager" />
</asp:GridView>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />
<asp:AsyncPostBackTrigger ControlID="ddSortBy" EventName="SelectedIndexChanged" />
<asp:AsyncPostBackTrigger ControlID="ddFilterBy" EventName="SelectedIndexChanged" />
<asp:AsyncPostBackTrigger ControlID="cbPageOptions" EventName="CheckedChanged" />
</Triggers>
</asp:UpdatePanel>
and below is the code where I am trying to update one of the hidden field with my CS code. Interesting, when I am trying to debug its showing all the values, however when I see it f on page source it doesn't give any value. Here is my aspx.cs code:
protected void Timer1_Tick(object sender, EventArgs e)
{
DataTable dtTrips = null;
WEX.Prototype.Data.TripDA tripDA = new WEX.Prototype.Data.TripDA();
string tID = hidTripIds.Value;
string[] tripIDs = new string[1000];
tripIDs = tID.Split(',');
foreach (string tripID in tripIDs)
{
TripSummaryBO tripSummaryBO = tripDA.getTripSummary(Convert.ToInt32(tripID));
if (tripSummaryBO.tripLastEditedOnDate > Convert.ToDateTime(hidCurrentDate.Value))
{
WEX.Prototype.Service.WSProxies WSProxies = new WEX.Prototype.Service.WSProxies();
dtTrips = WSProxies.Build();
Session["AllTrips"] = dtTrips;
dtTrips = (DataTable)Session["AllTrips"];
if (dtTrips != null)
{
if (cnt==0)
{
hidTripDetails.Value = ("Trip name-" + tripSummaryBO.tripName + " was modified by user " + tripSummaryBO.tripLastEditedBy);
}
else
{
hidTripDetails.Value = hidTripDetails.Value + " <br/> " + ("Trip name-" + tripSummaryBO.tripName + " was modified by user " + tripSummaryBO.tripLastEditedBy);
}
BuildGridViewControl(dtTrips);
cnt = cnt + 1;
}
}
else
{
//upTripsGrid.Triggers.Clear();
PageInit();
}
}
}
I have a pretty standard update panel. In the update panel are radio buttons that trigger the update panel to change it's view (list or grid) based on which radio is selected. This works great in every browser except IE8. IE8 doesn't seem to want to update the height of the panel when it's refreshed causing the content are to stay rather large or to not be large enough.You can see it here:http://ccctest.insidehcc.com/Crossroads/Connect/Community-Groups/Video-Library/Spiritual-CPR
[Code]....
when i specify values in my update query the query works fine and the database gets updated, but when i use parameters in my query the database does not update here is the code i have written
try
{
OdbcConnection MyConnection = new OdbcConnection(ConfigurationManager.ConnectionStrings["myconn"].ConnectionString);
MyConnection.Open();
String MyString = "UPDATE orddetpabak SET jud1=@jud1,jud2=@jud2,jud3=@jud3,adv=@adv where fil_no=@fil_no AND orderdate=@orderdate";
OdbcCommand MyCmd = new OdbcCommand(MyString, MyConnection);
String j1=DropDownList4.SelectedValue;
String j2=DropDownList5.SelectedValue;
String j3=DropDownList6.SelectedValue;
String j4=TextBox4.Text;
String j5 = HiddenField1.Value;
String j6 = TextBox3.Text;
MyCmd.Parameters.AddWithValue("@jud1",j1);
MyCmd.Parameters.AddWithValue("@jud2",j2);
MyCmd.Parameters.AddWithValue("@jud3",j3);
MyCmd.Parameters.AddWithValue("@adv",j4);
MyCmd.Parameters.AddWithValue("@fil_no",j5);
MyCmd.Parameters.AddWithValue("@orderdate",j6);
Response.Write(DropDownList4.SelectedValue);
Response.Write(" " + DropDownList5.SelectedValue);
Response.Write(" " + DropDownList6.SelectedValue);
Response.Write(" " + TextBox4.Text);
Response.Write(" " + HiddenField1.Value);
Response.Write(" " + TextBox3.Text);
MyCmd.ExecuteNonQuery();
//MyConnection.Close();
}
catch(Exception epp)
{
Response.Write(epp);
}
I got a gridview to display the data from the database properly but when I go edit. it give me an error. I searched and change ConflictDetection=CompareAllValues to OverwriteChanges
The error goes away. However the database is still doesn't update. Does anyone had to tweak the gridview function to make it works. Maybe I did something wrong.
I have a rss feed. The rss page returns five items and the rss reader on iGoogle works perfect and updates the items just like I want to. But the rss reader in my HTC cellphone doesn't update the list of items, it just adds new items to the items it downloaded the previous time. It results in updated items being presentated multiple times in the rss.How can I tell the client to forgett its cache and reload the list?
View 1 RepliesI have 3 gridviews in one of my web page. I have simplified the system structure in the image below(further description will be stated below the image): As shown in the image above, the web site(presentation layer) will work closely with the Business Logic layer(BLL) and Data Access Layer(DLL). ObjectDataSource control will be the middle man to select, update, insert and delete the data in the gridviews. During Select, returned data from the database at DAL will be stored in a datatable and return to BLL and then the website itself.
The data in the returned datatable will be filetered by type using RowFilter method and stored into the 3 dataviews. Each dataview will act as the datasource for the 3 GridViews respectively, and therefore I specified the datasource programatically instead of setting the datasourceid for each gridview.
dataview1 = New DataView(dtSelectedTable)
dataview1.RowFilter = "Type='1'"
GridView1.DataSource = dataview1
GridView1.DataBind()
dataview2 = New DataView(dtSelectedTable)
dataview2.RowFilter = "Type='2'"
GridView2.DataSource = dataview2
GridView2.DataBind()
dataview3 = New DataView(dtSelectedTable)
dataview3.RowFilter = "Type='3'"
GridView2.DataSource = dataview3
GridView2.DataBind()
However, the Update(command button) and Delete(template field) doesn't work, the RowUpdating and RowDeleting event wasn't trigger when I click on the button, but it works if I set the gridviews' datasourceid to the objectdatasource. I couldn't figure out why, hope that someone who have come across the same problem couldn't provide some guidance.