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

    Refreshing controls in masterpage from user control (CallBack issue)

    I have a public method in my applications MasterPage which I can call from within a UserControl - i.e. by: ((MasterPage)this.Page.Master).MyMethodName(); This works fine from behind a button say (in the User Control) as we're effectively doing a postback. This updates a label control in the...
  2. StevenK

    Changing GridView cell colour based on DropDownList selection

    I guessed that javascript was the way to go with this. Can anyone suggest how to make use of this in this example? Thanks again.
  3. StevenK

    Changing GridView cell colour based on DropDownList selection

    I have a DropDownList control within a cell in a row in a GridView control on my web page. Ideally what I want is that when a user changes the selection in the DropDownList control, the cell changes colour (i.e. maybe green) to indicate some further action needs to be taken - i.e. the 'Update'...
  4. StevenK

    Editing grid entries via ComboBox

    I'm still battling with this and making no progress (too stubborn for my own good!). Are there any decent walkthroughs out there that I've overlooked? Anything like that would be of great help.
  5. StevenK

    Editing grid entries via ComboBox

    I'm familiar with the building blocks - i.e. getting the data, loading the data, etc. It's more the means of putting it all together hence the request for a walkthrough / sample to follow. Can anyone suggest one that can be followed? Thanks again.
  6. StevenK

    Editing grid entries via ComboBox

    I need to have a GridView component (or AspxGridView if need be) on a web page - and be able to have a ComboBox (or equivalent) in one of the columns. This will show a status for the respective record - i.e. 'Pending', 'Active', 'Completed', 'Cancelled', etc. - which is stored as an integer and...
  7. StevenK

    GridView and vertical gridlines

    Thanks for the suggestion - but when I tried that yesterday (from some code I found online) I found that it gave me both vertical and horizontal lines. However that was the simplest way to control both together. :-) I had to resort to setting a CssClass against the ItemStyles of the template...
  8. StevenK

    GridView and vertical gridlines

    Not being all that experienced with css - would someone be able to suggest how I can achieve these vertical lines in the GridView cells via means of setting the style? Thanks again. Steve
  9. StevenK

    GridView and vertical gridlines

    I'm making use of a standard GridView control (in ASP.Net with C# code). I want vertical grid lines - however when I set the GridLines property (for the GridView control) to either 'Vertical' or 'Both' - the resultant vertical line is only faint (possibly a light blue thin line). How can you...
  10. StevenK

    Run-time error '1004' when running SQL stored procedure (VB in Excel)

    That could well depend on whether the user in question has the security to create objects within the database. Try ODBC and see how you go...
  11. StevenK

    Run-time error '1004' when running SQL stored procedure (VB in Excel)

    I was asking whether 'robodad669' whether they were making use of an ODBC connection? I think the issue I was having was due to the security (i.e. not having the permission to create temporary tables within a database) via means of a hard-coded connection string. Working through an ODBC...
  12. StevenK

    Run-time error '1004' when running SQL stored procedure (VB in Excel)

    I'm now working through an ODBC connection (preset to the required db on the required server) - let's call it 'ODBC_CONNECT1'. Then in the macros I've got (in part): ' Load data Dim strCmdText As String strCmdTextSubPara = "exec mystoredproc" With...
  13. StevenK

    Changing DateTimeFormat in a Windows Service

    Thanks. I was able to make use of somthing like this successfully. I used: System.Globalization.CultureInfo culture = new System.Globalization.CultureInfo("en-GB"); DateTime d = Convert.ToDateTime(myDateString, culture);
  14. StevenK

    Changing DateTimeFormat in a Windows Service

    I had a Windows application that was processing files and as part of that was converting strings into dates. In the Windows app - the entry of 'Nov-08' was being converted to a date with: - day = 1 - month = 11 - year = 2008 However within a Windows service (using the same code as the...
  15. StevenK

    OpenRowset from csv/Excel file with "1,000" entries...

    The imported files are submitted by the site users - and are essentially out of our control. We're trying to keep the restrictions (i.e. file format to be used by the submitter) down to a bare minimum - else this may scare some users off (as not all are technical know-hows). As such is there...
  16. StevenK

    OpenRowset from csv/Excel file with "1,000" entries...

    Has anyone encountered an issue like this? And been able to work around it? I hope that someone is able to offer some advice. Steve
  17. StevenK

    Removing a share?

    I was attempting at setting up some shares between a couple of projects - in order to save me time repeating / maintaining code. I set up a couple incorrectly. How can I remove a share through the Visual Sourcesafe interface? Thanks in advance. Steve
  18. StevenK

    OpenRowset from csv/Excel file with "1,000" entries...

    I'm using sql syntax like the following: select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=C:\MyDirectory\', 'select top 1 * from MyFile.csv') This works well. Except for the case that I sometimes have numeric entries in the '.csv' file...
  19. StevenK

    Obtaining column/field names from a csv file via SQL

    To confirm what I need... Suppose I have the csv file which contains: field1,field2,field3 one,two,three four,five,six The first row clearly holds the field names - 'field1', 'field2', 'field3'. I want the SQL syntax that will return this as a result set.
  20. StevenK

    Obtaining column/field names from a csv file via SQL

    That doesn't work. I have a '.csv' file with 11 records in it. The first row containing the column/field names. When I run the stated code I get an sql result set of 10 records - with the result set field names matching those as found on the first row in the '.csv' file. And it's that first...

Part and Inventory Search

Back
Top