Kestutis's Q&A profile

• SQL Server Error converting data type varchar to float.

  Hi, I am experencing a data type cast issue in T-SQL, basically our application comtains both numeric and non-numeric data in the same column, I want to retrieve the numeric data only. Assuming a table has one column create table TT(c1 varchar(20) ) and insert 2 rows into the table insert into TT values('100') insert into TT values('test') Now if I want to do numeric comparison on column c1, I will get an error, e.g. select * from TT where c1 >100 because SQL server trying to convert 'test' to a number impcilitly. I tried to create an UDF to handle the non-numeric data conversion, e.g. if the data is numeric then return the number, if the data is non-numeric, then return a NULL. create function numcas ...Show All

• Windows Forms Add events to the list view

  Moving to Windows Forms forums. Hi all my code in vb.net i used list veiw to view my records i want to add event to the list view when i scroll the scroll bar in the list view up and down. note: the scroll bar is already in the list view i know how can i add it i need to add event execute when i navigate on the scroll bar. i didn't found this event in the list view please how can i add it many thanks ...Show All

• Visual Studio Documentation Compiler - Sandcastle

  We did code complete of documentation compiler ( code named "Sandcastle") on June 15th and currently we are testing the tool building our .NetFramework documentation. We would like to release the CTP version of Sandcastle in Microsoft download center by next week. The perf in our testing has been great as we are able to build the entire framework content in less than 1 hour. I am in the process of going through final check and code signing required to post this in our download center. Please expect the CTP in the next week or so and I will provide an update here as soon I post the CTP. Anand.. Great, Thanks. Will this handle non-standard tags (exmple: nested tags named: objects, object, parameters) Will sandbox render th ...Show All

• Software Development for Windows Vista Drivers signing question.

  Hi all! My product installs a boot-start filter-driver, but uses co-installer for its setup. I have successfully signed this driver using MS recommendations, but I have a number of questions and I would be very happy if someone could help me clarify them: 1. For LOGO certification - is it obligatory to install filter-driver through .inf file or I can use co-installer 2. Shall I generate .inf and .cat files if I use 'co-installer' way 3. MS docs say that .cat files must be signed with a cross-certificate. But what about .sys-files inside the driver package What certificate should I use - from Verisign or the cross-certificate 4. In case of '.inf-file' installation scheme, are the sign rules similar for device drivers and for filter-drivers ...Show All

• Visual C# Plugin events C#

  I hope this is the correct place to post this Q. I am also going to write a tutorial/blog/experience report on this as I cannot find the correct resources on the net, believe it or not (ok so my search keywords are not great!)..... I am writing my very first plugin for my application in C# I have created an interface. I have implemented this interface in the plugin. I have also created a IPluginHost interface, which sets the host (application) in the plugin. I can load/create/instantiate the plugin. Now, I have made a delegate/event in the interface. The plugin implements this. //delegate example: public delegate void DoSomething(string text); //event in interface and plugin: public event DoSomething OnEventDoSomethi ...Show All

• SQL Server Why is there a 256 JOIN Limit in SQL Server 2000/2005?

  Hi, Does anyone know why there is a 256 JOIN limit in SQL Server 2000/2005 Are there any plans to raise this limit (or do any add-ins exist to raise this limit) Thanks. BTW, a separate question -- is there a limit to the number of rows a SQL Server 2000 database table can have What about SQL 2005. Thanks. Rows per table is limited only by how much space you have. I have seen multi-terabyte databases run quite efficiently (ok, only once, and the folks who ran it were really smart) One thing you really need to watch for is how many bytes you have in a row - you can only have 8060 bytes which is how wide a memory page is. There are formulas for calculating this, but you can get a very rough ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Model scaling without effecting the real coords

  Hi, when I load my models they don't always have the correct size in relation to each other, so i want to scale them. When i multiply the world matrix of the basic-effect that renders the model with a Matrix.CreateScale(0.2f) matrix i get the visual correct result. But the coords are scaled too. So when i want to set the position of my model i need to multiply the x, y and z coords by 5 to get the correct values for the model world matrix. Does anyone have an idea to only scale the model in visual I already tried to multiply the view and/or projection matrices with a Matrix.CreateScale(0.2f) matrix but I only got crapy results... at least I am not very familiar with matrices Thx & bye Thunder2002 Whe ...Show All

• SQL Server SQL Agent job fails running SSIS packages

  I need some help from you on a problem with SQL Server Agent that I believe many of you have experienced. When searching on the web I find some loose answers, but it would not solve my problems. So here is my story. 1. I have created two SSIS packages, package 1 and package 2. Both packages have a Execute SQL Task making a select sql statement to a table, say Customer in AdventureWorks DB. Package1 also makes a Execute Pacakge Task to Package 2. Both packages have protectionlevel property set to EncryptSensitiveWithUserKey 2. Then I created two package configuration files per package, one indirect xml configuration and one xml configuration file. The former I created an environment variable called pack1, which was specifying the path ...Show All

• .NET Development how to change ms access database password in c#?

  hi, how to change the ms access database password in c# i search through the web and found one in VBA but not in C#. http://support.microsoft.com/kb/170961 Please give some hints. Thank you. regrads, chunket Thank a lot. I'm sorry, I forgot about "specific" qoute "`" in Access. ALTER DATABASE PASSWORD `currentpassword` `` - set password ALTER DATABASE PASSWORD `newpassword` `currentpassword` - change password ALTER DATABASE PASSWORD `` `newpassword` - clear password All work fine. Which limit for passord (length, symbols) (when I test I can create password with 20 symbl.) ...Show All

• SQL Server Installing SQL Server 2005 Reporting Services

  Dear All, I've installed SQL Server 2005 Management Studio Express on my computer from http://msdn.microsoft.com/vstudio/express/sql Now, I would like to get SQL Server 2005 Reporting Services and Business Intelligence Developer Studio. Can I go ahead and install " SQL Server 2005 Express Edition with Advanced Services" provided on the above link My question is, " SQL Server 2005 Express Edition with Advanced Services" comes with SQL Server 2005 Management Studio Express that I already have on my computer. When I install " SQL Server 2005 Express Edition with Advanced Services" , does it impact SQL Server 2005 Management Studio Express that I already have on my computer Do I have to uninstal ...Show All

• Windows Forms IndexOutOfBoundsException when data is updated

  I'm having issues with my datagridviews. I have my application listening to events and updating its data tables based on them. I'm not providing any user interactivity and I have no use for any selection, but I have no idea how to turn that off. The reason is - as these things are being updated, I'm having the views die off, because (at least this seems to be how it's going down) the datagridview is trying to select a row that was just deleted as it was updated. It's giving error boxes at runtime saying row X doesn't exist when it's being selected. Is there some way I can prevent them from ever trying to make that selection If not, how can I at least go about preventing that from killing off my datagridviews ...Show All

• .NET Development Regex group

  Hi I'm making a little test building a search application using regex and some other stuff. This is one of the groups in my regex pattern: ( <atta>\\d{4}) The problem is i dont want the value to be 4 only, i need it to be able to find it at that spot even if it is 8, 9 or 10 instead. After doing some reading i saw that there is something you can write like {4+} so that is can be atleast 4 or more. But can't get it working, Anyone can help me What i do is that i got this line in my textfile: 00   296    30079    070109   14:00:00      4078          &nb ...Show All

• SQL Server Integrated Security with local SQL & IIS

  I have SQL RS running on a Win 2K (dev only) machine with IIS on the same local machine. I am trying to access the reports from another computer, but am getting an error An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source '<Shared Data Source Name>'. (rsErrorOpeningConnection) Get Online Help Login failed for user '<DOMAINNAME>\Guest'. IIS and the Datasource are setup for integrated security and the Datasource is aimed at the local SQL DB. Anonymous access is turned off in IIS and it prompts for the login info when trying to access it via the web. My understanding is that this should work without problems due to IIS & SQL ...Show All

• Visual Studio 2008 (Pre-release) XmlDataProvider, TreeView, databinding and inserting new XmlNodes

  Problem Summary : I want to see newly inserted XmlNodes appear on a TreeView that's bound to an XmlDataProvider. Background: I have an XmlDataProvider and I setting its Document to a programmatically created XmlDocument. (The actual XML is coming from a database.) I'm binding this to a TreeView. It looks something like this: ... < XmlDataProvider x:Key = " MyXmlData " /> ... < TreeView x:Name = " MyTree " ItemTemplate = " {DynamicResource MyHierarchicalDataTemplate} " > < TreeView.ItemsSource > < Binding Mode = " Default " Source = " {StaticResource MyXmlData} " XPath = " /MDocDefinition/* " /> </ TreeView.ItemsSource &g ...Show All

• Visual Studio 2008 (Pre-release) Reading Bitmap Pixel Colors very fast; Mixing WinForms and WPF

  Hello, we're creating an application for controlling robots; as a base of calculation for the movement of the variuos axis of a robot it is necessary to read the pixel colors from parts of certain bitmaps pixel by pixel . Those bitmaps are 24bit or 32bit bmps. Since I havn't done anything with WPF yet - is such an actually simple operation possible We can't use GDI+ for that, since it's too slow, and we don't want to use GDI, since it's not managed. One other question: Is it possible to mix "old" WinForms 2.0 Aps with WPF So for example have an old form where only a certain area is rendered with WPF functionality Thanks, Klaus   Hi Klaus, There are Imaging Interop APIs that le ...Show All