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

...@SQL nvarchar(4000), @PageIndex INT, @NumRows INT, @VacancyCount INT OUTPUT AS BEGIN SELECT @VacancyCount = (SELECT COUNT(*) FROM VW_VACANCYMODULE_ACTIVE_VACANCIES WHERE @SQL) Declare @StartRowIndex INT; Set @StartRowIndex = (@PageIndex * @NumRows) + 1; WITH VacancyEntries AS (...

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

...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' and subquestionid='2') returning a couple of rows (1 to 5). The webapp has been running for 2 months now and...

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.