by ebarcza 2/3/2020 1:13:00 PM



Outlook 503 No recipient(s) when sending

by ebarcza 1/22/2019 2:02:00 PM

Looks like your outgoing server requires authentication. Follow these steps for Outlook 2007.

On the main menu in Outlook go to tools>Account Settings>Change>More Settings>Outgoing Server>Then check the box that says 'my outgoing server (SMTP) requires authentication'.

That's it you're done it should now work. What this does is it automatically authorises the outgoing server to the right port set by your mail server.

Tags: ,


Bootstrap Centering a column using offsets

by ebarcza 1/8/2019 9:34:00 AM

This will create 2 columns centered in the 12 column grid system

This approach uses Bootstrap's own offset classes so it requires no change in markup and no extra CSS. The key is to set an offset equal to half of the remaining size of the row. So for example, a column of size 2 would be centered by adding an offset of 5, that's (12-2)/2.

<div class="row">
    <div class="col-md-2 col-md-offset-5"></div>

Tags: ,

Loop through RadGrid and read Check Boxes when not in edit mode

by ebarcza 10/10/2017 8:17:00 AM

Step 1 - create a GridTemplate Column with a checkbox

 <telerik:GridTemplateColumn UniqueName="colCheckDelete" HeaderText="Delete">
                        <asp:CheckBox ID="chkDelete" runat="server" />


Step 2 - The codebehind loop

foreach (GridDataItem item in rgDeals.MasterTableView.Items)
            CheckBox chkDelete = (CheckBox)item["colCheckDelete"].FindControl("chkDelete");
                //Delete the deal
                    int dealID = Convert.ToInt32(item.GetDataKeyValue("DealID"));
                    string sql = "Delete stuff where dealID = " + dealID;
                    int rslt = Utility.ExecuteNonQuerySQL(sql);
                catch (IndexOutOfRangeException ex)
                    //do nothing
                catch (Exception ex)
                    ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "CreateMasterAlert('alert alert-danger', '" + "One or More deletes failed" + "');", true);
        ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "CreateMasterAlert('alert alert-success', '" + "Delete Operation completed" + "');", true);


.NET | SQL SERVER | Telerik

Cannot read keys when either application does not have a console or when console input has been redirected from a file. Try Console.Read.

by ebarcza 6/23/2017 9:58:00 AM
[No text]


RadGrid Filter Case Sensitive

by ebarcza 11/11/2016 6:27:00 AM
GroupingSettings CaseSensitive = "false"

Tags: , ,

Windows Service Install System.Security.SecurityException

by ebarcza 12/7/2015 7:23:00 AM

An exception occurred during the Install phase. System.Security.SecurityException: The source was not found, but some or all event logs could not be searched. Inaccessible logs: Security.


To get around this issue, just right mouse click on the 


Paypal button and .NET aspx page

by ebarcza 9/21/2015 12:59:00 PM

Paypal buttons don't work on aspx pages with a master page usually b/c of the embedded form tags. You can't have a form within a form.

Quick fix hack alert - Before the paypal code enter a closing form tag (This will close the asp pages form) then remove the closing form tag from the paypal code and allow the end of .net page end form tag to close the paypals form.


View Server State permisssion was denied on object 'server', database 'master'

by ebarcza 9/1/2015 2:29:00 PM

I just ran into this error when creating a new user. Hope this helps somebody


Run this query in the master database




Remove all objects from a SQL Schema - Cannot drop schema because it is being referenced by object

by ebarcza 9/1/2015 2:09:00 PM

IF you run into this error when trying to delete a schema(usually as a result of trying to delete a user that owns a schema)

"Cannot drop schema because it is being referenced by object"


First run this sql to generate the statements that will execute the move

SELECT 'ALTER SCHEMA dbo TRANSFER [' + SysSchemas.Name + '].[' + DbObjects.Name + '];'
FROM sys.Objects DbObjects
INNER JOIN sys.Schemas SysSchemas ON DbObjects.schema_id = SysSchemas.schema_id
WHERE SysSchemas.Name = 'upstreamgasmgmt'
AND (DbObjects.Type IN ('U', 'P', 'V'))

The previous sql statement will return a set of records like this

ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[GetReportPoints];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[mappingTest];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[vwPhysicalZones];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[PantoneStaging_MeasurementVolumes];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[tbl_Volumes_PantonTest];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[test];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[ReportLAUFWellhead];
ALTER SCHEMA dbo TRANSFER [upstreamgasmgmt].[November204BidWeek];


Copy and paste that result set into a query window and run it.


Now try and delete the schema again!


Powered by BlogEngine.NET
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail


<<  February 2020  >>

View posts in large calendar

Recent comments



The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2020

Sign in