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!

Register Log in
  • Congratulations derfloh 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. hamking01

    Session Variables... gone....

    I had an app that worked fine at work, but when I moved it to my home computer the session stopped working. Found that my firewall was the issue, turned it off and everything worked fine. Give it a try.
  2. hamking01

    Is there a big difference between Visual Studio.Net 2002 and Visual St

    I didn't see much difference between 2002 and 2003. 2005 was a big step though. Many more controls available and provide much faster development with a lot less code.
  3. hamking01

    asp.net validation controls and database validation

    What's the recommended best practice for data validation? Is asp.net validation controls enough or should I also create validation in sql stored procedures? What do you guys think? I was discussing this with a co-worker, and feel that asp.net controls should be enough and would be easier to...
  4. hamking01

    Refresh GridView

    I have an asp:table in a webpartzone that contains a textbox and button and an asp:gridview in another webpartzone. When the user inputs data in the textbox and clicks the button, it inserts into an sql table. The gridview displays data in the sql table. The gridview is using an...
  5. hamking01

    Setup file options

    The application would be given away to allow users to install. I want to allow a few installation steps for the user as possible, so forget the sql server. Don't wanna deal with the security. With Access for example, it would create a new mdb file, with no security settings. How can I have...
  6. hamking01

    Setup file options

    When creating a setup/deployment installer for an asp.net application can options be added to allow users to choose the back-end database and based on the selection use a certain connection string for the web.config file. How do distributed applications setup the back end database? Or must...
  7. hamking01

    Install db from backup

    Yes I have sql server installed on my local computer. I was emailed the bak file and moved the file to my C drive. I then ran the above command.
  8. hamking01

    Install db from backup

    I received a backup of a db with .bak extenstion. I'm trying to restore it on my local computer. Could anyone tell me the steps of setting this up. I've tried from query analyzer's master run the following command: restore database bt from disk = 'c:\BolTrab_28.10.2005.bak' But this...
  9. hamking01

    datalist binding from multiple tables

    Sorry for taking so long, had to work on another project. I've used: <%# DataBinder.Eval(ds, "Tables[<table name>].DefaultView.[0].<ColumnName") %> But this returns the firstrow of the datatable for every record in the list. It doesn't read through each row.
  10. hamking01

    select based on either or

    I trying to add up values of a column based on whether another column has a date entered as such: SELECT P.Plant , ISNULL(SUM(CASE WHEN F.dt_Sign BETWEEN '01/01/00'AND '12/31/00' THEN M.AppvdAmount END), 0) AS CurrentTotal , ISNULL(SUM(CASE WHEN F.dt_Sign BETWEEN '01/01/00' AND...
  11. hamking01

    datalist binding from multiple tables

    You mean declaring the dataset within the aspx page. I would rather not do that, as all my code will be in a codebehind. As in my previous posting, it's already directing to the correct table. Just need to figure out how to reference the column now.
  12. hamking01

    datalist binding from multiple tables

    k, getting closer. The following: <%# Container.DataItem("Tables(FunChi7).DefaultView.[0].Hourly") %> returns: Tables(FunChi7).DefaultView.[0].Hourly is neither a DataColumn nor a DataRelation for table FunChi7. but at least it's recognizing the table. Just need the syntax to pinpoint the...
  13. hamking01

    datalist binding from multiple tables

    I've tried the above but it returns 'ds' is not declared. Also tried: <%# DataBinder.Eval(Container.DataItem, "Tables(FunChi7).DefaultView.[0].Hourly") %> but returns 'System.Data.DataRowView' does not contain a property with the name Tables. Am I missing something here? Thanks
  14. hamking01

    datalist binding from multiple tables

    could you elaborate please. Are you talking about picking the column after you created a dataset via visual studio designer? I created the dataset via code: Codebehind: Dim cmd as new sqlcommand("sproc1", conn) Dim da as new sqldataapdapter(cmd) Dim ds as dataset da.Fill(ds) Dim cmd2 as new...
  15. hamking01

    datalist binding from multiple tables

    I have a dataset that returns multiple tables. Some of these tables have the same column names. I'm trying to bind the columns to itemtemplate of datalist. How can I tell it to bind Table1 ColumnA instead of Table3 ColumnA? I've played with the Container.DataItem but can't get it to work...
  16. hamking01

    How to connect to database

    you need to import system.data.sqlclient instead of odbc
  17. hamking01

    Less coding from Select..Case

    LFCfan, That's exactly what I'm trying to do. I didn't try it out, but looking at the code it should work. I actually figured out a solution using a slightly different method. Instead of a key/value table I added another hidden textbox to each array of textboxes. It would then match the...
  18. hamking01

    Less coding from Select..Case

    Sorry, wasn't specific enough. If Select Case CInt(dtResult.Rows(i)(1).ToString) Case 1 Then need to fill 1st set of textboxes: {txtHrFoundry, txtTpFoundry, txtSlFoundry} Case 3 Then fill 2nd set of textboxes: {txtHrMold, txtTpMold, txtSlMold} The case #...
  19. hamking01

    Less coding from Select..Case

    I have a multi dimensional array of textboxes, arrTxtBx(37, 3), and data populated in a datatable, dtResult. For each row in datatable if 1st column is DbNull it'll return "0" for the 1st set of 3 textboxes, if 1st column in not Dbnull it'll return columns 3, 4, 5 as text for the 3 textboxes...
  20. hamking01

    Delete sql with WHERE ... IN ....

    SQLSister Haven't tried it yet, only took a brief look, but it looks like this is exactly what I'm looking for. Thanks

Part and Inventory Search

Back
Top