BilalShouman's Q&A profile

• SQL Server New Subscriptions

  When I go to the "My Subscriptions" screem in the Report Manager, I don't get a " New Subscription" option. I am running SQL Server 2005 Developer's version, as a domain administrator with every role function enabled. How do I get access to this functionality ...Show All

• SQL Server T-SQL overlapping time

  I have a table with following fields CURRENT_DAY FROM_DATE TO_DATE 1 1899-12-20 09:00:00.000 1899-12-20 10:00:00.000 1 1899-12-20 09:50:00.000 1899-12-20 11:00:00.000 1 1899-12-20 12:00:00.000 1899-12-20 02:00:00.000 I need the count of records that overlap with each other. [OR] 1 if there is overlap, 0 if there is no overlap. I am new to sql, thanks for any help. Yog I used the cross join, but its slow..i am sure there is a better way of doing this..not getting the idea. SELECT count(*) FROM TABLE1 S1 CROSS JOIN TABLE1 S2 WHERE ( S2.FROM_DATE BETWEEN S1.FROM_DATE AND S1.TO_D ...Show All

• SQL Server TOP 5 returning 10 ???? :(

  Okay here is my delema.. I have a embedded chart in a table that returns that is set up to return the top 5 of it's sub-children... got me So if i look at info of the datas' children i see Parent Data Infoasd Count Pdataasd,asd,as,d 123 134 Get these top 5 for chart -----------> Child Data Count Infower 56 Infower 43 Infower 23 Infosadew 2 Infoasd 2 Infoasdui 2 Infoasda 2 Infodasdas 2 Infoqweqw 2 Now as you can see at row 4 on the child data the count is 2 and then 2 and then ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. The values used in the attempt to create the GraphicsDevice were invalid.

  Is this because my graphic card does not support shader model 2 I didn't even know of this requirement till I saw it on the readme file. Time to change my geforce4 What type of card do you have We should be giving a better exception message than that (i.e. we check for lots of things and throw better exceptions but that one must have slipped through.) ...Show All

• Visual C# Thread

  I have a problem with my server application. When I run it and look in the windows task manager, it seems like there is only one application running. But when i'm closing it down, it's stille running in the background. Here is my code: public partial class ServerForm : Form { private TcpListener server = null ; private Thread serverThread; ArrayList BestiltView = new ArrayList (); public ServerForm() { InitializeComponent(); serverThread = new Thread ( new ThreadStart (serverstart)); //serverstart(); serverThread.Start(); } public void serverstart() { try { // Set the TcpListener on port 5000. int port = 5000; IPAddress localAddr = IPAddress .Parse( "130.225.1 ...Show All

• SQL Server What is wrong with query?

  I need help on my query please. I get the following error : Incorrect syntax near keyword 'As' Here is my query: Create Table Temp_Total As ( SELECT RIGHT( '0000000000' + REPLACE ( CONVERT ( VARCHAR ( 10 ), Total ), '.' , '' ) , 10 ) FROM [Transaction] ) Thanks Denis, I am trying to create a temp table for my select query. What you see is a small part of the query and I do not know if that is the right thing to do. I will be creating a temp table and then populate the info with my select query and then retrieve info from that and then drop the table. I do not know if that is the right way to go about doing it, maybe create a view and get my info from that. What do you suggest ...Show All

• Windows Forms Disable Close button on the form

  Hello; I have searched the forum, but could nof find the answer for this question. Is it possible to disable the X button on the form, as I need to be able to minimize the form, and it also have a button wich hides the form from the screen (not the minimize button), but this form must not be closed by user in any condition. Best regards. (Moderator: Thread moved to this forum for better responses) Hi verynoisy you can try this .ControlBox = false ; if you want all buttons disappear. ...Show All

• Visual C# how to add custom control to datagrid cell

  hi i carated custom control, how can i embeded that contol to datagird cell oh... you used third party software. To extend this, you should read the product documentation. normally, in the datagrid from .net framework 1.x, to create custom control, you should inherits from System.Windows.Forms.DataGridColumnStyle class. ( In this class documentation, there is a example how to extend it.) I hope it'll help you, soemoe. ...Show All

• Windows Forms Combo Box Binding Problem In Navigation

  hi everybody, i have a combo box and during the desing time itself i bind it to a dataset and it works fine loads the data and populates in the combo box, for eg : Data In My Combo Control Algeria, Australia, America, Botswant, Belgium, When the form loads i have to select any one of the above, the problem is when i press 'a' in my keypad algeria comes, but for the next press of 'a' Australia should come right, but its not navigating to Australia, keeps still in the Algeria itself..! Need Helps.... Regards, Prasenna. K Hi, Prasenna Have a try at this code: private void General_Load( object sender, EventArgs e) { this .comb ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I set the color for CustomVertex.Transformed?

  When I use CustomVertex.TransformedColored.It have a color proprtty. So I can easy set the color for every point. But because I want to draw a lot of triangles using same color. so I use CustomVertex.Transformed in order to save the memory.but when I draw they.(ps:use DrawIndexedPrimitives()) .It show white color. Please someone tell me how to set a color for every triangles . Since pre-transformed coordinates do not use lighting, you will have to apply your color using the texture blending stages. Try this: device.RenderState.TextureFactor = (int) 0xff0000; // RGB 255,0,0 device.TextureState[0].ColorOperation = TextureOperation.SelectArg1; device.TextureState[0].ColorArgument1 = TextureArgument.TFactor; ...Show All

• SQL Server assigning datepart function to a datetime variable?

  I am getting wrong output when assigning a datepart function to a variable. I should get 2006 but instead I get an output 1905. Below is the code and output. Any help will be greatly appreciated. Thanks DECLARE @FiscalStartCurrYear datetime SET @FiscalStartCurrentYear = DATEPART ( year , GETDATE ()) select @FiscalStartCurrYear Output ----------- 1905 - 06 - 30 00 : 00 : 00.0000 This should work:   SELECT DATEADD ( year , DATEDIFF ( year , 0 , GETDATE ()), 0 ) -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < Rob68@disc ...Show All

• .NET Development Compiling ASP.NET projects on x64

  What are the basic steps involved in compiling to x64 for ASP.NET 2.0 In Configuration Manager I've created a Solution Configuration of "Debug x64" and set the Active Solution Platform to "x64". I've set the Configuration and Platform dropdowns on all the projects to the above and checked the Build checkbox on all of them. A Rebuild All skips all my assembly projects but then attempts to build the website which then fails because its assembly dependencies have not been built. Why is it skipping my assemblies Can it not find the 64-bit version of the .NET framework on its own, or do I have to set that somewhere Thanks, Terry Ken -- thanks! Does this "force" the 32 bit mode, ...Show All

• Microsoft ISV Community Center Forums Restrict editing of activity based on date comparison

  Hi (again!) thanks to the help of many forum members i have built a system for our users.  I have a facility that allows users to do an end of month submission and it writes the date selected into a field called 'datelastsubmitted' in 'tblusers'.  the reason i am doing this is that i do not want users to then be able to go in and edit any activity that they have entered prior to that 'datelastsubmitted' value.  When they open up an activity to edit (as opposed to creating a new one) i want to be able to restrict them from editing the activity if the 'datelastsubmitted' value is more recent than the 'activitydate' value.  this form is based on a query between linked tables so datelastsubmitted and activitydate are a ...Show All

• Visual Studio Express Editions Adding more than one record

  I can't seem to add more than one record at a time. If I want to add another record after the last record added, I have to go out of the programme completely and re-run my programme. If I don't, an exception is thrown, any ideas why this is happening Here's my code below: Private Sub btnSave_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim newVenueRow As WhiteboardDataSet.VenueRow newVenueRow = Me .WhiteboardDataSet.Venue.NewVenueRow() newVenueRow.VenueName = txtVenueName.Text newVenueRow.description = txtDescription.Text Me .WhiteboardDataSet.Venue.Rows.Add(newVenueRow) Try Me .Validate() Me .VenueBindingSource.EndEdit() Me .VenueTableAdapter ...Show All

• Visual Studio Where to find the .AddNamedCommand(); .Commands ; .CommandBars Infomations

  Hi, I am quiet confusing about the conceptual design to the Commands and CommandBars. is there any information descript the relationships I am adding a new menu item , I can find there are types of API can do so, one is from .AddNamedCommand() but I have no ideal about the API help, and how to control it more detail. so, I am using the CommandBars object model, find a CommandBarControl object , add one in .Controls propety. but, I think there should be more precise different in thos two Object models Am I right can any help to provide more info thanks one is what Hi, See my article HOWTO: Adding buttons, commandbars and toolbars to Visual Studio .NET from an add-in at: http:// ...Show All