Search:

Yea I figured this out the hard way :)
It makes more sense to me now though.

Thanks everyone!

ahh but of course!

I still get in my vb.net state of mind from time to time and think about things too hard.

I wanted to do this as well but without even calling the class. Like this:



MessageBox.Show(GetCoolDude());

I seem to remember doing this in VB.net, I may be wrong though. I'd love to...

Check out this site:
http://blogs.vertigosoftware.com/alanl/archive/2006/07/25/Creating_a_Confirmation_Using_the_ModalPopup_Extender.aspx

I figured this out. It actually turned out to be a problem with a dropdownlist and not the datefield, i was just blaming the date field for the problem :)

Thanks! I still learned alot!

Ok I think that did it. Once I set the value of the ListItem to "0" it works great.

I'm not sure if this will work but specify the script type in your javascript being generated.

strScript="<script type='text/javascript' language='javascript'>"
strScript = strScript & "alert('"...

I created a strongly typed table adapter and added a simple update query that updates my database based on the values passed into its parameters. I've attached a screenshot of my parameters screen. ...

Yes it is to update the record in SQL. I'm not familiar with parameterized queries (i'll google it after this) but I thought the update method technically was one since it accepts parameters.

That works good, but when it tries to pass the value into my UpdateMethod it errors out saying:
Input string was not in a correct format.

edit:
i'm changing this post because I figured this part of the problem out...

Now the issue at hand is this:

For the date fields, I had to manually inject the values for the parameters...

hmm even when I fill in all the date values it still throws that error :(

I think the problem is I'm trying to pass null values into my method and it doesn't like it.

Hmm i just figured something out:

I removed all the date field values from the record i'm updating (in sql) so it won't pass a date value into the database and i'm still getting the error. Could...

See I THOUGHT that was the case, I've never had to format a ShortDateTime back into sql any other way. Here's the code:


adapterContacts.Update(Convert.ToDateTime(txtContactDate.Text));
...

Ok now I need to convert the shortdatestring to back to the format sql needs it. When I try to update using the value in shortdatestring I get:
String was not recognized as a valid DateTime even...

Ahhhh I think I figured it out :blush:

I just put ddlContactType.Items.Add(""); and when I stepped through debugging it reported the value = "" so maybe that will work.

I'm going to work on...

Here I am again :D

You guys may have remembered from my last installment that I'm populating all my DropDownLists at runtime using DAL methods. Here's an example using one of my US States...

Are there any .NET functions that will strip non-alphanumeric characters from a string (such as a phone number or social security number)?

I've searched everywhere but can't seem to get a...

I think you're trying to set the SelectedDate right? You can't use Text to do so on an ASP calendar.

Try


<asp:Calendar ID="DateOfServiceCalendar" runat="server"
...

Thanks to everyone who posted! And the idea of doing it at the database level is very good to know and I can apply that in the future.

That did it! :D But now I'm torn between formatting it there or at the db level. I mean I have it setup to remove the formatting when I update using these formatted field.

Well thats one way to do it! :D

wow none of these suggestions are working. this is odd. I'm posting the entire method I wrote to fill the dropdown list, maybe its something inside it:



private void fetchDeductables()
...

Also,
I just found this, it might help.

http://scottonwriting.net/sowblog/posts/5480.aspx

Looks like you have User Instance = true, which needs to be false in a hosting environment.

Also your "transmiamiConnectionString" is still looking by hostname, I don't know if this is your old...

I don't know why I"m having such a hard time with this format. It's still not working. I'm trying to format the values in a dropdownlist that come from a database as a 'money' type. Of course they...

On your Sign Out link, add the target="_top" property.

Example: <asp:hyperlink id="hyperlink1" NavigateURL="#" target="_top"></asp:hyperlink>

You'll need MS SQL 2005 on your web server or if you already have a sql server you can point your connection string there. Alternatively you can use Sql Server 2005 Express, which is free (unless...

Hey I'm reopening this thread as to not make another one. I'm having a similar problem trying to format a money datatype from SQL. Here's my code that gets the data:


txtDrCopay.Text =...

These are textboxes in a form (I think you think they are labels?). If the value is null of course I want the textbox to be empty and if the user chooses they can put something in the textbox and...

Ahh I see what you mean. I just noticed something to. Here's how I'm checking for null:


if (ds.Tables[0].Rows[0]["AddressLine1"] != DBNull.Value)
{
txtAddressLine1.Text =...

AHHH There's my precious .ToShortDateString method!

This is my first major project in c# (vb.net from the beginning) so I'm still rough around the edges :)

Thank you so much! Worked perfectly!

Ok thanks for clearing up the DAL issue. I wasn't sure if there was a way to bind a DAL method to a SqlDataSource. At this point I'm very proud of my DAL methods and want to use them :) I spent...

I have a field on my form that gets its data from a SQL DateTime field. Of course when the control populate it looks like this: "12/12/2008 12:00:00"
I want it to only show the small date (ie...

Are these other pages in different folders in the project? If so you can create another web.config inside each folder you want secured and then put

<authorization>
<deny users="?" />...

I considered that but then I feel like my DAL methods would be useless because I can't use my Select/Update/Insert methods with the SQLDataSource :)

Here's what I ended up doing:


int...

I think what I'm going to end up doing is just fill my dataset with the method to get all my data, then manually fill the controls on Page_Load(). Unless anyone can think of something more efficient...

You could use AJAX and try this custom extender (I have not tested it, though it looks promising).

http://weblogs.asp.net/rajbk/archive/2007/06/13/the-gridview-row-drag-overlay-extender.aspx
...

Hey I have quite a fiew fields for a specific form I'm writing. So instead of using a gridview, or detailsview, or formview, I just slapped a bunch of aps:controls on the page and setup my...