|
Well I guess if I still convert the users input (after setting a validation like \d{2}\\d{2}\\d{4}) it will still convert and do the calculation right. Because if you don't specify a time it will input 12:00:00 AM for you.
Also here is what I have for the update:
UPDATE Clipboard SET County = @County, Type = @Type, Date = @Date WHERE (IncidentNumber = @IncidentNumber)
|
|
|
|
|
so in your datasource you need to specify under the "Update Parameters" section each one of those
<UpdateParameters>
<asp:Parameter Name="county" Type="String" />
<asp:Parameter Name="type" Type="Int32" />
<asp:Parameter Name="Date" Type="DateTime" />
</UpdateParameters>
make sure the parameter datatypes match the sql data types.
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
Well one way to do this is to in the asp:Gridview tag code you can add
DataKeyNames="[id column name here]"
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="lvl1_id"
DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">
This will make whatever you put in that for a column the way gridview identify records. So if you're records have an ID column, it should be that. This is probably the method I would use.
AND make sure your datasource has an update parameter set:
<UpdateParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
<asp:Parameter Name="lvl1_id" Type="Int32" />
</UpdateParameters>
This is part of the DataSOURCE code. See the update parameters....in the SQLDataSource, this is where you can set it up. what this is saying it take the text box for lvl1_name and the lvl1_id for that record and perform a sql update. So if it's not updating, I would say it's because your datasource code in the .aspx is missing those update parameters. I will include a datasource next.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:blahblah %>"
DeleteCommand="UPDATE [bmj_level1] SET [enabled] = 0 WHERE [lvl1_id] = @lvl1_id" InsertCommand="INSERT INTO [bmj_level1] ([lvl1_name]) VALUES (@lvl1_name)"
SelectCommand="SELECT [lvl1_id], [lvl1_name] FROM [bmj_level1] WHERE [enabled] = 1 ORDER BY [lvl1_name]" UpdateCommand="UPDATE [bmj_level1] SET [lvl1_name] = @lvl1_name WHERE [lvl1_id] = @lvl1_id">
<DeleteParameters>
<asp:Parameter Name="lvl1_id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
<asp:Parameter Name="lvl1_id" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="lvl1_name" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">"
DeleteCommand="DELETE FROM [Clipboard] WHERE [IncidentNumber] = @IncidentNumber"
InsertCommand="INSERT INTO [Clipboard] ([County], [Type], [Date]) VALUES (@County, @Type, @Date)"
SelectCommand="SELECT * FROM [Clipboard]"
UpdateCommand="UPDATE Clipboard SET County = @County, Type = @Type, Date = @Date WHERE (IncidentNumber = @IncidentNumber)";
<deleteparameters>
<asp:parameter name="IncidentNumber" type="Int32" />
</deleteparameters>
<updateparameters>
<asp:parameter name="County" type="String" />
<asp:parameter name="Date" type="String" />
<asp:parameter name="IncidentNumber" type="Int32" />
<asp:parameter name="Type" type="String" />
</updateparameters>
<insertparameters>
<asp:controlparameter controlid="txtCountyAdd" name="County" propertyname="Text" type="String" />
<asp:controlparameter controlid="txtTypeAdd" name="Type" propertyname="Text" type="String" />
<asp:controlparameter controlid="txtDateAdd" name="Date" propertyname="Text" type="String" />
</insertparameters>
</asp:sqldatasource>
DELETE and UPDATE do not work.... uhmm
modified on Tuesday, May 20, 2008 11:47 PM
|
|
|
|
|
In your <asp:gridview> code in there add this:
DataKeyNames="IncidentNumber" like this:
<asp:GridView ID="GridView1" runat="server" DataKeyNames="IncidentNumber" DataSourceID="SqlDataSource1" GridLines="None">
now try it.
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
awesome! your a life saver!
|
|
|
|
|
Ok now my time search isnt working...
You enter lets say: 1/1/2008 and 5/5/2008 and click a button.. here is the command:
SqlDataSource1.SelectCommand = String.Format("SELECT * FROM [Clipboard] WHERE [Date] Between {0} AND {1}", Convert.ToDateTime(txtBeginningDate.Text), Convert.ToDateTime(txtEndDate.Text));
But I get an Incorrect Syntax at 12?
|
|
|
|
|
in the sql server. in the "Clipboard" table...what is the data type of the "date" column...
actually change of plans try this.
SELECT * FROM [Clipboard] WHERE [Date] < {0} AND [Date] > {1}
or
SELECT * FROM [Clipboard] WHERE [Date] > {0} AND [Date] < {1}
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
modified on Wednesday, May 21, 2008 12:30 AM
|
|
|
|
|
Hey! Yes I have the Date column set to: DateTime.
It actually wants the Date and the Time but I am fine with that.
It doesn't have an option for just the date.
Anyways what I did was that I forgot the: " ' ' " between the beginning and ending dates.
Like I did it like this: Where [Date] Between {0} AND {1}
and it should of been: Where [Date] Between '{0}' AND '{1}'
it works though. thanks!
|
|
|
|
|
i can't believe i didn't even notice that. i should have known better.
it was late 
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
lol! Its always the easiest problem that is the solution isnt it lol
|
|
|
|
|
hi Jacob Dixon,"Ok in the dialog for the update command it has the command for updating the fields. So when you click update in the grid view where are the commands that make it update? It will not update. When you change something and click UPDATE it just goes right back to what it was." for this please check the isnotpsotback property is given in Pageload event or not .
|
|
|
|
|
jgasm had me do something and it works great now. It was a DataKeyName value in the GridView code. I didn't have one set when I should of had it set to my ID Column.
As for the date/time thing I have figured it out. Thanks!
|
|
|
|
|
I have a simple login form that uses a master page. Im having a weird problem where when the login button is clicked the code behind cannot see the txtUserName.Text
The text box html is
<asp:textbox id="txtUsername" runat="server">
The code behind is
Dim currentUser As New DAL.AppUser
currentUser = currentUser.AuthenticateUser(txtUsername.Text, txtPassword.Text)
If currentUser.AppUserId > 0 Then
....
When I set a breakpoint at currentUser =... I see txtPassword.Text value but txtUsername.Text shows "" even though it is filled.
I checked that its view state is enabled. Tried deleting it and re-adding. Very weird.
Has anyone ever had this problem?
|
|
|
|
|
Try capital ID and make sure the ID value is unique on the page
<asp:textbox ID="txtUsername" runat="server" />
Wait, nevermind, you're using VB, could be anything then. 
led mike
|
|
|
|
|
Dim currentUser As New DAL.AppUser
currentUser = currentUser.AuthenticateUser(txtUsername.Text, txtPassword.Text)
If currentUser.AppUserId > 0 Then
=====================================
where is this in the code behind? is this on page load? or page init?
when the page is submit and then loads those text boxes will be blank when the code goes for them.
also when you step through the application and you go one step past the txtUsername, what is the value then? is it still "" for currentUser?
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
The code behind is on login.click button event
|
|
|
|
|
if i had to guess it's because the page is posting back to itself when "login" is clicked and then you're code to collect the information is processing after the post back.
otherwise...i have no idea
-----------------------------------------------------------
"When I first saw it, I just thought that you really, really enjoyed programming in java." - Leslie Sanford
|
|
|
|
|
I tried setting AutoPostBack to true and setting a string var on the txtUesrName_TextCahnged event but it show TxtUsrName.Text as NULL also so I am pissed at this point. Its a copy of another site that works fine. It must be some corruption in the asp page.
|
|
|
|
|
I think it's asp:TextBox, does the other one work with this capitalisation ?
Do you have code that sets the username value anywhere, such as page_load ?
Christian Graus
Please read this if you don't understand the answer I've given you
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I rebuilt the whole page and problem fixed.
|
|
|
|
|
Hi,
I am working on this web application that needs to allow the user to upload files. The problem I am having is that when I upload a file with a pound sign, and try to access it I get an error. For example, the file 'AMS.doc' would upload fine to the server and when I try to download that file when it shows up in my grid, everything will go as expected.
However, if I rename the file to 'AM#S.doc' and then upload it, it will get uploaded to the server and the file name will get saved to the database, however, when I click to try to download that file, I get an error message. Is there a way to fix this? I have tried Server.UrlDecode and Encode, as well as HtmlEncode and decode, and none have fixed the issue.
Thanks,
TheMajorRager
|
|
|
|
|
What kind of error are you getting? Are you sure it is trying to access it the same way it is stored in the database? Sometimes when you pull things out of the database, if it thinks there is a SQL Injection risk, it will stop reading.
It would help to get an error message, and some relevant code...
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hi all,
I have many Messages in web.config file:
for example:
1-Could not find schema information for elemect
'http://schemas.microsoft.com/.netconfiguration/v2.0:configuration'
2-could not find schema information for attribute'name' here:
<add name="FirstName">
3-and etc...
why these messages occure?
Is these messages a reason of that i can not connect to my database?
thank you,
Hoda
|
|
|
|
|
They could be, and probably are. All files should have no issues if you expect to be able to have everything work.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
