Wednesday, June 2, 2010

Cannot add diagram to SQL Server 2005 DB: Database diagram support objects cannot be installed because this database does not have a valid owner






Following error will be given...

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first sure the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set database owner to a valid login, then add the database diagram support objects.

Because of there is not set owner for this Database. To set this do the following....

1. Right click on your database.

2. Select Properties.

3. In database property window, select File section.

4.Set owner to valid login such as your current login.









Thursday, February 11, 2010

ASP.NET: Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack.


protected void btn1_OnClick(object sender, EventArgs e)
{
try
{
//Do some coding here...

Response.Redirect("default2.aspx");
}

catch (Exception ex)
{
//handle event exception. write error to log file.
}
finally
{
//some coding. like colsing connection.
}
}

In this kind of coding, above error will be displayed. Reason there are codes to execute after redirecting page. To avoid this problem use following code.

Response.Redirect("default2.aspx",false);

Friday, March 7, 2008

DataGridView control with ListBox

In this article I have discussed how to develop a control that inheriting standard features of DataGridView and add additional features to that control. By locking this NewDataGridView control you will be able to develop a DataGridView control adding many more features as you wish.

Link: http://www.codeproject.com/KB/edit/DataGridView.aspx

Wednesday, January 23, 2008

Crystal Report database connection in ASP.NET

In this article I am going to discuss how to use UDL file with Crystal Report to connect particular database.

What is UDL?

Universal Data Link files (।udl files) can be used to store information of connection string. So it works as a common user interface for specifying connection attributes.
Click Here

Saturday, September 29, 2007

Dynamic Crystal Report using .NET 2005 (C#)

This program shows how to dynamically load data from database and application in to the Crystal Report. By using this program we can customize Crystal Report to some limit at the run time of the application that specifying which field (Columns of particular table) should be displayed in the report.

http://www.codeproject.com/useritems/Dynamic_Crystal_Report.asp

Learning Video...

Loading...