IT and business subjects
14-Jul-0909 Leave a comment
EXECUTE sys.sp_spaceUsed ‘dbo.TableName’
To determine for more tables need to use a cursor. See below and other articles ( unchecked )http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx
14-Jul-0909 Leave a comment
13-Jul-0909 Leave a comment
Select Case True
Case sender Is TextBox1
Label1.Text = TextBox1.Text
Case sender Is TextBox2
Label1.Text = TextBox2.Text
End Select
However, this translates into IL (and decompiled using Reflector) as:
Dim flag1 As Boolean = True
If (flag1 = (sender Is Me.TextBox1)) Then
Me.Label1.Text = Me.TextBox1.Text
Else
If (flag1 = (sender Is Me.TextBox2)) Then
Me.Label1.Text = Me.TextBox2.Text
End If
End If
I don’t know if this helps.
06-Jul-0909 Leave a comment
They said it could not be done.
But here is the code to set a Local Report Parameter at runtime
”’ <summary>
”’ METHOD How to set Report Parameter
”’ </summary>
”’ <param name="MyReportViewer"></param>
”’ <param name="sParameterName"></param>
”’ <param name="sParameterText"></param>
”’ <remarks></remarks>
Private Sub SetLocalReportParameter(ByVal MyReportViewer As Microsoft.Reporting.WinForms.ReportViewer, ByVal sParameterName As String, ByVal sParameterText As String)
Try
Dim rp As New ReportParameter(sParameterName, sParameterText)
Dim rpP() As ReportParameter = {rp}
With MyReportViewer
.LocalReport.SetParameters(rpP)
.RefreshReport()
End With
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
02-Jul-0909 Leave a comment
26-Jun-0909 Leave a comment
In RegEdit, go to HKEY_CURRENT_USER\Software\Microsoft\Windows Desktop Search\DS and set "ShowStartSearchBand" to 0, and you’ll get the default search behavior back.
And while you’re at it and poking around in the registry, you might as well go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex and set FilterFilesWithUnknownExtensions to DWORD with the value of "1" in order to enable full-text searching of files (like code!) that Explorer by default skips over.
I am also trying
MSConfig
and Start Control Panel Administrative Tools Services
Steve
25-Jun-0909 Leave a comment
14-Jun-0909 Leave a comment
Stephen Shakespeare 