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

More Search Options

RSS Available

• Re: Using a datatable in sql

  Lori Thanks for the post, I have also come to the same conclusion that the one SQL would be best so I have done that and it now works well. Nice to be reasured with your answer.Thanks again

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by crippsy on 12/18/2006

• Re: Using a datatable in sql

  Though I had it from looking at http://forums.asp.net/thread/969353.aspx and http://forums.asp.net/thread/721035.aspx and so I used dbo. Mydatatable However, this did not work, but could it be along these lines? If so what would I replace dbo with ?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by crippsy on 12/12/2006

• Re: Using a datatable in sql

  Thanks for the info , however..... In the actual code is a space between Inner Join I have also tested the Mydatatable by binding it to GridView2. by using thefollowing source. which does work GridView2.DataSource = Mydatatable GridView2.DataBind() But the SQL statement comes back with Invalid object name 'Mydatatable' any more suggestions?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by crippsy on 12/12/2006

• Using a datatable in sql

  Hi I am trying to use the results of a datatable as an input to a ne SQL statement. The datatable is created and populted by the source below after previously creating MyLookupCommand MyLookupReader = MyLookupCommand.ExecuteReader(CommandBehavior.CloseConnection) Dim Mydatatable = New DataTable() Mydatatable.Load(MyLookupReader) I now create a new SQL string allong the lines of SELECT tableA.field1 FROM TableA INNERJOIN Mydatatable ON tableA.field2 = Mydatatable.Filed9 However I get the following

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by crippsy on 12/11/2006

• Re: specified cast is not valid

  Many Thanks for that. It was not as obvious as I first thought. great help

  Posted to Web Forms (Forum) by crippsy on 12/10/2006

• Re: specified cast is not valid

  Thanks for looking at this joe. It was much along my line of thinking as I had already tried that as one of my options. I have also checked to ensure that the data field is a GUID/Uniqueidentifier, which it is. I have looked at the value in the session field and it is a GUID formatt. Any other suggestions?

  Posted to Web Forms (Forum) by crippsy on 12/10/2006

• specified cast is not valid

  I get the "Speciifed cast is not valid" error when I run the following code Label3.Text = Session( "selectedCategory" ).ToString Dim selectcatguid As Guid selectcatguid = Session( "selectedCategory" ) '------------- This line cause the error. I have put the first line in to assure me that it is a GUID Any ideas, it seams that it should be so simple.

  Posted to Web Forms (Forum) by crippsy on 12/10/2006

• Re: Splitting the gridview

  Many thanks, just the job.

  Posted to Data Presentation Controls (Forum) by crippsy on 12/9/2006

• Splitting the gridview

  How is it possible to create a gridview that looks something like the ASP.Net forums page http://forums.asp.net/ In a cell I am looking to have two data fields : Title as a link with the description underneath or if you look at the last post column in http://forums.asp.net/ it has 3 fields: "last post ", "who by" and "time/date" Or is gridview not the right tool to do this and I should look at something else many thanks in advance

  Posted to Data Presentation Controls (Forum) by crippsy on 12/8/2006

• Re: GridView1.SelectedValue

  Cheers, it works now

  Posted to Data Presentation Controls (Forum) by crippsy on 12/6/2006