lolafuertes

Wich are the SQL sentences you have written in the [URL="http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.deletecommand.aspx"]DeleteCommand[/URL], [URL="http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.insertcommand.aspx"]InsertCommand[/URL] and [URL="http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.updatecommand.aspx"]UpdateCommand[/URL] of your OleDbDataAdapter? They ar not shown in your code and are required to call the Update. Sincerely

If the relation is defined to have cascade triggers on update and/or deletion, then the user must have permissions to update and/or delete in all the child related tables. If the cascade has multiple levels this applies to each level of the cascade trigger. See [URL="http://msdn.microsoft.com/en-us/library/aa902684(v=sql.80).aspx"]this article[/URL] There is another …

Please be so kind to post what you have written so far to try to detect where the problem is. Sincerely

If you use a dataset to hold the relevant info, when the user changes the filter criteria you can: - Fill it with an adhoc query or - Create a DataRowView agains the relevant datatable to filter the required data or - Use a Linq expression to select the relevant …

You can start reading [URL="http://msdn.microsoft.com/en-us/library/aa288453(v=vs.71).aspx"]this[/URL] to learn how arrays work in C#. Hope this helps

The message states that the contents of ds.Tables("Patient Database").Rows(inc).Item("ID") is not a valid image. Even if it was, an image is a large binary object, that has an special treatement to be retrieved (see [URL="http://support.microsoft.com/kb/194975/en-us"]here[/URL]) Is best to save in the database only the path to the image (normally will …

Please post what you have designed/written so far. Sincerely

IMO the easy way is to use a dataset. The dataset can contain a table holding a row for each seat with the relevant seat info. The dataset can be persisted on a XML file when exiting, and can be retireved at the start of the program. As is in …

One of the ways to obtain what you need is to create a Sub FillOrdersCombo using a paramenter indicating the Idvalue of the selected item in lbMatchingAccounts, to be called when the account is OK. in order the call to this sub does not fail, you will need tochange silightly …

Every high level languages has a compiler( or interpreter) who is responsible to translate them into machine low level code. In C#, the compiler produces executable (.exe) files, dynamic-link libraries (.dll), or code modules (.netmodule) depending the options you use. The code modules need to be linked in order to …

I assume that on the mouse hover and leave events you are assigning the right image. Then, do you call testToolStripMenuItem.Invalidate after assigning the new image to force the redraw of the control? Hope this helps

Actually is not an infinite loop. It will run for 100 times, when you need only 10. You can simplify the for-next using: [CODE] For row = 0 To ROWS - 1 For column = 0 To COLUMNS - 1 Console.WriteLine("Enrollment for " + campus(column) + " for the " …

Use the system.globalization to get the cultureinfo for the CurrentUICulture to obtain the decimal char, thousands separator, etc. and replace them by those of the invatiant culture. The thousands separators can be safely removed. Hope this helps

This namespace is available throug the Data Designer Extensibility (DDEX) SDK (part of the Visual Studio Industry Partner [VSIP] installation). Then it appears as reference to add to your project. For info on how to obtain it you can navigate [URL="http://msdn.microsoft.com/en-us/vstudio/dd637761"]here[/URL] Hope this helps.

In C# static means no need for instantiation. Inside a static method (Main) you ar calling a non static function Addtion. According to the C# rules, you need to declare Addtion as static like [CODE]static public int Addtion(int number1, int number2)[/CODE] Hope this helps

IMO The best way is to add a field indicating the source table, then another with the key value to the source service. The PK would be both fields. This way, you can have the same key value, but always coming from a distinct table. Be aware to add a …

If any conversion shoult take pleace, always is recommended to use a try/catch structure to catch any exception and be able to process as expected. Most of the problems with number conversions came of not testing, with some regex, that the input value is a valid number. Also, many times …

In the resources tab of your project properties, you need to import the image into the resources of the project (not the resource folder). This will create a resource file containing the resources of text, images, icons and any other kind of serializable object you need. Hope this helps

Can you be so kind to explain wich method you used to fill the data grid view (or post the code)?

On this [URL="http://sourceforge.net/projects/emule/files/eMule/0.50a/eMule0.50a-Sources.zip/download"]link[/URL] you can download an example of P2P allowing file sharing, messaging between peers, an a few utilities more. This is an open source from Source Forge so you must honor the creator open source license. Hope this helps.

I hope you already installed the MySql .Net Connector and you see MySQL Database in the data sources for your project. Please refer to this [URL="http://dev.mysql.com/doc/refman/5.1/en/connector-net-visual-studio-making-a-connection.html"]link[/URL] showing how to do the connection Hope this helps

@Mitja Bonca: Your answer does not solves the question. Your string length is 10, while the equivalent long length is only 9.

This behaviur is the default. You can change it at Control Panel, Ease of Access Center, Make the keyboard easier to use, and check the option Underline keyboard shortcuts and access keys, then click on Save button, at each computer you want to change it.

Just to clarify, in your mdb, all the fields of your table are string? Usually, the overflow message cames when you try to insert a non numeric value in a numeric field or a non date (or bad formatted date) in a date field. TIA

Before exiting the form_key functions, do you set the handled to true, false or do nothing? Did you analize wich control has the focus to change the behaviour?

Every drive has a root folder know as "\". So starting at drive letter to search and root dir (IE: "F:\") you can use this to obtain a [URL="http://msdn.microsoft.com/en-us/library/system.io.directoryinfo.aspx"]System.IO.DirectoryInfo[/URL][CODE]var RootDir = new System.IO.DirectoryInfo("F:\\")[/CODE] Just be aware that you need to specify a doube backslash in order to be interpreted a …

May be helpful to know which ODBC driver are you using? also which parameters?

Use the Environ function searching for the "SystemDrive". (see [URL="http://msdn.microsoft.com/en-us/library/0fx287h4(v=VS.90).aspx"]this[/URL]) Also you can use the System.Environment.SystemDirectory to get the full path (see [URL="http://msdn.microsoft.com/en-us/library/system.environment.systemdirectory.aspx"]there[/URL])

Even references a C# solution, have you read [URL="http://dranaxum.wordpress.com/2008/02/25/dynamic-load-net-dll-files-creating-a-plug-in-system-c/"]this[/URL]? Hope this helps

See [URL="http://msdn.microsoft.com/en-us/library/fht0f5be(v=vs.80).aspx"]string.Format[/URL] and [URL="http://msdn.microsoft.com/en-us/library/dwhawy9k(v=VS.100).aspx"]here[/URL] for standar numbers formatting or [URL="http://msdn.microsoft.com/en-us/library/0c899ak8(v=VS.100).aspx"]here[/URL] for custom formatting. Hope this helps.

Use a macro with the 'AutoRun' name Hope this helps

Did you End your program? I we can see your code, maybe we can better help.

If you inherit, the inherited should have the same visibility than the inheritant. If really the only contents is the connecttodatabase, best use private to declare the kaysonsSPdetails class and then use public to declare the connecttodatabase. To use this class, then you can use[CODE]public class DemoDvd { var k …

If I remember well, the new can be ommitted since .NET 2.0 The usage of new was to 'create' a pointer to the method, on versions 1.0 and 1.1, wich contents was used to add or remove it from the list of pointers to be called when an event is …

If you need to retrieve the largest value from the table, doing a [CODE]SELECT MAX(CategoryNumber) FROM Categories[/CODE] will return the expected value, that can be read using a data reader into an (i.e.) integer The the result from the query can then be compared with the value entered on the …

Change the line 7 to: dfol = "..\" & Foldername Hope this helps

I use [URL="http://www.fpoint.com/netproducts/spreadwin/spreadwin.aspx"]FarPoint[/URL] to do this. There are many libraries in the Internet to do it, but Excel. Hope this helps

What is the actual content of lblProductPrice.Text when the error is thrown?

On the main form you receive the [B]new[/B] account value created locally (empty / blank). The [B]Account account[/B] variable should be defined in the [B]program[/B] class with public visibility, before the login form is launched. Then the login form mut [B]not[/B] define a local variable intead must use the public …

You must use the same structure than in the button1 on button 2 to fill also the ListBox2 [CODE] ListBox1.Items.Clear() ListBox2.Items.Clear() tt = 0 ara.Sort() For Each I As Integer In ara ListBox1.Items.Add(I) tt += I ListBox2.Items.Add(tt) Next[/CODE] Hope this helps

Yes, you can:[CODE]MydataGridView = null; MyDataGridView = new DataGridView();[/CODE] Hope this helps

If this question is phyton related, best put it on the Phyton forum.

If all the forms and classes are in the same project, you can add [CODE]using Namespace2[/CODE]in the top of the forms, and you will be able to get the expected sintaxis. Hope this helps

The most similar in SQL [CODE]SELECT dbo.Trans_Head.Doc_Date, dbo.Trans_Head.Document_No, dbo.Trans_Head.Account_Type, dbo.NewAccount.Surname + '' + dbo.NewAccount.First_Name AS Account_Holder, dbo.Trans_Details.Account_Name,SUM(ISNULL(CASE dbo.Trans_Details.Trans_type WHEN 'DR' THEN dbo.Trans_Details.Amount ELSE 0 END, 0)) Payemnt, SUM(ISNULL(CASE dbo.Trans_Details.Trans_type WHEN 'CR' THEN dbo.Trans_Details.Amount ELSE 0 END, 0)) Receipts FROM dbo.NewAccount INNER JOIN dbo.Trans_Details ON dbo.NewAccount.Account_no = dbo.Trans_Details.Account_No INNER JOIN dbo.Trans_Head …

[QUOTE]but I'm having truble setting the value of the private variable with the values returned but a single SqlDataReader:[/QUOTE] Can you be so kind to clarify?

Use [CODE] Structure X Public a As Integer Public b As String End Structure[/CODE] Hope this helps

Your first field to insert cames from a date picker, so I guess it is a date. If a date field is defined un the user table, you should put a value, between apostrophes like a text, and in the format of yyyy-MM-dd to be clearly understood by MySql like …

As far a I know, the OnStart will be launched when you issue a Start of the service. This will initialize the service and launch the [B]main[/B] thread. You need to provide a mechanism to stop when the OnStop is launched. Normally an static boolean is enough to [B]notify[/B] the …

Use the SelectedItemChanged on the combo to cath the new selection. Then modify the Unit cost according. Hope this helps

See [URL="http://www.daniweb.com/forums/thread104775.html"]here[/URL] as one starting point There are hundreds of examples if you search UPLOAD EXCEL in this site. Hope this helps