Christian N's Q&A profile

• SQL Server Advice on SQL Server 2005 vs. Express Edition w/ Advanced Services

  I've been using SQL Server 2005 Std. for my development work on a laptop w/ 2 GHz Celeron and 768 Mb RAM. Now that Express Edition has Reporting Services and Full-Text Search, would I be wise to just use it instead I actually have both on my machine since Express Edition installed with VS 2005 Standard. Also, if I uninstall SQL Server 2005 Std. what will I lose Thanks in advance. -Mike It depends what you want to do. SQL Express Advanced Services is not the same as Std, Std has more features (OLAP, Integration Services) richer features (better SSMS, better reporting including report builder) it also has ...Show All

• Visual Studio Tools for Office Excel Question

  Hi,    can anyone tell me how to copy a sheet from workbook a to workbook b please   thanks, Ed. For questions unrelated to VSTO, but related to Excel's object model, please post this on one of the Excel specific forums, like http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US Thanks   ...Show All

• Visual C# Database Question

  Hell All, I am creating a program that will be used by about 20 people or so. It is a test case managment system, what I want to do is have everyone connect to a central database on a server somewhere on the network and be able to edit , update, create, save test cases. What I am unsure of is, do I need to write software on the database server to handle transaction, etc, or can i just connect to the database from the program on the users desktops, and load the data both ways from there. I am new to database programming. Also is there a way to write generic database commands, so any database, like MySQL, PostgreSQL, Oracle can be used on the ...Show All

• Visual Studio Express Editions Bug or problem?

  Dim song As String = tags.artist & " - " & tags.song When setting a text box to song it only appears with the tags.artist. When debugging i have found that first of all it sets the song to "tags.artist but it misses out the ending ". Is this a bug with vb and if so can it be fixed or is it something i have done wrong Gamesplant In response to your request for code - it doesn't need much at all. Define a structure to hold the information (or you could use a class) Public Structure ID3Tag <VBFixedString(3)> Public Header As String <VBFixedString(30)> ...Show All

• SQL Server How to configure data source/Oledb-ado connections from outside the package?

  Hi All, Another requirement has cropped up with regard to picking up connection settings for data sources from an external File. My source and target are both in SQL Server. What i need is that if my source or target changes I should just change my external file and same should reflect in my package. How can I accomplish it Please suggest some solution. Thanks in advance. Regards, Aman Anand Thanks for the reply Thiru. I saw your message just now. But, you confirmed what I tried sometime back in my Package before seeing your reply. Anyway thanks again. Regards, Aman ...Show All

• Visual Basic treeview question

  i have here a treeview control wherein it contains a root node named "Receptions", it has a child node named "Orders".Orders has a child node also named "Records"..I have also a panel named panelTransaction...I want to show the panelTransaction when i clicked the Records node..can someone please show me how thanks... You can call panelTransaction.Hide() to hide the panel and panelTransaction.Show() to show the panel. To detect that a node in the TreeView has been selected you can handle the AfterSelect event for the TreeView control. Inside the event handler there are a couple of ways you can fig ...Show All

• SQL Server SQL help request

  Hello.  I have two tables connected by a one-to-many inner join.  The second table only has one field that i need.  Take by example it is a status table. Items Table                              Status table id-------------------------/--   item_id name                                 \      status price                   &nbs ...Show All

• .NET Development How to extract substrings from a string?

  For example, I have a string str = "Jun; James; Jun-Jun; Kim" ; How can I get this output Jun James Jun-Jun Kim Please help. It's confusing. string str = "Jun; James; Jun-Jun; Kim" ; string [] substrings = str.Split( ';' ); /// Splits the string on the ';' character. foreach ( string s in substrings) { Console .WriteLine(s.Trim()); /// .Trim() removes whitespace from beginning and end of string } ...Show All

• Visual C++ Can symbols from an .exe file be imported into a DLL?

  I would like to create an executable which uses multiple DLLs. I want to load the DLL's manually depending on execution. There is common code which resides in the .exe, which I would like to use in the DLLs. When I try and compile the DLLs I get unresolved symbol errors during the link. Is there a way for me to share the common code, residing in the .exe, with the DLLs Thanks. Omar Canon You could pass a function pointer to the DLL but that's kinda nasty. There shouldn't be a reason why this common code couldn't live a DLL, what kind of linker errors are you getting ...Show All

• Visual Studio How to support INSERT SNIPPET?

  Hi,everyone, There is a good function that user can insert snippet In C# project. I also want to implement that for my own language by VSIP. Is there any one who could give me some good advices Thanks very much. Best regards. 1. It is provided by the Microsoft.VisualStudio.Package.Source class in the Microsoft.VisualStudio.Package.LanguageService.dll. 2. My response is predicated on the assumption you are using managed code.  If you cannot use Microsoft.VisualStudio.Package.LanguageService.dll then you will have to implement IVsExpansionProvider yourself. 3. The snippet template editing is provided by the core text ed ...Show All

• Windows Forms How can I change data source of crystal report at run time?

  How can I change data source of crystal report at run time I want to use SQL statement to change data source of report. Hi, i got into this problem too. Before seeing this post, i posted a similar question in the 'Design Time Support' form. Any solution ...Show All

• Visual C++ Problem in MFC AppWizard(exe)

  my code is like this: void CRrDlg::OnGetText() { CString kk; int f; CRrDlg* pEdit=(CRrDlg*)GetDlgItem(IDC_EDIT7); { f=22; kk=f; pEdit->SetWindowText(kk); } } I cant show 22 as output and i don't want to use kk.Format() to display. Is there any way to put variable f as variable kk how to convert int to a char string And, how to use SetDlgItemInt I can't use Format because everytime i use it,it will overwrite the previous data. ...Show All

• .NET Development Getting Data back out of an XML file

  hi i use the following to get some info out of an xml file: dim mycountries=new DataSet mycountries.ReadXml(Server.MapPath("/aspcomm/xml/countries.xml")) ddcountries.DataSource=mycountries ddcountries.DataValueField="value" ddcountries.DataTextField="text" ddcountries.DataBind() the xml file has the following in it: < xml version="1.0" encoding="ISO-8859-1" > <countries> <country> <text>United Knigdom</text> <value>UK</value> </country> <country> <text>Europe</text> <value>EU</value> </country ...Show All

• Visual Studio Team System "Auto" alerts is possible?

  It is possible to make the alert "my workitems are changed by others" an automatic alert By automatic I mean that everyone is subcribed to this alert by default or there is any way to subcribe users on their behalf (So I can go in an subcribe each one to this alert) Bottom line: I want that no mather what if some one assign a workitem to another team member, the other party gets notified by default. Thanks This can't be done with our UI but could probably be scripted with the TFSSubscribe utility. Brian ...Show All

• Windows Forms Searching for my parent class help!...

  I have a dialog box and my UserControl sets like this: Parent hierarchy Form (class ToolsOptions : Form) | TableLayoutPanel1 | TableLayoutPanel2 - Panel - UserControl What I want to accomplish is get the Class ToolsOptions. I successfully did it this way, but is there a faster way then using the String to compare. Like checking to see if the classes match like you can in C++ MyUserControl: private void OptionsEnvGeneral_Load(object sender, EventArgs e) { Type type; Control objA; objA = this.Parent; do { type = objA.GetType(); if (type.FullName.Contains("ToolsOptions&qu ...Show All