JWTK's Q&A profile

• Windows Forms DataGridView row automatically selected

  This seems to be a really simple issue, but for some reason I've failed to find an answer. I have a DataGridView with MultiSelect = true and SelectionMode = FullRowSelect. I'm binding a business entity collection to the DataGridView. The collection may or may not be empty when it is set to the DataGridView DataSource, or objects may be added to the collection later. The problem I'm having is that as soon as the DataSource is set, the first row on the DataGridView is selected. I've done a few tests and it seems like no matter what happens with the DataGridView, as soon as something is bound to the data source something (first row or cell) will get selected regardless of the SelectionMode. Is there anyway to have nothing selected ...Show All

• SQL Server programs!!!!

  i repaired my problem with the SQLserver Express.....now i know how to use....but nowadays i have some problems with my DataBase....i would like you people share your DataBase to see what is my problem......mi msn is jmontes32@hotmail.com .......if you give some programs....i will learn more about SQL server.. sorry if you find some grammmathical mistakes....i'm learnig english see you jamie You most likely will not have many folks 'sharing' their databases with you. However, you can download and install sample databases that Microsoft makes available. Here are three. Databases -AdventureWorks http://msdn2.microsoft.com/en-us/library/ms124659.aspx Databases -Northwind and Pubs http://www.microsoft.com/dow ...Show All

• .NET Development Serializing an Object into a database Column

  I'm trying to serialize a custom object into my database, Heres the code: /// <summary> /// Creates new user session /// </summary> /// <returns>Guid</returns> public static Guid InsertNewUserSession(CustomPrincipal principal, string connString) { Guid token = Guid.NewGuid(); using (SqlConnection connection = new SqlConnection(connString)) { MemoryStream memoryStream = new MemoryStream(); BinaryFormatter binaryFormatter = new BinaryFormatter(); binaryFormatter.Serialize(memoryStream, principal); SqlCommand command = new SqlCommand("upInsertNewUserSession", connection); command.CommandType = CommandType.StoredProcedure; ...Show All

• SQL Server Reporting Services MemoryLimit

  We're having trouble with memory configuration in Reporting Services 2k5 SP1, running on Win 2k3 SP1. We have a very large report, which we've been running to benchmark performance.   First, here are the results of our testing: Initially, the server had 512mb of RAM. When running the report, the w3wp.exe process used up to 400mb of RAM and Reporting Services usually timed out before delivering the report. We increased the RAM in the server to 1024mb, and found we could run the report. It took around 02'30" to complete, and the w3wp.exe process peaked at 520mb of RAM usage. When we tried to run two instances of the report concurrently, RAM usage peaked around 800mb, and Reporting Services timed out before delivering the ...Show All

• SQL Server Does Debug > Build in Script Task actually do anything?

  I'm looking for some way to verify the syntax, references, variables, etc. in my Script Tasks without having to run the package or the task. There's a Build command in the Debug menu, but it doesn't seem to do anything -- certainly, not like the "Build Solution" in a Visual Studio project. Am I missing something Does Debug > Build in the VSA editor actually do anything Thanks! - Mike mike.groh wrote: I'm looking for some way to verify the syntax, references, variables, etc. in my Script Tasks without having to run the package or the task. There's a Build command in the Debug menu, but it doesn't seem to do anything -- certainly, not like the "Build Solution&q ...Show All

• Internet Explorer Development Horizontal browser window under main page.

  I am developing an application inVS2005 that requires me to open a web page that has 3-4 lines of text in a seperate browser page underneath the normal window in ie6 or ie7. This browser is controlled by the localhost web engine in .net2, so I don't need any controls for web access. I will be using html links to control user access. How do I go about creating such a page I fairly new to programming and I have no clue as to how IE works. Thanks for any help you can give me. Is this along the lines of what you were looking for http://www.codeproject.com/csharp/dotnetbandobjects.asp There is another article on MSDN about Creating Custom Explorer Bars, but it's not for the faint of heart. http:// ...Show All

• SQL Server Convert Date

  Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR(YYYYMMDD) AS year, DAY(YYYYMMDD) AS date FROM Purchase thank you so much... curiousss wrote: Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor ...Show All

• Windows Forms MessageBox problems

  Hi all! I have a problem when displaying a MessageBox. The problem is that in the box does not appear any text, neither the caption nor the message nor the button text...what is happening the code is: MessageBox.Show("The system is not connected.","Robstar", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); thanks in advance!! Are you using VirusScan Enterprise 8.0 Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Smart Device Development LDAP Authenication on WM 5.0

  I am looking for a solution for an application to authenicate a user against LDAP from a WM 5.0 PDA. After much research I have only found one solution using PEINVOKE and WLDAP32.DLL. My problem is that I am not a C++ programmer, my experience is with VB. Converting the LDAP structure to a VB compatiable structure and making the calls has me scratching my head. Can anybody help with my problem I would like to use the pinvoke option, but as I explained in my original post, I am not a C++ programmer and converting the code you referenced is giving me problems. I had found the code you referenced before and that is what I am needing help with. Converting the Ldap structure as defined in the winldap.h include ...Show All

• Visual C++ A final WMI question (I hope)

  Hi Folks; I need to use WMI to determine the disk drive sizes in a system with multiple drives. The system I've tested this on has the drives but WMI seems to add the drive sizes together. I've looked on the msdn site and checked out the Win32_DiskDrive table but couldn't find anything to specifically meet my needs. I was wondering if there was a way to pull out individual drive sizes. In case of logical disks, I think you can try the Win32_LogicalDisk table, which has the FreeSpace column. ...Show All

• SQL Server Regarding MSsubscription_agents table...

  Hi,            I am using transactional replication with updatable subscriptions. I am not able to apply the snapsnot after doing schema changes. The subscriber throws the error Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. This error is thrown on the below query... select * from MSsubscription_articlecolumns where artid = 4 and agent_id = ( select id from MSsubscription_agents where update_mode > 0 and UPPER ( publisher ) = UPPER ( N 'Servername' ) and publisher_db = N 'TestTransUpdate2' and publication = N 'Test_TransUpdate2' ) The table MSsubs ...Show All

• SQL Server SqlCeRemoteDataAccess Pull issue with ConnectionString

  I am using a tested connection string. when I execute the following code: Me .Cursor = Cursors.WaitCursor Try clsRDA.VerifyDatabaseExists() clsRDA.DeleTable( "WorkOrder" ) Dim rda As SqlCeRemoteDataAccess rda = clsRDA.GetRDAObject() rda.Pull( "WorkOrder" , "SELECT * FROM WorkOrder" , My .Settings.RemoteAbacBillConnectionString, RdaTrackOption.TrackingOnWithIndexes, "WorkOrder_Errors" ) Catch ex As Exception MsgBox(ex.Message) Finally Me .Cursor = Cursors.Default End Try I get the following error: Failure to open SQL Server with given connect string. Can you connect to SQL Server directly using the above credentials If ...Show All

• .NET Development Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

  I did a quick search around this forum and around the web but I can't find any helpful information regarding this problem.  Currently, I am running a site on asp.net 2.0 within a shared hosting location.  Their SQL backend is 2000.  I managed to create the db via aspnet_regsql, and then upload the aspnetdb and set provider stuff to the correct bits of information, however when I try any query, like logging in, it doesnt work, and get the error could not find stored procedure...  I checked, and the procedure does exist.  Everything is set up as it should be, schema and all.  Any ideas   I used Scott Guthries blog on how to use asp.net authentication on SQL 2000, and that worked without any problems. ...Show All

• .NET Development Sending data elements and files by http POST

  Hi, I want to make an application that send by http post some input elements (user and password) and a file. I was using webclient wit UploadValues and UploadFile methods, but I need to send all (data and file) in only one http request. (but I don't n know the way or method for that) Please, If you have some code example, i will appreciate so much Thanks in advance ...Show All

• Visual Studio 2008 (Pre-release) XAML error in the line <Setter Property="TabPanel.Bottom" Value="-1"/> (Using June CTP)

  Hello I created an application using May CTP, and then I installed June CTP. I have tried to build this application with Interactive Designer (June CTP), but I got an error in this part of XAML: <MultiTrigger> <MultiTrigger.Conditions> <Condition Property="IsSelected" Value="True"/> <Condition Property="TabStripPlacement" Value="Top"/> </MultiTrigger.Conditions> <Setter Property="TabPanel.Bottom" Value="-1"/> </MultiTrigger> The error happened in this line: <Setter Property="TabPanel.Bottom" Value="-1"/> It says : " Cannot find the Template Property 'Bottom' on the type System. ...Show All