DataSource Controls :: Why Value Of Id Field Lost In
Jan 22, 2011
I used sqldatasouce and storeprocedure to populate DetailView. I need update few tables by pass parameters to my storeprocedure. but some value always lost (most of them is keyfield). when I checked those value through sqldatasource_updating event they are null . How can I get the correct value?
I have a hiddenfield, which I want to save the scroll position of asp.panel scrollbar during postback, and when during postback this value is called back to set the scroll position.
Using javascript I can grab the value from the scrollbar, and assign it to the hidden field, but when I post the page back the value has gone.
Here is my code snippet: <script type="text/javascript" language="javascript"> function SetScroll(val) { [code].....Am I missing something? How do I keep the value during post back?
I have a 20 to 30 fields on a form. Most of them are optional. However, the users can fill out what they want. If a user dosen't fill in a field when data is sent to the database it's sent as blank, instead of NULL. Is there a way I can generically say "for all textboxes if Equals("") then DBNull.Value". Without going through each and every textbox?
I would like to do an attachment on my database but I lost the full-text catalogs file. Sql server won't let me attach the database without it. What do I need to do to overcome this issue? Is there a way to tell Sql Server to skip the missing catalogs? If not, how do I generate another full-text catalogs file to replace to lost one?
I am working on an ASP.NET application (well supposed to be deploying it about 3 days ago) and my hidden fields are loosing value when the form gets posted back..
I am using them to store information i write using javascript and on my own machine this works fine but as soon as i deploy it on our server everything else works except these values are lost..
I am using the .NET AJAX control toolkit on the same page and have noticed my calander datepicker also looses the data..
I have checked using firebug and the data is definitely getting post to the server but is getting lost somewhere!
I have some code where I need two separate required field validators for one control, both in separate validation groups which are then validated by two separate buttons.This approach works well when the buttons are clicked but both validators show if I enter a value in the textbox and then remove it.
Is there a way to turn this"lost focus" validation off? I only need it to validate when the buttons are clicked.
EDIT,Unfortunately, if I set EnableClientScript=false then I dont have any client notifications. What I want is for the dynamic error message to show (effectivly in the OnClientClick event of the button) but not the "lost focus" of the textbox.Is there some way I can disable or "unhook" the lostfocus client event?
EDIT,A combination dDejan's answer and womp's answeer here sorted the problem perfectly.
My final code looks like this (for anyone else with a similar situation)...
Javascript...
<script type="text/javascript">
$(document).ready(function() { [code]....
So, now there is no validation until a user clicks either the "Get Email Confirmation Code" button or the "Register" button. If they click the "Get Email Confirmation Code" button all of the controls validate apart from the textbox where the user is to input the email validation code and we only see one validator message.
If they click the "Register" Button then all of the controls validate and we only see one validation message.If either button is pressed, the user goes back, adds and then removes some text then we only see one validator. Before this change you used to see both messages saying the same thing.
Dim abc As String abc = Request.QueryString("str") Dim userName As String = CStr(Session("user")) Label2.Text = userName Dim MyConnection As New OdbcConnection(ConnStr) MyConnection.Open() Dim MyCommand As New OdbcCommand MyCommand.Connection = MyConnection If MyCommand.CommandText = "Select userid from week where userid ='" & userName & "'" Then MyCommand.CommandText = "Update week Set value = '" & abc & "' where userid ='" & userName & "'" Else MyCommand.CommandText = "INSERT INTO week (value, userid) VALUES('" & abc & "','" & userName & "')" End If MyCommand.ExecuteNonQuery() MyConnection.Close()
At the top of my form I have some code that calculates a field
[Code]....
In my form I have this code. What changes below do I need to make to have the value of Date in XXXX?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sqlConnection %>" SelectCommand="SELECT NumPeople, Date1,Time1,Venue FROM People_Count WHERE ((Date1=@ArvDate and Time1 >= '06:00:00.000') or (Date1=XXXX and Time1 <= '06:00:00.000')) and Venue='F & B' ORDER BY Date1 ASC, Time1 ASC"> <SelectParameters> <asp:QueryStringParameter Name="ArvDate" QueryStringField="ArvDate" /> </SelectParameters> </asp:SqlDataSource>
I am attempting to compare one of ASP.NET's membership userID's with the current userID in an SQL query, however because of the "hyphens -" in the uniqueidentifier field type of userID, i am unable to compare the ids. is there a way around this? (in my example, family_id from tblFamily is the userID that has type uniqueidentifier). my code as it stands is:
Dim UserID As String = New String(Membership.GetUser(User.Identity.Name).ProviderUserKey.ToString()) Response.Write(UserID) Dim strConn As String = ConfigurationManager.ConnectionStrings("ApplicationServices").ConnectionString Dim SQLI As New Data.SqlClient.SqlCommand("SELECT family_name FROM tblFamily WHERE [family_id] IS " & UserID & "") Dim sqlCon As New Data.SqlClient.SqlConnection(strConn) sqlCon.Open() SQLI.Connection = sqlCon Dim RSI As Data.SqlClient.SqlDataReader = SQLI.ExecuteReader() RSI.Read() Dim FamilyName As String = "0" While RSI.Read FamilyName = Convert.ToString(RSI("family_name")) End While Response.Write(FamilyName) RSI.Close() sqlCon.Close()
I have a form that submits one entry to a 'Listings' table and multiple entries to a 'ListingLocation' table depending on how many cities the user selected. When the listing is created, I need the auto generated 'id' field to input into each of the the listing rows of the 'ListingLocation' table. This seems like it should be simple but I cannot figure it out. I currently have it hardcoded to enter '22' where I need it to enter the listing id.
For example: INSERT INTO table (col1, col2, col3) VALUES ('value1','value2,'value3')But I would only like to insert the row if value3 isnt already present in col3 in some previous row. What is the best way to do that?And the insert command is run 50+ times in a loop (with different values each time for value3)
i need to update one field in a tabel just to +2 and i can not find out how to do it the code i have write until now is just to find the field i has to update this i the code
[Code]....
write the last code there can +2 to a.point field in my db
to provide a link to documents held in directory so directory contains [URL] or [URL] Agenda contains
00209-FebruaryMtgMin%5E_.pdf
If I declare Directory as VarChar(nnn) where nnn is large enough to accomodate the longer field, The statement <%# Eval("Directory")+eval("Agenda")%> returns
I'm trying to get an IDENTITY column to auto-increment with each new row inserted, so that the field (userid in this case) can be used as a unique identifier.
However, I'm getting this error:
[Code]....
My code looks like this:
[Code]....
I don't understand - if I have to explicitly insert something into my auto-increment column, how do I know what to insert? Isn't the point of an auto-increment column that it's... auto?
I have a gridview which shows a list of data... at the end of each item I have added a button which is linked to the onclick event... when a button is clicked I want a value to update on that specific row... but I can't get it to work :( my code is below...
SqlDataSource 1 code...
UpdateCommand="UPDATE [PurchaseProduct] SET [BDConfirmSent] = 'Yes' Where [Id] = @Id"> <UpdateParameters> <asp:Parameter Name="Id" /> <asp:Parameter Name="BDConfirmSent" /> </UpdateParameters>
Code Behind...
Protected Sub SqlDataSource1_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles SqlDataSource1.Updating e.Command.Parameters("@BDConfirmSent").Value = "Yes" End Sub Protected Sub Button1_Click() SqlDataSource1.Update() End Sub
When I click the button it just postsback the page but then the [BDConfirmSent] field is still empty instead of being "Yes"