|
|
Control has an Invoke method that should be used when you need to update a control from a thread other than the one that created it. Use InvokeRequired to determine whether it is necessary to use Invoke.
Charlie
if(!curlies){ return; }
|
|
|
|
|
I tried to insert a record to database(in user register operation) using Access 2003 database and an exception appears("this operation must use updateable queries.").But when i use the same code with SQL2000 Database,every thing is OK.
Anyone can explain for me,and how to insert a record to Access database ? thanks.
the full code:
/////////////////////////////////////////////////
bool result = false;
//OLEDB
OleDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(CfgKeyOleConnString+CfgKeyOleDatabase);
string strSQL = "INSERT INTO Users (UserName,Name,UserPassword,Email,RoleID) VALUES (@UserName,@Name,@UserPassword,@Email,@RoleID)";
OleDbCommand dbComm = new OleDbCommand(strSQL,dbConnection);
dbComm.Parameters.Add(new OleDbParameter ("@UserName", OleDbType.VarChar, 50));
dbComm.Parameters["@UserName"].Value = userName;
dbComm.Parameters.Add(new OleDbParameter ("@Name", OleDbType.VarChar, 50));
dbComm.Parameters["@Name"].Value = displayName;
dbComm.Parameters.Add(new OleDbParameter ("@UserPassword", OleDbType.VarChar, 50));
dbComm.Parameters["@UserPassword"].Value = userPassword;
dbComm.Parameters.Add(new OleDbParameter ("@Email", OleDbType.VarChar, 50));
dbComm.Parameters["@Email"].Value = userEmail;
dbComm.Parameters.Add(new OleDbParameter ("@RoleID", OleDbType.Numeric , 8));
dbComm.Parameters["@RoleID"].Value = Convert.ToInt32(Role);
try
{
dbConnection.Open();
dbComm.ExecuteNonQuery();
result = true;
}
catch(Exception ex)
{
Console.WriteLine(ex.ToString());
result = false;
}
finally
{
if (dbConnection.State==ConnectionState.Open)
dbConnection.Close();
}
return result;
...NLD...
|
|
|
|
|
The OleDb data provider does not use named parameters. Instead, it uses question marks as placeholders.
string strSQL = "INSERT INTO Users (UserName,Name,UserPassword,Email,RoleID) VALUES (?, ?, ?, ?, ?)";
Obviously, you need to make sure your parameters are added in the correct order.
Charlie
if(!curlies){ return; }
|
|
|
|
|
Anybody familiar with how to set Socket Options, specifically DontFragment?
I've tried the following lines and get the following error messages:
<br />
Socket s = new Socket(IPEP.Address.AddressFamily, SocketType.Stream, ProtocolType.Tcp);<br />
s.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.DontFragment, true);<br />
Error: optionValue
<br />
Socket s = new Socket(IPEP.Address.AddressFamily, SocketType.Stream, ProtocolType.Tcp);<br />
s.SetSocketOption(SocketOptionLevel.Socket, SocketOptionName.DontFragment, 1);<br />
Error: An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call
I haven't been able to google any working examples, and MSDN is suprisingly general.
Thanks for your help!
|
|
|
|
|
I had the same fun trying to stop one of the base web services classes from sending a fragmented POST to the server... I found no resolution  I didnt get any errors though, but from viewing packet captures i could see no matter what, it still was fragmented...
top secret
Download xacc-ide 0.0.3 now!
See some screenshots
|
|
|
|
|
It's fairly gratifying to know that my programming skills are maturing to the point that I'm asking questions people don't know the answer to.
|
|
|
|
|
I’ve implemented a GUI for a tabletop device using C# and the .NET framework 1.1. At the moment, my interface consists of a collection of virtual sheets of paper in which you can draw. Those documents can be rotated and moved. For the first prototype, I implemented all the graphics by myself in the code. But now I have to reengineer this system in order to add functions. I’m planning to use the standard components, like buttons, textbox, panels, etc. Then, as the second step, I will use activeX, video players, PowerPoint documents, Excel documents etc. Of course, all those things should rotate as well.
So, the question is: Can I extend components, or forms (or generic Windows components...), in order to rotate them? As to as I now, it seems to be impossible to change the orientation of a Component’s ClipRectangle in C#, even if it’s only possible to rotate their graphic interface.
Are there some MS developers who can help me?
Here is the video of the first prototype:
CHILpromo_small.avi
|
|
|
|
|
You can rotate a graphics device using Graphics.Transform, then draw as you usually would, resulting in a transformed image.
using System.Drawing;
using System.Drawing.Drawing2d;
...
Matrix m = new Matrix();
m.Rotate(90);
graphicsSurface.Transform = m;
Any remotely useful information on my blog will be removed immediately. There are 10 kinds of people in the world. Those who have heard of the ubiquitous, overused, worn-out-like-an-old-shoe binary "joke" and those who haven't.
Judah Himango
|
|
|
|
|
to rotate only graphics is not enough. The client rectangle doesn't change, so the Hit-testing algorhythm is wrong.
|
|
|
|
|
|
I normally don't make post like this but PLEASE search before you ask a question. If you would have simply typed "datagrid checkbox" without the quotes into the CP search box you would have found your answer in a few seconds.
Besides The Code Project[^] another good link is http://www.datagridgirl.com[^]
-Richard
|
|
|
|
|
Sorry i meant to ask if i can do this using windows forms not asp .net
|
|
|
|
|
DataGridBoolColumn
CP and Google are your best friend...
|
|
|
|
|
Hi all,
I am living in the UK, using UK time format dd/mm/yyyy, both in the program and the database (MSAccess), but when I use the the comand text such as:
"SELECT ... WHERE(TheDate BETWEEN #"+startdate+"# AND #"+enddate+"#)"
the sql engin get confused between day and month fields and gives wrong result.
Is there any way to set the time format as a default to the UK format?
Thanks,
|
|
|
|
|
Use parameters instead:
"SELECT ... WHERE(TheDate BETWEEN ? AND ?)"
comm.Parameters.Add("startDate",OleDbType.Date);
comm.Parameters.Add("endDate",OleDbType.Date);
comm.Parameters[0].Value=startdate;
comm.Parameters[1].Value=enddate;
|
|
|
|
|
I know this is a RTFM kind of question, but I can't find the answer in the FM.
I have a C# project that uses libraries from an external application.
The instructions I have read:
you will need to change your project settings to include the following folders:
include paths:
[drive]:\Program Files\Blah\Blah\SDK\Include
executable paths:
[drive]:\Program Files\Blah\Blah\Bin
How do I do that?
Thanks.
|
|
|
|
|
Hi  )
I'm making a small pocket pc application, and would like it to access the Contact Database.
I have searched the net for days but can't find out how.
I don't know if it's a sqlce database.
Any help would be appreciated.
Steen
|
|
|
|
|
Hi,
I've put a datagrid in a tabPage. As in most cases the number of collumns exceed the width of the screen.
How can I make a scrollbar appear in this case ? (so horizontal,vertical)
More info. The tabControl holding the tabpage is put in an Panel.
Thanks in advance
|
|
|
|
|
I have a rather complex project in C# - that contains, among others, a Panel on which I have a number of objects of the same UserControl Type. The UserControl contains 4 PictureBoxes on it. Each PictureBox has an image associated to it, from the resources.. Sometimes, very rarely, but it happens, I get the following error:
System.ArgumentException: Invalid parameter used.
at System.Drawing.Image.get_Width()
at System.Drawing.Image.get_Size()
at System.Windows.Forms.PictureBox.GetPreferredSize()
at System.Windows.Forms.PictureBox.SetBoundsCore(Int32 x, Int32 y, Int32 width, Int32 height, BoundsSpecified specified)
at System.Windows.Forms.LayoutManager.LayoutDockedControls(Control container, LayoutEventArgs levent)
at System.Windows.Forms.LayoutManager.OnLayout(Control container, LayoutEventArgs levent)
at System.Windows.Forms.Control.OnLayout(LayoutEventArgs levent)
at System.Windows.Forms.ScrollableControl.OnLayout(LayoutEventArgs levent)
at System.Windows.Forms.Control.PerformLayout(Control affectedControl, String affectedProperty)
at System.Windows.Forms.Control.PerformLayout()
at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e)
at System.Windows.Forms.Control.WmShowWindow(Message& m)
I am not quite sure, but I think I ususally obtain this error when scrolling the panel on which the user controls are situated. The error, as I've said, happens only very seldom. I can't provide the code, since it is very large.
Any help would be greatly appreciatedly - maybe someone got into the same problem.
|
|
|
|
|
Hello, a simple question (or not), I want to register more than 1 channel http at the same application. I just want to do something like this:
System.Runtime.Remoting.Channels.Http.HttpChannel ch1 = new System.Runtime.Remoting.Channels.Http.HttpChannel(8100);
System.Runtime.Remoting.Channels.Http.HttpChannel ch2 = new System.Runtime.Remoting.Channels.Http.HttpChannel(8101);
System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(ch1);
System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(ch2);
Or a way for change the channel name.
tks
Wender Oliveira
.NET Programmer
|
|
|
|
|
Hello everyone
I'm just starting a project in C# sending data back and forth from a Pocket PC to a desktop machine.
I'm using sockets at the minute and it seems pretty straight forward to do this over WIFI or in a cradle via activesync but I'm struggling to find much to help me move this to use GPRS on say an XDA II.
I'm sure it can be done but I've not seen any examples or instructions in any books or on the web - can any of you guys point me in the right direction? I've seen examples of "Connection Manager" but it all seems to be C++ - can this be used in C# somehow?
Many Thanks
Matthew
|
|
|
|
|
Hi guys,
I have just been fiddling with a DataGrid for the first time and have managed to display pretty much what I want, except that it always highlights cell 0,0.
Is there an option somewhere that will stop this as it makes the grid look really nasty. The only option I could find that stopped it was DataGrid1.enabled = false but of course this has lots of other unwanted side-effects such as the columns cannot be resized by the user.
Any ideas would be much appreciated
Mike
|
|
|
|
|
I am programming in C# and I want to get direct access to the harddrive to read data and maybe later also write data.
I have looked at msdn but I dont really know what to search for. Maybe someone know what native functions I should call?, or point me in the right direction.
Thanks! // Anders
------------------------------
http://www.anderslinder.se
|
|
|
|
|
It's not accessing the hard drive directly, but you could call functions from the Win32 API. The page below covers the functions you can use. If you go to http://www.pinvoke.net/ you ought to be able to find the P/Invoke signatures to let you use them. Alternatively, you could created a class wrapper in Managed C++ that called the functions directly, and then consume that within your C# app.
http://jan.netcomp.monash.edu.au/ssw/files/win32.html[^]
--
Paul
"Put the key of despair into the lock of apathy. Turn the knob of mediocrity slowly and open the gates of despondency - welcome to a day in the average office."
- David Brent, from "The Office"
MS Messenger: paul@oobaloo.co.uk
Download my PGP public key
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Every control implements that interface. 