Jacco Mintjes's Q&A profile
SQL Server Prgramming for SQL Server 2005
Folks, I'm new to sql server and want to know 1) what are the possible ways to program ( I mean do we have any frontend tools OR where do we write program which eventually talks to sql database)so we can do ETL operation for data of sql server DB. 2) How to learn that programing ( meaning what are the resources ) 3) I'm new to database concepts as i'm Java Programer - what basic things I must know in order to design sql database all above que is to support my current new job, PLS advise asap. thanks. If you already have an existing database, you can start using it with SqlConnection and SqlCommand. Look them up in the MSDN. You’ll need a book to get started with the T-SQL languag ...Show All
.NET Development SchemaImporterExtension - machine.config
Hi! I created the derived class like shown in the sample. Now I can't get the debugger to step into my class. My machine.config looks like this (in contrast to what the sample is assuming I guess): < configuration > < configSections > < sectionGroup name = " system.xml.serialization " type = " System.Xml.Serialization.Configuration.SerializationSectionGroup, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " > < section name = " schemaImporterExtensions " type = " System.Xml.Serialization.Configuration.SchemaImporterExtensionsSection, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " /> & ...Show All
.NET Development Obtaining IP Address of Client
Under ASP, you can obtain the client's IP from Request.ServerVariables("REMOTE_ADDR"). What is the equivalent in a Web Service OK, maybe the problem is that I just am not knowledgeable enough about ASP .Net. After reading your explanation I must say that the application I am working on is not referencing a web service. It is simply web pages that can be accessed by a web browser. So, based on the statement you made below . . . "May not be exactly the answer you want, but the browser (client) IP information is available in the asp.net page..." . . . it sounds like I can get the IP info . . . but how Any help . . . I mean anything would be greatly appreciated! As far as why . .. the cu ...Show All
.NET Development CodeDom for 'is' operator
I would like to compare some types for membership in an inhertance tree. In C# I use the 'is' operator. VB also has a similar operator. Is there a CodeDom class that I can use to encapsulate the 'is' operator Thank you. Kevin Ah, sorry - I was assuming we were talking about the VB.NET is operator. I should have paid a bit more attention to the original post. Best regards, Johan Stenberg ...Show All
Windows Forms DataGridView Connect Multi Tables
i have connect DataGridView With Multi table the Table is BillBuys and the Second is BillBuysDetails and the Last is Storage The Colmnu in BillBuys BillNo PK SuppNo FK BillDate The Column in BillBuysDetails BillNo FK TrdNO Fk (like ItemNo) BuyPrice SalePrice Qty Unit The Colum in the Storage i TrdNo FK PatchNO ExpDate MinSalePrice MaxSalePrice the Question 1- How to Dispaly all Columns in the DataGridView Note the SuppNo is DataGridViewComboBoxColumn and TrdNo DataGridViewComboBoxColumn 2- in the insert Operation how to Fill BillNo in the BillBuysDetails Table hi, palestine ,i hope this article will help u! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=539873&SiteID=1 ...Show All
SQL Server Runtime data source error
Hello I have a defined data source to an oracle server . I've alredy intalled oracle client, and setup my data source to save the user and password. I'm using .NET provider/OracleClient DataProvider Connection. When I click on "Test Connection" Button, SSIS reports SUCCESS. In Connection Manager TAB I created on connection called "OracleServer" from my oracle data source, described above. In my package, I defined a DataReaderSource task, I specified "OracleServer" as a connection to it. I can preview data and view oracle's columns name..., so it make me think that everything is fine. But when It execute the task it FAIL and notify logon error and that password can't be blank. Please help, I need read f ...Show All
.NET Development How can I continue after an error?
Here's a good one for ya... I'm writing some code in a method that intentionally passes bad data to a series of calls in the method. The problem is, once the first error in the method is encountered, it jumps to the catch and then leaves the routine. What i need it to do is to continue at the next item in the routine that is going to throw an error. Since .NET doesn't seem to have Resume Next, is there any equivalent way to do this Public Sub CauseErrors Try Error1(BadData) Error2(BadData) Error3(BadData) Catch End Try End Sub Hi, The problem you are facing is not a problem but it is the intended behaviour of Try... Catch block Structure your Try ... Catch in the follo ...Show All
Software Development for Windows Vista Utter lack of Icon documentation
I'm trying to update an application to be nice and Vista-y; the current problem is with icons. What icon sizes should my application have to be Vista+XP compatible. How can I tell In particular, why doesn't Microsoft actually documentation the icon file format As near as I can tell, there are single-byte 'height' and 'width' values in the list-of-icons in the icon header. This means that icons can only be 0 to 255 pixels. However, it seems that icons in Vista can in fact be 256 pixels, so clearly there isn't a simple mathematical relationship between the value in the file and the value used. My question is: what is the mathematical relationship between the height and width fields and the actual icon height Are they just set to zero, bu ...Show All
Visual C++ How to retrieve REAL unique USB flash drive serial number.
Hi I want to retrieve real unique serial number of a USB flash memory. I tried to use Win32_PhysicalMedia class but it’s give me only model like: Generic USB Flash Disk USB Device, but for serial number: None. I don't know if it is possible or not and I can’t find any information abut this. I can retrieve USB device(not memory) serial number, but I don’t know it is unique. Can anyone help Thank You all. mareknik Hello Re: How to retrieve REAL unique USB flash drive serial number. Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID ...Show All
Visual Studio Tools for Office Applying Formatting to Excel columns programatically
I am coding in VB.net (VS2003). The output of my program is an Excel spreadsheet. Everything works except some of the formatting. I have: ws.range("J").NumberFormat = "0%" and ws.range("K").NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* ""-"" _);_(@_)" where ws is dim'd as a worksheet The formatting syntax is copied from a VB6 program. However, I am coding in VB.net (VS2003) and it is giving me runtime errors: System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC. at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyB ...Show All
Internet Explorer Development IFrames don't always work in IE6
Hi all! I have a pretty strange problem with Iframes in IE6. The page that is having the problem is this one: http://www2.morsoe.com/dk/Garanti/Garantiregistrering/ The page is used for registering the customers products with the manufactor. The page is maintained in MCMS and the registration-form itself is retrieved from http://morsoegaranti.gr3.dk/frontend/default.aspx in an Iframe. That also worked fine, but it seems that it is causing problems now. The Iframe won't load - you have to right-click and select "update" on the iframe to get it to work. But if I copy-paste the IFrame into a new blank HTML-document, it works fine - everytime. Anyone know what is causing this When the site was launched in spr ...Show All
Visual Studio VS 2005 acting-up baaaaadddddly
I am building an .exe using VS2005 with SP1 on XP-64. First it was working fine, then the debugger starting acting up and refusing to stop at breakpoints, I was able to fix that by changing the debugger type from Auto to Native code. Then VS refused to work all together asking me to reinstall the application. Did that about 4 times to no avail, then decided to remove all needed files and download new ones, Platform SDK and .NET Framework and such, from the website and reinstall everything. Tha made the compiler work again and the Debugger did stop at the breakpoints, however it won't go into the functions where it stopped, F11, and would crash. I noticed that since it crashed at a very low address it must be crashing in one of the ...Show All
Visual FoxPro SCREEN RESOLUTION
HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW Hm my design resolution is 800x600 but when i install my program to my customer . his screen resolution is 1024x768 . Its makes my program screen so .... How do i fit my program to my customer screen Thanks in advance. ...Show All
Visual C# Strange null reference problem within enum?
Hi All, We've been having a strange problem. Recently we have seen null pointer exception coming out from our code. The exception trace is dead simple: Message: The run has errored with description: Object reference not set to an instance of an object. Object reference not set to an instance of an object. ------------------------- User: Source: mscorlib Server stack trace: at System.Collections.Hashtable.get_Item(Object key) at WGP.Adapter.IntToPrataEnum(String prataCode, String val) at WGP.Adapter.Curve.BuildCurves(Double[] date, Int32[] instrument, String[] currencies) ... Anyway what really strange is that the code in IntToPrataEnum method is dead simple and straight forward. As far as I can see, I couldn't find a single ...Show All
Windows Forms Sudoku help needed
Hi, I am trying to make a sudoku game but have run into a problem. basically i have a function to create the game view: private void createView() { Table1.Rows.Clear(); for (int rowIndex = 0; rowIndex < State.Board.GetLength(0); rowIndex++) { TableRow row = new TableRow(); Table1.Rows.Add(row); for (int columnIndex = 0; columnIndex < State.Board.GetLength(1); columnIndex++) { TableCell cell = new TableCell(); int value = State.Board[columnIndex, rowIndex]; if ((ActiveCell == null) || (ActiveCell.Row != columnIndex) || (ActiveCell.Column != rowIndex)) { string id = String.Format("BoardButton_{0}_{1}", columnIndex, rowIndex); if (value >= 10) { Image image = new Image(); ...Show All
