GraemeH's Q&A profile

• Visual Studio Express Editions Error message "non-generic method" using ObjectDataSource and GridView

  Here is my process: (all with visual web developer 2005 Express, April version.) 1.  create new dataset in the app_code folder, called interaction.xsd.  (right-click on the app_code directory and select new...) a.  Step through the TableAdapter Configuration Wizard. b.  Select the data connection (ManagementConnection String (Web.config) c.  Create new stored procedures d.  sql statement "SELECT Interaction.* FROM Interaction e.  new stored procedure names:  InteractionSelect_sp, InteractionInsert_sp, InteractionUpdate_sp, InteractionDelete_sp f.  Fill method: FillInteraction, Get method:  GetInteraction g.  Checked Create methods to send updates directly... h.  I now have Interac ...Show All

• SQL Server databases on SAN will not reattach @ SQL server reboot

  Hello. I have a SQL 2000 server running on server 2003. The databases are located on a lefthand networks SAN. At SQL server reboot, the databases will not automatically reattach. You can however manually attach them. Have you found anyway to automate this   Generally @ server reboot the building is unnocupied.  Do to the fact that this is connected to live traffic lights the server really cannot be restarted during normal work hours.   edit - the dependancies are already set.  I do believe that it is starting the services in order but taking into effect drive spinup and initialization...i think the SQL service is beating it to the punch....anyway to make the SQL servi ...Show All

• .NET Development Insert Image From asp.net2.0 webpage to sql database and Retrieve the image from sql database to asp.net2 webpage

  hi, I don't know how to Insert the Image From asp.net2.0 webpage to sql database and Retrieve the image from sql database to asp.net2 webpage.if any body knows answer for this please replay imm. Thnks. I wrote a tutorial on this using the Enterprise Library 2.0 Data Access Application Block , but the concepts still apply: Saving and Retrieving Images From SQL Server Using DAAB For better scalability on a website, I recommend not storing images in the database as well. I mention this in my article. Regards, Dave ...Show All

• .NET Development Deserialize Soap XML

  I was wondering if anyone could answer this question: I get a "xmlns not expected" error message when I'm trying to deserialize a XML document made using <SoapType()> metadata before the class definition. I have a compound class(one class depends on another) and I add a start element and end element to the XML doc so that it's well formed. Herein lies the issue. How can I deserialize the XML document with my code inserted start/end elements so I don't get my error message Anybody have any ideas I would be greatly appreciative for any help...Thanks!! The XmlSerializer will ignore the [Soap...] attributes, you need to use SoapReflectionImporter to generate the mappings, and then pas ...Show All

• SQL Server How to identify a database snapshot?

  Hello, Because you can not backup a database snapshot, I'm curious to as how you identify the database as a snapshot I need to add an exclusion to my backup scripts so that they don't attempt to backup a snapshot. Thanks select source_database_id from sys.databases if source_database_id is null for a database then it is not a snapshot. if it is not null, then the database is a snapshot and the source_database_id refers to the database from which the snapshot was created. Also take a look at http://msdn2.microsoft.com/en-us/library/ms178534.aspx ...Show All

• Visual Basic DataBinding Problem

  I am using VB.Net 2003 and and Access dB I have 3 tables, Parts, Serial Numbers, Batch Numbers. on my form I have added 3 different DataAdapters 1 for each table. I created a Dataset to include the 3 different Adapters. I then edited Dataset.xsd and added two relation objects from the toolbox. 1 between the Parts table and the Serial Number table and 1 between the Parts table and the Batch Number table. My Parts table has, amongst others, two fields defined as Boolean, one to mark the record as serialized and the other to mark it as Batch Tracked. Now I have my form displaying the correct information from the dataset, BUT, When I add a Checkbox and bind it to one of the boolean fields, my program gives and erro ...Show All

• Smart Device Development How to determine if phone has SMS capability?

  Hi. I am using VS2005/VB.Net and CF2 to write applications for Windows Mobile 5 Smartphones. I'm developing an application that relies on the phone having the ability to send and receive SMS message. I believe (but I could be wrong) that in some countries, and/or with some network providers, that the ability to use SMS is something that must be "turned on" by the network provider and/or setup within the phone. Therefore, I would like my application to be able to confirm that SMS is enabled and working on the phone, and if not, inform the user appropriately, rather than the user thinking that my application isn't working as intended. So, is there a way to programmatically determine if the Smartphone has the ab ...Show All

• Visual C# C# 3.0 release date

  I heard elsewhere it'll be released when .NET 3.0 is released, but that doesn't sound right. I can't find anything on Microsoft's website. When is it coming out If unknown, can you give me a range (Q2 2007, etc) Thank you much. Gabriel ...Show All

• Visual Basic Cannot perform '>=' operation on System.String and System.DateTime.

  Dear all, I have written the following code in my program : selectStr = "((ExpiryDate is not Null)and(ExpiryDate >= #" & Format(Convert.ToDateTime(_startDate), "dd MMM yyyy" ) & "#)) and " _ & "(IssueDate <= #" & Format(_endDate, "dd MMM yyyy" ) & "#) and " _ & "(TypeId= 19)" tempDataRow = dttable.Select(selectStr) Data in the dttable is as follow. ID IssueDate TypeId ExpiryDate amount 838 01/01/2006 0:00 1 0 86 09/11/2006 0:00 9 10000 86 10/11/2006 0:00 9 23456 855 01/07/2007 0:00 19 ...Show All

• .NET Development Database insert problem

  Hi! I'm attempting to insert records from a tab-delimited text file into a database. I can successfully parse the text file and get the data into a datatable. I verified this by binding the datatable to a gridview - I can see all the rows. My problem is when I try to insert those records into a SQL 2005 table. The error I get is: System.ArgumentException: Input array is longer than the number of columns in this table. My database has 36 columns. When I generate the datatable, I leave out the primary key column because such a column doesn't exist in the text file. Obviously, I'll need a primary key in the database. My goal is to insert the data via stored procedure. Does my stored procedure have to have a parameter for the primar ...Show All

• Visual Studio Team System question about the trial version of TFS

  I installed the trial version to test it for a couple of weeks and TFS is not allowing me to add domain accounts to it. Is this a limitation in the trial Not as far as I know - I didn't do anything special (other than follow the install/setup instructions to the letter). Is the TFS server running in a different domain from the users that you're trying to add If so, there need to be the appropriate trust relationships between the domains to make it work. ...Show All

• Visual C++ Decorations on C++ DLL function declarations really needed?

  I used the _stdcall decorators on the Visual C++ function definitions and declarations, but I couldn't get communication between the DLL and the Visual Basic application that was trying to call the functions of the DLL.. When I removed the declarations from the VC code almost completely (all but for the DLL_Main function definition), it worked fine.  Is there any disadvantage to using this approach   Everyone I communicated with about it , including my boss and people that answered the MIcrosoft help posting that I put up, stated that you have to use those decorations.  Why is that   It works fine without it so far.  My boss will be back from travel tommorrow.  I was hoping to find out today so I can make ...Show All

• Community Chat Using components!!

  HI!! Now am oring in a components but facing many problems while doing it.. can any1 give the example of develping the component and using it.. Lets say,, Create a component for simple encryption and dcryption!! Expecting replies!! Thanks in Advance! Vishnu V. ...Show All

• .NET Development Need help with makeing an array from data in dataset based on criteria

  Can someone tell me what is wrong with this code. I'm trying to add values to my array with data from a dataset that matches the criteria that I want. Dim actarray() As String 'Dim actarray(Me.DataSet.WorkList.Rows.Count - 1) As String Dim i As Integer Dim n As Integer For i = 0 To Me.DataSet.WorkList.Rows.Count - 1 If Me.DataSet.WorkList.Rows(i).Item("DSK") = "LK1" Then actarray(n) = Me.DataSet.WorkList.Rows(i).Item(0) n += 1 End If Next MsgBox(actarray.GetUpperBound(0).ToString) For i = 0 To (actarray.GetUpperBound(0)) Me.ListBox3.Items.Add(actarray(i)) Next MsgBox(Me.ListBox3.Items.Count) Once I get to the part inthe code were I assign t ...Show All

• Visual Studio Team System Cannot execute a Build - TF42045

  I am getting "TF42045: A build for the team project: xxx is in progress on build machine: yyy. On each build machine, only one build can be active for each team project. Use a different build machine or try again later." and I can no longer execute any builds for the Team project. I have restarted the TFSBuildService and the build server, enabled tracing on the application server, which again logs the above message and there are no alerts in the event viewer. Can anyone suggest where I can look for this phantom build that is running I have also called the DeleteBuild web method in the BuildController to clean up previous build it that makes any difference. thanks in advance. Tha ...Show All