DataAdapter is a .Net framework class that facilitates communication between a DataTable and a database.
DataAdapter is a .net framework class that facilitates communication between a dataset and a database.
Questions tagged [dataadapter]
434 questions
-1
votes
1 answer
How do i get image from imageUrl in imageView
How can i get image from image url in image view.
My imageUrl is coming from databaseadapter.
In Fields class LocationImage dataype is string but in setBackgroundResource method it is asking for int value as parameter. LocationImage url is getting…
atluriajith
- 762
- 3
- 17
- 41
-1
votes
1 answer
Set string equal to value in database
I want to set status equal to the status present in the information in my database, a person can be either an admin or a user, based on if the person is an admin or user a different form would be loaded.
using System;
using…
Jason_27
- 21
- 2
-1
votes
3 answers
The new row added didn’t save into underlying database using C# and SQL server
I am trying this code to add new row to database, the new row is saved but when I close the program down, reopen it, the row has disappeared.
private void Dep_Add_Click(object sender, EventArgs e)
{
try
{
SqlCommandBuilder cb = new…
AbdelMalek
- 2,836
- 2
- 19
- 12
-1
votes
1 answer
How can I add the value of a single Cell from Access database to a string variable
As the title says I have a MS Access database from where I need to find a specific dataset determined by a String Value. the reason for having to do this is so I can find the value of a single cell in this datase which has to be used as a path to…
FilipFilop
- 7
- 2
-1
votes
1 answer
Got an out of memory error while loading data into datatable c#
i have stock ohlc data the total record count is 4 million records but when i load data into datatable from data adapter its gives me an error of out of memory.
Query
SELECT company_id,trading_Date,trading_open,trading_high,…
user1485785
- 11
- 4
-1
votes
1 answer
WPF/C# Insert data into databa
I'm really new to C#/WPF. I try to program my first app. So I added a local database (.mdf file) with a DataSet and TableAdapter. I also created a table (User).
public static int CreateNewId()
{
using (var todoDataSet = new…
netdev
- 1
- 3
-1
votes
1 answer
Adapter.Update() does not work?
i use this code for insert something to Customer Table but it dose not work?
my database does not update and the value of r always is 0.`
using (SqlConnection cn = new SqlConnection(con))
{
cn.Open();
string query =…
Soraya
- 5
- 6
-1
votes
1 answer
DataAdapter.Fill syntax error
So,
Trying to write a very simple method to update a single column in a database. I keep getting a runtime error of "Syntax Error" near the commented line below
public void SaveStatus(string id, string step)
{
// assuming that there is…
deadEddie
- 242
- 2
- 8
- 20
-1
votes
4 answers
Converting a List to a string
I need to convert a few rows of data I am pulling from a DataTable from a List into a string separated by commas. Here is what I have now. It does not work at all (it shows System.Data.DataRow,System.Data.DataRow in the messagebox), however a…
Nathan
- 1,135
- 2
- 12
- 27
-1
votes
1 answer
VB.NET Dataset update
I'm new to vb.net and having quite a challenge with updating a field in a table using the For...Next construct on a data set. Sample code below - can anyone tell me what I'm missing? I know this particular example could be accomplished with a…
user185998
-1
votes
1 answer
How to query multiple IDs using Data Adapter and DataSet?
I've got a set of unique IDs that belong to Users table, eg. 1478, 8906, 4677, etc. Now how do I get a DataSet back with full record set of these users using DataAdapter?
Jake
- 169
- 2
- 16
-2
votes
1 answer
DataAdapter.Fill returns the row count but Rows.List is null
I'm really puzzled about this. I have a table in SQL Server with three nvarchar(255) columns and a couple rows just for testing. the following code correctly returns the column names and the row count of 2 but Rows.List = null. If I use…
Joseph Nuttall
- 21
- 4
-2
votes
2 answers
Is there any direct way to load data in to memory without putting load on database server?
I am trying to read millions of data from sql server and oracle rdbms.
Sql Server - select Id as LinkedColumn,CompareColumn from Source order by LinkedColumn
Oracle -select Id as LinkedColumn,CompareColumn from Target order by LinkedColumn
This…
I Love Stackoverflow
- 6,738
- 20
- 97
- 216
-2
votes
2 answers
Change Connection String in App.config at runtime
The code below serves to change connection string in App.config at runtime, I found it here but this code did not work for me on Visual Studio 2010 and SQL Server 2008, I could not open the connection to the Northwind database.
using System;
using…
Sami-L
- 5,553
- 18
- 59
- 87