dangster_gangster's Q&A profile

• SQL Server Data types in SQL Server

  Hi, Can someone please tell me what are all the data types in MS SQL Server 2005 Express used for I have only used Access before and the data types in Access are - DATA TYPE    INFORMATION STORED Autonumber - A number that is assigned automatically and never changes thereafter. Currency   - Amount in the currency format chosen. Date/Time  - Date and Time. The Format property chosen on the general tab to date alone or time alone or both in different formats. Hyperlink  - Hyperlink addresses. Lookup     - Values that come from another table, a query, or a list of values that ...Show All

• Visual Studio Express Editions Which option to select?

     I'm thinking of getting started in Visual Studio because i want to know how to make programs and aplications.     I've got some knowledge about c and basic but i dont know which language chose now. Could you please tell me what are advantages of Visual c++, c#, basic and advantages betwen Express and Standard versions  What do you suggest     When sing the .net framework to develop applications it is basicly the same and the language is only a matter of choice. When you compile the code the end product looks and runs the same. As for the differences between the standard and enterpr ...Show All

• Visual Studio Future Local Report functionality

  The local report processor is a great tool to use to provide clients with reports.  I have been integrating this control into our reporting system and it has been very successful. I do have a question though.  Does anyone know yet what improvements or new features that might be added to the local report processor in future releases   The two features that I miss out on the most are the ability to export reports in HTML and being able to include custom report item processing. Ocassionally I see mention from Rajeev or Brian that "feature x" has been requested a lot and now Microsoft is looking into putting that into a futu ...Show All

• Windows Forms RootComponentDesigner Add component

  Hi,     I noticed when you add an SqlDataAdapter from the toolbox to a component design surface it calls the wizard.     I can't reproduce this using code. I'm using the following in a Designer:     Note the Configure wizard is only called when my code explicitelly launches the designer verb, but in this way the SqlAdapter's commands don't get assigned unique names (ie they are named sqlSelectCommand instead of sqlSelectCommand1, and adding another adapter to the same component throws an exception since there's already an "sqlSelectCommand" in the root component).    Shouldn't the wizard ...Show All

• .NET Development 3Month and still baffled. XML Namespace SSI Help needed

  Thanks for taking the time to read my post.  For 3 months now I have been trying to get SSI XML Source to recognize my Schema and Instance file.  I have commited my self to using this tool and have been struggling tremendously.  The error that I'm getting is this: Error at SovrenXML Full Schema Resume Import[XML Source[1]]:  The component "XML Source" (1) was unable to process the XML data.  Ambiguous completType definition.  The element http://ns.hr-xml.org:Resume has multiple members name http://ns.hr-xml.org:NonXMLResume . I would attach the schema but it would not allow me to post and was getting errors.&nbs ...Show All

• Visual Studio Express Editions Can I Create an Access DataBase Without Access?

  I don't own Access and this is for Learning Purposes.... Can I create an Access DataBase with my own Schema(I guess that's the word) with VBE or any Other Way I downloaded Northwind.... Can I change Northwind schema without Access Thanks   Yes. I know you could do it with DAO. I'm not sure about ADO. Since ADO.NET is a little less faciliated in persisting, the USE of ADOX has been recommended to me for things like table creation and storage and I find that it works very well with VB.NET. I've installed systems based upon access databases on on target systems that did not have access. I ...Show All

• SQL Server Anyone else finding this painful?

  Although I am sure I will grow to love this new product I can honestly say that everyday has been a painful experience. Most of this, once again, is the learning curve to the new product. Moreover, each accomplishment leaves us feeling as if we are doing things the wrong way. Here is an example... We are populating lookup tables from a staging environment. This is pretty straight forward, insert records that don't already exist in the destination. Unfortunately, the only way we could get this to work properly, outside of just writing T-SQL for everything, was to use a lookup transformation and redirect the error rows into the table. Altho ...Show All

• Visual Studio Team System How can I find out what my team has checked out?

  I am a team leader and new to TFS-VC. I am familiar with the Pending Changes window to show what I have checked out, but how can I find out what the rest of the team has checked out I’m looking for something equivalent to the old SourceSafe “search for status” dialog, that allows you to view either all checked out files or those checked out to a particular user. Also, I have seen the command-line statement tf /status /user:* and even though it does do pretty much what I need, I much prefer a GUI tool and something integrated within Visual Studio. Thanks. There is no equivalent UI in v ...Show All

• SQL Server Management Studio Scripting Bug?

  In my install of management studio when I use the scripting wizard and get to the Choose Script Options dialog The Script Behavior drop down has only two options (Generate CREATE statements only, or Generate DROP statements only).  It doesn't have the option to generate a drop followed by a create.  If you read the description of the Script Behavior that is below the options you'll see that it advertises a Drop and create option.  Why doesn't the dropdown have all three options   Bug or not Hello Mikewo Thanks for posting this question. We are aware of the misleading description, which is an error. The descrip ...Show All

• SQL Server Report layout

  Hey guys, I want to create a report called "Report X", which has four reports under it. Assume the following scenario. 1. Report X 1.1. Bar chart report 1.2. Pie chart report 1.3. Matrix report 1.4. Pie chart report In addition to this, there are about four parameters that should be available for all reports. So my question is: what approach should I follow to implement/design a report for the above requirement. Can anyone give me how to design the report layout. Any idea is appreciated. Thank you for your cooperation in advance. Sincerely, Amde Hi ...Show All

• Windows Forms Error while accessing value of the control

  Hi, I have two combobox filled with data in a window form. I also have one more window from in which I have declared two variables. Now my requirement is that how can we access selected value from the combobox in first form to the valiable declared into second form. How can we access selected value of the combobox from any place in the working application. If possibe please provide some example. Thank you Hi, I have used following code: dsYear = Some Provider.ExecuteDataSet(System.Data. CommandType .Text, "Select distinct trim_year from VehicleTrim" ); this .bindingSource1.D ...Show All

• Windows Forms Disabling the .NET IDE option

  If I add a new form to the existing project, all the designer generated code are placed under the "form_name.Designer.cs" file. But I don't want this option. How can I disable this option Hi, There is no checkbox in any Options dialog that you can set to do this. Why would you like to disable this Martin ...Show All

• Windows Forms How to apply ColumnStyle and Alternating Row style

  I want to apply column style and alternating row style to my datagridview How should I do that Here's what I want to achieve: I have 3 columns. I want the first column to display its cells contents in bold. I also want to aply alternating row color to each row. Also, the Text should wrap in each of the cells. How should I achieve the above scenario All can be set using the Desinger. A DataGridView has the AlternatingRowsDefaultCellStyle property. Also each column of a DataGridView has the DefaultCellStyle property where you can set Font and WrapMode. ...Show All

• Visual Studio Problems passing parameters - Local mode

  I have a .rdlc report where no records appear to have been retrieved though I know they are there. That is: I have a .rdlc report. I have a parameter in this report Called Companys. In the List Region for the form, In the Filters tab I have code like the following: =Fields!Company.Value = Parameters!Companys.Value In the Load Event of the Viewer I have code like the following: Dim para As String = Nothing parameters = New ReportParameter( "Companys" , para) Me .ReportViewer1.LocalReport.SetParameters( New _ ReportParameter() {parameters}) Me .ReportViewer1.RefreshReport() When the form loads n ...Show All

• Visual C# FTP -- list files in directory

  I have found code that allows you to list the files in a directory for use with FTP-ing. The problem is I am not sure what "DirName" is in the code: http://www.java2s.com/Code/CSharp/File-Stream/Changesthecurrentworkingdirectoryandthenliststhefilesinthedirectory.htm Since I cannot pull the answer to DirName from the args (since I have no args) what would it DirName look like if lets say I want to check out the files on ftp://localhost which is my ftp for my computer ~Lauren From the looks of that code it is working not with an FTP site but with the local file system. I’d recommend looking into a fully managed FTP cl ...Show All