You searched for the word(s): userid:746063

More Search Options

RSS Available

• Retrieve data from LoginView

  I'm having trouble retrieving the data from a listbox I have located in a LoginView Template. Thanks in advance. *************************** Protected Sub UploadButton_Click( ByVal sender As Object , ByVal e As System.EventArgs) Dim SQLCon As New Data.SqlClient.SqlConnection SQLCon.ConnectionString = ConfigurationManager.ConnectionStrings( "QuoteSysConnectionString" ).ToString() SQLCon.Open() Dim SQLCmd As New SqlCommand Dim My_bidno As Integer My_bidno = LoginView1.loggedIn.Template

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mrgasp07 on 10/8/2009

• Re: Select Statement Parameter

  SELECT DISTINCT sonumber, reqdate FROM [Your Results] sonumber reqdate 0001 06/07/09 0002 06/08/09 0003 06/09/09 0003 06/10/09 0003 06/11/09 I would like it only display the next req date for the sonumber. (Top 1, ASC ????) sonumber reqdate 0001 06/07/09 0002 06/08/09 0003 06/09/09 Thanks in advance

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 7/1/2009

• Select Statement Parameter

  SELECT DISTINCT [Your Results].sonumber, [Your Results].company, [Your Results].custnumber, [Your Results].sodate, jobdata.dept, jobdata.status, jobdata.ID, jobdata.notes, jobdata.sonumber AS Expr1, [SO total query].SumOfextprice, [Your Results]. reqdate FROM (([Your Results] INNER JOIN jobdata ON [Your Results].sonumber = jobdata.sonumber) INNER JOIN [SO total query] ON jobdata.sonumber = [SO total query].sonumber) **************************************** The above statement works fine. I would

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 6/26/2009

• Re: Update Statement syntax

  got it! Had the pieces of the puzzle, just in the wrong place. thanks < asp : AccessDataSource ID ="AccessDataSource1" runat ="server" DataFile ="~/mqasjl.mdb" SelectCommand ="SELECT DISTINCT [Your Results].sonumber, [Your Results].company, [Your Results].custnumber, [Your Results].sodate, [Your Results].reqdate, jobdata.dept, jobdata.status, jobdata.ID, jobdata.notes, jobdata.sonumber AS Expr1 FROM ([Your Results] INNER JOIN jobdata ON [Your Results].sonumber

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 6/11/2009

• Re: Update Statement syntax

  It's not grabbing the data from the gridview. If I use the GUI and execute the query and add data manually it updated the table fine. It seems it's not grabbing the WHERE (sonumber = ?). Both tables contain sonumber field.

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 6/11/2009

• Re: Update Statement syntax

  < UpdateParameters > < asp : Parameter Name ="sonumber" Type ="Double" /> < asp : Parameter Name ="status" Type ="String" /> < asp : Parameter Name ="notes" Type ="String" /> < asp : Parameter Name ="dept" Type ="String" /> < asp : Parameter Name ="original_ID" Type ="Int32" /> This help?

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 6/11/2009

• Update Statement syntax

  I'm pulling data from 2 tables and trying to update 2 fields in the jobdata table. WHERE clause might be confused? No error, just nothing happens. Thanks in advance. DataFile ="~/mqasjl.mdb" SelectCommand ="SELECT DISTINCT [Your Results].sonumber, [Your Results].company, [Your Results].custnumber, [Your Results].sodate, [Your Results].reqdate, jobdata.dept, jobdata.status, jobdata.ID FROM ([Your Results] INNER JOIN jobdata ON [Your Results].sonumber = jobdata.sonumber)" UpdateCommand

  Posted to Access Databases and AccessDataSource Control (Forum) by mrgasp07 on 6/11/2009

• Re: Add another parameter to Where clause in trigger

  Got nevermind.. or bidmast . bidstat = 'Change'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mrgasp07 on 1/16/2009

• Add another parameter to Where clause in trigger

  The below trigger works great. I would like to add the bidmast.bidstat = 'Change' not sure on the syntax. where bidmast . bidstat = 'Quoted' OrElse bidmast.bidstat = 'Change' ??? Thanks in advance.... -------------------------------------------------------- ALTER trigger [dbo] . [maintrev] on [dbo] . [bidtran] for update as begin if update ( rqdate ) or update ( qtyord ) or update ( price ) or update ( descrip ) or update ( material ) or update ( prodsrvs ) begin update bidmast

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mrgasp07 on 1/16/2009

• Re: Help with SQL Trigger

  It worked Perfect thanks!!!!!

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by mrgasp07 on 1/16/2009