Search results for query: *

I am trying to understand temporary tables that begins with # With a simple query the creates a query and drops a query. This work Okay. CREATE TABLE [#TEMPTABLE]( [CardboardID] [int] NOT NULL, [BuntchID] [int] IDENTITY(1,1) NOT NULL, [FirstSerialNumber] [int] NULL...

I have done an application that the users scan the FirstSerialNumber and LastSerialNumber I have to keep track of the LastSerialNumber is comes in order with the FirstSerialNumber that is scanned. If the LastSerialNumber is 99926 Then the FirstSerialNumber should be 99927. After the number...

I have this SQL that work good. SELECT CASE WHEN MAX(B.LASTSERIALNUMBER) - MIN(B.LASTSERIALNUMBER) > 5000 THEN MIN(B.LASTSERIALNUMBER) ELSE ISNULL(MAX(B.LASTSERIALNUMBER), 0) END AS LastSerialNumber, ISNULL(MAX(TB.LASTSERIALNUMBER), 0) FROM ASSIGNMENT A LEFT JOIN CARDBOARD CB ON...

I have to created a vb.net windows application. I would like to have this application to be a web application. Is it possible for me to convert it to a web application? George

I am trying getting the Max(LastSerialNumber) of a specific scanningstatationid I want to get the max of lastserialnumber for scannningstationid = 2. But I am also getting the max of lastserialnumber for scanningstationid 1. I dont want the max value for scanningsationid is 1 The value that I...

I want to get all table loop them throug and the drop them DECLARE @TABLES AS VARCHAR(100) DECLARE TEMPTABLE_CURSOR CURSOR FOR SELECT [NAME] FROM SYSOBJECTS WHERE NAME LIKE 'TEMP%' AND OBJECTPROPERTY(ID, N'IsTable') = 1 OPEN TEMPTABLE_CURSOR FETCH NEXT FROM TEMPTABLE_CURSOR INTO @TABLES...

I have this code to validate a login to a Active Directory. Private Function ValidateActiveDirectoryLogin(ByVal Domain As String, ByVal Username As String, ByVal Password As String) As Boolean Implements IActiveDirectory.ValidateActiveDirectoryLogin Dim Success As Boolean = False Dim...

I want do dynamically show a crystal report. Now I have to create a form a add a CrystalReportViewer to the form. I tried to create i dynamically but it doesn't work. Imports CrystalDecisions.Windows.Forms.CrystalReportViewer Imports CrystalDecisions.Shared Private WithEvents crview As New...

Now I am in the right forum. :-) I am trying to use a ttx file using Visual Studio 2005. I have nothing under "More data sources" to select. Is this option removed in Visual Studio 2005? I used to use ttx files with Visual Basic 6.0. /George

I asked same question at "Business Objects: Crystal Reports 4 Other topics" but I think it was in the wrong forum. I think is right. I am trying to use a ttx file using Visual Studio 2005. I have nothing under "More data sources" to select. Is this option removed in Visual Studio 2005? I used...

I am trying to use a ttx file using Visual Studio 2005. I have nothing under "More data sources" to select. Is this option removed in Visual Studio 2005? /George

I have a treeview that I build the database when my application is loaded. If the user adds a new customer then I have to Call refTreeview to show them the new added customer. If I call refTreeview I want to be able to expand the menu that the user has expanded. My Code Public Sub refTrevieew()...

I want to get the date from the daynumber. Today daynumber is 317 so I want to get 2007-11-13 Does anybody know how I can return date from a daynumber? George

I am using a gridview. Many things are working great. RowEditing, PageIndexChanging, RowDeleting, RowUpdating but not the Sorting. I have been googling a and trying sense last night but I cant get it to work. So I hope anyone here could help me. I am using a DataSet to bind to the data This is...

I have always worked with DataReader and It have worked fine, but know I forced to use DataSet. I have google around a little. With this simple sql question the The DataSet is filled from everything from the "Employees" table Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data...

I am trying to get a value from gridview when trying update a row. I press edit on the gridview and then type som new information on the textbox and then click update. On RowUpdating I am trying to catch to the new value that I has entered and then click update. But I am getting the old text...

I would like to type this to C#. I am new to C# but know VB.NET Protected Sub GridProjects_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridProjects.RowUpdating Dim empid As String empid =...

I want to get the current selected row from a DataGrid. I am using C1flexgrid from ComponentOne and I want to get the current row that is selected. When I have found the SelectedIndex. I want check if a column has the value "ERROR" How would I set the X variable to the current selected row...

I have table and I have 2 columns that are very important and those column are FirstSerialNumber and last LastSerialNumber The firstserialnumber should begin with last serialnumber + 1. If you could se with this example below this is okay. FirstSerialNumber LastSerialNumber 24888...

I have an Imagebutton and what to set set text right on the image? <asp:ImageButton ID="ImageButton1" runat="server" Height="22px" ImageUrl="~/ads.gif" Style="z-index: 104; left: 35px; position: absolute; top: 343px" Width="186px" /> How could I do that?