Answer Questions
Rraj MySql- Help me
I'm with a error in my mysql, I want to fill my database by a WinForms. An unhandled exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in mysql.data.dll Additional information: #42000Voce tem um erro de sintaxe no seu SQL proximo a 'page) VALUES (''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''')' na linha 1 My code is here down. using System; using MySql.Data.MySqlClient; using System.Data; namespace Rodrigues__Projeto { /// <summary> /// Summary description for Acesso. /// </summary> class SQL_methods { public static MySqlConnection Conexao_mysql() { MySqlConnection conn = new MySqlConnection(); try { ...Show All
R.Tutus how can i connect to paradox database file(.db) using ado.net
Hi , I am developing a windws application. the back end is sql server 2000 and (another application storing clients info in paradox format)paradox(.db).it also using bde ver 5.1. 1)What is the best way to connect to .db files(odbc/oledb/....) how 2)is it better to convert all .db file to sql and then connect (30 users are using the application that storing the info in .db format) 3)will i be able to update paradox files using ado.net 4)can i connect paradox via sql server 2000 then use that table in my application (the way we connect sql server 2000 via ms access) thanks vijay1 wrote: 1)What is the best way to connect to .db files(odbc/oledb/....) how Use .Net Pr ...Show All
ImGivingUp .Net 3.0 installation
Hi, I have VisualStudio .Net 2005 with Framework 2.0 installed in my system. My requirement is to install .Net 3.0 to work on WPF . I downloaded dotnetfxsetup.exe from MS site [ redistributable package - 2.8 MB ] . While installing it tries to refer internet for another download. I donot have internet connection so I need to download entire stuff from another m/c and move to my system to install. How to get the downloads. Please provide me the link. Thanks & Regards Vijay I had exactly same problem.. :) Thanks. Do I really have to download WinFX SDK and Runtime Components I installed everything else and also tried to install WPF extensions for Visual Studio 2 ...Show All
Mihir_Soni_bcdb9d Need of a fast timer
Hi, I was wondering if there were a faster timer than the control timer provided in the toolbox. I would like to take some value from a controller card at a rate of around 10-20 KHz. Or I was wondering if it is possible to have an infinite loop ( which stop when I press a buton), with a function which tells to do any events ( move mouse, paint, close...) that may appear Thank you for your answer, Eric Hi, Timer control in the toolbox has a interval number base on milliseconds. The minimum rate is 1 millisecond. For control a timer with event you can use of Enable/Disable properties of a timer. You probably want a thread that sleeps at x amount of milliseconds Thread TmpThread = new Thread(new Para ...Show All
Wil Burton how to Insert data to MS Database from listbox
I've dropdownlist x1 and listbox x1 I can select which user's information I want to show on listbox by dropdownlist. the content of dropdownlist is binding with database it presents on dropdownlist is like Andy、Joan ... we can reference to Database to get it's index ( like 1, 2 ... ) if user select Andy, I want listbox shows Andy's information and then save user's index and information both to difference column in same table like that , Andy's index is 1 so save 1 to column1 Andy's information is "math" and "calculus" and save math's index 1 and calculus's index 2 to column2 so we can get result like below index ∣course 1 ∣ 1 1 ∣ 2 is it possible if yes, coul ...Show All
Eric66 Acces Database
Hi, I'm trying to add some variables to an access database that has one table with three columns. The code doesn't produce any errors but when I open the database file there is no data. Here's my code "data" as an instance of a dataset called RDXInfoDataSet data.Table1.AddTable1Row(type, extn, linetype) data.Table1.AcceptChanges() data.AcceptChanges() Any ideas why it's not working well firstly, you shouldnt use AcceptChanges() in this case as it will tell the DataAdapter (which fills the records to the dataset from the database and updates the database from the new values in the dataset) that there are no updates to be made but infact ther ...Show All
Ryan Sanders Codedom generic contraints
Simple CodeDom question. It seems simple enough to set constraints on a generic method, using CodeTypeParameter properties HasConstructorConstraint and Constraints, but I can't see how to use them to add a class or struct consraint. Any ideas Thanks Tim Misunderstood your question, sorry I'm also looking for an answer on this... Apologies - it was late when I wrote the original post. Here's some more information. // I've created my method: CodeMemberMethod method = new CodeMemberMethod(); method.Name = "MyMethod"; method.Attributes = MemberAttributes.Public | Memb ...Show All
Bradrover IoCompletion handle
Hi. I'm not sure this is a right topic for that section. I have a problem with growing number of IOCompletion Threads. In our producion environment we have from time to time ExecutionEngineException. I was trying to understand what is going on and started from analysing DUMP file. I found that there are more than 1000 thread doing IOCompletion operation: 103 76 528 084fe878 880b220 Enabled 00000000:00000000 0014d518 0 MTA (Threadpool Completion Port) the stack of the each of them is: 0:044> ~103e k ChildEBP RetAddr 0e4af0f8 7c90e31b ntdll!KiFastSystemCallRet 0e4af0fc 7c80a746 ntdll!ZwRemoveIoCompletion+0xc 0e4af128 79f2f30a KERNEL32!GetQueuedCompletionStatus+0x29 0e4af194 79ecb00b mscorwks!ThreadpoolMgr::CompletionPo ...Show All
Helen999888 TCP keepAlive settings problem
am trying to set the keepalive timer by the setting the keep alive option in setsockopt Cli.SetSocketOption( SocketOptionLevel .Socket, SocketOptionName .KeepAlive, true ); i found something in .net similar to the WSAIoctl(socketid,SIO_KEEPALIVE_VALS,struct tcp_keepalive settings,...) in winsock2 library which sends keep alive messages every n milliseconds specified by the tcp_keepalive.keepalivetime. the api am trying to use is this Cli.IOControl( IOControlCode .KeepAliveValues,...,...); can someone tell me how to use this api to set the keepalive time and interval to the socket or does the .NET framework is incapable of doing something similar. Thanks in advance Sathish On the receivin ...Show All
Pastards Classes that reference eachother
I'm creating a music organization application. I have tracks and playlists and I want to be able to access the playlists from each track and I want to be able to access tracks from the playlists. So each class needs to reference the other. Anybody have an example on how I should do this I want to make sure I do it right from the beginning. Thanks JGA I kind of follow that... Can you provide a very simple example Store the Track objects in a collection member of a Playlist (like List<Track>). Have the Track constructor take a Playlist reference that you then store in a private member. That way, you can always find the Playlist back that the track belongs to. ...Show All
Denis A.B. Measure data-traffic per IP-adress
I have a pc with a number of devices connected to it. They are all connected via an utp cable. All devices have their own IP-adress. Now I want to measure the traffic of this data. In this way I want to check wether there is activity at the device (scanner). So when the number of bytes during a certain period is below a certain value, it must start another process. This must be monitored per IP adress. I want to use C# code to make this work. It's not my goal to measury the connectivity, I've read several articles on that subject. It's really about the quantity of data. Other recommendations regarding this subject are welcome as well. Thanks in advance! Thanks, but is there any of this code in .NET I only see C++ and th ...Show All
A.F.B Windows App and DNF Version
I have an application in production that is a Windows App using framework 1.1. I need to install the framework 2.0 on this production box, but need this windows app to continue to use fw 1.1. I don't see a setting in the app that specifies the framework version to use. What do I need to do to ensure that this app still uses 1.1 instead of 2.0 Thanks I believe you may need to set it in the configuration http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpgenref/html/gngrfrequiredruntime.asp I'm not sure but I think it should be ok to run the .NET 1.1 app on .NET 2.0 framework, but do not quote me. you can install the .NET Frameworks side by side without interference and I think ...Show All
Alexandre Martins Tricky P/Invoke calls
Hi, I'm trying to read a 3D input device in C#, but some of the dll call signatures are a bit complicated and not well covered in the examples I've found. One example (C++): SpwRetVal SiGetDeviceName(SiHdl hdl, SiDeviceName *pname) typedef struct { char name[SI_STRSIZE]; } SiDeviceName; In C#, I tried with static extern SpwRetVal SiGetDeviceName(IntPtr siHdl, out byte* name) which indeed returns a pointer (which I though I would be able to "parse" manually), but it cannot be dereferenced. I also tried [StructLayout(LayoutKind.Sequential)] struct SiDeviceName { char[] name; } and static extern SpwRetVal SiGetDeviceName(IntPtr siHdl, out SiDeviceName name) but that throws an write protected memory exception. ...Show All
Ecrofirt Attributes and inheritance on fields/properties/methods
Hi there! I'm trying to work out how (if at all) attributes are inherited on overriden fields properties and methods. According to this msdn page , they are inherited, but how do you retrieve these attributes Here's some code I'm testing with... I've discovered that the static method Attribute.GetCustomAttribute works as you would expect with inherited attributes, just in case anyone else is having the same problem. It would still be helpful to understand why the above doesn't work like this though. I believe you are mixing concepts here and this is causing confusion. Let's first tackle attribute inheritance. By default attributes are inherited but this is not necessarily the case. When an attribute is created the AttributeUsage ...Show All
yuhatn Why this kind of exception handling
hi, Please see the below code Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try fun() Catch ex As Exception MsgBox(ex.Message) MsgBox(ex.StackTrace) End Try End Sub Private Function fun() Dim a, b, c As Integer Try a = 0 b = 0 c = a / b Catch ex As Exception MsgBox("Reached fun_catch()") fun1() Finally MsgBox("Reached fun_finally()") gan2() End Try End Function Private Function fun1() Dim s, s1 As String s1 = s.IndexOf("a") End Function Private Function fun2() Dim s, s1 As String Throw New EntryPointNotFoundExce ...Show All
