redneon's Q&A profile

• SQL Server Getting results with stored procedure from single textbox searching table with multi columns

  I admit I am a novice to queries and stored procedures but understand stored procedures are more secure, so I am choosing to challenge myself with a stored procedure and have not been successful at all. What I am looking for is a stored procedure which would query the single table named Hospital, which would search from a single textbox the end user would enter the text they are searching for on a Windows VB application but is dependant on a few end user selected items. 1. The end user can select a radio button either "Starts with" or "Contains" 2. The end user can select from 6 checkboxes (Hospitals, Address, City, State, Zip, Type) to limit or expand their search from the columns in the table. The table has ...Show All

• .NET Development .NET 1.1 vs .NET 2.0 behaviour with Image fields

  In not .NET 1.1 and 2.0 the System.Type mapping for a SqlDbType of Image is byte[]. If you use this type to create a SqlParameter (with a value of DBNull.Value) and then use this in a SQL statement of the form "Update table Set ImageField = @parm where ......" Then in .NET 1.1 it works, but in 2.0 you get an Exception "nvarchar is incompatible with image" How can you determine the correct System.Type to use for Image fields, and why is the behaviour now different The application code is generic and not tied to specific database designs. Thanks Tony Here is my sample code which will generate the error. Create a table with an image field, and update the ...Show All

• .NET Development connect WinForm via internet to database

  Hey, i have created a winform, and connected it to my database. The next step is to connect my winform to the database over the internet, so clients can download my winform and access the database from their computer. I have no idea what i have to do to the database to make it available over the net, and i have no idea how to connect to it. I imagine its using SOAP, however, i can't find anything on the internet where sumone has done sumthing similar. This is for my final year project, if you need me to explain a little more then i can as i am in desparate need of help! Cheers, Simon. Also break your problem down...don't ask for the world in one post. MSDN is a great resource but there are those who try to get people to write their co ...Show All

• SQL Server Bug? Report Builder returning only unique records!

  Our users use Report Builder for writing ad-hoc queries. They have run into a problem where Report Builder is returning only distinct records is the entities unique identifier is not added to the report. Example: TransID Type TransQuantity 1 CS 4 2 CS 4 3 CP 2 4 CN 3 Adding the above fields to the report builder canvas will return 4 rows. However, if I were to add only Type and TransQuantity to the canvas as such, Report Builder will only return 3 rows: Type TransQuantity CS 4 CP 2 CN 3 Is there any way to have Report Builder return the actual number of records Our users often will export the results from Report Builder into Excel to slice and dic ...Show All

• Visual Studio Team System Script INSERT statements for static data?

  Hi, Following scenario - after importing database schema to VSTS4DB, I want to create a new static table called Countries with some data inside. I create a Table script (CREATE TABLE Countries ...) without a problem, and when I build I see the CREATE TABLE statement in the generated build script. I would like, however, to include also some INSERT statements, so that the static table can be filled with data as well. I tried to add a Script file to the solution, but whatever I write inside does not get included into the generated build script. If I include the INSERT statements directly in the Table script, they get ignored. How can I include INSERT statements into the generated build script It would be nice if there is a poss ...Show All

• SQL Server HELP HELP varchar

  I have a field type of "varchar" It can not accept to Store Arabic Characters!!! plus i can't change it into ntext or nvarchar my system which goin to export the data into SQL server by suing insert command will hang. so im stucked with varchar!!! here some sample of my data stored currently in My SQL SERVER 2000 " /   " Plzzzz help me if there any other way to do it Do you have the right collation set in your database Have a look in BOL (Books on Line) at COLLATE - there's a lot of info in there about how to deal with charachters from different languages and alphabets. /Kenneth ...Show All

• SQL Server SSIS

  I AM WANTING TO FIND THIS AND DOWNLOAD IT. and just to be clear, SSIS stands for SQL Server Integration Services, thus you will see " Integration Services " on that link with X transforms. ...Show All

• SQL Server Reading Drillthrough Report from SQL 2005 from Excel 2003?

  Hi all,         Previously our users used Excel 2003 with Cube Analysis Add-ins to drillthrough the OLAP reports in MS SQL 2000. Since then my company has migrated the database to MS SQL 2005 including the OLAP cube. Currently before the launch of Excel 2007, my users refused to use Excel 2007. Under such situation, is there a way I can configure my OLAP cube such that my users can read the drillthrough report in SQL 2005 using Excel 2003.         Thanks. You could try the Excel Add-in for SQL Server Analysis Services 1.5: http://www.microsoft.com/downloads/details.aspx FamilyId=DAE82128-9F21-475D-88A4-4B6E6C069FF0&am ...Show All

• Connected Services Framework Connecting WCF Services

  Hi, Is it possible to connect WCF services using CSF If it is, what are the guidelines How can I configure CSF using specific channel to access WCF service Thank you, Mark WCF with Ws* bindings are wire level compative with WSE messages and hence CSF messages. So we should be able to use WCF services with CSF. Please refer to Interporabiity of WCF for guidelines on selection bindings to make it interop with WSE3.0 services. ...Show All

• Visual C# I would like to display the same ListView control on all the tabs in TabControl

  How do I display the same ListView control on all the tabs in TabControl without duplicating codes Hi, you can use this code to move your ListView control to the newly selected tab whenever active tab page changes: private void tabControl1_SelectedIndexChanged( object sender, EventArgs e) {     tabControl1.SelectedTab.Controls.Add(listView1); } Andrej ...Show All

• Community Chat ImageListBox Control

  Hi, i hope i played this post right, if not i am sorry for that. I have written a little or more complex control called "ImageListBox", it has a more complex definition of an item than a normal ListBox. So every item can contain an image, header text and normal text. I wanted a much more attractive version than a normal ListBox, so i wrote it. I would like to hear your opinions about it and some bugs that maybe someone will find ;) http://www.thunder-development.de/typo3/index.php id=55 (Unless i dont know what to do exactly with it, it contains a "Demo" string, please dont get angry by this) CU Thunder2002 A stripped down version of the control with DEMO written in it (like you have ...Show All

• Smart Device Development is it possible to make pda as a video capturing machine?

  I want to make the pda to capture the video in live and then send back storage server in real time throught WiFi. In another word, I want to make the pda to become a wireless webcam As I've explained before, there's no unified API for camera before WM 5.0. So p lease call device manufacturer for video capture SDK if available. ...Show All

• Visual Studio Tools for Office VSTO Outlook Add-In ClickOnce Deployment!

  Hey guys, Got my outlook add-in working fine, building and installing works fine on all machines, but its such a pain in the arse when i change the smallest little thing, and a total uninstall is required on all machines, and then a re-install - but it seems so confusing to work the ClickOnce method. Can someone point me in the direction of some really handy articles anywhere, or step by step instructions on how to do it, and any common problem solvings Regards, Jay Have you tried testing it outside of modifying the setup project yet Basically publish your application. Then install it using your setup project then copy the .manifest file from your publish location and replace the one if your local installation's directo ...Show All

• .NET Development Calendar, Date and Time

  I have to create a chat project. I am working on chat admin page. I have to be able to let the user use the calendar to select the date from the calendar and also user will select the time to schedule a chat. This is quiet similar to the outlook calendar scheduling. with the start time and end time. How would i do this. Also how would i populate the time in the drop down list box with am and pm Is this something that i have to have the data in the database This is my first time. Could somebody please guide me through this I would sincerely appreciate your help. Thanks Where can i find this control I am using visual studio 2003. It is for web application. Also if you can show me or send me some ...Show All

• SQL Server How can I Remove the Screwed-up AdventureWorksDB in SQL Server Management Studio Express?

  Hi all, I downloaded AdventureWorksDB.msi Microsoft and struggled to install it in my SQL Server Management Studio Express 8 months ago. I forgot the AdventureWorks examples and other stuff were in my C:\ drive. Recently, I downloaded a new AdventureWork.msi and executed it to install without removing the old stuff from the "Add and Remove" of Control Panel. Now my AdventureWorks database is screwed-up in my termical PC that is linked with Microsoft NT 4 LAN System!!! Please kindly help and tell me how I can revome the scewed-up AdventureWorksDB in my terminal PC. Thanks in advance, Scott Chang Hi, Refer http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/SQLServerDatabasesAndSamp ...Show All