Simon Jefferies's Q&A profile

• .NET Development Acces Database

  Hi,   I'm trying to add some variables to an access database that has one table with three columns. The code doesn't produce any errors but when I open the database file there is no data. Here's my code "data" as an instance of a dataset called RDXInfoDataSet   data.Table1.AddTable1Row(type, extn, linetype) data.Table1.AcceptChanges() data.AcceptChanges()   Any ideas why it's not working I had - but I didn't read it properly... I only read the part about AcceptChanges, which didn't apply to me as I wasn't using it. I missed the part about copying the MDB file... That was it! ...Show All

• Visual Studio Tools for Office run word document

  hi i have this situatiom i have saved a word document in the db as binary ,then i retreive it and everything is ok but in order to run it i must first save in to a location and then run it what i want is thati want to run without saving it to a location after the reader reads it i want to run it this is the code i use to get the file Dim da As New SqlDataAdapter _ ("Select * From a where id1=532", con) Dim MyCB As SqlCommandBuilder = New SqlCommandBuilder(da) Dim ds As New DataSet con.Open() da.Fill(ds, "a") Dim myRow As DataRow myRow = ds.Tables("a").Rows(0) Dim MyData() As Byte MyData = myRow("f") Dim K As Long ...Show All

• SQL Server BCP Interactive - from script

  I have a script where I'm doing a bcp out - I need to have the script do the format file on export. Is there a way to run bcp interactively from script, accepting the defaults THat way it will make a format file for me. yes, you can bcp in without a format file. We've never ever had to use a format file when bcp'ing in or out. Of course our datatypes always matched, and we always use -n, but I'm sure -c works as well. ...Show All

• Visual Studio Express Editions tetx box problems

  ok im trying to get a list to appear in a text box when i use a dropdownbox. i want it to look something like: E01-00 = AC Power Failure E02-00 = System Low Battery and so on. If Me .ComboBox1.Text.Contains( "RP-3" ) And Me .ComboBox2.Text.Contains( "Error Codes" ) Then Me .RichTextBox1.Text = ( "E01-00 = AC Power Failure" And "E02-00 = System Low Battery" ) End If I think im missing something here. If Me .ComboBox1.Text.Contains( "RP-3" ) And Me .ComboBox2.Text.Contains( "Error Codes" ) Then Me .RichTextBox1.Text = ( "E01-00 = AC Power Failure" ) Me .RichTextBox1.Text = ...Show All

• SQL Server Failed to Initialize CLR Errors

  This was running fine for two months and yestday we had to do a reboot. We then tried to execute some of our CLR functions and are now getting the below error What can I do to check that all is ok Msg 6511, Level 16, State 82, Line 2 Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x8007000e. You may fix the problem and try again later. I am having a similar problem, but is actually with not manage code it is instead with procedure. I tried to post this message before, but it was deleted by the moderator for having a duplicate post. during search I could not find any duplicate post that was related to store procedure. I don't know where Mr. moderator found the ...Show All

• Visual Studio Express Editions Audio Play button from string

  Hello over there.. Newb over here.. I'm trying to get a push button to do a 'play' function using the source audio location as a String from a Textbox.. Everything looking good but I can't get the play button to accept the passdown of the String sound location. All help/critique is good. Many thanks. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles P1.Click Dim TempMedia As New System.Media.SoundPlayer( New stream(TextBox1 As String ) TempMedia.Play()) End Sub **Expected Comma, ')' or a valid expression. Nevermind.. Solved! Private Sub Button1_Click( ByVal sender As System.Object, ByVal e A ...Show All

• Visual Basic Looping

  How do I setup a for next loop array to open files if I don`t know how many files are in the folder davco wrote: Now I am getting"Index was outside the bounds of the array" Here are some array checks you can do before setting the image: If files.Length = 0 Then MessageBox.Show( "No pictures found" ) End If If selectedIndex < files.GetLowerBound(0) Or selectedIndex > files.GetUpperBound(0) Then MessageBox.Show( "Invalid selection" ) End If Andrej ...Show All

• SQL Server Problem connecting to external SQL Server

  Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server to connect to this external SQL DB... How easy! Well not for me .. This is the error Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I know its my VPS causing the problem, as I asked a friend to see if he could connect to it via his server and the forum worked straight o ...Show All

• SQL Server SQL JOB Never completes if more than one step is added

  I need to add a SQL Job the deletes three tables in two diffrent databases I set up the steps as follows Step 1 delete table in Dynamics database go too step two Step 2 delete table in tempdb database go too step three Step 3 delete table in tempdb database finish and report success to log simple at best, but when job runs it never completes the first step and just sits there running. All three steps work perfect if in diffrent jobs and this works if run from query window with "go" between each delete statment also works if I but all three in one step with a "go" and do a database change for the one table. what am i missing in this very simple task     CHeck whether users are connected to Dyna ...Show All

• Visual Studio Team System FxCop 1.35: DoNotExposeGenericLists false negative?

  Consider the example below.  FxCop fires a DoNotExposeGenericLists warning for method GetFooCollection, which returns a FooCollection derived from List<T>. Should it not fire the same warning on the FooCollection declaration, i.e. if a publicly visible class derives from List<T> Especially since the fix is to modify FooCollection (derive from Collection<T> instead of List<T>). // No Fxcop warning here public sealed class FooCollection : List<Foo> {    ... implementation ... } ... public class MyClass {    // Fxcop warning DoNotExposeGenericLists here     public FooCollection GetFooCollection()     {         ...Show All

• Visual C++ MS Visual Studio 2005 - VC++ - pausing output to screen

  I am working on an assignment for my C++ class and have hit a snag, I hope someone here will be able to help me with this. The program is a Mortgage Calculator, which I have working for the most part. However, I am supposed to display the information for each payment over the term of the loan. I also need to pause the screen after so much information is displayed and wait for the user to press any key before the screen continues. My question is: How do I pause the screen after so many lines of code are displayed This is what I have tried before, but is did not work at all. bool anyKey = false ; if ((i+1) % 12 == 0) { getch(); cout << "Press any key to continue " ; cin >> any ...Show All

• Windows Forms Rich Text box and Table(Visual C# 2005)

  Hey, is it possible to make the Rich Textbox Control have a table inserted into it Like the way MS Word does Thanks :) But there is no way to code it into it As a feature in the program unless you customly made your own richtextbox control Thanks :) ...Show All

• Smart Device Development Pointer to Bitmap object in CF v1.1

  I have a dll to which I need to pass in a pointer to the first byte of a bitmap object. In CF v2.0, I can just use the BitmapData.Scan0 method. However, this does not exist in v1.1. I have looked at the bitmap formats but am struggling to work this out. The bitmap file already exists on the device. I simply need to pass a pointer to it (as an IntPtr) to the third party dll. The bitmap file has to be an 8 bit format. Can anyone advise me on this please Thanks. ...Show All

• SharePoint Products and Technologies WSS3 Search Engine not working

  When i try to search with Sharepoint Version3, I get the following error. The site http://ynd01-svr-015/documentation/ could not be found in the Web application SPWebApplication Name=SharePoint Parent=SPWebService Is this a common problem whould love to have the step by step to tell me how to fix this. Can anyone help me my boss is asking for this. Thanks a lot I believe a colleague of mine Kurt might be able to provide the answers you're looking for, check out his two blog postings about SharePoint search errors: http://home.infusionblogs.com/kguenther/Lists/Posts/Post.aspx ID=35 http://home.infusionblogs.com/kguenther/Lists/Posts/Post.aspx ID=321 ...Show All

• Visual Basic Reusing Forms

  Greetings I am converting a VB6 program containing multiple forms into a 2005.net VB program. In the old VB6 program I use a modal form and then I want to re-use the same form but but change some of the labels and make visible a control that was invisible the first time around. In the VB 6 version I was in, say, Form1 and executed the following code: Unload Form1 Form1.Show 1 This re-did the Load event and I used a counter to customize the form in its second life. Is there any way to do this simply in VS2005 VB Thanks for your reply. I'm not well versed in the Studio 2005 context. I'm not sure what you mean by "Applications.OpenForms" but I will try to get a reference to it in Hel ...Show All