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

More Search Options

RSS Available

• Re: Problem with dates in Dataset Select statement

  I never used the query designer. So I cannot give you any suggestion on that. Regarding get the today's date, since it is used to build the query, so you shoudl use the sql function: GetDate().

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by chunshahab on 3/15/2007

• Re: Can't get On_Inserted event to fire?

  e.Command.Parameters["ID"] should work. You don't have to loop through the entire collection. Just pull th eone you need.

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/15/2007

• Re: URGENT - Assigning the label value in code behind design by reading database

  Try this: MyReader.Read(); String V_Name = (String)MyReader["Name"];

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: Can't get On_Inserted event to fire?

  CREATE PROCEDURE dbo.CompanySubmit ( @CS_CompanyName nchar(100), @id int OUTPUT ) AS INSERT INTO [tblCompanyInfo_Submit] (CS_CompanyName) VALUES (@CS_CompanyName); SET @id = @@IDENTITY I did not test it. You see the drill.

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: Can't get On_Inserted event to fire?

  CREATE PROCEDURE dbo.CompanySubmit ( @CS_CompanyName nchar(100), @id int OUTPUT ) AS INSERT INTO [tblCompanyInfo_Submit] (CS_CompanyName) VALUES (@CS_CompanyName); SELECT @@IDENTITY AS 'LastCompnay' SET @id = @@IDENTITY I did not test it. You see the drill.

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: Can't get On_Inserted event to fire?

  You can add a Out parameter to you SP and then assign the @@identity to the out parameter Then in your code, after you execute the Sp, read out the output parameter and assign it to the text box Hope this helps.

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: Include All if Parameter Value Null?

  Yes. You can create a Stored Procedure for this and compose your sql statement within your stored procedure based on the parameters. You also can compose the same sql statment in your code file. Both uses the same logic. Bottom line, you need to based on the user's selection and figur out the correct where clause. Here is the piece of code you can use in your stored procedure. Declare @sql nvarchar(4000) , @where nvarchar (4000) SET @where = '' SET @sql ='Select * From Table ' if (@location IS NOT

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by chunshahab on 3/14/2007

• Re: How can show LAST page of gridview first

  On page load, set the PageInex of GridView to your last page.

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: Can't get On_Inserted event to fire?

  Yes. It is OnIIemInserted event: protected void DetailsView1_ItemInserted( object sender, DetailsViewInsertedEventArgs e) { } This is for SqlDataSource OnInserted: protected void SqlDataSource1_Inserted( object sender, SqlDataSourceStatusEventArgs e) { } I think your problems are: 1> You should not use On_Inserted as the event handler's name, it is used by SqlDataSource. That why it complains. 2> If you want to put the event handler on SqlDataSource, you should use SqlDataSourceStatusEventArgs

  Posted to Data Presentation Controls (Forum) by chunshahab on 3/14/2007

• Re: getting null reference exception

  Check whether this "UserNameListBox.Items.FindByText(SelectedUserName)" returns the item. My guess is it did not find the item.

  Posted to Getting Started (Forum) by chunshahab on 3/14/2007