Leonardo K's Q&A profile

• Windows Forms Datagrid - Dynamic Bound Column -Column Names case Sensitive

  Hi, I'm using asp.net datagrid control to populate the data. I have a datatable with columns and rows in one situation where im using pivot table to convert the columns as rows and rows as columns. then I'm adding columns by using BoundColumn class to the grid dynamically. finally binding the datatable to the datagrid. Datatable has two columns like "SERVICE" and "service" their value will be assume 1 and 2 when binding datatable to the datagrid by datasource its displaying two columns and values will be 1 and 1 irrespective of actual values 1 and 2. can any one help me regarding this. Thanks in advance. Hi, Can you post some of your code please It's difficult to help you just with this description ...Show All

• SQL Server Import Data to SQL server from Excel spreadsheet

  Hi all, Firstly, i'm new to integration services and have only done a little with DTS jobs. I'm trying to create an integration services project which will import data from an two worksheets in an Excel spreadsheet to two different tables in a database. I'm looking at only one table at present to make things a little more understandable. One stipulation i have is that i need to be able to specify a variable value and insert that as an additional column in the database. I have and Excel source and a SQL destination both of which have been set up with there specific connection managers. I also have a variable which i add in using the derived column task. When i try to debug this i am getting a few problems. I think these may be to do with th ...Show All

• Visual Studio 2008 (Pre-release) bindingName and bindingNamespace in configuration file

  There is a way to specify the binding name and binding namespace in the end point of a service through configuration. These two attributes affect the way WCF generates the wsdl:binding names. What I noticed is that if you have a service with multiple end points (in my case I have a service with multiple contracts, each with one operation) and if I explicitely specified bindingName and bindingNamespace in each of the endpoints, the last set of binding name and namespace are winning. For example, if my configuration file is authored as below: <system.serviceModel> <service name="WCFFooService.MyCustomerService"> <endpoint binding="wsHttpBinding" contract="WCFFooService.ICustomer" bindingNamespace="urn:MyCompany.Custom ...Show All

• Visual Basic How to import a text file into a database

  Hi All, I have a comma delimited text file that I need to import into a predeifined Firebird database. I'm connecting to the database programmatically, and need to import each comma delimeited field into the corresponding database table. Pleas help , I've been struggling with this for weeks.................... Thanks This is what I have thus far. Do I need to use an array Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim SQLString As String = "Select * from rdstype27" 'Connect to Firebird DB Dim cn As New FirebirdSql.Data.FirebirdClient.FbConnection( "User=DBADMIN;Password=admin;Database=E:\Firebird\ ...Show All

• SQL Server Table and Column collation properties

  I want to list collation properties of all the tables and in my database. Is there an easy way of listing all of these objects I have a feeling that some columns in my tables have different collations. I am using SQL Server 2005. Thx in advance Hi . SELECT * from INFORMATION_SCHEMA . Columns --Look for the collation attributes HTH , Jens K . Suessmeyer . --- http :// www . sqlserver2005 . de --- ...Show All

• Visual Studio Tools for Office Windows Vista, VSTO 2005 SE addin on Office 2003 not working

  Configuration: Windows Vista Visual Studio 2005 VSTO 2005 SE Office 2003 Professional Problem: I've just upgraded from XP to Vista and after that even the simplest VSTO Outlook addin doesn't work any more. I can't debug the project and ThisApplication_Startup event not firing. When I look at the addin i Outlook (COM Add-Ins/Add-Ins available) the Load Behavior is "Not loaded. A runtime error occurred during the load of the COM Add-in." Kindly help me with this issue Regards Gazza   Seems like the microsoft people have taken a looong break over the christmas holidays... So no one knows if it's possible to develop a VSTO 2005 SE addin for Office 2003 on Windows Vista This ...Show All

• .NET Development Web method parameters coming through as "nothing"

  Hi, Hope someone can help me with this. I had a very simple web method with about 30 string parameters. I could communicate with it via post, get and SOAP. It worked fine. Then I split it into two different web methods. Each of the new methods works fine with post and get but using SOAP causes all of the parameters to come through as "Nothing" So I can successfully access the web method via SOAP, no errors or anything but all the parameters are empty. I've tried a new web service with the same web methods with the same result. Anyone have any suggestions It seems like there is some WSDL file that is not getting updated or something.. I' really stuck here I would suggest using WebServiceStudi ...Show All

• Visual Studio Express Editions Fonts residing in the app's folder

  Is there a way to use fonts that aren't installed but that resides in the application folder If you want to use a 'freeware' TTF and embed it in a program, try my private font test program at http://users.adelphia.net/~gcumbia/FontPrivate.zip I can not get the private font to print! (Using the regular 'drawstring') It is replaced with a regular font. ...Show All

• Visual Studio Express Editions vb2005 express

  Is is possible to use vb2005 in educational establishments soley for the purpose of teaching ...Show All

• SQL Server Variable Value: How do I set it from value in flat file at runtime

  I have a number of DTS packages I am trying to convert and am totally new to Integration Services. I have a flat file that I reference to get a date that I use in some SQL statements in the package. It seems like the best way to do this would be to create a variable to hold the date and set it at run time from the flat file. I've been searching the documentation and the forum and can't figure out how to do this. This is so basic that I feel like an idiot putting it on the forum but I need some help. This whole Integration Services thing is a big shift from DTS (which I eventually became pretty good at) Now I'm back to ground zero. Any help would be appreciated. If you can direct me to any basic training resources that would be cool t ...Show All

• Windows Forms keep listview item selection / Microsoft Bug VS 2005 SP1 Beta?

  Hi, I'm trying to keep my listview selection while switching tabs in my tabcontrol. this is the code I have: Private Sub listviewView_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ListViewItemSelectionChangedEventArgs) Handles listView.ItemSelectionChanged listViewCurIndex = e.ItemIndex End Sub Private Sub Tab1_enter(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Tab1.Enter If not listViewCurIndex = 1000 Then printerView.Items( listViewCurIndex).Selected = True End If End Sub How can I do this Platform: Microsoft Windows XP Version 2002 SP2 Microsoft Visual Studio/Visual C# 2005 Version 8.0.50727.363 (SP.050727- ...Show All

• Visual Studio 2008 (Pre-release) SelfHost WCF example on 2 machines

  Hi, all ! I tried selfhost example to run different machines and client faild unless I added <identity><servicePrincipalName/></identity> to endpoint. So my questions in this case : 1) Why only "servicePrincipalName" work and not "userPrincipalName" ( this example run service as console application and not windows service ) 2) Why I don't need to add value attribute for "servicePrincipalName" in this case 3) Why I can only set end-point address as "computername.domainname" and not "computername@domainname ". When I set it on service instead of "localhost" service failed 4) How the adress will be changed for workgroup. 5) Is it possible to use ...Show All

• Visual Basic MAKING .NET CONTROLS - OCX VB6 COMPLIANT

  Hi all, I have to create a .NET control. It have to run in a vb6 app. I'd like to use it like a standard OCX control. I've found in the net that it's possible. there's anyone who can tell me in which way I can do it It's simple: have a .net control and import it in a VB6 controls list by "add control". and have it working right. Dario TIA for any suggestion! So, this will be better doc'd in the upcoming release, but here's a brief summary: 1) If you are deploying a VB6 app using this control, just copy the control to where your vb6 exe is located, run regasm.exe on it (which is a utility in your frameworks directory) on the control, and then your app should run fine. ...Show All

• Visual Basic MAKING .NET CONTROLS - OCX VB6 COMPLIANT

  Hi all, I have to create a .NET control. It have to run in a vb6 app. I'd like to use it like a standard OCX control. I've found in the net that it's possible. there's anyone who can tell me in which way I can do it It's simple: have a .net control and import it in a VB6 controls list by "add control". and have it working right. Dario TIA for any suggestion! This will be explained in the upcoming release, but here's the short answer. (this is assuming you are using what Jon described in the post above -> the template you can download) You have to specifically expose any events that you care about. Say you want to expose the usercontrol click event. To do this, ...Show All

• SQL Server SQL EXpress ADV. Services Full Text Search

  I have seenfound several posts about Full text Search and looked at the BOL but havn't found a simple how-to. If anyone could point me to or post instructions on configuring Full Text Search in SQL Express W/ Adv Services it would be great. So far I have completed the following: Created my database using SQL Expr w/ Adv Services. Database is monted in a SQL server instance not a user instance. In SMSE under database>properties>files checked the box "Use full-text indexing". What now. I have seen posts referncing using the template explorer in SMSE and the Full Text Index templates. I see four templates in my template explorer related to FTS . Create Full-text Catalog Create Full-text Index Start Full Population Stop Popul ...Show All