goldmine's Q&A profile

• SQL Server Dates

  Hi, I have date columns in my tables defined as smalldatetime. How do I perform a Select that will retrieve records with dates equal to the date selected in a calendar control as follows: < asp : SqlDataSource ID ="SqlDataSource3" runat ="server" ConnectionString =" <%$ ConnectionStrings:ReservationsConnectionString %> " SelectCommand ="SELECT [TIM_Time], [TIM_ID], [TIM_Valid_From] FROM [Times] WHERE ([TIM_Time] = @TIM_Time)"> < SelectParameters > < asp : ControlParameter ControlID ="Calendar1" Name ="TIM_Time" PropertyName ="SelectedDate" Type ="DateTime" /> </ SelectParameters > I ...Show All

• SQL Server Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• Visual Studio Express Editions geting numeric data in and out of text boxes

  Hello, Summary: How do I set up text boxes so that when I enter numeric text in one box (named X_Test_Input) , it will raise events that the other box (named X_Accel_Raw_Value) will collect/consume and display the data in that second box. Overview: This is my first attempt Windows programming. My goal is to collect six numbers from an embedded device over Ethernet (five to ten times a second) and display them on my computer so as to have them available for further processing. In dividing this into small steps, I first want to be able to get values from somewhere and display that data. Only after I get the basic windows display part of this working will I attempt to get the data from the embedded device. In my ...Show All

• SQL Server Report being generated never shows second report

    I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on.  The really strange thing is that I had this application working for about 3 months.  I even had up to 30 reports in 30 tabs at one point.  BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report.  Even worse, another user is able to run this application and DOES get all the reports displayed.  So what could have been updated on my PC that is causing this problem   Thanks in advance. ...Show All

• Windows Live Developer Forums Filtering Address based on Country in Virtual Earth

  Hi, I am working with Microsoft Virtual Earth. I want to show Adresss. I used VEMap.Find() method to find the address. I passed street name,houseno,city,zipcode,county,state and country informations to find the address. The problem is I got the address throughout the world which matches the address. But I want to filter the address based on Country entered. So pls kindly assist me to sort out the problem. Is there a method to filter the address based on country in Virtual Earth Help me. Thanks in advance. Hi, Sorry I re-posted the query by mistake. I used FindResults to show the location if it returns more results. If client accepts the idea which you said, then I will not populate the cities if more results a ...Show All

• Audio and Video Development Question about audio fingerprinting

  hi, The only information I can find about Audio Fingerprinting is in WM10 it is done using metadata and in WM11 it is waveform fingerprinting. I have tested that and its working fine. But is there any literature on fingerprinting and is there any API for fingerprinting (finding id3 tag, album art based on waveform fingerprint) Thanks, kalyan Audio Fingerprinting: When an ID3 tag for a song is missing, the first few seconds of the song is cut and it is compared with a database of songs stored in some server and the information about the song is identified. ...Show All

• Windows Forms Determining whether a control came from an inherited form

  Hello, I'd like to know if there is a way to determine if a control was added to an inherited form or was it inherited from a base form. I tried GetType but I couldn't figure out with properties/methods to use. Thanks, JR Dim myType As Type = BaseForm.GetType() Inside the loop if myType .GetField(ctrl.Name, BindingFlags.Public Or BindingFlags.Instance) is Nothing then   ' Control in inherited form else   ' Control in base form end if ...Show All

• Visual C++ [c++] array related problem (and wrong loop use)

  Hello, I have an mage black and white with 256 values of grey. The image is 256*256 therefore it will have 65 536 greyvalues in total, however its only 256 differents values of grey, so it should be store in one single array, lets say called "holdTheColourGrey [256].... where holdTheColourGrey[0] is the pixel totally black, holdTheColourGrey[1] is the pixel a bit less black... until holdTheColourGrey[255] is the white pixel. THe value inside that holdTheColourGrey[0] is the number of times this pixels exist, example if the image is totally black I should have 65 356 in that case!!! Get it Now im using visual c++ and that code that bugs: int histoArray[256]; int sumpixels; int a,b,i; //just counter va ...Show All

• .NET Development Publisher Policy to patch another Publisher Policy

  Is it OK to provide two publisher policy files for a single version of an assembly e.g.: PubPolicy 1.0.0.0 redirect to 1.0.0.1 PubPolicy 1.0.0.0 redirect to 1.0.0.2 How will the CLR loader respond to this Will it pick the latest version It would be nice if it worked this way since it would allow us to provide roll-up patches. I guess the other approach is to provide a redirect for the previous publisher policy file e.g.: PubPolicy 1.0.0.0 redirect to 1.0.0.1 PubPolicy 1.0.0.1 redirect to 1.0.0.2 This isn't quite as nice because it requires the 1.0.0.1 patch to be installed before the 1.0.0.2 patch can be installed. No, the first example will not work. You'll have to remember that publisher p ...Show All

• .NET Development More error info:

  I'm calling a remote server (client activated, hosted in WinForms app). A simple call without parameters (or with a simple string param) works fine. When I pass certain parameters, it crashes. Build is the remote class. This call to CreateBuildTree() works: Build prp = new Build (); prp.CreateBuildTree(); This one doesn't: Build prp = new Build (); string BuildDir = prp.GetBuildDir(); TreeNode root = new TreeNode (); root.Text = BuildDir; prp.CreateBuildTree(root, BuildDir); even when CreateBuildTree doesn't contain any code!!! public void CreateBuildTree() { } The error I get on the client side is "Server encountered an internal error. For more information, turn off customErrors i ...Show All

• SQL Server How to set ProhibitDtd in SSIS?

  Hi, I'm having a problem using XML-files as source for dataflow-task. On the source-editor for XML i chose the XML-file and the XSD-file. After clicking OK SSIS throws an error, saying I need to set ProhibitDtd in XmlReaderSettings to false, otherwise I'm not able to work with this file. Unfortunatley I dont know were I can set this option. Regards, Jan Wagner It sounds like your source XML file contains embedded DTD. If this is true, try to remove the DTD first. Regards, Yitzhak ...Show All

• Visual C# How to make an app with a parameter? like csc.exe and then you need parameters

  Hi! How can I make an app with a parameter like for example string.exe Hello would give the output hello. Matt You probably have the WebBrowser control on the main form (e.g. Form1). Either you pass arguments in the Form1's constructor from the Main method, or retrieve arguments from the Form1's Load event, like in the following example: private void Form1_Load( object sender, EventArgs e) { string [] args = Environment .GetCommandLineArgs(); string url = string .Empty; if (args.Length > 1) { url = args[1]; // First argument contains program name, so get the second one webBrowser1.Navigate(url); } } Andrej ...Show All

• Smart Device Development Smartphone 2003?

  Hi! I want to write a game for a Smartphone 2003 using .Net Compact Framework (C#). I would like this game to be multiplayer to using Bluetooth. Please tell me a simple way to do this! A sample Bluetooth chat application would be perfect. There's good Bluetooth support including chat samples in the http://32feet.NET library. ...Show All

• Visual Studio Express Editions Convert DayOfYear to Date

  Hello All I am seeking guidance in converting a DateTimePicker.Value.DayOfYear to Date. Outline 1). On a windows form enter the day number (production day) into a textbox and return the production Date in probably another textbox( ) If anyone could offer guidance that would be great! Mark Dim DayOfYear As Integer = Me . DateTimePicker1 . Value . DayOfYear Dim StartOfYear As Date = "#1/1/2006#" Dim MyDate As Date = StartOfYear . AddDays ( DayOfYear - 1) ...Show All

• Visual Basic Childform misbehaving? Ignoring location commands.

  I have used the following code to try to have to childforms appear in a parent form. However, when i run the program, the child forms do not go to the specified sizes nor locations. The only bit that assumes the control doesn't exist already is the bit where I call new on it. The code all assumes the control is not part of hte form yet, however. Naturally, you cannot cut and paste my code, it's creating an instance of a class I wrote ( that you don't have ). Substitute your own control name for the one I am creating. ...Show All