Bitlink Development Blog

for procedures

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'') AND type in (N'P', N'PC'))
drop PROCEDURE
go

for views

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[matching].[workingset_patient_episodes]') AND type in (N'V'))
drop view [matching].[workingset_patient_episodes]
go

Tags:

COPY %windir%\filename a:

SETLOCAL
..... set vars only local to batch file
ENDLOCAL

START .....
/minimized or /m
/maximized or /max
/restored or /r
/wait or /w

IF EXIST some.txt COPY c:/some.dll %windir%/SYSTEM/some.dll   (IF NOT EXISTS)

IF ERRORLEVEL 4 ERASE trashfile.tmp /P

IF %M%==1 GOTO SavedIt
:SavedIt

FOR variable in (set list) DO command .... or DO ( ... commands ... )
FOR %%D in (SYSTEM, COMMAND, SHELLNEW, "Start Menu") DO DIR "%windir%\%%D" /W

SET /P M=Type 1, 2, or 3, then press ENTER:
IF %M%==1 GOTO EXPORT
IF %M%==2 GOTO IMPORT

dir /s /f (recurs, files only)

Tags:

Error: Unable to cast object of type 'System.Web.Compilation.BuildResultCompiledAssembly' to type 'System.Web.Compilation.BuildResultCompiledGlobalAsaxType'

Solution:

search for "AssemblyCulture" and make sure to delete the culture or put a valid one in.
e.g. [assembly: AssemblyCulture("THIS_IS_INVALID")]

Tags:

z-index: 1;
position: absolute;

An object with a larger z-index than another will be in front of the other object

Tags:

The error message:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

This can be fixed by the following steps:

Tools -> Options -> Designer Page -> "Prevent saving changes that require table re-creation" -> uncheck

Tags:

Simply add the following to your declaration:
onclick="return false;" 

This will disable the javascript that ticks / unticks the box.

Examples of both readonly CheckBoxLists and readonly CheckBoxListes:

<asp:CheckBoxList ID="CheckBoxList1" runat="server" onclick="return false;">
<asp:CheckBox ID="CheckBox1" runat="server" onclick="return false;" Text="test" />

Tags:

use the following CSS in your stylesheet:

body
{
   margin: 0px auto; /* this is what does the trick */
   padding: 0px;
   width: 800px;
}

Tags:

Solutions to the following error:

Content controls are allowed only in content page that references a master page

You get this error when you have no masterpage assigned to your web form

Options to consider (other than simply adding your masterpage statically):

 You can derive all your pages from a base page in the web config file:

    <system.web>
      <pages pageBaseType="BasePage" >

then create a class and declare it as follow:

    public class BasePage : System.Web.UI.Page { ....

with the following method in it:

    protected override void OnPreInit(EventArgs e)
    {
        string ThemeName = "Bitlink";
        //this should point to your masterpage:
        MasterPageFile = VirtualPathUtility.ToAbsolute(("~/")) + "Themes/" + ThemeName + "/Master.master";
        base.OnPreInit(e);
    }

this way all your pages would be assigned to a certain masterpage dynamically.

Tags:

Characters

Classes

Tests etc

mode modifiers

groups and repititions

Replacements

Tags: regular expressions

If you have a datagridview and want to be able to right-click, which should automatically selecte the row that you've clicked and fire the ContextMenuStrip, it can be done as follows:

private void dataGridView1_MouseClick(object sender, MouseEventArgs e)

{

    if (e.Button == MouseButtons.Right)

    {

        foreach (DataGridViewRow s in dataGridView1.SelectedRows)

            s.Selected = false;

        DataGridView.HitTestInfo hit = dataGridView1.HitTest(e.X, e.Y);

        dataGridView1.Rows[hit.RowIndex].Selected = true;

        dataGridView1.CurrentCell= dataGridView1.Rows[hit.RowIndex].Cells[hit.ColumnIndex];

        contextMenuStrip1.Show(dataGridView1, new Point(e.X,e.Y) );

    }

}

Tags:

you get the error: Value cannot be null. Parameter name: propName

the reason could be (it was in my case) that the gridview you are trying to bind contains a comma with no further fields as follow:

  .... DataKeyNames="FullNo1,StudyNo,"

feel free to post other solutions to this error

Tags:

 In web.config:

<appSettings>
    <add key="ContactUsEmail" value="me@mysite.com"/>
</appSettings>

In your code:

using System.Configuration;

        private void SendEmail(string emailbody)
        {
                string V = (string)ConfigurationSettings.AppSettings["ConnectionInfo"];
        }

Tags:

either in you web.config file you can add the following entry:

<system.web>
      <pages theme="standard" maintainScrollPositionOnPostBack="true">
</system.web>
 

or for any page you can set the page directive as follow:

<%@ Page MaintainScrollPositionOnPostback="true" .... 

Tags: maintain scroll position

The following line will provide the useragent from the person accesing your web page

 HttpContext.Current.Request.Headers["User-Agent"]

 it would look similar to the following:

useragent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.9) Gecko/20100315 Firefox/3.5.9 GTBDFff GTB7.0 (.NET CLR 3.5.30729)

Tags: user agent

This happens if you run your application in 64bit
(using the Jet for excel etc)

simply switch to 32bit 

Tags: