Comments by Michael_Davies

Michael_Davies 12-Jan-23 3:54am View

Deleted

^__i class="icon-instagram text-white">
^__i class="icon-paper-plane text-white">

Michael_Davies 4-Dec-22 9:17am View

Looking at MS documentation they recommend not using SMTPClient but Mailkit instead, for reasons of security (looks like I'll have to update my old app.).

https://stackoverflow.com/questions/20228644/smtpexception-unable-to-read-data-from-the-transport-connection-net-io-connect

Michael_Davies 4-Dec-22 8:12am View

What is the error message, add a Try Catch around the send and catch the error message.

I have similar code using Gmail, apart from actual values, the only extra I add is the SMTPClient Delivery method set to Network but not likely to be a problem.

Michael_Davies 19-Nov-22 9:21am View

sorry...meant 12 12 ... remmebering I said "IF n was 21", obviously not 21 as it is the index in the loop so will be 0 at the end...

Michael_Davies 19-Nov-22 8:11am View

printf("The reverse of %d is %d",n , n , reverse);

Three parameters only two %d... so if n was 21 and reverse was 12 it would print 21 21.

Michael_Davies 1-Nov-22 14:14pm View

Hi, See https://www.codeproject.com/Questions/441965/How-to-add-new-row-at-particular-position-in-datag

Michael_Davies 20-Oct-22 10:17am View

I used an online VB to C# converter...

while (Marshal.ReleaseComObject(excelApp) != 0)
Application.DoEvents();

Michael_Davies 20-Oct-22 9:38am View

So add the :

While System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp) <> 0
Application.DoEvents()
End While

Also see this page for MS advice on Excel & COM

https://learn.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-visual-c

Michael_Davies 30-Sep-22 5:10am View

What partition type is MySQL installed on the working and the non-working, there were issues with GPT partitions.

Michael_Davies 30-Sep-22 2:38am View

Try adding innodb_flush_method=normal to the ini.

Michael_Davies 16-Sep-22 7:22am View

Check this out; https://topic.alibabacloud.com/a/several-methods-of-mfc-hide-main-window-running_8_8_10256747.html

Michael_Davies 16-Sep-22 7:05am View

Do they have a hide/show methods for dialog?

Michael_Davies 15-Sep-22 13:57pm View

In which case I would cut out OleDB and use OpenXML to read the Excel file, there are several examples using OpenXML to load a DataTable, one I have used is the ExcelUtility.cs on the link below.

https://stackoverflow.com/questions/3321082/from-excel-to-datatable-in-c-sharp-with-open-xml

Michael_Davies 15-Sep-22 9:56am View

Have you tried changing Pooling behaviour?

https://www.visualbasicplanet.info/client-development/configuring-connection-pooling-with-ole-db-connections.html

Michael_Davies 6-Apr-22 10:00am View

Hard to say what may be the issue as the parameter contents are not visible, hard code the parameters to test, so set the host, port etc. hard values and test until success.

Try port 465 with SSL. If you use port 587 or 465 then SSL=true. Google uses port 465 for SSL, 587 is Start/TLS and non-secured is port 25.

You say no to standard credentials, however credentials are required if the server requires the client to authenticate before it will send email on the client's behalf and secure ports do require authentication.

If the account has 2fa enabled then you may have to generate and use an App password. When you log in to Gmail for the first time on a device Gmail will challenge the log in, once logged in the device is recognised and generally will not challenge again (2fa gives the option to never ask again on the device). This may be why it works locally but not on your server, locally you have logged in so Gmail allows the traffic whereas on your server Gmail is challenging and not getting a response and drops the requests.

Take a look at https://www.c-sharpcorner.com/UploadFile/009464/send-email-to-gmail-in-Asp-Net-using-C-Sharp/

Michael_Davies 29-Aug-21 12:47pm View

Hi Marc,
Microsoft have either taken down or moved the article, here is the Codeproject link to an article with the code;

https://www.codeproject.com/Tips/704989/Print-Direct-To-Windows-Printer-EPOS-Receipt

Michael_Davies 14-Mar-18 4:11am View

Have you tried using Windows Image Acquisition library, one of the properties may indicate state.

Severla sites, try this https://social.microsoft.com/Forums/en-US/4b350704-d9b3-4920-a68a-802f5f4e8a6a/how-to-retrieve-installed-scanner-win32scanner?forum=netfxbcl

Michael_Davies 30-Aug-17 8:29am View

Try .setModel(null) or from the root .removeAllChildren() plenty more on Google...

Michael_Davies 29-Aug-17 10:21am View

Having got your list of the cust_id's into myList use them in the button create routine instead of cmd.Text="button_"& (count + 1).

Michael_Davies 26-Aug-17 12:37pm View

Use the debugger and check the value of i to be certain it returned 1.

Michael_Davies 25-Aug-17 13:33pm View

AFAIK please see https://code.msdn.microsoft.com/windowsdesktop/access-2007-oledb-with-2fed4cc1

Either way he is mixing ? with placeholder names.

Michael_Davies 25-Aug-17 4:58am View

Then it is not a table vs dataset issue as per the title of your question.

Michael_Davies 25-Aug-17 4:01am View

The DataSet contains at least one Table, use that.

myRrpt.SetDataSource(dsCustomers.Tables(0))

Instead of the index you can use the table name.

Michael_Davies 23-Aug-17 1:42am View

Have you opened the cover or removed the paper to create a state other than okay then tried reading the status?

Michael_Davies 19-Aug-17 13:14pm View

Set it to 32 bit and see if it fixes, the first chance faults occur when resources load (in this case OLEDB), Microsoft.ACE.OLEDB.12.0 is 32 bit. Lots of articles on the subject here's one using the same for Excel; https://blogs.msdn.microsoft.com/farukcelik/2010/06/04/accessing-excel-files-on-a-x64-machine/

Michael_Davies 18-Aug-17 15:10pm View

Is your project 64 or 32 bit?

Michael_Davies 16-Aug-17 7:49am View

It looks to me like you initialise the queue manager without any parameters, which is acceptable, however you do not then supply the parameters before using the initialised object.

See https://www.ibm.com/support/knowledgecenter/en/SSFKSJ_7.5.0/com.ibm.mq.ref.dev.doc/q111270_.htm#q111270___c

Michael_Davies 15-Aug-17 7:07am View

Change the Access Rights & File Security;

https://msdn.microsoft.com/en-us/library/system.security.accesscontrol.filesecurity(v=vs.110).aspx

Michael_Davies 12-Aug-17 15:23pm View

Which barcode reader device, is it a keyboard insertion type?

Michael_Davies 9-Aug-17 1:50am View

Use the debugger to check the results as it may be that the query is not returning a value, I think dates for Access need to be enclosed by #'s.

rs3.Open "select sum(TotalHours) as thrs from tbldwardetails where employeesid =" & Val(empids) & " And dwardate=#" & Val(dwardate) & "#", db, 3, 3

Also not sure why you you Val() the date, the date in this case is not a number but a string.

Michael_Davies 7-Aug-17 11:47am View

Typo?

cmd.Parameters.AddWithValue("[@Ethnic", TextBox6.Text)

and

cmd.Parameters.AddWithValue("@@TypeofBiochemistry", TextBox51.Text)

Also putting [] round a name means it is a field/variable name, not sure but to me the result of putting [] round the data values would produce just that literally [the actual data] whereas you just want just the data, again not sure of the result as never done it, it just looks so wrong.

Using ' in a field name, asking for trouble.

Looking at the other posting raised by Graeme you have not even tried with the help given, all of the above I've just mentioned is mentioned there, fix the issues and come back if it still fails.

Michael_Davies 6-Aug-17 13:54pm View

Not that it is the answer but shouldn't this be dataGridView1.Columns.Count-1?

for (int j = 0; j < dataGridView1.Columns.Count; j++)

Also the inner for loop across the columns will not store the first row of the datagridview as you use the first row setting to set the headers and the data will not store as it is on the else.

Personally i would;

1. store the data starting at row 2 of the sheet.
2. store the header names in the top row, row 1 of the sheet.

	int cellRowIndex = 2;
	int cellColumnIndex;

	for (int i = 0; i < dataGridView1.Rows.Count - 1; i++, cellRowIndex++)
	{
		cellColumnIndex = 1;

		for (int j = 0; j < dataGridView1.Columns.Count - 1; j++, cellColumnIndex++)
		{
			worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j].Value.ToString();
		}
	}

	cellColumnIndex = 1;

	for (int j = 0; j < dataGridView1.Columns.Count - 1; j++, cellColumnIndex++)
	{
		worksheet.Cells[1, cellColumnIndex] = dataGridView1.Columns[j].HeaderText;
	}

Michael_Davies 6-Aug-17 12:09pm View

Is the Data; valid? and should'nt it be DATA SOURCE not DATASOURCE

Try;

<add key="connection" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Varun\\Documents\\InventoryManagement.accdb" />

https://www.connectionstrings.com/access/

Michael_Davies 6-Aug-17 2:58am View

What do you mean by online, do you mean a server on the internet or on the local network. MS Access requires access to the physical file and its location.

In both cases you'll need to change the DATA SOURCE to the correct location and have access rights to that location;

For a server on the internet, basically, you'll need to have a secure access path to reach the file, not a good idea better to have a server side SQL engine like MS SQL, MySQL etc.

For the local network share the directory that the DB file is located in then access it using \\<machine name here>\<share name here>\Mydb.mdb.

Michael_Davies 6-Aug-17 2:35am View

There's more than one Temp directory, System.IO.Path.GetTempPath() returns the first temp directory it finds in a search list;

This method checks for the existence of environment variables in the following order and uses the first path found:

The path specified by the TMP environment variable.
The path specified by the TEMP environment variable.
The path specified by the USERPROFILE environment variable.
The Windows directory.

The Temp variable is set to the system's temp directory, usually C:\Windows\Temp and you need access rights before you can even list the contents.

There are other temps for the user in the <User Profile Dir>\AppData folder in Local and Roaming sub directories. It might be better to check them for a Temp directory and then delete from them, the only thing that would prevent a file being deleted there would be that it was open by another process.

To gain access to the Windows\Temp see https://msdn.microsoft.com/en-us/library/c1f66bc2(v=vs.110).aspx

Michael_Davies 6-Aug-17 1:54am View

Are you sure it is the excelConnection.Open giving the fault then, as the error seems to be related to the Access DB, there is no file name in the strConnection, just what looks like the network name of a PC and the error shows the file name as '' which is no name.

Michael_Davies 4-Aug-17 2:01am View

Difficult as not sure how you are getting your buttons data, nor how C# behaves with an array of Button and assigning to the screen Button.

I have a table with button details; page, buttonid, text, PLU, back and fore color.

The operator has 7 page buttons that select which page is being shown on the 50 buttons.

When the page button is selected I initialise all the buttons to a default blank state using the array then read the records with that page from the table setting the details for the button in the array using buttonid as the index.

The program also allows them to edit the buttons setting colors, text, image if required though experience shows it is best without, and a PLU stored in the button .Tag so that when it is clicked the .Tag is used to find and process the item.

Michael_Davies 3-Aug-17 8:57am View

Not sure how you are managing your buttons but when loading;

Loop all buttons and set attribute to hidden.

Loop reading your data and assigning to a button and set the attribute to visible.

I use VB and have an array of button and assign each element to one of the onscreen buttons, then looping the array changing text and attributes affects the button and keeps it simple.

Michael_Davies 3-Aug-17 8:19am View

In which case set all your buttons to hidden then as you populate a button set it to not hidden.

I do a similar thing for a POS till project, I do not hide the buttons just set them to enabled=false as it looks better on screen.

Michael_Davies 3-Aug-17 8:19am View

Deleted

In which case set all your buttons to hidden then as you populate a button set it to not hidden.

Michael_Davies 3-Aug-17 5:01am View

What have you tried, it is impossible to help you as we do not even know your table schema nor how you determine which rows to hide.

You only tag your question as C#, presume you are using SQL as well. To determine the number of records in a table you could just SELECT COUNT(*) FROM <tablename>;

Michael_Davies 2-Aug-17 13:42pm View

Not without seeing your code.

Michael_Davies 2-Aug-17 7:43am View

Don't use float to store "money", you'll not get the right answers...

Michael_Davies 1-Aug-17 1:44am View

What does this do?

txtEnter.Rows.Clear();

Michael_Davies 31-Jul-17 5:39am View

So again I ask do you call ReadServerData more than once?

Michael_Davies 30-Jul-17 9:11am View

So you have an application that gives an error and you show code that is relevant to that error but it is not the code and you are not using it, people can only help with the question you ask and the code you show otherwise you are just wasting other peoples time.

Michael_Davies 30-Jul-17 6:30am View

Are you calling ReadServerData more than once?

You attach to the port, execute your loop and break on \n\n but do not disconnect the listener, which means if you execute it again it will try to attach a new listener.

Michael_Davies 30-Jul-17 5:43am View

That error would usually mean that some other application is already hooked onto the port for listening, close that application.

To see which application open a cmd prompt and type netstat -an

Michael_Davies 29-Jul-17 8:13am View

txt_Adults is the textbox control, hopefully it is not Null as the event handler was fired by it, you probably mean to check that txt_Adults has text, use either (txt_Adults.Text != "") or (txt_Adults.Text.Length != 0).

if (txt_Adults.Text.Length != 0)
{
int32 tempValue;

	if (int32.TryParse(txt_Adults.Text, tempValue) == true)
	{
//
// tempValue now contains the integer value of the text
//
		if (tempValue > Max_NoAdults)
		{
			txt_Adults.Text = "";
			txt_Adults.Focus();
		}
		else if(tempValue <= Max_NoAdults)
		{
			NoAdults = tempValue;
		}
	}
	else
	{
		txt_Adults.Focus();
	}
}

Michael_Davies 29-Jul-17 7:07am View

Use the Improve question and show your code as it is now.

Michael_Davies 29-Jul-17 6:45am View

AES_ENCRYPT will return a string of bytes and cannot be stored in an integer field, you column will have to be varbinary or blob, see the documentation https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html.

This makes it difficult if you need to perform mathematical operations or numeric comparisons.

Michael_Davies 29-Jul-17 4:32am View

Lots of issues in your code, take a look at these;

You are using a While on an event handler with potentially never ending loop.

You test if the control txt_Adults is Null or not, as it is a handler for the txt_Adults control you can safely assume txt_adults exists.

You Convert.ToString a literal that is a string "0".

You appear not to verify that txt_Adults contains only numeric and simply Convert it, if the user types anything other than numbers you will get an exception.

Michael_Davies 27-Jul-17 6:47am View

Do not use a TextBox for fixed selectable values, the user can type what they like, for instance if they type "Gold" there will be no discount, use a ComboBox.

Michael_Davies 24-Jul-17 15:53pm View

It would be useful to see the input string.

Michael_Davies 15-Jul-17 11:05am View

The files are text files you do not need the IDE to open them, any text editor will do, even Notepad.

Michael_Davies 14-Jul-17 16:16pm View

If your certain that the C:\Users\SomeUserNameHere\... never changes then all you have to do is extract the string part after the third backslash which is possible in Regex, you could also split the string to an array using \ to get the components.

Using split;

Dim sIn As String = "C:\Users\CoolDude\Documents\Access\Test.pdf"
Dim sOut() As String

sOut = sIn.Split("\\")

The array sOut would then have the following elements;

C:
User
CoolDude
Documents
Access
Test.pdf

You could then reconstruct a string from element 3.

Bear in mind that a users working directories can be moved, like mine I never keep them on the C: drive, to another location in which case the rules would possibly change.

Michael_Davies 14-Jul-17 2:56am View

Try port 465.

Michael_Davies 13-Jul-17 11:14am View

The Zebra manual is freely available online https://www.zebra.com/content/dam/zebra/manuals/en-us/software/zpl-zbi2-pm-en.pdf

And Google finds a lot of examples including this one;

https://www.manualslib.com/manual/199681/Zebra-Stripe-S-500.html?page=31

Michael_Davies 13-Jul-17 5:49am View

Normally a printer that natively supports barcode printing does not require you to send an image of a barcode you send a command with data and it is done for you.

If you do not know the printer manufacturer you are/will be using then it is not possible to tell you how as you would need to get the manufacturers manual; for instance Zebra printers use a command language to print data and barcodes, most epos receipt printer use the Epson escape sequences and can print barcodes.

For a printer that does not support barcode printing by command you would have to construct a graphic and send the graphic to the printer.

Michael_Davies 13-Jul-17 1:37am View

What is the make and model of the printer and have you checked the printers documentation.

Most printers that support barcode do not require the barcode to be sent as an image it is usually done by a text command.

Michael_Davies 12-Jul-17 6:08am View

Rather than testing the length with so many nested If's you could just;

penfaktur.Text = "" + Format(Now, "ddMMyyyy") + penfaktur.Text.PadLeft("0",4) & ""

Also you are using old BASIC function calls like Val and Mid when there are methods and functions on strings in .Net.

Have not tested this but just to show;

penfaktur.Text = (Integer.Parse(dr.Item("no_faktur").ToString.SubString(10, 4)) + 1).Tostring

Also you need to be certain that there was a number in the string or you will get an exception.

Michael_Davies 12-Jul-17 2:52am View

Where is your code, we cannot see what you are doing.

Also a quick Google gives; https://social.msdn.microsoft.com/Forums/windows/en-US/db486d50-48f3-405d-bc7a-ad3720d4dd57/datagridview-how-to-capture-a-cells-keypress-event?forum=winformsdatacontrols

Michael_Davies 11-Jul-17 1:51am View

Use the online reference for the method and you will find you can put a file name in the parenthesis for the workbooks.add.

bookList is never assigned/created therefore it is nothing and you cannot use nothing... and as you do not need it you may as well discard it.

Try: ThisWorkbook.Application.ScreenUpdating = False

Michael_Davies 10-Jul-17 15:46pm View

Had a go using your code and it worked fine for me, added the Excel 12.0 reference and then did this;

Dim exapp As Microsoft.Office.Interop.Excel.Application = New Microsoft.Office.Interop.Excel.Application
Dim workb As Microsoft.Office.Interop.Excel.Workbooks
Dim ThisWorkbook As Microsoft.Office.Interop.Excel.Workbook = exapp.Workbooks.Add()

No problem.

Michael_Davies 10-Jul-17 15:31pm View

Advice : Before you exit your sub make sure you disconnect from the exapp;

While System.Runtime.InteropServices.Marshal.ReleaseComObject(exapp) <> 0
Application.DoEvents()
End While

exapp = Nothing

Michael_Davies 10-Jul-17 9:49am View

Your dates and the AND are in quotes so treated as a single entity;

and purinvdt BETWEEN '" & txtdtf.Text & " And " & txtdtt.Text & "' ORDER BY

You open the quote after the BETWEEN and close it after the second date, whereas it ought possibly to be;

and purinvdt BETWEEN '" & txtdtf.Text & "' And '" & txtdtt.Text & "' ORDER BY

Michael_Davies 8-Jul-17 13:45pm View

In .Net Framework a Try<something> attempts to perform the task required, if it fails the answer is usually Null, it does not throw an exception.

Look at Parse and TryParse which are used to convert variables, Parse will throw an exception if the input is unconvertable, TryParse will return True if it succeeded and the target variable will hold the converted value, it will return False if it did not and the target variable will be Null.

For example;

int sdest = Int.Parse("123"); // This will succeed

sdest = Int.Parse("ABC") // This will fail and throw an exception that must be handled

The easiest way is to;

int idest;

if (Int.Tryparse("ABC", out idest) == true)
{ // String converted...all is well idest has the value}
else
{ // conversion failed...go no further idest is Null}

Michael_Davies 8-Jul-17 13:13pm View

Quite agree, but if he wants to do it that way...

Michael_Davies 8-Jul-17 13:13pm View

So test for null and ignore it.

Michael_Davies 8-Jul-17 12:49pm View

This might help https://msdn.microsoft.com/en-us/library/7eh4aaa5(v=vs.100).aspx

Michael_Davies 8-Jul-17 11:50am View

Quick caveat, if you use a string for the key and have more than 9 colors you'll have a sort problem; "1" & "10" with sort together.

Michael_Davies 8-Jul-17 11:17am View

Added an example to the answer using your code as a base, tested it on a simple form with a combobox called comboBox1, rename it to your box name.

Basically switched your key and values round in the first dictionary as you want the sort order for the color, then add the colors name and the key to the new dictionary, export the keys to a list and sort to get the order you want then populate the combobox in that order.

Michael_Davies 8-Jul-17 10:42am View

The solution still stands, once you have selected the colours you want you then need to sort them as the order you want is not natural, in your list Orange comes before OrangeRed in the propertyinfo as that is the natural sort order, to get the order you want in a combobox you will have to sort them, now your code is clearer I suggest you create a second dictionary and add the element from the first dictionary if it is found in the propertyinfo then iterate the new dictionary in key order to get the sort you want.

Michael_Davies 8-Jul-17 10:11am View

Perfectly clear,

Combobox does not provide a method to allow you to move items around, the list is either sorted if .sorted=true or the items appear in the order yo load them.

So you have to copy the list elsewhere, clear the combobox, sort the list as you wish then put them back into the combobox.

Michael_Davies 6-Jul-17 6:34am View

Repost of https://www.codeproject.com/Questions/1195153/Foreign-key-and-mysql-with-hibernate

Michael_Davies 5-Jul-17 8:20am View

Please show the results of the SQL, for instance 2101 has Finished and Pending so will show.

Michael_Davies 2-Jul-17 9:30am View

Why not use a ListView in detail mode add a column for each item Plate, Angle & Diameter then set the sort on the Angle column.

Michael_Davies 2-Jul-17 9:18am View

What result are you getting in orderedList, does it meet your expectations and if so what is wrong.

Rarely use a listbox, prefer listview set to detailed and add a handler for sorting so it sorts as you add items to the list or turn sorting off, build the list then sort.

Michael_Davies 28-Jun-17 7:02am View

Why VB6, VS 2017 community edition is free and better equipped for the job.

Michael_Davies 26-Jun-17 12:16pm View

Have you read the MySQL manual on locking tables?

https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html

Michael_Davies 25-Jun-17 15:08pm View

Okay, now you have changed the SQL but the textbox2.text is inside the string and therefore will only be treated as the word textbox2.text and not the contents of the textbox2.text control.

Also note you are still missing the closing parenthesis, I've added it in below.

Here you go;

SqlCommand comand =new SqlCommand("CREATE TABLE Dobavljaci" + textBox2.Text + "(ID int,Naziv Char(50),Sjediste Char(50),Adresa Char (50),Ziroracun Char (50),sifra Char(50),JIB Char(50));",CON);

BEWARE IT IS NOT GOOD TO CONCATENATE A STRING FOR AN SQL COMMAND, YOU ARE VULNERABLE TO SQL INJECTION AS THE USER CAN TYPE ANYTHING AND COULD WREAK HAVOC.

You will also need to verify the string does not contain invalid characters for a table name or it will fail, you will need to use Try..Catch.

Michael_Davies 25-Jun-17 12:19pm View

Please explain what you mean, you say it works yet you say you need to add additional name.

There is no space in your SQL between the word TABLE and the contents of textbox2.text, so if textbox2.text had the word "door" in it the resulting SQL would be;

Also you fail to close the opening parenthesis there should be another ) after JIB char(50) and before the ;

CREATE TABLEdoor(ID int,Naziv Char(50),Sjediste Char(50),Adresa Char (50),Ziroracun Char (50),sifra Char(50),JIB Char(50));

Which should fail as TABLEdoor is not an SQL keyword, put a space in to get;

CREATE TABLE door(ID int,Naziv Char(50),Sjediste Char(50),Adresa Char (50),Ziroracun Char (50),sifra Char(50),JIB Char(50));

Which should then work.

Michael_Davies 25-Jun-17 9:41am View

A lot depends on your database design. In order to understand people would need to see the schema and how you are booking.

You could have a table with a field per seat and a date field one row per day. High disk cost and data transfer.

You could have a master table holding the date joined to a table by and id field with just the id and a field to hold an integer for the the seat number; if the record exists then the seat is booked if not it is free. This would keep the disk space usage down.

Michael_Davies 25-Jun-17 5:43am View

If he wants the column name & details try this;

foreach (DataColumn col in dataTable.Columns)
{
Console.WriteLine(col.ColumnName);
}

Michael_Davies 24-Jun-17 16:48pm View

Certainly, type mysqldatatable into Google, devart give examples and definitions.

Also if it is a table and not a query result just execute "DESCRIBE <tablenamehere>" to get full information from the tables schema.

Michael_Davies 20-Jun-17 15:09pm View

What timings are you getting at the moment and over how many records?

One thing you might consider doing would be to create a temporary table or view for the nested select then apply the main select to that and see how the timings compare.

Michael_Davies 20-Jun-17 5:35am View

Have you tried contacting support@w3schools.com?

Michael_Davies 19-Jun-17 13:19pm View

Not sure it has been mentioned but you need two parameters to AES_DECRYPT/ENCRYPT, the text and the key, you only pass the text so the answer is NULL.

Also you need to ENCRYPT not DECRYPT the data supplied byt the user to compare or you DECRYPT the field to compare, see below.

comm.CommandText = "SELECT uname,uid,urole FROM users WHERE uid= '" & Trim(Me.txtUID.Text) & "' AND upwd= AES_ENcrypt(Me.txtPwd.Text,<YOU NEED THE KEY HERE>)"

I am sure you will have people telling you about SQL Injection attacks so will pass it by...

Michael_Davies 17-Jun-17 14:51pm View

Your definition is that the numbers are between a and b, take it then that x is the mid point between a and b.

Anyhow, lots of documentation on the Random class on MSDN, take a read, experiment and use Google to find what you are looking for.

Michael_Davies 16-Jun-17 11:03am View

protected void DataList3_DataList3_ItemCommand

onitemcommand="DataList3_ItemCommand"

?

Michael_Davies 14-Jun-17 16:44pm View

Simple Google returned many answers including;

https://stackoverflow.com/questions/233702/where-does-outlook-store-the-vba-code-files

Michael_Davies 5-Jun-17 16:56pm View

In you above comment you name the table stock in not stock_in as in your query, if it is the stock in then you need to use square brackets as you are using a space in a name; [stock in]

Michael_Davies 5-Jun-17 16:33pm View

You'll need to show the schema for anyone to be able to answer that.

Michael_Davies 5-Jun-17 15:44pm View

Why not show us your code so we can help?

Michael_Davies 31-May-17 7:52am View

Is ID an auto number column? if so it is not in your parameter list try putting ID in the parameters and put DEFAULT in the place where ID is in your field list;

INSERT INTO pathmaster (ID,
Path,
pathName,
fileName ,
Count,
CreatedBY,
CreatedDate,
Type,
Status
)
VALUES(DEFAULT,
Pathparam,
(Select MAX(pathName) from pathmaster)+1,
FileNameparam,
Countparam,
CreatedBYparam,
CreatedDateparam,
Typeparam,
Statusparam
);

Michael_Davies 30-May-17 7:08am View

Is Excel installed on the server?

Michael_Davies 24-May-17 11:17am View

Do you mean you want to update the item.itemstatus where the repair.status=2?

A lot depends on the version of SQL you are using;

https://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql

Michael_Davies 23-May-17 15:06pm View

Have you looked at using a UNION?

Michael_Davies 23-May-17 2:51am View

S'funny, Google returned a lot of answers;

http://www.wpbeginner.com/wp-tutorials/how-to-create-custom-post-types-in-wordpress/

Michael_Davies 23-May-17 2:38am View

You do not say which operating system, Win/Linux? For Windows there are several methods of IPC, see;
https://msdn.microsoft.com/en-us/library/windows/desktop/aa365574(v=vs.85).aspx

Michael_Davies 16-May-17 10:21am View

Do not know if case makes a difference but you have Triggers and /triggers and Style.Triggers with style.Triggers, every online example I looked at has them correctly cased and works.

Michael_Davies 12-May-17 10:48am View

Worse t does not exist outside of the loop and appears to have nothing to do in the loop.

Michael_Davies 12-May-17 3:20am View

What do you mean by "fetch current time from internet", datetime uses the system time, the system has a method to update it's time using time servers on the internet and the time zone settings, what is it you want to do exactly.

Michael_Davies 11-May-17 8:13am View

You have to construct your Select SQL with the data for the parameters embedded, your existing query uses parameter names (@cToken etc.) and there is no way of passing the values for the parameters to a Table.Select. This is okay for a table in memory as it is not prone to SQL injection, never to be used for queries to SQL server by command.

Example;

.Select("Token_no='"+ cToken +"' and Date = ...etc.

Note: as above you will also have to enclose the parameter data in single quotes for string fields.

Michael_Davies 11-May-17 4:05am View

Where is the code?

Michael_Davies 10-May-17 3:04am View

What is the problem, all you have shown is a list of data what are you trying to achieve and show the code you have tried so we can help.

Michael_Davies 7-May-17 5:45am View

Whenever I use ComObject I find I have to loop until the release returns zero, never used final so not sure if there is a difference but a single call does not always release the COM link;

While System.Runtime.InteropServices.Marshal.ReleaseComObject(Excel) <> 0
Application.DoEvents()
End While

Michael_Davies 5-May-17 11:21am View

Try this Instead of your code:
If IsDBNull(Cmd.ExecuteScalar) Then
Tbcltid.Text = "DGL/C- 2905"
Else
Number = Cmd.ExecuteScalar + 1
Tbcltid.Text = "DGL/C- " & Number.Tostring()
End If

Michael_Davies 30-Apr-17 12:11pm View

It may have one but it is not being found if you test the var checkBox you will probably find it is Null and you are assuming the Find returned something and using it regardless.

Put a test in for checkBox != Null then check = true and you might find the Null reference goes away, you then have the deeper problem as to why it is not being found.

Michael_Davies 29-Apr-17 7:08am View

I what way did it not work?

What is going wrong?

Have you used the debugger to walk thru and see what is happening?

Is the table called table, bad to use reserved words for object names?

Michael_Davies 28-Apr-17 6:18am View

Total, which is a string so no need to .ToString(), has a non-numeric character ":" in it and this cannot be converted to integer, hence the exception.

Michael_Davies 26-Apr-17 13:58pm View

VB = is equality
C == is equality

Michael_Davies 23-Apr-17 14:18pm View

Deleted

The event fires for selected item change, when a new item is selected the old selected item deselects first and this fires the event as it is a change however nothing is selected at that point so item is null.

wrap your code with:

if (lvSelectCustomer.SelectedItems.Count != 0 )

Michael_Davies 22-Apr-17 6:09am View

Not working? In what manner is it not working? My bike is not working can you fix it?

Michael_Davies 22-Apr-17 6:09am View

You do mention it is int but you are trying to display it as a decimal.

Michael_Davies 22-Apr-17 5:53am View

You can run a 32 bit on a 64 bit system, leave it as 32 bit.

Google quickly finds that "currently the Microsoft.Jet.OLEDB.4.0 is not supported for the 64 bit OS."

Michael_Davies 22-Apr-17 4:57am View

This statement has no function;

Convert.ToDecimal(RENT).ToString("#,##0.00");

Convert returns a value to be assigned to a variable or passed as an argument.

string decstring;

decstring = Convert.ToDecimal(RENT).ToString("#,##0.00");

or in your case;

e.Row.Cells[17].Text = RENT.ToString("#,##0.00");

Michael_Davies 20-Apr-17 6:07am View

The title of your post is "Convert from gregorian to hijri date" and the nut of your question is "i know that i need some kind of convert so please some help me"

If this is not the question then please click Improve Question and refine the problem so people can help you.

Michael_Davies 17-Apr-17 14:17pm View

You do not give enough information, what kind of scanners?

Are the scanners using direct keyboard input or are they through a manufacturers library?

If they are keyboard emulating then there is no way for them to be simultaneous, you can however differentiate between the devices by setting different lead in characters for the scanners and so long as they do not scan at the same time you can know which scanner scanned the code; by default keyboard emulating scanners do not have a lead-in/out character but you can normally program them to do so. Check the scanners settings.

Michael_Davies 17-Apr-17 6:43am View

Use the search box on this site for articles on printing, there are many.

Michael_Davies 16-Apr-17 7:41am View

The DataBindingComplete event might work for any data binding change along with the form show or load event.

Michael_Davies 13-Apr-17 14:39pm View

Take a look at using asynchronous commands in MySQL;

https://www.devart.com/dotconnect/db2/docs/Devart.Data~Devart.Common.DbCommandBase~BeginExecuteNonQuery(AsyncCallback,Object).html

Michael_Davies 3-Apr-17 2:27am View

We cannot tell what is happening, show the code in question.

Michael_Davies 30-Mar-17 14:41pm View

Changed your tag to SQLite.

https://www.tutorialspoint.com/sqlite/sqlite_using_joins.htm

Michael_Davies 30-Mar-17 14:40pm View

The response comes from the web side, is there a script under approval that takes the request and returns the answer in JSON format? It is the script on the web side you need to look at.

Also you are sending as http and the client id and their secret are not encrypted and very visible on the internet. The server side should reject such requests if they are not secured (https).

Michael_Davies 29-Mar-17 16:23pm View

Did you find this;

https://www.experts-exchange.com/questions/26895919/C-RichTextBox-contents-to-clipboard.html#a35180339

Michael_Davies 29-Mar-17 2:08am View

Show your code, no one can even try to guess what is wrong without seeing the code.

Michael_Davies 25-Mar-17 6:41am View

Define "wrong output", SQL will count the number of rows matching the condition and return that count, the output cannot therefore be wrong, if it is not what you expected then the condition needs attention.

Do not just say something is wrong, show what you expect and why and the actual result.

Michael_Davies 23-Mar-17 3:14am View

Hi, blanked out the user, password and public IP address of your SQL server, dangerous to reveal such details anywhere online.

Michael_Davies 20-Mar-17 5:42am View

What value is in yn after you enter a non y character? Walking through ith a debugger you can see that value of the variable and verify it, alternatively echo yn after inputting it so it shows on the console.

Michael_Davies 20-Mar-17 5:30am View

What happens when you use the debugger to see the value in yn after you enter it.

Michael_Davies 20-Mar-17 4:59am View

Does the cout for Add More not show, please be clear.

Pause the program before exit and copy the console text of a session and paste it here so we can see what is happening.

Michael_Davies 20-Mar-17 4:39am View

Sorry, the loop should stop when you enter any character except y, are you saying it does not stop if you enter say an n?

If you want a loop to execute at least once use Do... While, it will test the condition after the code has executed rather than before.

Michael_Davies 20-Mar-17 4:37am View

Deleted

You have exchanged a for with a while and set the same condition, the loop will never execute as the condition is satisfied on the first test.

Try setting yn to 'n' and see what happens.

Michael_Davies 19-Mar-17 9:15am View

How does usr deal with the parameter data? are you using parameterised queries if so it would normally deal with formatting the date correctly.

Michael_Davies 17-Mar-17 10:46am View

MySQL usually accepts date in the format YYYY-MM-DD, DateTime usually resolves as DD-MM-YYYY, might be different depending on localisation.

Try:

usr.RowModifiedDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

Michael_Davies 13-Mar-17 9:32am View

Deleted

As per NotPoliticallyCorrect plus the maths is wrong;

To find a percentage in a number it is number / by 1.[thepercentage], so for 20% of 1 it is 1 / 1.20 = .83333

To add a percentage to a number it is * instead of /.

Michael_Davies 13-Mar-17 6:03am View

Try it as "application/x-www-form-urlencoded"

Michael_Davies 12-Mar-17 12:27pm View

In the second table where there is no Branchid is it Null or do you put the dash in when no branch?

Michael_Davies 12-Mar-17 6:24am View

Currently you take a single file name into a textbox to import to a static table name. If you have multiple files you need to get the files you wish to import together in a list then batch process them one at a time with some naming convention for your table names.

How you gather the list is up to you, we are not privy to how you work with the files and there is more than one way to do it.

You could present the user with a checkbox list of XL files in a specified directory and let the user click the ones they want to import, you could also set up a watch on a directory and import then delete any XL file dropped into it. The list goes on.

For getting a list of files check out ; https://msdn.microsoft.com/en-us/library/ms127994(v=vs.110).aspx

Michael_Davies 11-Mar-17 16:59pm View

Looks like the loop in BuildMemoryBoard will exit the moment it finds a code has not been used already, whereas you want to exit the loop when every slot on the board has been filled. Use the debugger and watch what happens.

You pass the array as a parameter to IsExistInBoard, do not use it but use the global variable directly, which you are passing as an argument...

Michael_Davies 11-Mar-17 4:52am View

So what you need to do is;

1. A sub that collects the file names to be imported then uses a loop to call 2. below with the file name and a table name.

2. A sub that accepts a filename and table name as string parameters that contains the code you have already shown using the parameters for the file name and table name.

Job done.

Michael_Davies 11-Mar-17 2:31am View

What does not work, it does work as you say it imports a file successfully.

Help us to help you, "it won't work" does not mean anything.

Click Improve question and give the details of what does not work, if it is just the need to import multiple files is into the same table or separate tables?

Michael_Davies 9-Mar-17 2:32am View

Is cell A1 Text cell or General/numeric, try putting quotes round the value;

=IF(A1="8712100756818";....

Michael_Davies 8-Mar-17 9:59am View

Have you tried using the windows password reset disk, create one on a usb stick that then allows you to reset the password if you forget it and get locked out.

Also logon as admin and reset the password of any user.

Michael_Davies 4-Mar-17 8:40am View

Go ahead, treat it just the same as you would on your active form simply qualify the DGV name with the form name first.

Michael_Davies 4-Mar-17 8:09am View

What method are you using to access the database; if you are using ADO recordsets and the .Filter it will be painfully slow, opening a recordset with an SQL query improves the speed dramatically.

Michael_Davies 2-Mar-17 8:21am View

SrCell is always the first cell of whatever r is, r should be nothing as it has not been assigned. You also use r to set selected = true, r does not yet have a value, row does, you do not need to select a row unless you intend it and be aware an event will fire when you do and any handler will be called.

If InvoiceDataGridView.Rows.Count > 1 Then
For Each row As DataGridViewRow In InvoiceDataGridView.Rows
If Not row.IsNewRow Then
SrCell = row.Cells(1).Value
row.Selected = True ' You do not need to do this, use row instead of InvoiceDataGridView.CurrentRow through the rest of your code, it will speed things up

Not sure of the effect of removing rows during an iteration as it changes the collection being iterated, personally I'd do it as a an index set to the count -1 step to 0 -1;

For r = InvoiceDataGridView.Rows.Count -1 to 0 Step -1
...
currRowAmount = InvoiceDataGridViewRow(r).Cells(3).Value
...
Next

You can then use r as an index to the rows and removing a row will not affect the loop as it is going backwards.

Michael_Davies 27-Feb-17 6:43am View

Gmail does support secure connections, as far as I am aware Google do not allow non-secured connections to their smtp, so your error message is not correct, usually a lot more information comes with the error use a TRY...CATCH to grab the message detail and display it in full.

Also comment out the UseDefaultCredentials, you are providing credentials, I suspect the DefaultCredentials are based on your PC's login.

Michael_Davies 27-Feb-17 4:45am View

Try port 465.

Other than that there are lots of working examples for sending via gmail on this site.

Michael_Davies 27-Feb-17 4:39am View

What do you mean by the code works but the calculation goes wrong, show an example.

Michael_Davies 27-Feb-17 2:59am View

in your code it is "alloc" not "allocation" on the Session() call. Have you made a spelling mistake that will then return Null as alloc cannot be found but allocation might be?

Michael_Davies 27-Feb-17 2:59am View

Deleted

in your code it is "alloc" not "allocation" on the Session() call.

Michael_Davies 27-Feb-17 2:34am View

First use the debugger, when the exception occurs hover the mouse over the variables on the offending line to see which of them is Null then work out why and deal with the condition.

Second why are you filling a DataTable then using a Reader?

Third in the defining statement of your variables da, dt and cmd you instantiate them with New, you then instantiate them again in code, why, "Dim da As New SqlDataAdapter" will create the variable and allocate a new instance, having never used that instance you then create a new one before you use actually use it; "da = New SqlDataAdapter(cmd)". Same goes for dt and cmd.

Michael_Davies 25-Feb-17 5:07am View

What is null, tu or obj, use the debugger to see which element is null and work from there, the difficulty in trying to help you is that both are global variables declared, instantiated and manipulated elsewhere in your code that we cannot see.

The debugger is your friend, once you know which variable is null you can set a watch to see when it occurs.

Michael_Davies 24-Feb-17 6:04am View

Why convert to string what is already a string?

"Convert.ToString(cbPlan.Text) - which would bring the PlanName and not the ID."

Michael_Davies 23-Feb-17 6:38am View

That is up to the programmer, his original code would only close the connection if the condition was true, thus leaving it open, the rest is down to experience.

Michael_Davies 23-Feb-17 2:30am View

Deleted

The close for the connection is embedded within an if condition, move it outside of the if as you should close the connection regardless of the condition.

Michael_Davies 21-Feb-17 3:39am View

Thanks for that, filled a gap in my understanding of WMI.

Michael_Davies 21-Feb-17 2:26am View

Deleted

The database on the remote machine uses a port to communicate, in order to connect to that port from a remote pc you need to redirect a local port to it and then use that local port to communicate with the remote database.

Michael_Davies 18-Feb-17 15:05pm View

Already did that to verify and DriveLetter D: exists and is filled in correctly.

Michael_Davies 18-Feb-17 13:43pm View

Dave, I tried it on my PC and get the same errors, not sure what can be different, I do have a D:, tried C: too.

Michael_Davies 18-Feb-17 13:38pm View

Appreciate that, I've just looked at MS examples, copied them in VB and C# and tried both of them and they fail every time, tried variations on expressing D: as in VB it is enclosed with ", C# with ', no method of escaping the string changes the result and examining the management object shows the path correctly.

You might have to do it the other way.

Michael_Davies 18-Feb-17 12:25pm View

Have you tried it in WMICodeCreator (download from MS), you can select the Win32_LogicalDisk and see all the available data, run the code to see the output then generate script, VB or C# code.

Michael_Davies 18-Feb-17 10:37am View

100gb out of what size HD, 10% and less free can cause problems.

Also look at using perfmon:

http://www.makeuseof.com/tag/use-windows-performance-monitor-like-power-user/

Michael_Davies 18-Feb-17 9:11am View

How much free space on your operating system drive, usually C:?

Michael_Davies 16-Feb-17 7:06am View

Your column names do not match the .Sort list, guess PN is meant to be part_No but PN is not part_No if the column name is part_No, no idea what LS is as it does not even acronym any of your given column names.

Try .Sort = "part_No ASC, Qty DESC"

Michael_Davies 16-Feb-17 6:03am View

Do you get asked for the password when you invoke the script on PC_2

Michael_Davies 16-Feb-17 4:03am View

When you say "But - when I run this through powershell:" in what way, if you are running it in Powershell as a logged on user your credentials are that of the logged on user and so long as that user has the right privileges it will run.

What context are you running it under Powershell when it fails.

Michael_Davies 14-Feb-17 6:34am View

That's me all over too fast on the fingers, thank you.

Michael_Davies 14-Feb-17 6:11am View

I was already typing the code but sent the answer half done by mistake, full answer now present.

Michael_Davies 14-Feb-17 6:10am View

Updated the answer, the property method is the best way to go.

Michael_Davies 13-Feb-17 15:32pm View

There is an example similar to what you are trying to do

http://stackoverflow.com/questions/18391924/updating-excel-sheet-using-oledb

string commandString = String.Format("UPDATE [{0}${1}{2}:{1}{2}] SET F1='{3}'",worksheetName, column, row, data);

Plus you'll have to set HDR=NO in your connection string, see the answer in the link but here's the relevant text

The only difference to note here is the "SET F1='{3}'". This will set the cell you specified in your range to what's in the data variable.
Note the use of "F1". This is simply a default that is used when "HDR=NO" is specified in your connection string, in other words, there are no column headers or names. If you had column headers you would use that in place of F1. It is important to understand here that F1 does NOT correspond to cell F1 in any way.

Michael_Davies 13-Feb-17 15:22pm View

Why are you using a cell reference in the sheet name, I am presuming you are trying to set cell F1's value to 'OK', if so try:

UPDATE '30187' SET F1='OK'

Michael_Davies 13-Feb-17 14:57pm View

Normally sheet names are contained in single quotes try UPDATE '30187'$K6:K6 SET F1=OK

Michael_Davies 12-Feb-17 12:22pm View

Might be something to do with nesting.

You have :

if ((a == 1) || (a == 4) || (a == 7))
{
a -= 1;
if ((b == 1) || (b == 4) || (b == 7))

This means that b, and later c, is only tested if a is 1, 4 or 7 otherwise the testing of b and c for 1, 4 or 7 never happens if a is 1, 4 or 7.

This will not give the answer your looking for but will help to see why, firstly if the 100 digit is 1,4 or 7 then the answer is going to be according to the question a - 1 + 99, if b = 1, 4, or 7 then the answer is going to be a(adjusted if it is 1,4,7) + b - 1 + (9 if c is 1, 4 or 7, else c).

if ((a == 1) || (a == 4) || (a == 7))
{
a -= 1;
b = 9;
c = 9;
}
if ((b == 1) || (b == 4) || (b == 7))
{ b -= 1;
c = 9;
}
if ((c == 1) || (c == 4) || (c == 7))
{ c -= 1; }

For 450 that will give 399, now you can work out how to get the max temp.

Sorry forgot to add, you may have destroyed the original values of a, b and c so to work out the max temp you need to keep them by using temporary variables.

Michael_Davies 12-Feb-17 12:09pm View

Okay so walk through with the debugger and watch what happens at each step, you should know what variables will contain given the value you enter compare them and when you see the different value work out why.

Michael_Davies 12-Feb-17 12:04pm View

You say there is an error, do you get an error message, if so what is the message and which line, if the error is related to expected behaviour explain what is expected and the actual result.

Michael_Davies 12-Feb-17 10:16am View

I is is not inconvenient, supplying you with the answer when it is simple typing errors does not help you at all.

If you use VS then start to type textbox2.text=b.tostring(); and watch what VS does as it starts to fill in as you type each character press the tab key when you see the name you want to complete the typing for you, so typing:

te should bring up a list with textbox1 and textbox2 in it, use the arrow keys to select the correct one and then press TAB to fill it in. Then press .te to show the methods for the TextBox control positioned at items starting with te then use the arrow keys to select Text etc.

Spelling and case are important in C#.

Michael_Davies 12-Feb-17 10:03am View

Copied from the answer given to the closed question.

If you use VS IDE it will auto type the correct case and spelling and you could not therefore type .tostring it would case it to ToString.

At least two more spelling/case errors to go.

Michael_Davies 12-Feb-17 9:53am View

What are you using to edit the code, Visual Studio will autocomplete methods.

It is still technically a spelling mistake, you probably copied and pasted the code from the question that was closed.

There is a difference between:

textbox2.text=b.tostring();

And

textbox2.text=b.ToString();

Reckon you'll get one more error...

Michael_Davies 12-Feb-17 9:45am View

So now show your fixed code so we can be sure you have solved those errors, better yet if the compiler shows other errors try to fix them.

Michael_Davies 12-Feb-17 9:41am View

You fixed the other mistake, now the spelling.

Michael_Davies 12-Feb-17 9:36am View

Compare the two lines:

if (i.DefaultellStyle.BackColor == Color.Red)
if (row.DefaultCellStyle.BackColor == Color.LightGreen)

There are two mistakes, one spelling the other should be clear.

Michael_Davies 12-Feb-17 9:32am View

Missing character in the line below, you should have a compile error telling you that line has an error:

if (i.DefaultellStyle.BackColor == Color.Red)

Michael_Davies 12-Feb-17 3:07am View

This code was generated by WMI Code Creator and it works as is, what is your difficulty.

Michael_Davies 12-Feb-17 3:07am View

Deleted

This code was generated by WMI Code Creator and it works as is, what is your difficulty.

Michael_Davies 10-Feb-17 2:30am View

Why not use a NumericUpDown control?

Michael_Davies 10-Feb-17 1:54am View

Why not use a NumericUpDown control?

Michael_Davies 9-Feb-17 10:01am View

You can use the controls Validating event to prevent the user leaving the field if it is not filled in correctly. You can add an ErrorProvider control to flag the control with a red icon and error message. Any button click calls a function to select each control in turn to trigger validation and return true if all is well.

Michael_Davies 8-Feb-17 11:25am View

Works in MySQL no problem.

Michael_Davies 8-Feb-17 7:00am View

Which line?

Michael_Davies 6-Feb-17 5:59am View

The error message tells you all you need to know you are concatenating more than 254 strings.

Michael_Davies 6-Feb-17 5:09am View

I'd add make sure that the controls .Visible=true and .Enabled=true as well.

Michael_Davies 4-Feb-17 13:13pm View

Also ch is not initialised.

Michael_Davies 4-Feb-17 6:10am View

You'll probably need a new connection as myconnection has the datareader on it.

also be careful, you open myconnection outside of the using and close it inside the using, if there's nothing to read then the connection will not be closed, may never happen but it is tidier to open and close at the same level of braces.

Michael_Davies 30-Jan-17 13:38pm View

You probably are adding records, so long as the are no rules preventing duplicates, you just need to test the right place for the result of your insert.

If you write everything inline it will teach you more about databases than relying on something you do not understand written by someone else.

Good luck with whatever you decide.

Michael_Davies 30-Jan-17 13:02pm View

That explains what Access is in your code, you must declare Access as a new DBControl somewhere.

In which case you can use it as it store the parameters in an array then adds them to the query before execution.

It is not the neatest or best DB access class I've seen, the NonQuery sub does not return a value, you can read the results from the .Record which will contain a count of records in the table returned by the query string which is quite probably 1 row with 1 column that is an integer and it contains either 1 for row inserted or 0 nothing inserted so you'll have to use that to test success or not.

Also the connector specifies a hard coded database named Database11.accdb, which must be in your working directory, presume this is your database that you are working on.

Michael_Davies 28-Jan-17 14:10pm View

If your RefreshGrid is called then you should see the msgbox, use the debugger to walk through and see what is happening.

Is the date field a date field or a string to store a date?

Show me the date you are storing as it appears in lbldate.text.

Michael_Davies 28-Jan-17 12:10pm View

I've added an else condition to display failure.

Most problems I had using an Access DB occurred around date and time fields, they must be in the correct format or the whole insert is rejected. Notice you have date and time fields and you get their content from labels if your naming convention reads right, check them for correct format.

You also have what looks like ComboBoxes, have you made sure that an item has been selected on the comboboxes?

Are any of your tables fields required and cannot be empty?

Comments by Michael_Davies (Top 200 by date)