LisLis's Q&A profile

• Windows Forms DataGridView Child Table Problem using byte[] DataRelation

  I have two DataGridViews where one shows a parent table, and the other shows child rows for a selected row in the parent table.  I am using a DataRelation object hooked into a DataSet to establish the relationship.  The problem that I'm having is when the DataColumns defined in the DataRelation are of type byte[], the relationship no longer works.  Meaning, the child table will not show the child rows corresponding to th ...Show All

• Visual Studio Team System Naming Convention for Whidbey

  Hi, Good Day. Can anyone provide pointers as to where i can find a comprehensive Naming Convention guideline and coding guideline document for Whidbey, that goes well with FXCOP Thanks a lot in advance. Regards, Murali http://www.amazon.com/gp/product/0321246756/002-2872601-5856864 v=glance&n=283155&n=507846&s=books&v=glance Some of this content is posted on Brad Abrams' blog as well: http://blogs.msdn.com/brada The up ...Show All

• SQL Server Query Performance

  Hello SQL Gurus, From the query below, I am using 2 TOP functions to return the desired row. I am wondering if someone can shed some light on how to AVOID using 2 TOP statements and combine into just one select query select TOP 1 * from (select TOP 2 Num from A order by Num) X order by Num desc Truly Appreciate your help as this performance issue has been bugging in my head for quite some time... Sincerely, -Lawrence ...Show All

• .NET Development Invalid character value for cast specification.

  Hi all, I am runing SQL Server 2000, Windows 2003, and doing this in C# on .Net Framework 2.0. I have the SQL Statement: insert into test_table (col_1) values ( ) OleDbParameter Value = 65788 OleDb Data Type is OleDbType .Numeric col_1 has a data type of Numeric(18,0) But I keep getting this error message: Invalid character value for cast specification. The same procedure works for all column type available on SQL Serv ...Show All

• Visual Basic Cannot update Access database record

  After adding a data source to an Access database file, I created a detail form by drag and drop one of the table to Form1. When I run it, the data can be retrieved correctly, however any modification cannot be updated back to the database. I checked the insert, update and delete commands in the tableadapter are correct. I tried execute the insert command from the Query from Query Builder, which can create a new row in the database. I ...Show All

• SQL Server SSAS service does not start

  Hi I recently installed SQL 2005 . The install proceeded well, but Analysis services service cannot be started on to the machine. When i try to start the service via Configuration manager I recieve and error "An error occured while performing this operation" I have tried to reinstall the product , but that did not help Thanks Sumeet **I'm moving this thread to the AS forum. Take a look ...Show All

• .NET Development SSL/TLS exception when using HttpWebRequest with client certificate

  Hi, I wrote following code to call a aspx page in code (from another aspx page): HttpWebRequest httprq = ( HttpWebRequest ) HttpWebRequest .Create(uri); string certificateName = "SoapProxy2" ; X509Store store = new X509Store ( StoreName .My, StoreLocation .CurrentUser); store.Open( OpenFlags .ReadOnly); X509Certificate2Collection certificates = store.Certificates.Find( X509FindType .FindBySubjectName, certi ...Show All

• SQL Server Creating table where column_names are results from query from other table

  How I can create table where column name is result of query of second table Next cod doesnt work: Use Pubs declare @naz varchar(40) declare naziv cursor for select top 1 au_lname from authors open naziv FETCH NEXT FROM naziv INTO @naz close naziv deallocate naziv GO CREATE TABLE #t1 (@naz varchar(20), quote int ) GO DROP TABLE #t1 use dynamic sql, although it won't work for temp tables. EXE ...Show All

• Architecture "Unique ID" server for multi-server app

  I'm building an ASP.NET app that I hope will scale to need multiple servers. For certain objects, I'd like to provide users with an "External ID". This would be either a user entered or randomly generated string, like "Fred's Data" or "q1g52xTK". This external ID would be associated with a GUID, and would allow the user to get at the object without having to know the GUID (such as at log-in). (They will also be a ...Show All

• Windows Forms printing a datagrid in VB2005 (Again)

  Has anybody found a good solution to this yet I can not get my grid to print I can only see some "C" code but that has not helped me much. By print, you mean to a printer, right First, you'd get a bitmap that shows what's on the control, using Control.DrawToBitmap (air code -- something like this):        Dim rect As Rectangle = myGrid.ClientRectangle    &n ...Show All

• SQL Server ~* Is RS Utiliy client or Server component?? *~

  Hi, will the Rs.exe utility get installed on installing only the Server Components Thanks in advance ...Show All

• Visual Basic VB.NET2005- Installed application icon does not support drag whereas manually created shortcut does.

  Using VB.NET 2005, I have configured my program to respond to a textfile icon dragged to its shortcut on the desktop. That's easy: Dim Filename As String = My .Application.CommandLineArgs.Item(0).ToString This will launch the application, and the file dragged to it can then be opened. But it doesn't work! When I drag a text file to the icon that was created by the Setup project, I get the red circle with a line through it, a ...Show All

• Visual Studio Team System Customizing the menu in VSTS Project Team Portal

  Hi Is it possible to customize the VSTS Team Project Home Page left Menu. How do i add modify and delete items from the left menu. The left menu contains items like Documents, Process Guidence and Reports etc with Submenu. I am able to add/update a submenu What i would like to know is how do i add/update/delete the mejor menu items in the left menu   Thanks The easiest way to customize the Quick Launch menu in Windows Sh ...Show All

• Visual Basic Weeknumber

  How do i get the weeknumber in Visual Basic 2005 Express edition Well that doesn't work for me. There's an interesting article about this here http://www.thecodeproject.com/csharp/GregToISO.asp msg=396665 The code is in C# but shouldn't be too difficult to convert ...Show All

• Visual Studio Team System VSTS release plans? VSTS and Intel compilers?

  1. Will Team System be released with Visual Studio 2005 on November 7, 2005 I have heard rumors that it will ship separately. 2. What beta, CTPs are planned between now and the time Team System goes RTM 3. Our product has future plans to offer a 64-bit version and the Intel compilers are the currently available technology. Will Team System work with the Intel compilers Thanks, Sri Prasada See Soma's b ...Show All