Search results for query: *

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...

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...

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...

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, 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; }...

Hi All, Does anyone know how to use Page.SetFocus to set focus to a particular point on a page. I have an error message that pops and I want the page to focus on it. If I use Page.SetFocus I can set focus to a textbox but not to an anchor or label. Can anyone help? Thanks

Hi All, I am trying to get an authentication system on the site I'm doing. I'm using LoginView on each of the two restricted pages to show either the login diaglog or the actual page content. When I encapsulate the actual page code in the <loggedintemplate> and build the page it says that all...

Hi All, I have a datasource with an insert command and parameters as below. The textboxes referred to are populated and can be edited. Only trouble is when I run the Update method of the datasource the original textbox value is used in the update (I.e. no change) instead of the new one I type...

Hi All, If I have a datasource and run the SELECT method of it. i.e datasource.select(); How do I then get at the values without using a datagrid or repeater or whatever. i.e. I have textboxes and I want to write the results of the select statement to these text boxes (only one record will...

Hi all, When should you use NCHAR? I know it's for use with non-english characters but even if you are expecting English input should you use it to allow people to enter characters with umlauts or for email colums Can the Char column type store charcters with umlauts or can it only store the...

Hi all, Is there an easy way to print out a c# variable from the code behind in my HTML text without using a textbox? In classic ASP it was <#= variable_name #> (or something like that). Can you do this in ASP.net? ta C

Hi all, I have been given an HTML template of a site. It has a nice decrative table that has been put together by the designer. I need to display data from a database in this table. I've looked at gridview, detailsview etc but these would require me to recreate the table and having tried this...

Hi All, I am trying to create a gidview but I am having a right nightmare trying to get it to display in firefox as it does in IE (or similar). I've been trying to replace a table in an HTML document with a gridview but I'm finding that the gridview is retstrictive and unpredictable with...

Hi All, I am trying to create a gidview but I am having a right nightmare trying to get it to display in firefox as it does in IE (or similar). I've been trying to replace a table in an HTML document with a gridview but I'm finding that the gridview is retstrictive and unpredictable with...

This is a beginners question - sorry in advance if it is a bad question... In classic ASP you could put script into the html to change what HTML is shown. E.G. If I want to show one table if a querystring equals acertain value and another table if the querystring equals someother value - i...

Hi All, I am working on my first c# .net website. I'll be given the HTML templates and I have to add the code behind. I need to display an SQL database on the screen and allow it to be updated, delete records etc. I can't see how I can use a datagrid as I already have the HTML table setup...

Hi all... Is there a way to forward calls (to an external number) whilts connected to them? E.G. I get a call, I listen to the person then I press a 'hotkey' and the call is forwarded to an external phone number associated with that hotkey. Does anyone know if this is possible, I can only...

Hi all, I need to match urls against emails based on domains and I've decided the best way to go is to remove the http/www etc from the URLs the remove the name@ bit of the emails - then match. The trouble is, I can't work out how to get SQL server to remove all characters from the start of the...