I'm trying to rework some code I've found, and it's all now working except for the date (dbDate). I need to keep it as a date value (and not convert to string), but I can't get the code to work:
View Complete Post
We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..
We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.
strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"
'get the new transaction_id out for just inserted alarm
strSqual = "select max(transaction_id) as transaction_id from trans"
set rst = getStaticRecordSet(strSqual)
I create table:
DataSet data=new DataSet();
DataTable myTable = new DataTable("NewTable");
DataColumn keys = new DataColumn; // create column keys = new DataColumn(); keys.DataType = System.Type.GetType("System.String"); keys.ColumnName = "PointID"; myTable.Columns.Add(keys); &nb
In this article, the author delves into some commonly used ways of writing data access code and looks at the effect they can have on performance.
MSDN Magazine August 2009
This month the Toolbox column takes a look at database logging, Joel Spolsky's blog, printing code projects, and ASP.NET reading.
MSDN Magazine May 2008
Protecting application secrets, such as database connection strings and passwords, requires careful consideration of a number of pertinent factors such as how sensitive the data is, who could gain access to it, how to balance security, performance, and maintainability, and so forth. This article explains the fundamentals of data protection and compares a variety of techniques that can be used to protect application settings. The author discusses what to avoid, such as hiding keys in source code and the use of Local Security Authority. In addition, he presents some effective solutions such as the Data Protection API.
MSDN Magazine November 2003
Developers love the ASP. NET application cache. One reason they love it is that ASP. NET lets them create dependencies between items placed in the cache and files in the file system. If a file targeted by a dependency changes, ASP.
MSDN Magazine April 2003
I'm about to go NUTS :)
I have 2 CalendarExtenders on page. And I want to show the date that I get from SQL SEVER:
select -> SELECT convert(datetime, ÃÂ begin) as Begin, convert(datetime, end) as End FROM Table
The date field, on base,ÃÂ is a char(8) ÃÂ and the record is like YYYYMMDD. That's why I convert it to datetime.
But, on code behind when I do this :
CalendarExtender1.SelectedDate = DateTime.Parse(objDataEvento.Rows(0)(2)) CalendarExtender2.SelectedDate = DateTime.Parse(objDataEvento.Rows(0)(3))ÃÂ
Depend of the date, It's showing minus 1 day on page.
Like: If, on base, the date is 08/12/2010, on page it's showing 07/12/2010.
WHYYYYYYYYYYYY ??????????????? ÃÂ