sql server2000's Q&A profile

• Visual C++ How to use a dll?

  I have a small dll with a header file that reads as follows: #ifndef QUERY_DB_H #define QUERY_DB_H #include <string> int query_db(int argc, std::string argv); #endif To test it i add the header and the dll to a console project as existing items and put them in the same folder. Then call it as follows: #include "query_db.h" int main(int argc, char *argv[]) { int z = 0; query_db(2, "test.txt); return z; } When I try to build, I get a linker error that the project cannot see that I have already implemented query_db main.obj : error LNK2019: unresolved external symbol "int __cdecl query_db(int,class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >)" ( query_db@@YAHHV $basic_string@DU ...Show All

• Windows Forms Reading ONE string from a CERTAIN LINE in a file

  How would I go about reading a certain line of text from a file I already know I can do ReadAllText() but I don't want to read everything... <=====================> TEXT FILE <======================> Line 1: Test Line 2: Test 2 <=====================> END TEXT <======================> Now how would I read JUST line 2 from the text file There isn't a ReadLine(Path, Line#) or anything. Thanks for any help on this. Files aren't random access by line. You must either read the whole thing in and use an object that can deal with it in terms of lines, or work your way through it to find the data you need. Sounds like the last option is what you are interested in, so here's a simple implementation: public string ...Show All

• Visual C++ DLLMain defined in .obj file?

  Does anyone know if when you use the wizard to create a dll in visual c++, it puts the definition of DLL_Main in the Project_Name.obj file I get an error when I add in a definition of it in the cpp file, saying its already defined in the obj file. It's not in the cpp file when I first create the workspace. Ah, the return of the summer function This is a MFC DLL. It does not need DllMain, DllMain is provided by MFC. And you say that you can call summer from VB !! I have no idea how come that it works. summer function here is a member of a class and for various reasons (calling convention is thiscall and not stdcall or cdecl and the name of the function is decorated) you cannot call this (easily) from any other language than C++ ...Show All

• Visual Studio 2008 (Pre-release) how to get the values back from DataGridView

  I need to add new rows to a databound DataGridView and get back the contents from the datagridview and update back to DB DataGridView is part of Windows Forms, not WPF/Avalon. Try posting your question in the " Windows Forms Data Controls and Databinding " forum -- http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=7&SiteID=1 ...Show All

• Visual Basic listbox not saving...

  hi, i'm trying to write a program with a listbox and trying to save it using streamwriter and i cannot get it to work.here is the code:Dim saveFileDialog1 As New SaveFileDialog saveFileDialog1.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*" saveFileDialog1.FilterIndex = 2 saveFileDialog1.RestoreDirectory = True If Me.savefiledialog1.ShowDialog = Windows.Forms.DialogResult.OK Then Dim grocerySW As New IO.StreamWriter(saveFileDialog1.FileName) For Each i As Object In Me.groceryListBox.Items grocerysw.WriteLine(i.ToString) Next End Iffirst of all, when i run the program, and try to save it, if i type in a new filename, i get an error saying the file cannot be found. how can i correct this ...Show All

• SQL Server LastPeriods

  Hello, I am trying to retrieve the last 3 periods from the current month (ie Sept, Oct, Nov). I am thinking that LastPeriods function might work, but I am getting the following Error " The LASTPERIODS function expects a member expression for the 0 argument. A tuple set expression was used. " Here's the code. SELECT { LASTPERIODS (3, TAIL ( nonempty ([Week].[Week].[Week Name]. Members )) ) } ON COLUMNS FROM [GMDSummary] Maybe something like that SELECT { LASTPERIODS (3, TAIL ( nonempty ([Week].[Week].[Week Name]. Members )).Item(0).Item(0) ) } ON COLUMNS FROM [GMDSummary] ...Show All

• SQL Server Cannot create new or change existing subscriptions

  We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says Only members of sysadmin role are allowed to update or delete jobs owned by a different login When trying to create a new subscription the report manager displays "An internal error occured" and the log says System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin. We are running sql reporting services 2005 sp1. The report server database s ...Show All

• Visual C++ Where can I get a sample server-client programs?I want to get a sample program to study .If you some expert have one ,please giv

  Where can I get a sample server-client programs I want to get a sample program to study .If you some expert have one ,please give it to me. I appreciate your help. Check out some of the Starter Kits for Visual Studio 2005 . ...Show All

• Visual Basic read binary data stream from com port, write to file between certain characters

  I am new to using vb.net with binary and com ports and have a project where I need to monitor com5 for a binary data stream that I will receive every 5 minutes from a sensor. The data stream starts with "cs" and ends with "end" and I want to simply save the binary data that falls between these characters as a file with a ".000" extension. The "cs" and the "end" cannot be in the resulting file. I wasn't sure about removing "cs" and "end" since the data is in binary. Do I need to convert the entire binary stream to ascii and test for the "cs" and "end" then convert back to binary before saving Does anyone have a code snippet or suggestion on how I sh ...Show All

• Visual Studio Express Editions XML DataSet

  Hi Everyone, I have just finished watching a few videos that a friend sent me about VS.Net (not 2005) and I found them informative but I can't seem to get the final XML file into a DataSet. I have written a Schema and got that into my XML file (which is nice) but I now want to use one of the elements in a combobox and put the other info into two textbox's So my XML node have: < aaa > < aa > < value > a </ value > < meaning > meaning1 </ meaning > </ aa > < aa > < value > b </ value > < meaning > meaning2 </ meaning > </ aa > </ aaa > So in the video it said just select "Create DataSet" but I can't find i ...Show All

• Visual Studio Team System Ideas For Generation of UnitTests

  <My .02>One of my biggest problems with the right click create UnitTests on an area of functionality is that it throws all of the unit tests into this unmanageable collection of Tests not associated with a list. I think a great feature would be to have an ability to have the new tests automatically assigned to lists. By class name seems to be a good method though there are ltos of possibilities. Also If your Devel staff is wise enough to break their classes up into regions of code based on functionality (Mine does it by C.R.U.D.) then break them up into sub lists according to those as well or atleast an option to. </My .02> ...Show All

• Visual C# Generics class and abstract class

  Hi, I'm currently converting a project to use generic classes. In the situation described below, I don't know whether I should keep an abstract class or not. Before using generic types, there're an AbstractElement class, and two derived classes - Element16 and Element32. There's a DataList class, which has an ArrayList to store AbstractElement object. Now I use a generic type Element<T>, where T can be uint or ushort, to replace Element16 and Element32. But I don't know how to modify the DataList class to use Element<T>. I don't want to make DataList a generic type, since the users of DataList don't know whether the Element objects in DataList are Element<ushort> or Element<uint>. Should I keep the Abstract ...Show All

• Visual C# finding file size

  hi I need to know the size of the file which I am going to read with a stream. but I can not find any way to have the size of the file. regards you can use the FileInfo Class to get the file size. the length property return the size of the file.   FileInfo f = new FileInfo("File Path"); f.Length <- return the size of the file. ...Show All

• Visual Studio Team System Migration, common code- Sync between VSS and TFS?

  Are any new tools available that would help with the migration period from VSS to TFS. We want to move product teams over one at a time, but they rely on common code that spans teams. So we want have VSS changes sync'd with TFS so that the team migrating to TFS can work on TFS and teams still using VSS can continue to do that. Are there other ways people are dealing with common code during a migration Thanks Hello, The Migration and Synchronization Toolkit that we are currently developing will facilitate the development of a tool to sync files between TFS and another source control system (i.e. VSS). You can check out the TFS Migration blog for more info: http://blogs.msdn.com/tfs_migrati ...Show All

• Windows Forms flipping tabpages programmatically

  This is what I want to do: when I click a button on tabPage1 I want the tabControl flip and show tabPage6. I've treid numerous tricks--none worked. In the button Click event I have: this.tabPage6.Focus (); SendKeys.Send ("{ENTER}"); this.tabPage6.Show (); No effect. I've tried MouseEventArgs, MouseDown, MouseClick for tabPage6 but none of them even fired. Thanks for help. "Correct command is: tabControl1.SelectedTab = tabPage6;" Yep. It worked. Thank you, Markku. ...Show All