Search results

Hi jmcilhinney, Thank you very much for your valuable feedback. I am studying your solution at the moment and working on implementing in the Windows Form environment. Nevertheless, thank you very much once again and will get back to you if any clarifications required. Kind regards, Andrew

Hi jmcilhinney, Sorry, yes I assume that, need to send the parameter value for the "Select Item" also, since I am performing a validation in the Data Access Layer and accordingly saving the updates to the database table. Thank you. Kind regards,

Hi jmcilhinney, Thanks for your feedback. I have used the designer window and created the event by double clicking on the "btnUpdate" controller. Please refer the below code block private void btnUpdate_Click(object sender, EventArgs e) { foreach (DataRow row in...

Hi Skydiver, Can you please elaborate this bit more? Thanks. Andrew

Hi Skydiver, Look, I am still a beginner for programming and of course will tend to make mistakes. I assume, any beginner would have done mistakes and people learn things by doing mistakes too. Thus, an expert's job shouldn't be to criticize people's mistakes and instead guide them. During...

Hi jmcilhinney, Thanks for your valuable feedback. Yes, I am using Data Transfer Objects in my application. According to my understanding, I wrote the below code under the Data Access Layer and it looks like; using (SqlConnection conn = new SqlConnection(_connStr)) using (var...

Hi All, I am currently working on getting Please find the respective Data Access Layer code below; public void UpdateUser(PersonDTO bPerson) { using (SqlConnection conn = new SqlConnection(_connStr)) using (var dCmd = new SqlCommand(@"UPDATE Person SET...

Hi Sheepings, I understand that it is not a good database design. My objective is not to make a good database design at this stage instead, I want to understand how the CRUD operations works in a 3-tier architecture and if I understand the programming concepts properly, I want to migrate an...

Hi All, I am trying to implement the update data record(s) from a data grid view to the database table. I got three Layers implemented and need to update changes to the data grid view data using a data table into my database table. In my Data Access Layer, the respective code looks like below...

Hi jmcilhinney , Please find the attached project code herewith. The code related to the Data_Layer as follows; Note I have created the connection string in the AppConfig file and calling it in the Data_Layer. public class Connection { private string conn =...

Hi jmcilhinney, What I am saying is, when I am running the code in the debugger mode adding a breakpoint, when I run the respective command line, dataGridViewProducts.DataSource = objLogic.LoadProduct(); and check the results just after executing the above command line, it shows the expected...

Hi All, I am trying to get my head around how the 3-layer architecture works using a sample example. I am able to get the data on to the Presentation Layer, Form_Load event. Please refer my below code, ClassBusinessLayer objLogic; private void Product_Details_Load(object sender...

Hi jmcilhinney , Thank you very much for the guidance. Finally, was able to fix the issue ussing "adapter.AcceptCHangesDuringUpdate" property, correctly. Kind regards, Andrew

Hi jmcilhinney, Thanks for your quick respond. I did add the said AcceptChangesDuringUpdate property to false but no change in the expected outcome. Please refer my code below; SqlConnection connect = Connection.GetConnection(); table.AcceptChanges(); //Mark selected...

Hi, I got a Data Table which is generated at the Form_Load event. The data then populate in to a dataGridView. The user is allowed to add values to a dataGridView column (issueQuantity) and when saving the data, I want to update two tables in the SQL server. However, when I'm running the...

Thank you Skydiver

Hi, Found the root cause of the parameterized issue. Basically, I am loading the sql table data into a data table which got slightly different columns from the DataGridView when finally updating the data table to update the changes into the sql tables. Thanks. Andrew

Hi, I know what you are referring to. However, I have tested updating a sql statement using the above format and it worked for me. Not sure exactly the reason behind the parameterized query issue here. Thank you. Andrew

Hi Skydiver, Thanks for the provided sample code for the recommended method of programming above. Got a slight issue which does not capture by my tired eyes. This is related to the same project discussed above and when updating a SQL table, I am getting a parameterized query error specifying...

Hi Skydiver, Thanks for your comment. It was a bit of a strange to me, that I have initialized the con variable outside the Form_Load() method and within the main class so that it could be access by other methods within the same class. After adding breakpoints, found that the Button Transfer...