|
Hello
Ok I will try to do everyting directly on the datasource
Here is what I do
1- open a connection
2- Select sql from a db table
3- Fill a dataset
5- set dataset as datasource of DGV
6- Let user modify values in ONE column (my order column)
I have two way to modify values
a)- Manually
b)- Automaticaly (with renum ond reorder function)
For now a) and b) are applied directly to DGV, I will manage to do automatic modification on the datatable
AFTER : I apply change to db with getchanges
I use the same connection with different adapter and I close it when the user close the application.
Does it sounds right to you ?
|
|
|
|
|
I'm trying to open a serial port and just leave it open while my whole program is running. I don't need to write to it, I have a relay that activates when the port opens. I can open the port and everything is always fine for a while until the port closes at different times. This powers down my test equipment and ruins my test.
Can anyone tell me why the port closes? This is what I Do:
SerialPort port = new SerialPort("COM4", 9600, Parity.None, 8, StopBits.One);
// Open the port for communications
port.Open();
It stays open for anywhere between 3 and 4 minutes.
|
|
|
|
|
Is it an USB - ComPort adapter ?
|
|
|
|
|
It is a USB Commport Adapter. I have an older machine that has a real serial port. I'll try it on that one.
Could it be a problem with the USB device?
|
|
|
|
|
|
DateTime date = File.GetCreationTime(Application.ExecutablePath).AddDays(12);
stillHasTime = (date >= DateTime.Now);
I use this code to cause a demo version to expire after 12 days. We've tested it many times and it works great, but we have two users who are reporting that they got asked to register after two days. Can anyone tell me any reason why the creation time of an app that has never been installed on the PC before, would be out by 10 days ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Stupid question... What does the OS think the current creation date is for the file? It may not be your code! Its possible that something changed this value.
Hogan
|
|
|
|
|
I don't have access to the client machines to find that out. What would change the value, wouldn't the OS create that value and leave it as it is ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian,
I'm not sure what would change it, but it is possible via the .NET framework to change the Creation Date for a file or directory. I do a process at work where I have to move files and folders manually and I have to manually reset the file creation data. I'll admit that it is rare that needs to be done, but it is possible and does happen.
File.SetCreationTime();
So I wouldn't assume that your code is wrong just yet. Talk to that client first.
Hogan
|
|
|
|
|
They may have caught a virus joggling with their system time.
.Net BCL wraps the standard Win32 routines for I/O so this error shouldn't really be .Net specific.
|
|
|
|
|
Christian Graus wrote: DateTime date = File.GetCreationTime(Application.ExecutablePath).AddDays(12);
stillHasTime = (date >= DateTime.Now);
But Christian, is this the best method for checking the demo expiration when creation date can be altered ? I am just wondering.
|
|
|
|
|
There's not much you can do.
Even totally stupid noob can change their system time, so your best chance is storing a file on a clients machine with some kind of time-mark. Some sorta hidden system file stored somewhere deeeeep containing time-mark acquired from the internets is the best way I can think off right now.
|
|
|
|
|
hii
i have used mltiple regression for crime forecasting, i know all the formulas to used but i m confused for forecasting formula...
Yt+1= b0+b1(Xt+1)
where does i get the value for thsi Xt+1??
can any one help or can provide me a code in C# for forecasting of crime??
|
|
|
|
|
This is not really a C# question, it's a question for people who know about crime forecasting.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Todays forecast is for some minor fraud in the financial districts with late afternoon muggings rolling up from the poorer areas. In commercial centers managers can expect some isolated violent acts as they ask their staff to work back on the weekend.
Back to you Christian...
|
|
|
|
|
My guess is the "t+1" part is a subscript that stands for "the next time unit". So Yt+1 and Xt+1 are the Y and X values at time t+1.
|
|
|
|
|
For a much more powerful tool that can be used for crime forecasting, see www.patternscope.com .
|
|
|
|
|
 How can I convert the OLE Object(byte array) from db1(my Access database) into a c# Bitmap object?
The Ole Object is a jpeg.
Source Code:
byte[] pictureData = <<...Ole Object...>><br />
int offsetValue = 78;<br />
Stream stream = new MemoryStream();<br />
stream.Write(pictureData, offsetValue, pictureData.Length - offsetValue);<br />
Bitmap bitmap = new Bitmap(stream);
Notes:
I have tried an offset value of 0-pictureData.Length.
I get an ArgumentException with message "Parameter is not valid." when instantiating bitmap object.
Thanks in advance
modified on Thursday, March 13, 2008 3:56 PM
|
|
|
|
|
You shouldn't need any offset. If it doesn't work with an offset of 0, your data is probably bad.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Keep in mind also that the call stream.Write puts the stream position at EOF. So when you then pass the stream to create your new bitmap, its at the end of the stream and thus nothing to write.
Just because we can; does not mean we should.
|
|
|
|
|
I set stream.Position = 0.
Unfortunately, I still get the same ArgumentException.
Thanks in advance
|
|
|
|
|
A little searching finds that you should pass your byte array "pictureData" to the constructor for the MemoryStream. Then pass the stream to the Bitmap constructor.
byte[] pictureData = <<...Ole Object...>>
Stream stream = new MemoryStream(pictureData, 0, pictureData.length);
Bitmap bitmap = new Bitmap(stream);
Resource: http://www.csharphelp.com/board2/read.html?f=1&i=40858&t=40858
Just because we can; does not mean we should.
|
|
|
|
|
I tried your code but I still get the same problem.
Thanks in advance
|
|
|
|
|
i have a number in my table that i need to inser in the database.the loop is returning a null value.how to convert object to string .here is my code.
can anyone help on this..
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
/// <summary>
/// Summary description for TMPerminent
/// </summary>
public class TMPerminent
{
#region Variables
OracleConnection con;
#endregion
#region CONNECTION STRING
public string connectionString = System.Configuration.ConfigurationManager.AppSettings["OracleConnectionString2"];
# endregion
public TMPerminent()
{
OracleConnection con = new OracleConnection(connectionString);
}
//public void AddNewRow(DataRow gvWeekDays,DataRow gvHrsNewRow, DataRow gvTaskNewRow, string strTWODID,string strEmpTSID)
public void AddNewRow(string dayid, string dayhrs, ref DataRow gvTaskNewRow, string strTWODID, string strEmpTSID)
{
//string strDay = null;
//string strHrs = null;
//Get the values stored in the text boxes
string txtDivision = gvTaskNewRow[0].ToString();
string txtSegment = gvTaskNewRow[1].ToString();
string txtDetail = "0";//gvTaskNewRow[2].ToString();
string txtFuntion = "0";//gvTaskNewRow[3].ToString();
string txtDescription = "0";//gvTaskNewRow[4].ToString();
string txtTask = "0";//gvTaskNewRow[5].ToString();
string txtCounty = "0";//gvTaskNewRow[6].ToString();
string txtHighway = "0";//gvTaskNewRow[7].ToString();
//Get the values stored in the text boxes
txtDivision = gvTaskNewRow[0].ToString();
txtSegment = gvTaskNewRow[1].ToString();
txtDetail = gvTaskNewRow[2].ToString();
txtFuntion = gvTaskNewRow[3].ToString();
txtDescription = gvTaskNewRow[4].ToString();
txtTask = gvTaskNewRow[5].ToString();
txtCounty = gvTaskNewRow[6].ToString();
txtHighway = gvTaskNewRow[7].ToString();
//Prepare the insert Command of the DataSource control (inserting new record into the TASK TABLE)
string strInsertTask = "";
strInsertTask = "insert into TASK_WRK_ORDR_DTL (TXDOT_DIST_NBR,SGMNT_ID,DTL_CD,FUNC_CD,TASK_WRK_ORDR_CD,TXDOT_CNTY_NBR,HWY_CD,MISC_DSCR_TXT) values (" +
txtDivision + "," + txtSegment + "," + txtDetail + "," + txtFuntion + "," + txtTask + "," + txtCounty +
"," + txtHighway + "," + txtDescription + ")";
////Select the hrs data in the row
//for(int i=0 ; i < 7 ; i++ )
//{
// if (gvHrsNewRow[i].ToString() != string.Empty)
// {
// strHrs = gvHrsNewRow[i].ToString();
// strDay = gvWeekDays[i].ToString();
// break;
// }
//}
//prepare the insert command for the HRS table
string strInsertHrs = "";
//dayhrs = "123";
//dayid = "12";
strInsertHrs = "insert into TS_DAILY_ACTV (DAY_ID,TWOD_ID,EMP_TMSHT_ID,WRK_HRS_QTY) values (" + dayid + "," + strTWODID + "," + strEmpTSID + "," + dayhrs + ")";
//OracleConnection con = new OracleConnection(connectionstring);
OracleCommand cmdInsertTask = new OracleCommand(strInsertTask,con);
OracleCommand cmdInsertHrs = new OracleCommand(strInsertHrs,con);
con.Open();
cmdInsertTask.ExecuteNonQuery();
cmdInsertHrs.ExecuteNonQuery();
con.Close();
|
|
|
|
|
joynee wrote: strInsertTask = "insert into TASK_WRK_ORDR_DTL (TXDOT_DIST_NBR,SGMNT_ID,DTL_CD,FUNC_CD,TASK_WRK_ORDR_CD,TXDOT_CNTY_NBR,HWY_CD,MISC_DSCR_TXT) values (" +
txtDivision + "," + txtSegment + "," + txtDetail + "," + txtFuntion + "," + txtTask + "," + txtCounty +
"," + txtHighway + "," + txtDescription + ")";
Ah yes, string concatenation. Could someone please tell me what year it is? I'm sure I must have the wrong calendar.
Dear joynee, you might want to do some research on something called "SQL injection".
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
