Mike Yamashita's Q&A profile

• Windows Forms datareader bind to datagridview

  hi, how to bind datareader to a datagridview without using datatable. thanks, Popskie   try this code,    cnn.Open();    cmd = new SqlCommand("s_Y",cnn);    cmd.CommandType = CommandType.StoredProcedure;    dr=cmd.ExecuteReader();    DataGrid1.DataSource=dr;    DataGrid1.DataBind(); ...Show All

• Visual C++ Attemp to use MSIL code from this assembly...

  I have a C/WIN32 program that I have "transformed" into "C++" and build with /CLR. Everything compiled ok - exept from some warning about: warning LNK4248: unresolved typeref token (01000011) for '_IMAGELIST'; image may not run warning LNK4248: unresolved typeref token (01000011) for '_TREEITEM'; image may not run But when I run my program I got the error : "Attemp to use MSIL code from this assembly during native code initialization. This in ...Show All

• .NET Development problems connectiong to a SQL Server 2k DB using VS 2005

  some knowing issues about this topic i cant connect to a SQL Server 2000 DB in a remote computer with Windows XP PRO, using a ASP.NET Web Service App in Visual Studio 2005... my actual computer use Windows XP Home and VS 2005 v8 I'm getting crazy with this "little problem" my networks works fine and i can see the remote computer files and folders, either if i try to connect using the Client Components like Query Analizer i ...Show All

• Visual Studio Express Editions fatal error C1083: Cannot open include file: 'xxxx.h': No such file or directory

  Hi, I'm using Visual C++ 2005 Express, and I see that this type of error message has been giving a lot of people problems, but after trying a few of the fixes posted here, my project still gets the same error message. Here's a snippet of my .h file: //randomcard.h int randomcard( void ) {    int randomnum; and here's the top part of my .cpp file: #include <stdlib.h> #include <stdio.h> ...Show All

• SQL Server About Clickstream Datawarehouse

  Hello: I am a student from China.Now i am writing my graduation thesis which about Clickstream datawarehouse for e-commerce with SQL Server 2K5.But I just be a student,so i donot have a real webstation on Internet.And i cannot have the data about that,so now i cannot finish my graduation thesis.Can you have a sample about clickstream datawarehouse or weblog data i want to design a date warehouse and analyse them with SQL Server 2K5. Just sa ...Show All

• .NET Development DbCommandBuilder output

  Is there a way to get the Update command from a DbCommandBuilder with the actual parameter values that will be used when DbDataAdapter.Update() is called, not just the parameter placehoders like GetUpdateCommand() does For sql, the best way is really using SQLProfiler. Parameter substitution wont really happen on the client, but on the server. Is this for another DB Maybe BID can help, though i'm not positi ...Show All

• Visual Studio Team System Installing TFS - Error 28002

  Over the past few days we have been installing a single server deployment of TFS on a Win2K3 server with a domain administrator account. The error we get is Error 28002 (about 90% through) during the install. We tried this install many times on two different servers, as well upgraded the Domain Controller from 2000 to 2003. We even setup the install TFS account to have full domain administration rights. The error in the system logs: ---- ...Show All

• Visual Basic Having trouble getting a correct value of textbox3

  Hi Im using VIsualbasic2005 Express (its .net of course ) Dim intText1 As Double Dim intText2 As Integer Dim intText3 As Double intText1 = Val(Frm3.TextBox1. Text) 'Here is says Conversion from string "" to type 'Long' is not valid. intText2 = Val(Frm3.TextBox2. Text) intText3 = CDbl(Val(Frm3.TextBox2. Text) * Val(Frm3.TextBox1. Text)) Frm3.TextBox3.Text = intText3 Textbox3 is still 0 When textbox ...Show All

• Windows Forms How To Get AssemblyName of the application

  I am trying to load a form dynamically at runtime.  I want to get a handle to the Form just from the form's name.  So far it seems like CreateInstanceWithUnwrap should do what I want.  Unfortunately I'm not sure how to get the&nb ...Show All

• Visual Basic Overriding Equals Method Using Generics

  I've got a copy of an article from Visual Studio Magazine on my desk (May 6, 2006 "Build Better Collections with Generics" Jean-Paul S. Boodhoo) and I've a question about overriding the Equals method in a generic collection. For example, if I create a generic collection using a 'Contact' object (like one might use in an address book) I can use the default Equals implementation to compare two contacts to help guard against adding th ...Show All

• SQL Server Releasing Memory (free mem)

  Is there any settings in RS that will release used memory to used it again, to avoid lack of mem for large amount of records Thanks in advance. ...Show All

• .NET Development DataSet Update() Method...has anyone seen it work?

  I've been working on this for several hours now and I just can't get it to work. Here's the idea...2 identical databases (one local, one remote). Fill dataset objects with the contents of the the same table from each database. I then clear the contents of the dataset of the local table data and use the Merge() function to merge the data from the Remote database table data into the local database table...then update the local database. Sounds ...Show All

• SQL Server Mismatch in Conversion Handles

  Hi, I am developing an application to mail the Newsletters on a daily basis with Service Broker . I have a peculiar problem, that the queues associated with same dialog is giving different conversation handles. I'm testing the application with one mail at a time, i.e., there are not more than one item in both the queue at one point of time. But the handles returned by the queues are different within the same conversation. Why it is happeni ...Show All

• SQL Server Intersecting Drillthrough results - an MDX challenge

  Hi, Anyone have any guidelines on how to intersect the results of 2 or more DrillThrough operations In other words, say, if I drillthrough on Cell1 and get Factkeys: 1 to 20. I drillthrough on Cell2, and I get FactKeys: 15 to 30. Now what I want is to run my MDX Select query, which returns only Cell1 and Cell2. Then I want to do an ' Intersected Drillthrough ' operation, which should give me the intersected Factkeys: 15 - 20. This ...Show All

• SQL Server datetime HOUR function format

  I am using reporting services to make a matrix. The row value is the date portion of DateIn. The value is a count of transactions. The column type is the problem. It is the hour part of the timein value. I got it from the database like this: {fn HOUR(dbo.[Transaction].[TimeIn])} AS Hour This works, but gives 24 hour time (and only the hour part, so it looks like 10, 11, 12, 13, 14, etc.) I want it to look like 10:00 AM, 11:00 AM, 12: ...Show All