Always submit in A1 cell through C#

Question

I have a text box for first name and a submit button to input in MS Access database only for A1 cell. I want the result as: Whatever I shall input in text box, when I shall press the submit button it will always store in A1 cell. I use C# and visual studio 2015. Is it possible? If yes, please a sample code or example link.

Amit Gupta · Accepted Answer

I ll suggest you to post a new question for seperate new question, this will help others to find the correct answer for the particular thread.    Anyway!!   You can use any of your identity column to get the result like   Select Top 1 * from tablename order by columnname Desc

Shovan Saha · Answer

Dear Amit Sir, I want to submit data in database at the same time the last row will display in a label. Please help me. I have written this and call in button press function. I do not get the result at the run time. When I close the application and reopen then I get the result.   private void lblBranchCodeArea1() { con.Open(); try { OleDbDataReader myReader = null; OleDbCommand myCommand = new OleDbCommand("select * from LalBranch", con); myReader = myCommand.ExecuteReader(); while (myReader.Read()) { lblBranchCodeArea.Text = myReader["CodeNo"].ToString() + ", " + myReader["BranchName"].ToString() + " " + myReader["AreaName"].ToString(); } con.Close(); } catch (Exception d) { MessageBox.Show(d.ToString()); }

Amit Gupta · Answer

Of course, write your select statement and then split it with space and show it in your label.

Shovan Saha · Answer

Dear Amit Sir, if I update "Shovan Lal Saha" through text box into database, if I want to show first part of database cell "Shovan" into a label, is it possible? If that please help me.

Amit Gupta · Answer

You need to change your query statement from insert to update, insert query will always insert the value to new cell wheeas update will help you to achieve your task.   Refer this link https://stackoverflow.com/questions/29534671/update-data-using-oledb-in-c-sharp

Shovan Saha · Answer

Dear Amit Sir, Here is my code, here I can not fix to submit in A1 cell: private void add(string PaymentDate) { string sql = "INSERT INTO LalData(PaymentDate)VALUES(@a)"; cmd = new OleDbCommand(sql, con); cmd.Parameters.AddWithValue("@a ", PaymentDate); } private void btnSubmit_Click(object sender, EventArgs e) { add(PaymentDate.Text); }

Amit Gupta · Answer

Please share your code, what you had done, I think if you had only aingle column in your datatable then it will write only in one column, it might looks like that it was on other column.

Shovan Saha · Answer

Yes Amit Sir, you are right, But I can not write query to insert into only one cell. Through my code, I get the result, that is increased in A2, A3, and so on. But I want to use only A1 cell. Please help me by providing me only two lines sample code.

Amit Gupta · Answer

What is the problem then? Write your query to insert into that cell only. Is it like that or something wrong I have understood?