Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. quinnipiac0807

    How to tell which button causes form to submit?

    I have a form that has two asp:buttons on it. When one button is pushed, I want the page to do some validation that I'me doing with Javascript and submit based on a condition, BUT, if the second button is pushed, I just want it to submit without any validation. What I'm doing now is, in the...
  2. quinnipiac0807

    Focus on Parent Hides Popup

    I have a parent form that I have set the focus to a certain textbox. The focus works fine, but the problem is, when I open the popup using window.open(), it resets the focus to the same textbox again hides the popup behind the parent window. Is there any way around this? Thanks in advance.
  3. quinnipiac0807

    Dual Monitor Setup

    I'm sure this question has come across this forum many times. I have a Dell Latitude D600 that I put in a docking station at work (dock, external keyboard, external mouse, external monitor), and I want to increase my productivity with dual monitors. I have a MOBILITY RADEON 9000 video card...
  4. quinnipiac0807

    Removing ALL Spaces from Variables

    This could be a dumb question but I'll give it a go anyway. I'm using SQL Server 2000, and I'm trying to take a variable and make sure it has no spaces in it, ANYWHERE!!! As easy at this seems it's really confusing me. Ex. - If a varibalbe looks like this 'Lee Ann', I want to change it to...
  5. quinnipiac0807

    Returning Null

    I have this line of code that works with my class. I want this to return null if selecteditem.value == 0. Problem being that when null is converted to int it returns 0. I need to put a null value into my database. Any suggestions. address.StateID =...
  6. quinnipiac0807

    Null Values

    I'm having some trouble handling Null values when I submit them to my database from my .net page. I can handle the strings fine, obviously, but I'm having trouble with foreign keys and dates and things like that. I was just wondering if anyone had a good site for me to look at to read up on...
  7. quinnipiac0807

    Date Question

    I have a class that calls a date out of my database. If there's no date in the database I want the field to be blank, but if it's blank it puts 01/01/01 in the field. This is how I'm evaluating it. if(dr["EstCompDate"].ToString() != String.Empty) t.dtEstCompDate =...
  8. quinnipiac0807

    Simple Question

    I'm pulling a date out of a database and putting it in a label on my .aspx page. My question is, what is the easiest way to format the date to this format. mm/dd/yyyy. A shortdatetime format. I've found many different ways to do it but I wanted to know what the easiest is. This is how I...
  9. quinnipiac0807

    Javascript using c#

    This should be a fairly easy question and I'm not sure why I can't get this to work. I have an asp:button on my page and a javascript function in the html. I need to call this funtion using c# on the btnCancel_Click() event. I'll show you the funtion and the code I'm using but for some reason...
  10. quinnipiac0807

    Submit Form Question

    I have a form, and when I click the Submit button I get this error. Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where...
  11. quinnipiac0807

    Repeated Sql Returns

    This is my statement and it returns 8 of each each answer even though there should only be 2. So there's 16 instead of 2. I know you can use distinct but is there anyother way to fix this. I feel like select distinct will leave some answers out. select t.AssetID, a.AssetID, t.CustodianID...
  12. quinnipiac0807

    Can't Refresh Parent Page!!!

    I've been working with this problem for a while but have been unable to come up with a solution that works. I have a parent page called CustodianView.aspx and a child page called DeleteCustodianAssignment.aspx. I use an image button to get from the parent page to the child page, then an...
  13. quinnipiac0807

    True/False to Yes/No

    Is there a way to change the data coming out of a database using an sql statement. For instance, I have a column that's bit. Instead of it saying true/false when it comes up on my page i want it to say yes/no. How do I do this with a sql statement?
  14. quinnipiac0807

    Window Refresher

    Got the ddl working but here's my question. I have two pages, we'll say Page1.aspx and Page2.aspx. When you click something on page 1 it opens page 2 and you can make changes on page 2. So when you click ok on page 2 it brings you back to page 1 but i need page one to reload to show the...
  15. quinnipiac0807

    SQL in VS.Net

    I'm trying to create a statement for a dropdown list but it says there incorrect syntax near +. I think this should work. What I want to actually show up in the ddl is Asset Tag - AssetMfr AssetDesc. string sql = "SELECT a.AssetID, a.AssetMfrID, m.AssetMfrID, a.AssetDescID...
  16. quinnipiac0807

    Input string not in correct format

    I'm trying to pass a variable from one page to another and I"m getting the input string in correct format error. I usually can work arround this error but this time I can't. Here's the code. protected void grdAssets_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs...
  17. quinnipiac0807

    Getting Current Date

    I'm trying to put the current date into a table with column name StopDate (smalldatetime) and table name psd_AssetCustoian. AssCustID is the Primary Key. This doesn't work. Any clue why? SET StopDate = CAST(GETDATE() AS smalldatetime) WHERE AssCustID = @AssCustID Thanks in advance
  18. quinnipiac0807

    ddl Question

    private bool LoadDepartment() { SqlConnection Conn = new SqlConnection(Global.ConnectionString); Conn.Open(); //Populate Department DDL string sql = "SELECT ITDivisionID, ITDivShortName + ' - ' + itdivision as ITDivision " + "FROM psd_ITDivision " + "ORDER BY ITDivShortName "; SqlCommand Cmd =...
  19. quinnipiac0807

    Quick formatting question

    Quick formatting question. What is the easiest way to change the format of a boolean variable in a datagrid on an asp webpage. Would it be to do it in the SQL procedure, or is there a way to put it right in the c# code?
  20. quinnipiac0807

    Formatting DataGrid

    I'm just trying to convert a column in a datagrid to dd-mm-yyyy instead of day/month/year and then time. This is my statement: try { DateTime StartTime = Convert.ToDateTime(drv.Row.ItemArray[1]); e.Item.Cells[1].Text = StartTime.ToShortDateString(); } catch { e.Item.Cells[1].Text = ""; }...

Part and Inventory Search

Back
Top