HI,
How can I programmatically change the properties of Send Mail task using Script Task. I want to change the From, To and Attachment parameters of the Send Mail task.
If the Script Task can't do it, Is there any alternative to do?
Thanks
All those questions are answered here: http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx
-Jamie
Hi,
say I have two Sqldatasources objects:SqlDataSource1 and SqlDataSource2...
Does anybody know how can I alter programmatically these two sqldatasources in a gridview?
Thanks!!!
Ok,I resolved it,
I had to delete the "DataSourceID="SqlDataSource1" from the gridview directive and add the following code to a button event:
GridView1.DataSource = SqlDataSource1
GridView1.DataBind()
|||But now my new question is :
How can I see what is the current/previous DataSource of my GridView Control?
Thanks...
|||GridView1.DataSource will return the data source (as an object)
You can also useGridView1.DataSourceID to obtain the ID of the datasource as a string
For example:
dim TheCurrentDataSource as object
TheCurrentDataSource =GridView1.DataSource
GridView1.DataSource = The NextDataSource
GridView1.DataBind()
HTH
How can i programmatically via Tsql change the datatype of all the columns of a table to varchar(1000)?
Like I have a table employee
Employee
(
colA int
colB int
colC varchar
)
If i run the tsql..
it should give me
Employee
(
colA varchar
colB varchar
colC varchar
)
Is the table empty? If not, what is the disposition of the data that is already in the table?
|||Well you could try using a change script generated by Enterprise Manager, like this one:
Code Snippet
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_Employee
(
ColA varchar(1000) NULL,
ColB varchar(1000) NULL,
ColC varchar(1000) NULL
) ON [PRIMARY]
GO
IF EXISTS(SELECT * FROM dbo.Employee)
EXEC('INSERT INTO dbo.Tmp_Employee (ColA, ColB, ColC)
SELECT CONVERT(varchar(1000), ColA), CONVERT(varchar(1000), ColB), ColC FROM dbo.Employee (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.Employee
GO
EXECUTE sp_rename N'dbo.Tmp_Employee', N'Employee', 'OBJECT'
GO
COMMIT
Please don't use the graphical tools to make schema changes. It can generate scripts that are inefficient and unnecessary. You can just use ALTER TABLE to change the column from int to varchar in this case. If you do use the tools then please make sure to review the scripts because there is lot of things that can be simplified or improved. For example, in above case there is no reason to do CREATE TABLE and INSERT. You can do SELECT...INTO - this can perform minimally logged operations & can run magnitudes of time faster.
