SQL Server Timeout Expired on Redesign of Table with many rows

07-Aug-0909 Leave a comment

 
 
Go to SSMS > Tools > Options > Designers > Table and Database Designers >
and change Transaction Timout After from default of 30 seconds to something larger.
 
May well also be necessary to temporarily increase the log file size. Then return it back to it’s previous size

Filed under SQL Server

WPF Format Date in ListView

04-Aug-0909 Leave a comment

 
I am very new to WPF. So here goes:

<GridViewColumn Header=“Date Input” Width=“150”>
<GridViewColumn.CellTemplate >
<DataTemplate >
<TextBox Text=“{Binding Path=DateInput, StringFormat=’dd-MMM-yy’}” />
</DataTemplate>
</GridViewColumn.CellTemplate></GridViewColumn>

 
Good article here…
 
 
 
 
 

Filed under Visual Studio, WPF

Find Text in File

04-Aug-0909 Leave a comment

Technorati Tags: ,
 

Private Function IsTextInFile(ByVal MyDir As String, ByVal TextToFind As String, ByVal MyFileWildcard As String) As Boolean

Dim list As System.Collections.ObjectModel.ReadOnlyCollection(Of String)
list = My.Computer.FileSystem.FindInFiles(MyDir, TextToFind, True, FileIO.SearchOption.SearchTopLevelOnly, MyFileWildcard)

If list.Count = 1 Then
IsTextInFile = True
End If

End Function

Filed under VB.Net

Search Crystal Reports in Visual Studio for table/procedures

03-Aug-0909 Leave a comment

 
 
This is a part of the VB proc I built to generates the list of all tables used by my reports. Reports are listed in a ‘reports Table’, and I use a memo field to store the name of all used tables. It is then quite easy to update all requested reports once tables have been modified.
Publicfunction tablesUsedByAReport(myReportName asstring)asstringDim m_report As CRAXDRT.Report, _      m_crystal As CRAXDRT.Application, _      m_tablesUsedByAReport AsStringDim m_table As CRAXDRT.DatabaseTable, _      m_section As CRAXDRT.section, _      m_objet AsObject, _      m_subReport As CRAXDRT.SubreportObjectSet m_crystal =New CRAXDRT.ApplicationSet m_rapport = m_crystal.OpenReport(m_nomRapport,1)'table names in the report'ForEach m_table In m_rapport.Database.tables    m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"Next m_table 'table names in each of the subreports'ForEach m_section In m_rapport.Sections    ForEach m_objet In m_section.ReportObjects        If m_objet.Kind= crSubreportObject Then            Set m_subReport = m_objet            Set m_report = m_subReport.OpenSubreport            ForEach m_table In m_rapport.Database.tables                m_tablesUsedByAReport = m_tablesUsedByAReport & m_table.location &";"           Next m_table        EndIf    Next m_objetNext m_section 'my tables list'tablesUsedByAReport = m_tablesUsedByAReport Endfunction

 

Filed under Crystal Reports, Visual Studio

Newer posts →