Tag: c#

Accessing another database user’s tables using Entity Framework

I am trying to access Oracle database using EF Core 6. But the database user given to me doesn’t have any database table. Instead I can see and modify another database user’s tables via SQL DEVELOPER. For example; my user: my user Other user: IFSAPP the following query While returning me a result, does not return any results. With EF

DataGridView selected row to check a checkbox

I am currently trying to check a checkbox dependent of the SQL data after selecting the row in a datagridview. I have gotten this to display text with TexBoxes, but cannot get it to check a check box. Yes = True No = False Any recommendations, would be very much appreciated. The table being displayed is bound by’binding source’ the

C# Multiple comboBoxes used in MySQL Where

Im trying to learn using MySQl with C# so im creating app that allow sorting and adding data to my tables. That is code that i use to show items selected only by my comboBox_1 value. But now i want to add 2nd comboBox and show data that meets both conditions. The problem is i have no idea how to

How link/bind textbox, dropdown list and SQL database together on C#?

Basically what the task is that you search someone’s name in the textbox, click search, the users with that name will populate the dropdown list. SQL Server: this is the query I am try to add to the search button on my page: Aspx side: C# side: I’ve got this already (this is me attempting to fetch data from the

Why Is My API Not Returning Nested Object (.NET 6 Entity Framework and SQL DB)

I have created an API, using EF and database first approach via scaffolding. I have the following in my context file and then the following in my models Request: Request Line: My Request controller looks like this: In Swagger, it is displayed correctly in the example, based on the model: But when running the GET, what I am actually seeing

How to insert images of picture box which is created by for loop?

If user enters 5 this loop creates 5 pictureboxes Here I have a click event for selecting image of each picture box My question is… How can I insert those images of pictureBoxes into SQL SERVER at once? can anyone help ? appreciate it. Answer If you have 5 picture boxes in your application and in your database table there

Save listbox to SQL database, “Procedure or function Music_Add has too many arguments specified”

Here is the stored procedure on my DB. I want to save data of list to my SQL database, i can save one data, but when i try to add more it caused error like this “Procedure or function Music_Add has too many arguments specified”. Can someone help me how to fix that error… Thanks… Here is the code to

Search in the database

This Messages form display table with these informations (ID,FROM,TO,TITLE,MESSAGE). I am trying to search for all the messages send to a certain user . user will enter his name in the Search_textBox then it will filter the table to keep only messages to this user. I get this error : Answer this is Correct

SQL | C# – Reader rows

I have a small problem with MySqlDataReader. I have data in MySql and I have column “name” and X rows under. Reader reads sucessfully all of this but output is in one string and looks like “FirtSecondThird” but i need all of this words in list word by word. The code is: Does anyone know what to do with it?