Recent content by Kai77

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 {...

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

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?

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?

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

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

u tha man atomic!

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

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?

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

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!

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

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'...

k thanks!

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