Archive for July, 2008
A store procedure for microsoft sql to check win
This procedure use time… month and day
CREATE procedure sp_update_WinHands
@month as nvarchar(10) ,
@day as nvarchar(10)
as
declare @win as float
declare @lose as float
DECLARE @hand INT
declare @query nvarchar(1000)
declare @check as int
set @check=( select count(tableid) from bethistory where month1=@month and day1= @day)
if ( @check=0 )
begin
insert into bethistory(month1,day1) values (@month,@day)
end
SET @hand = 1
WHILE (@hand <=12)
BEGIN
set @win = (select count(id) from BetHeader
where datepart(m,dt)=@month and datepart(d,dt)=@day
and case when lasthand>@hand then 1 else 0 end=1)
set @lose = (select count(id) from BetHeader
where datepart(m,dt)=@month and datepart(d,dt)=@day
and case when lasthand>@hand then 1 else 0 end=0)
if( @win=0 ) begin set @win=1 end
set @query= ‘update bethistory set h’+cast(@hand as nvarchar(10))+’=’+cast(@lose as nvarchar(10))+’.00/’+cast(@win as nvarchar(10))+’.00 where month1=’+@month+’ and day1= ‘+@day+”
exec ( @query )
SET @hand = @hand + 1
END
GO
Check log every 5 min in C#
where timerticlickvoid is the click of the timer….
public void timertickvoid()
{
// Set the timer interval to 5 minutes
timerCheck.Interval = (int)(5 * 1000 * 60);
FileStream fs = File.OpenRead(“timer.log”);
StreamReader sr = new StreamReader(fs);
string myInput = sr.ReadToEnd();
sr.Close();
fs.Close();
DateTime dtFile = Convert.ToDateTime(myInput);
DateTime dt2 = DateTime.Now;
TimeSpan span = dt2.Subtract(dtFile);
int dif = span.Days*60*24 + span.Hours*60+span.Minutes;
if (dif > 5)//>60
{
RunRoutines();
}
}
How to add a filelist directory to combo in winform c#
where sPath is the location of directory
DirectoryInfo di = new DirectoryInfo(sPath);
FileInfo[] rgFiles = di.GetFiles(“*.jpg”);
foreach (FileInfo fi in rgFiles)
{
string sfile = fi.Name;
sfile = sfile.Replace(“.jpg”, “”);
object obj=sfile;
ckboxTemplates.Items.Add(obj);
}
Save node tree to xml
this is a function to save node to xml
private void SaveNodesXML(TreeNodeCollection nodesCollection,
XmlWriter textWriter)
{for (int i = 0; i < nodesCollection.Count; i++)
{
TreeNode node = nodesCollection[i];
textWriter.WriteStartElement(XmlNodeTag);
textWriter.WriteAttributeString(XmlNodeTextAtt, node.Text);
textWriter.WriteAttributeString(XmlNodeImageIndexAtt, node.ImageIndex.ToString());
if (node.Tag != null)
textWriter.WriteAttributeString(XmlNodeTagAtt, node.Tag.ToString());if (node.Nodes.Count > 0)
{SaveNodesXML(node.Nodes, textWriter);
}
textWriter.WriteEndElement();}
}
how to copy a directory in c-sharp
this is a function to copy all files in a directory.
public static void Copy(DirectoryInfo diSource, DirectoryInfo diDestination, string FileFilter, string DirectoryFilter, bool Overwrite, int FolderLimit)
{
int iterator = 0;
List<DirectoryInfo> diSourceList = new List<DirectoryInfo>();
List<FileInfo> fiSourceList = new List<FileInfo>();try
{
///// Error Checking /////
if (diSource == null)
throw new ArgumentException(“Source Directory: NULL”);
if (diDestination == null)
throw new ArgumentException(“Destination Directory: NULL”);
if (!diSource.Exists)
throw new IOException(“Source Directory: Does Not Exist”);
if (!(FolderLimit > 0))
throw new ArgumentException(“Folder Limit: Less Than 1”);
if (DirectoryFilter == null || DirectoryFilter == string.Empty)
DirectoryFilter = “*”;
if (FileFilter == null || FileFilter == string.Empty)
FileFilter = “*”;///// Add Source Directory to List /////
diSourceList.Add(diSource);///// First Section: Get Folder/File Listing /////
while (iterator < diSourceList.Count && iterator < FolderLimit)
{
foreach (DirectoryInfo di in diSourceList[iterator].GetDirectories(DirectoryFilter))
diSourceList.Add(di);foreach (FileInfo fi in diSourceList[iterator].GetFiles(FileFilter))
fiSourceList.Add(fi);iterator++;
}///// Second Section: Create Folders from Listing /////
foreach (DirectoryInfo di in diSourceList)
{
if (di.Exists)
{
string sFolderPath = diDestination.FullName + @”\” + di.FullName.Remove(0, diSource.FullName.Length);///// Prevent Silly IOException /////
if (!Directory.Exists(sFolderPath))
Directory.CreateDirectory(sFolderPath);
}
}///// Third Section: Copy Files from Listing /////
foreach (FileInfo fi in fiSourceList)
{
if (fi.Exists)
{
string sFilePath = diDestination.FullName + @”\” + fi.FullName.Remove(0, diSource.FullName.Length);///// Better Overwrite Test W/O IOException from CopyTo() /////
if (Overwrite)
fi.CopyTo(sFilePath, true);
else
{
///// Prevent Silly IOException /////
if (!File.Exists(sFilePath))
fi.CopyTo(sFilePath, true);
}
}
}
}
catch
{ throw; }
}
how to Fill_Combol()
it’s easy… where cblProject is the combol for fill…
public void Fill_Combol()
{
SqlCommand com = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.TableMappings.Add(“Table”, “hforms”);
com.Connection = SoftCD.StartForm.MSSqlcon;
com.CommandType = CommandType.Text;
com.CommandText = “select PRID,PR_DESCR from LibProject order by PR_DESCR “;
da.SelectCommand = com;
da.SelectCommand.ExecuteNonQuery();
da.Fill(ds);cblProject.DataSource = ds.DefaultViewManager;
cblProject.DisplayMember = “hforms.PR_DESCR”;
cblProject.ValueMember = “hforms.PRID”;
}