All Questions
393
questions
0
votes
0
answers
44
views
How to pass a specific parameter to my dataset
I have DataTable as a result of executing a stored procedure. The stored procedure is returning a number of tables, therefore Tables[0], Tables[1], etc.
I'm trying to query the first table, Tables[0], ...
0
votes
0
answers
57
views
Add parameter to Datatable function
I want to display procedure result in DataGridView and Get parameter value from Combobox
I have created a SQL procedure named Report_with_depo
Create proc [dbo].[Report_with_depo]
@customer_id ...
0
votes
0
answers
21
views
How to retrive multiple data tables from sql using c# [duplicate]
I encounter a problem.
I have a generic function that executes stored procedures via connection to my sql DB.
In all SP I need only one dataTable to be returned.
public DataTable ...
-3
votes
1
answer
333
views
SQL where clause with multiple “OR” conditions dynamically
I have a c# windows application where I get data from SQL database.
I need to write an sql query with where clause having multiple “OR” conditions dynamically.
Select * from table
where
(Name = @...
1
vote
2
answers
740
views
C# - Two DataTable comparison. Get Rows which are Updated, Deleted and Created(New)
I have 2 DataTables: 1st DataTable is created today and 2nd Datatable was created yesterday.
Each DataTable contains over 100K rows and 30 columns.
I have a unique column - "Master_ID"
I ...
0
votes
1
answer
395
views
Using C#, how can I insert data from a SQL Server to Google Sheets?
Using some code I found online, I am able to insert static data into a Google Sheet. Ultimately, I'd like to import data from a SQL stored procedure into a Google Sheet on-demand.
The static code ...
0
votes
1
answer
248
views
Want to Fetch date from sql to textbox textmode=date
I tried to fetch a date from textbox where textbox mode is date.
<asp:TextBox ID="txtDate" required="required" TextMode="Date" runat="server" class="...
0
votes
1
answer
27
views
Arithmetic on two identical Datatables
I have two DataTable like this. I would like to subtract the values corresponding to Symbol columns from the two DataTable, and store the result in a third table. All three DataTable are created like ...
-2
votes
1
answer
67
views
While using expression in DataTables.Columns.Add the ColumnName is wrong
Example code of adding a new column to a DataTable:
var test = "HELLO";
var dt = new DataTable();
dt.Columns.Add("A", typeof(string));
dt.Columns.Add("B", typeof(string));...
1
vote
0
answers
138
views
Add new row with sum when value changes in column DataTable / DataGridview
I'm trying to add a new row with the sum of the columns when the value of the first column "Unidad" changes. Here's a picture showing the two rows i would like to add the new row in between ...
0
votes
2
answers
299
views
C# convert model object to Datatable
I have a .Net application which is calling a WebAPI
The WebApi response is a JsonString:
{
"total" : 50,
"users" : [
{
"id" : "abc123&...
0
votes
0
answers
49
views
How to effectively dynamically store data to DataTable
I'm trying to dump data into DataGrid that I have stored in DB. I would like it to be automatically saved in the DB when new data comes in. The method that collects the data is in one class and the ...
0
votes
0
answers
134
views
Deadlock on Select from table-valued parameter
I have this piece of code which acquires connection from EF Core DB context
and executes select on the received data.
var conn = _dbContext.Database.GetDbConnection() as SqlConnection;
await conn....
0
votes
0
answers
622
views
Add new column headers and data to csv file from sql query c#
I'm in the middle of creating a console application in C# which extracts data from a few separate sql queries and displays the data in a csv file.
The column headers come from the file ExtractDocument....
0
votes
1
answer
82
views
Pass/Send a DataTable as part of a SQL Statement (Not a Procedure)
Question: I would like to pass the contents of a DataTable as the from parameter in an Oracle SQL Statement. Is this possible?
The Scenario
Create the DataTable and Fill.
Pass Contents as the from ...