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: *

  • Users: Kai77
  • Order by date
  1. Kai77

    Acces object properties using reflection

    I have the following class: namespace GPR.ODS.App.MSO.WebApp.Data { public partial class MutatieResponse { private MutatieStatus mutatieStatusField; private ApplicatieFout applicatieFoutField; ///// <remarks/> public MutatieStatus MutatieStatus {...
  2. Kai77

    Show property value in a repeater

    I have the following strucure: public struct AvailableSkillDetails { public int ID; public int CDT_ID; public int SKI_ID; public bool DIPLOMA; public DateTime DIPLOMA_DATE; public string DESCRIPTION; } I put several of these objects...
  3. Kai77

    Upload file content to SQL Server 2005 from ASP.Net

    I want to upload a file from a webpage and store the file in a binary field (image) of a record in SQL 2005 Server. What data type do i need to use to upload the file content?
  4. Kai77

    Add record with a binary field with C#

    I want to upload a file from a webpage and store the file in a binary field of a record in SQL 2005 Server. What data type do i need to use to upload the file content?
  5. Kai77

    Dynamic where clause

    check out this posting: http://www.experts-exchange.com/Databases/Q_21937504.html#17215276 still need to check out the solutions provided by hmckillop
  6. Kai77

    Dynamic where clause

    Hi, I wrote the following stored procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= Alter...
  7. Kai77

    Show missing records

    u tha man atomic!
  8. Kai77

    Show missing records

    Hi, I have a table "Users" with a primary key usr_userid. I made a view table called "AllUsers" which includes the table "Users" and a couple of other tables with the use of joins. When I do a count on Users, it returns 939 record. And the view returns 933. So I would like to create a view...
  9. Kai77

    Not getting all records of a MS SQL Server

    I am trying to retrieve all the records of a table in MS SQL Server, it has over 120.000 records. But when I do a "Select *" statement it only returns 43093. When I enter this in the Query Analyzer it does return all the 120.000 records. How can I solve this problem?
  10. Kai77

    Need help with a query

    Hi, I have a table which stores the answer of a survey question of a user (multiple choice). Now I am using this statement to read the number of each answer that was given for a question for ALL users: SELECT TOP 100 PERCENT dbo.surveyresults_answers.ans_quid AS QuestionId...
  11. Kai77

    SQL performance issue

    No, the testing database does not even come close to the production database. I will make a copy of the production database and test it locally on Monday. Thanks for your insights. Enjoy your weekend!
  12. Kai77

    SQL performance issue

    Profiler show about 12-16 rows in total when accessing a page. All of them just runs the stored procedure and resets the connection immediately afterwards. But I ran profiler locally in my own testing environment, it's the online webapp that has the problem. The hosting provider told me that the...
  13. Kai77

    SQL performance issue

    I made a survey webapp using Asp.Net. The answers given by a user are stored in a table called "survey_results". About 10 stored procedures are called each time a page of the survey is viewed. The stored procedures are simply a query (e.g.: select * from survey_results where questionid = '1'...
  14. Kai77

    Add items to dropdownlist

    k thanks!
  15. Kai77

    Add items to dropdownlist

    it works, but isnt there a more efficient way to do this, where i do not have to declare a new listitem?
  16. Kai77

    Add items to dropdownlist

    I want to add items (text/value pair) to a dropdownlist. How come I only get items which are all the same (all items have the same text/value as the last item that is being added)? My code: Dim ddlItem As New ListItem ddlItem.Text = "April 2005" ddlItem.Value = "April"...
  17. Kai77

    XSL - check if child node exists

    I have the following XML document: <?xml version="1.0" encoding="utf-8" ?> - <navigation> <chapterlevel_1 title="Homepage" level="1" id="1747" active="1" breadcrumbmember="1" /> <chapterlevel_1 title="Profiel" level="1" id="1749" active="0" breadcrumbmember="0" /> - <chapterlevel_1...
    • Kai77
    • Thread
    • Replies: 2
    • Forum: XML
  18. Kai77

    Add css class attribute to a checkbox control

    I am trying to assign a CSS class named "checkbox" to my checkbox. I have tried both the .Attribute.Add and the .Attribute.AddAtributes methods. But I keep getting this: <span class="checkbox"><input id="_ctl17_cbBrochure" type="checkbox" name="_ctl17:cbBrochure" checked="checked" /></span> It...
  19. Kai77

    Store decimal datatypes in SQL with VB.Net webapp

    Yes, i know hardcoding would work, I am guessing that a decimal in VB.net is not the same as decimal in MS SQL. If you were to use Dim MyCommand As New SqlCommand MyCommand.Parameters.Add("@dec_responsedecvalue", SqlDbType.Decimal, 9).Value = cdec(4999.99) You would see my problem...
  20. Kai77

    Store decimal datatypes in SQL with VB.Net webapp

    In the function you can see: .Parameters.Add("@dec_responsedecvalue", SqlDbType.Decimal, 9).Value = obj_nbo_AnswersDetails.dec_Responsedecvalue where obj_nbo_AnswersDetails.dec_Responsedecvalue is basically decValue.

Part and Inventory Search

Back
Top