For example by using the built-in time command like this: string timeToSet = "12:05"; Process.Start("cmd", "/c time "+timeToSet); Regards, mav -- Black holes are the places where god divided by 0...

I don't know what you mean by "when will my database corrupt"? Do you mean how many rows can you insert before the key has to wrap around? If you are using an int type you have a maximum of 4294967296 unique values. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Both arguments are good. If you want more compact data go with the dbase, if you dont care about space store it in a file. I would use one or the other, not both. I prefer the dbase because you can have your pics backup easily. With pic files you will need to a tape backup. Nick 1 line of code equals many bugs. So don't write any!!

You have to concatenate " ' " to dates.... alter PROCEDURE SP_PHIEUNHAP_Search ( @FromNgayNhap datetime, @ToNgayNhap datetime, @CheckNgayNhap bit, @MaNCC int, @FromNgayLap datetime, @ToNgayLap datetime, @CheckNgayLap bit, @NguoiLap int ) AS DECLARE @sql nvarchar(500) DECLARE @flag bit declare @tungay datetime declare @denngay datetime SELECT @sql = ' select MaPN, NgayNhap, TenNCC, NgayLap, HoTen, TongTien ' SELECT @sql = @sql + ' from PHIEUNHAP, NHACUNGCAP, NGUOIDUNG ' if (@CheckNgayNhap = 1 ) begin SELECT @sql = @sql + ' where NgayNhap >= ''' + CONVERT(NVARCHAR, @FromNgayNhap,111) + ''' and NgayNhap <= ''' + CONVERT(NVARCHAR, @ToNgayNhap,111) + '''' set @flag = 1 end if(@CheckNgayLap = 1) begin if(@flag = 1) SELECT @sql = @sql + ' and NgayLap >= ''' + CONVERT(NVARCHAR,@FromNgayLap) + ' and NgayLap <= ' + CONVERT(NVARCHAR, @ToNgayLap,111) + '''' else SELECT @sql = @sql + ' where NgayLap >= ''' + CONVERT(NVARCHAR,@FromNgayLap) + ' and NgayLap <= ' + CONVERT(NVARCHAR, @ToNgayLap,111) + '''' set @flag = 1 end if(@NguoiLap != -1) begin if(@flag = 1) SELECT @sql = @sql + ' and NguoiLap = ' + CONVERT(NVARCHAR, @NguoiLap) else SELECT @sql = @sql + ' where NguoiLap = ' + CONVERT(NVARCHAR, @NguoiLap) set @flag = 1 end if(@MaNCC != -1) begin if(@flag = 1) SELECT @sql = @sql + ' and PHIEUNHAP.MaNCC = ' + CONVERT(NVARCHAR, @MaNCC) else SELECT @sql = @sql + ' where PHIEUNHAP.MaNCC = ' + CONVERT(NVARCHAR, @MaNCC) set @flag = 1 end SELECT @sql = @sql + ' and NguoiLap = MaND and PHIEUNHAP.MaNCC = NHACUNGCAP.MaNCC ' EXEC sp_executesql @sql :suss:

Hi dexom, Here are some links. Hope it will help you. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemWebUIWebControlsDataGridClassUpdateCommandTopic.asp[^] http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskallowinguserstoedititemsindatagridwebcontrol.asp[^] denpsia

I don't understand what you are asking. Have you looked at DotNetNuke[^] it is open source portal software for .NET My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

I call them stored procedures and I beg to differ with you on that statement. http://dev.mysql.com/doc/mysql/en/roadmap.html[^] The current production release is 4.1. MySQL 5.0 is available in alpha status. See the table of features and which version they belong to.

hmm if I understand your problem you want to download "complete page" with images etc... ok so after you download html page, extract links from it (e.g parse markup with regular expressions to find links) and then download images from these links... is this what you want? David Never forget: "Stay kul and happy" (I.A.) David's thoughts / dnhsoftware.org / MyHTMLTidy

gmail baby!

First you need to mark your class with the [Serializable] attribute so the fields/properties can be mapped to your output file. To write the file youve got a few options. First, you can use an XmlSerializer and TextWriter to write the file as XML formatted text. You can write the file as as Binary file using the FileStream and BinaryFormatter classes.

I suggest changing your major. Anyone who thinks he has a better idea of what's good for people than people do is a swine. - P.J. O'Rourke