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

More Search Options

RSS Available

• Re: Onrowcreated

  Many many thanks Kpyap. Let me check it first for not seeing the records.

  Posted to Data Presentation Controls (Forum) by wmec on 12/3/2009

• Re: Onrowcreated

  Kpyap, great appreciations to your forever help! Currently I got stuck by this emptytemplate problem!

  Posted to Data Presentation Controls (Forum) by wmec on 12/2/2009

• Re: Can I use database tiggers in SQL 2005 express or SQL 2008 express?

  it's supporting that. Here I've created one. Can you open management studio? USE [my_schema]; GO SET ANSI_NULLS ON; GO SET QUOTED_IDENTIFIER ON; GO create trigger [trg_te] on test_table WITH ENCRYPTION after update as begin DECLARE @out_desc varchar(1000); end; go

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wmec on 12/2/2009

• Re: Trying to figure out how to set up a connection string.

  [quote user="ryguy7272"] Am trying to figure out the same thing here: view plain copy to clipboard print ? // Returns a DataTable with the set of data in the albums table public static DataTable GetAlbums() { // Connect DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings[ "SqlConnStr" ])) { // Just have the adapter fill the table SqlDataAdapter adap = new SqlDataAdapter( "SELECT *," + "(SELECT COUNT(*)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wmec on 12/2/2009

• Re: Can I use database tiggers in SQL 2005 express or SQL 2008 express?

  you can run my codes in the way you execute one query. within the explorer, right-click the first object there and choose 'New query'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by wmec on 12/2/2009

• Re: How to synchronize data of different oracle database ?

  [quote user="anup_phansa"] Hi all I am using oracle database, Database db1 Table: tlbdb1_City1 Database db2 Table: Tlbdb2_City2 I want to synchronize data of tlbdb1_City1 to Tlbdb2_City2 How it is possible, change of tlbdb1_City1 is automatically update at Tlbdb2_City2 Regards Anup [/quote] you can have 3 triggers for update/delete/insert on tlbdb1_City1 to automatically apply the change to Tlbdb2_City2 Here is one example An AFTER INSERT Trigger means that Oracle will fire this trigger

  Posted to Oracle (Forum) by wmec on 12/1/2009

• Re: Is there a performance gain with specifying schema info with SqlDataSource Commands?

  [quote user="newbie2C#"] I'm using a SqlDataSource for a details view that uses stored procedures for the update and delete capabilities. I noticed in the SSMS that my stored procedures had schema info as a prefix on the objects. This was like this: dbo.spMyStoredProcedure. My details views delete and update capabilities work with out doing this, but I'm wondering if my app would perform better with this schema info included. This would be like: DeleteCommand="dbo.spDeleteStoredProcedure"

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

• Re: Onrowcreated

  Any advice?

  Posted to Free For All (Forum) by wmec on 12/1/2009

• Re: Can I use database tiggers in SQL 2005 express or SQL 2008 express?

  certainly yes. take this - SQL Server 2005 Express Edition with Advanced Services SP3, from the link below then you'll have the management studio http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx

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

• Re: Onrowcreated

  Many many thanks Kpyap. But if I am able to run this form then there should be no problem for the tags. Any advice for my previous questions?

  Posted to Free For All (Forum) by wmec on 12/1/2009