Neil Harper's Q&A profile

• .NET Development asp.net 2 assign queryresultset to array

  I have a query that returns all values from one field for the req_id specified I need to put the result into an array so that I can then assign individual values to textboxes. There will never be more than 8 values. Tried using dbreader but that would only take one value from field. I see, this line dbReader2.Read() reads the first value then the while loop takes over and reads the rest. I initalised the datareader to soon. While dbReader2.Read Request(index) = CStr(dbReader2("request").ToString()) index += 1 End While Thanks for your help, all values now getting displayed. ...Show All

• Visual Studio Tools for Office Disappearing Document ActionTask Panes with Word

  I've been working on a fairly complex Word VSTO application which is about complete, except for some intermitent strange behavior which happens after a document has been saved. When reopening the document ( either the saved one or starting the new one via the application word template) one of two things may happen. 1) the document action pane begins to display and then closes , leaving only the getting started task pane. it is not listed as a disabled application, logging off and back on will fix the problem as if it had been black listed 2) The Document Actions pane stays open, but the two actions pane controls which should be there are not visible, despite code (msgbox(me.ActionsPane.Controls(1).Visible) claiming the control IS ...Show All

• .NET Development Creating Image File: Parameter is not valid.

  Hi everybody, I am creating an image(jpeg) file from stored bytes[] in sql database, Varbinary datatype, (I used Image datatype also same result), I am using this jpeg image file to set to a Image web control, what seems the problem and how to fix this problem Do I have proper datatype in sql to store converted jpeg file data Please provide codes. Thanks. [code] string sqlText = "Select * From PictureImages Where ImageName = @ImgName"; SqlCommand cmd = new SqlCommand(sqlText, conn); cmd.Parameters.Add("@ImgName", SqlDbType.VarChar, 20, "ImageName").Value = txtImgName.Text.Trim(); if (conn.State == ConnectionState.Closed) conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); string filePath = Request.PhysicalApplicationPath + ...Show All

• Windows Forms Memory Usage Guidelines

  I developed an app in VS2005 and am wondering if there are any guidelines available for how much memory is safe to consume per hardware specifications. For instance, how to determine minimum hardware requirements for an application Thanks, cj ...Show All

• SQL Server T-SQL Reporting

  is there anyway to run complex reports using T-SQL including variables and cursors and such Why don't you just put it in a stored procedure, schedule it, dump it to a table, then use reporting services to just select * from the table and display it tabular so they can then export it to excel or something from the web ...Show All

• .NET Development connection and fucntions

  heya al- just wanted to find out about linking databases to web page. Ive used a ole database connector with a page I want to display the data in a script part however when i take out the database connection and put it into another aspx file and call the aspx file in the page i want it in- it comes up with errors such as variables not initialised etc. e.g. heres my database connection: <script runat="server"> Sub Page_Load() Dim dbconn, sql, dbcomm, dbread dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("linkdb.mdb")) dbconn.Open() End Sub </script> And heres the fucntion i want to perform in a different web form: <script runat=&qu ...Show All

• .NET Development DataAdapters - Please help Im confused

  Hi Ill try to make this as simple as possible but bear with me please. Its probably very easy when you know how!! Brief overview, I only wish to populate my appointment datatable with the apontments where activity.assignedto = a drop down selection. Tables Activity Appointments ------------------------------------------- Id (PK) -----1--| Id (PK Auto increment) AssignedTo |--m----- ActivityId StartTime Etc When you drop a table onto a dataset designer it creates a new table with a tableadapter that selects * from the table. You can add new queries to the tableadapter and it will automatically create the delete/insert/upda ...Show All

• Visual C# removing program from startup

  how can I remove programs from my startup menu I don't want them to run when i start windows. that would remove all items from the startup list...which is not what you want and may have some consiquences. You should look for the specific item you are after and remove it otherwise the user won't be happy in the removement of the startup items ...Show All

• Visual Studio 2008 (Pre-release) June CTP Problem

  Hi iam having a problem with the June CTP.... i have created a Tabcontrol which had a Listbox inside it, I changed its margin property as "-200,0,0,0" ...   in Beta 2   the portion of the Listbox outside the tabcontrol was visible... But in June CTP it is not ... am i missing out some thing....need help regarding this... <TabControl Margin="93,26,99,1" x:Name="TabControl" IsSynchronizedWithCurrentItem="True">    <TabItem Margin="10,-2,-2,-1" Width="80" Height="42" x:Name="TabItem" Header="TabItem">     <ListBox Margin="-200,0,0,0" Width="323" Height="41" x:Name="ListBox" IsSynchronizedWithCurrentItem="True"/>    </TabItem>   & ...Show All

• Visual Studio Express Editions Problem with absolute positioning controls on Masterpages?

  OK -- I'm a newbie to VWB EE so please forgive if this is a known prob, but I've been just getting into creating web forms and using masterpages and already come across a problem. When I layout my form in design mode and position my controls absolutely they look absolutely fine. :P But when I display them in the browser in "run time" they are shifted over to the left. I think this is because my master page has a left-hand nav area (via a table) and the absolute positioning somehow doesn't take that into consideration. It is really more of an "absolute within the contentholder" as opposed to an "absolute within the page". What am I doing wrong Should I be looking at this differently when using masterpages ...Show All

• SQL Server Like operator

  Hi, Can you just tell me how to use LIKE Operator(Syntax) please.I am new to SSRS2005. Hi Adam, I am getting some value from query.I want to use LIKE operator in layout and check the value. For example I am getting Email address from query.I want to validate '@' exisists or not. Thanks Adam. ...Show All

• SQL Server How to print labels like label 1 of 1 and label 2 of 3....

  I have a report that will be a label and I need to print N number of labels depending on a certain number returned from the query. Let's say that number returned is 3. So, on my first label I want to print 1 of 1 and on the second label, 2 of 3 and the third, 3 of 3. All other information on the label will be the same for all 3 labels. All information used is from the query. One of the fields accessed through the query holds the number I need to use to do this. Is there a way to do that through the report designer using vs.net Is there a setting for this or is it a SQL thing I need to put in the query some how. Or am I completely off track Any help would be greatly apprciated. thanks Sorry but I ...Show All

• Visual Studio Express Editions about sqlconnection?

  hi gud day ppol.... i have a problem regarding sqlconnection for example dim theConnectionString as new sqlclient.sqlconnection(" what's NEXT "no idea"") thx in advance... sorry for stupid question So u mean is i should input the corresponding connectionstrings depends on my database for example MSAccess OLE DB, OleDbConnection (.NET) " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = C:\mydatabase.mdb ; UserId = admin ; Password = ;" ...Show All

• Visual Studio Team System "Auxiliary Tables" for Easy Administration of Field Values

  In our current Change/Defect Management system we have the concept of "Auxiliary Tables" that have easy administration access and are used for dynamic data in a form's dropdown lists. For example we use them to store "Project ID Numbers" from our time tracking tool. These data get added and archived on a daily basis by non-technical people as projects come and go. Does Team Foundation have a similar concept Basically a place where people can easily administer data that is used in a work item form. I can see how we can export/import the work item xml schema and add values there, but we need a place where non-technical people can easily enter data. Team Foundation does not come with anything built-in to accept ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I restructure the default directories to allow for easy distribution?

  First off, let me just say "good job, well done" to the people responsible for getting XNA up and running. It's incredibly easy to get a project started and working with MSVC# 2005 express, however, I think the directory structure could be improved to allow easy distribution of files. The way I see it a project consists of three types of files, and at the moment the default behaviour of MSVC# is to mix them up, making it difficult for hobbyists to work and share with other hobbyists and the XNA community. If the directory structure was changed slightly, then it would allow bulk copying a viable distribution solution. The three types of files are... Source Files: These are the files that are required to build the project, they inc ...Show All