Search results for query: *

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?

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

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

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

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

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.