Search results for query: *

I need to keep similar tables in two different databases in synch. This is what I want to do: -Any column update to database1.mytable should trigger the same column update to database2.mytable. -Any column update to database2.mytable should trigger the same column update to database1.mytable...

I think what I want returned is: Select *fields that you want to display* from table1 where title like "%Component Developer%" AND title like "%Magazine%". The title should contain all terms in the search criteria and should search for full terms if the user put it in quotes, e.g. 'Component...

How would we write code to parse statements to account for various user entered search criteria, similar to the searches you can do with Google? For example: If the search is for a Title and the user enters: "Component Developer" Magazine, how would we write the sql code to search for titles...

I have a javascript function that is called when I click my server-side submit button. I want to validate that one of my labels is not empty before allowing a submit. I cannot figure out how to access the value stored in myLabel.text. For hidden form variables I use the following syntax in...

Good point on the db hit. I think I'll go with a session. Thanks for sticking with me!

Thank you very much for your help, but I was trying to avoid sending the id in the URL. I guess I can just use a session.

Yep, I ran into the read-only exception, too. I was trying to give a simple code example. What really happens is this: 1. The user fills in a bunch of text fields to create a new record. 2. The user clicks the 'save & continue' button that calls btnSubmit_Click(). 3. btnSubmit_Click inserts...

Unless I'm missing something, Server.Transfer("AnotherPage.aspx",True) does not pick up the values that were changed server-side. I think tgreer is right in that I need to change the http form data. I'm just not sure how to go about it. Thank you.

Thank you, but how do I do that? What is Request.Form.Set()? I couldn't find any documentation.

I have a textbox, txtName, runat=server. When the submit button is clicked, I want to change the value of txtName in the code-behind page and then submit the changed form variable to another page. It seems that the value of txtName must also be changed client-side in order for the value to...

Just concatenate it to your string like you would any variable.

I used to use ColdFusion's <cfabort> tag to end processing of a web page if a certain condition was true. For example, if the user came from the wrong page, I would display an error and then use <cfabort> to prevent the processing of the remainder of the page.

In C#, it's Environment.NewLine

My fix: I put the arraylist in a session variable and then reset the datasource in the EditCommand event handler. I was trying to avoid calling populateform() because it does a lot of other things (calls to db, etc.). Does this sound like an OK way to do this or am I going to get myself into...

I have a datagrid with an arraylist as the datasource. I added an Edit, Update, Cancel button column and coded the EditCommand event handler. When I click on the Edit button, the datagrid disappears. Have I lost my datasource during postbacks or something? Here's my code: private void...

I know that a string variable defaults to null and an integer defaults to zero if you don't assign values, but what is the default for a datetime variable? I need to check the value to see if it's 'blank' so that I know to insert dbnull.value into the database. Currently, my workaround for a...

I am using system.web.mail to send an email in asp.net (c#). I would like to format the body of the email message so that it includes an indentation on new lines. Can someone give me an example of how to do this? Thanks! Here's my code so far: MailMessage mail = new MailMessage(); mail.To =...

Hi, I'd like to store the contents of a listbox in a session variable. No error is produced from the assignment statement, but I cannot retrieve the items from the session variable afterwards. Thanks. //The following code is in page load... if(Session["lstGrpMembers"] == null) { //set the...

FYI, here's the final solution. I had to check for itemindex != -1 because the header row threw an argument out of range exception. IN CODE BEHIND PAGE: public void dgGroupMembers_ItemDataBound(object sender, DataGridItemEventArgs e) { if(e.Item.ItemIndex != -1) { CheckBox...

No, during runtime (depending on the type of user). I want all checkboxes within the grid to be disabled. Thanks.