Hi all,
Has anyone else ever seen the following issue or can sugest away to prevent it...
I have a form, I can delete from the various text boxes at will without issue.
But As soon as I make a selection from a drop down then move focus to another cell then press delete, the form posts.
Anyone...
what an idiot I am.
You're right
I was stuck on thinking about having to pass the null value through a parameteter and forgetting the odvious.
I'm building the update query any way so, as you say I'll just write it into the statement as SQL.
thanks
ta
C
Actually I think I'll set all of the fields that could be null to null first then, write the new data over the top.
Still a bit messt but better I think
Hi
I have an update statement and when fields in my form are left blank I want NULL inserted into the databse rather than "".
I can't find a way to do it.
If I can't find another way my plan is to set the fields in the data base to <NULL> using c# then use a second SQL query after the update...
Foolishly I have inserted a column at a specific location on a large table (3.4million records).
In retrospect I should have added them to the end.
It's taking ages to do it.
Does anyone know...if I cancel it will my table be corrupted, or does it keep a store of the old table before it drops...
I started looking into Javascript and .net (2.0)
and I found this page...
http://dotnetslackers.com/articles/aspnet/JavaScript_with_ASP_NET_2_0_Pages_Part1.aspx
This explained that there was an update to .net 2.0 that sorts this problem.
Just add MaintainScrollPositionOnPostback="true" to the...
Hi all,
I have a textbox field in a form that has an associated checkbox.
When this checkbox is checked the field is greyed out and becomes readonly.
Currently I have the onCheckedChange event (with autopostback on)trigger some code that sets the attributes of the textbox to do this.
My...
I see what you're saying and that is a good idea but having thought about it I can't because I don't want this page to have anything other than SELECT access to this database (it's a public facing page). Also all the updates are checked by somebody before they are added to the main site (which...
Hi,
I have a detailsview that shows the details of a record.
The person viewing the page can update the details.
When they click update the record on screen inserts to a different table (to protect the original table) rather than updating.
I did this by automatically putting the detailsview...
Hi All,
I've seen a bit on the web about closing conncetions and datareaders.
I have consequently been putting try-catch-finally blocks around my connections and datareaders and closing the connections in the finally block.
My question is: If you have a data source or datareader dragged and...
Hi All,
Thanks, I used similar to jasons code above and it still didn't work, but I think it was because I had the code in the onpageload event and the listbox in question was populated from a database table using a datasource in the HTML.
I think the above code was running before the listbox...
Hi SBO,
Thanks for your help.
I tried...
if ((dditems.Value == "Graduate")) {
dditems.Selected = true;
}
But it is telling me that it doesn't have a definition for '.Value' or '.Selected'
I've been looking through the intellisense list of options but can't find anything else...
Hi , Thanks for your answer.
I can see what you're getting at, I need to cycle through each item in the listbox, compare it to each item in the array of values I want selected and select where there is a match.
The trouble is I am using c# and can't find a way to set the individual item to be...
Hi all,
I have an array of values that I want to select in a multi selection listbox.
I've tried this, but it only ever shows one of the selecte d values...
(c#)
foreach (string itemstoselect in arrayofitems)
{
lbJobType.SelectedValue = itemstoselect;
}...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.