Sourcesafe: Reset Sourcesafe Admin Password

Hack the um.dat file to remove the Admin password

from offset 80 the bytes are (all numbers are hex)

0:80 55 55 bc 7f 41 64 6d 69 6e 00 00 00 00 00 00 00
0:90 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0:a0 00 00 00 00 90 6e 00 00 a8 01 00 00 00 00 00 00

This information is at YOUR OWN RISK

VS: Retrieving value of Enum

It's obvious you want to use Enums instead of numeric or even string values. But you still want to be as flexible as using a numeric or string value.

public enum enJudgement
{
Bad= 1,
Average= 2,
Good = 3
}

Retrieving the string value
enJudgement.Bad.ToString();

Retrieving the numeric value
Type tJudgement = typeof(enJudgement);
Enum.Format(tJudgement , Enum.Parse(tJudgement , enJudgement.Bad.ToString()), "d"));

Converting numeric/string value to Enum
(enJudgement)Enum.Parse(typeof(enJudgement), NumericOrStringvalue);

Install Microsoft apps that require SP2 without installing SP2

Launch regedit.exe
Go to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Windows
Change the CSDVersion value to be 512 or higher (0x0000200 in hexadecimal)
Close regedit.exe and install for example Visual Studio 2005
Rerun regedit.exe and change the CSDVersion value back to what it was originally

NB Don't forget to restore the CSDVersion, otherwise your PC won't boot after a Windows Update

More info: Aaron Sebner's Weblog

VS: Excel datasource reads values as DBNull

When using a connectionstring to connect to a Excel sheet like this:

SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=Excel 8.0')...[Customers$]

you can create a dataset based on the excel sheet.

However, using this connectionstring with mixed colums (columns that contain numeric values and tekst values) the provider will think the column is numeric and won't read the tekstual values.

To solve this problem you have to add an extended property IMEX to the connectionstring, tellling the provider to treat mixed colums (default) as string.
This way all the values in the columns will be read:

SELECT * INTO XLImport3 FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\test\xltest.xls;Extended Properties=''Excel 8.0;IMEX=1''')...[Customers$]

VS2005: Formview insert mode - Fill with initial value

Use the FindControl method to automatically fill your controls:

protected void FormView1_PreRender(object sender, EventArgs e)
{
string strDefaultProdName = "Product name";
if (FormView1.CurrentMode == FormViewMode.Insert &&
((TextBox)FormView1.FindControl("ProductNameTextBox")).Text.Length==0)
((TextBox)FormView1.FindControl("ProductNameTextBox")).Text =
strDefaultProdName;
}

VS: Using Windows Authentication on a webservice called by an ASP.NET webapplication

It’s relatively simple to use the right authentication, but unfortunately mostly after you know it! Here are the steps to call a webservice with Windows Authentication:

1. Modify the web.config of the ASP.NET webapplication:
<authentication mode="Windows" />
<identity impersonate="true" />

2. Modify the web.config of the webservice:
<authentication mode="Windows" />
<authorization>
<allow users="Administrator" />
<deny users="*" />
</authorization>

3. Disable anonymous authentication in IIS for the ASP.NET webapplication and the webservice

4. Before calling the webservice set the credentials
localhost.Service1 srv= new WebAppTest.localhost.Service1();
srv.Credentials = System.Net.CredentialCache.DefaultCredentials;
srv.WebserviceFunction();

Good luck!

SQL: SQL Server marks DB as Suspect.

I hope it won't happen to you often, but it may occur you see a database in the Enterprise Manager marked as suspect. When so, you won't be able to open it or drop it. When a reboot of SQL server doesn't help, you can try the following:

use master
go
exec sp_resetstatus msdb -- replace msdb with your database name

Restart SQL server and you should be able to access the database again.

Run DBCC NEWALLOC, DBCC TEXTALL, and DBCC CHECKDB.

If you still can't access the DB, try the following:
Bypass (Emergency) mode and DUMP TRANSACTION WITH NO_LOG

VS: Ask user to confirm delete of record

Using a grid with a delete button, you often want the user to confirm the delete action. This is how to do it:

In VS 2005 add this to your button:
OnClientClick="return confirm('Are you sure you want to delete this record?');"
In VS 2003 add this to your button
OnClick="return confirm('Are you sure you want to delete this record?');"

Or bind it in code:

protected void myDataGrid_OnItemDataBound(object sender, DataGridItemEventArgs e)
{
if(e.Item.FindControl("DeleteLink") != null)
{
((LinkButton) e.Item.FindControl("DeleteLink")).Attributes.Add
("onClick", "return confirm('Are you sure you want to delete this record?');");
}
}

When the user presses the button it receives a messagebox with the text. When the user presses OK the server event is called. When the user presses Cancel, nothing happens.

Installed Windows XP Service Pack 2 to install VS 2005 and now you can't be reached in the network?

Follow the steps on this URL to solve your problem:

http://support.microsoft.com/kb/892199/en-us

VS: How to show a messagebox in a ASP.NET application

The following class implements messagebox functionality. When calling this function a messagebox is shown and the current page is still shown. (often the messagebox functions create a blank form with a messagebox on top)

You can call the function at any place (because it's static) like this: Messagebox.Show("Hello World");

public class Messagebox
{
public Messagebox()
{

}

private static Hashtable m_executingPages = new Hashtable();

public static void Show(string sMessage)
{
// If this is the first time a page has called this method then
if (!m_executingPages.Contains(HttpContext.Current.Handler))
{
// Attempt to cast HttpHandler as a Page.
Page executingPage = HttpContext.Current.Handler as Page;

if (executingPage != null)
{
// Create a Queue to hold one or more messages.
Queue messageQueue = new Queue();

sMessage = sMessage.Replace("\r", " ");

// Add our message to the Queue
messageQueue.Enqueue(sMessage);

// Add our message queue to the hash table. Use our page reference
// (IHttpHandler) as the key.
m_executingPages.Add(HttpContext.Current.Handler, messageQueue);

// Wire up Unload event so that we can inject some JavaScript for the alerts.
executingPage.Unload += new EventHandler(ExecutingPage_Unload);
}
}
else
{
// If were here then the method has allready been called from the executing Page.
// We have allready created a message queue and stored a reference to it in our hastable.
Queue queue = (Queue)m_executingPages[HttpContext.Current.Handler];

// Add our message to the Queue
queue.Enqueue(sMessage);
}
}

// Our page has finished rendering so lets output the JavaScript to produce the alert's
private static void ExecutingPage_Unload(object sender, EventArgs e)
{
// Get our message queue from the hashtable
Queue queue = (Queue)m_executingPages[HttpContext.Current.Handler];

if (queue != null)
{
StringBuilder sb = new StringBuilder();

// How many messages have been registered?
int iMsgCount = queue.Count;

// Use StringBuilder to build up our client slide JavaScript.
sb.Append("<script language='javascript'>");

// Loop round registered messages
string sMsg;
while (iMsgCount-- > 0)
{
sMsg = (string)queue.Dequeue();
sMsg = sMsg.Replace("\n", "\\n");
sMsg = sMsg.Replace("\"", "'");
sb.Append(@"alert( """ + sMsg + @""" );");
}

// Close our JS
sb.Append(@"</script>");

// Were done, so remove our page reference from the hashtable
m_executingPages.Remove(HttpContext.Current.Handler);

// Write the JavaScript to the end of the response stream.
HttpContext.Current.Response.Write(sb.ToString());
}
}
}

VS2003: How to enable JavaScript debugging

Step 1:
The most forgotten step in enabling script debugging in VS 2003 is enabling the browser to debug scripts. You can find this option in Internet Explorer. Tools -> Internet Options…-> Advanced. You should disable the checkbox Disable script debugging.

Step 2:
Start your VS solution. After starting go to the page you want to debug. In VS go to Debug->Windows->Running documents. Here you see the documents that have been currently loaded in the Internet Explorer.
Open the document (in the running documents window) you want to debug and place a breakpoint.

When you refresh the page your code will stop at the breakpoint when the code passes.

If you have any problems, check to see if VS is set to debug scripts. Tools->Options…->Debugging->Just-In-Time->Script

VS2003: Using Microsoft Excel and ASP.NET

To create an export to Excel you can use the following functions below. Then simply call the function exportToExcel and pass the datatable you want to export and the filename.

private static void exportToExcel(DataTable dt, string fileName)
{
//if the file already exists then delete it
System.IO.FileInfo fi = new System.IO.FileInfo(fileName);
if (fi.Exists)
fi.Delete();

//set the table name if its not there
if (dt.TableName == string.Empty)
dt.TableName = "Sheet1";
else//remove $ from table name if it is there
dt.TableName = dt.TableName.Replace("$", string.Empty);


string sql;
OleDbConnection connection = GetConnection(fileName);
OleDbCommand command = new OleDbCommand();
command.Connection = connection;

try
{
// Create table
command.CommandText = GetTableCreationSql(dt);
command.Connection.Open();
command.ExecuteNonQuery();
command.Dispose();


// Insert Into Table

sql = GetInsertSql(dt);

foreach (DataRow row in dt.Rows)
{
command = new OleDbCommand();
command.Connection = connection;
command.CommandText = sql;
SetParametersInCommand(row, command);
command.ExecuteNonQuery();
command.Dispose();
}
}
finally
{
//Garbage cleaning
connection.Close();
connection.Dispose();
}

}

///
/// create a string which should be the sqlCommand for creating Table in oleDB
///
/// create table [tableName] ( Column1 type, ..., Columnn Type)
private static string GetTableCreationSql(DataTable dt)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("create table [");
sqlBuilder.Append(dt.TableName);
sqlBuilder.Append("] ( ");

//Create a list of column names and their data types, e.g
//[ColumnName1] nvarchar, [ColumnName2] nvarchar,...[ColumnNamen] nvarchar
foreach (DataColumn col in dt.Columns)
{
if (col.Ordinal == 0)
sqlBuilder.Append("[");
else
sqlBuilder.Append(", [");

sqlBuilder.Append( col.ColumnName.Trim());

sqlBuilder.Append("] nvarchar");
}

sqlBuilder.Append(" )");

return sqlBuilder.ToString();
}

///
/// form a insert statement to insert data into oleDB
///
/// Insert Into tableName ([ColumnName1], [ColumnName2] ,...[ColumnNamen]) values (?,?,..,?)
private static string GetInsertSql(DataTable dt)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder paramMarks = new StringBuilder();
sqlBuilder.Append("Insert Into [");
sqlBuilder.Append(dt.TableName);
sqlBuilder.Append("] ( ");


//Create a list of column names and their place holders
//[ColumnName1] , [ColumnName2] ,...[ColumnNamen]
// ?,?,...?
foreach (DataColumn col in dt.Columns)
{
if (col.Ordinal == 0)
{
sqlBuilder.Append("[");
paramMarks.Append("?");
}
else
{
sqlBuilder.Append(", [");
paramMarks.Append(",?");
}

sqlBuilder.Append(col.ColumnName.Trim());
sqlBuilder.Append("] ");
}

sqlBuilder.Append(" ) values (");
sqlBuilder.Append(paramMarks.ToString());
sqlBuilder.Append(")");

return sqlBuilder.ToString();
}


private static void SetParametersInCommand(DataRow row, OleDbCommand command)
{
UnicodeEncoding en = new UnicodeEncoding();
string argumentName = string.Empty;
int index = 0;
foreach (DataColumn col in row.Table.Columns)
{
argumentName = "@Args" + index;
command.Parameters.Add(new OleDbParameter(argumentName, OleDbType.VarBinary)).Value =
en.GetBytes(row[col].ToString());
index++;
}
}
private static OleDbConnection GetConnection(string filePath)
{
return new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=YES;\"");
}

VS2003: Using Microsoft Word and ASP.NET

It can be a pain using Word documents from an ASP.NET application. Especially because you don’t want to install Office of Word on the server.

The new VSTO 2005 uses Serverdocument to modify Word documents. Nice but then you are bound to Office 2003, and the beauty of a Web interface is that everyone can use it. Also users with Office 2000/XP.

To provide an ASP.NET application to modify Word documents you can use Microsoft’s DSOFile.dll. This DLL simply can modify the document properties of a Word document. For extra functionality you can use good old VBA to read the document properties into fields if neccessary, or you can just insert the documentproperties into the template document.

To use the DSOfile functionality:

- Add a reference to it.
- Make sure you also register the DLL with Regsvr32.

string strFileNameNew = "";
DSOFile.OleDocumentPropertiesClass m_oDocument = null;

//Init variabelen
string strTemplate = System.Configuration.ConfigurationManager.AppSettings["FormTemplate"];

try
{
System.IO.File.Copy(strTemplate, strFileNameNew,true );

m_oDocument = new DSOFile.OleDocumentPropertiesClass();
m_oDocument.Open(strFileNameNew, false, DSOFile.dsoFileOpenOptions.dsoOptionDefault);

// Fill document properties
object objParam = “Value to insert”
m_oDocument.CustomProperties["DocProp"].set_Value(ref objParam);


//Document opslaan en sluiten
m_oDocument.Save();
}

finally
{
if (m_oDocument != null)
m_oDocument.Close(true);
}

To add functionality to process the document properties with the fields in the document, use corresponding names and the following VBA code in Document_Open() of your document:

For Each prop In CustomDocumentProperties
For Each frmField In ActiveDocument.FormFields
If frmField.Name = prop.Name Then
frmField.TextInput.Default = prop.Value
End If
Next
Next

ActiveDocument.Fields.Update

To save the values again in the documentproperties (perhaps for importing the Word document again) you place the following VBA code in the Document_Close():

For Each prop In CustomDocumentProperties
For Each frmField In ActiveDocument.FormFields
If frmField.Name = prop.Name Then
prop.Value = frmField.Result
End If
Next
Next

ActiveDocument.Save


You can download DSOfile.dll from Microsoft at:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9BA6FAC6-520B-4A0A-878A-53EC8300C4C2&displaylang=en

VS2005: Formview - Get Row ID of inserted record

In VS 2005 define a SQLDatasource or ObjectDatasource with an insert statement and add an output parameter. Then use the following SQL statement to fill your output parameter (use ; to separate the statements):

INSERT INTO Values ();
select @NewID = SCOPE_IDENTITY() ;

On your form catch the inserted event of the used datasource and save the generated ID (for example in the viewstate):

protected void datasource_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
{
ViewState["ID"] = e.OutputParameters["NewID"];
}

In the Save function you can retrieve the new ID by getting it from the querystring (if that is the case) or by using the viewstate (which you filled above):

private int Save()
{
//edit or update
if (fvApplicatie.CurrentMode == FormViewMode.Insert)
{
fvApplicatie.InsertItem(false);
//Retrieve ID from Viewstate
return int.Parse(ViewState["ID"].ToString());
}
else
{
//Retrieve ID from Querystring
fvApplicatie.UpdateItem(false);
return int.Parse(Request["ID"].ToString());
}
}