FAQ Database Discussion Community


How to update several values in row in matlab's dataset?

matlab,dataset
I have a 46x46 dataset and I need to update several values in single row. For example: data = A B C D 0 0 0 0 0 0 0 0 0 0 0 0 I want to make it like A B C D 0 0 0 0 0...

Bulk uploading data to Parse.com

json,import,parse.com,dataset
I have about 10GB worth of data that I would like to import to Parse. the data is currently in JSON format which is great for importing data using the parse importer. However I have no unique identifier to these objects. Of course they have unique properties e.g. a url,...

How to get the MaxLength of a Column in a DataSet returned by ExecuteWithResults in C# SMO?

c#,sql,dataset,smo
I need to get the max length of any column returned in any SELECT executed in the ExecuteWithResults method. Example: The Table TbCli has the column NmCli (varchar NOT NULL) using System; using System.Data; using Microsoft.SqlServer.Management.Smo; ... Server server = new Server(); server.ConnectionContext.ServerInstance = "ServerInstance"; server.ConnectionContext.LoginSecure = true; server.ConnectionContext.DatabaseName =...

Oledbconnection

c#,sql,dataset,oledbconnection,oledbcommand
I'm trying to create a method that will allow me to simply pass an SQL Command to a database with ease. I keep running into this error for some reason though. The full string is this Couldn't fetch the required data. Update unable to find TableMapping['tables'] or DataTable 'tables'. My...

update multi-table dataset via datagridview vb

xml,vb.net,datagridview,dataset
Apologies - I know there's lots of info out there about this subject, but that's precisely the problem - so much info about this - hard to piece it all together to understand/get it working. So many concepts and approaches involved. Basically have read an xml file into a Dataset....

What type of collection do ListViews use to store their data?

c#,.net,user-interface,data-structures,dataset
I just need to know what kind of collection a listview uses to store its data. I see in the documentation that it's its own special kind of collection (ListViewItemCollection) but, is this an offshoot of another kind of collection or is it unique to ListViews entirely?

Understanding R syntax in this example

r,dataset,stackexchange
Finding Peak in a dataset - using R Hi I saw this thread on stackexchange. I am not an R programmer (yet). But I would like to implement in the C. But being not familiar with R syntax, I am not able to understand the code. I know its creating...

How can I count and log the number of rows in a sheet with a specific month/year value

excel,vba,excel-vba,dataset
I've downloaded a dataset which details all of the car accidents reported in England between January 1979 and December 2004 - this file is in csv format and is understandably quite large (6,224,199 rows, to be exact). Because the size of the file exceeds the number of rows that Excel...

Getting Specific Data in DataSet Column and export in excel

c#,database,excel,excel-vba,dataset
i have 5 column in my dataset. name, age,sex, address and contact number then i have 3 datarows in dataset i need only name, address and contact number during export in excel.. how can i do that? im using the using Excel = Microsoft.Office.Interop.Excel; i only get the 1st row.....

DataSet using first row as column header move the checkbox column 1 row down

c#,datagridview,dataset
I have DataSet which i populate from Excel file: OleDbConnection conn; OleDbDataAdapter command; conn = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + filePath + " ';Extended Properties=Excel 8.0; "); conn.Open(); firstSheetName = GetFirstSheet(conn); command = new OleDbDataAdapter("select * from [" + firstSheetName + "]", conn); command.TableMappings.Add("Table", "Table"); dtSet = new DataSet(); command.Fill(dtSet); dgvInputFile.DataSource...

Read from dataset and place into objects

java,arrays,oop,object,dataset
I have a external dataset which is filled with the following data: userid, itemid, rating. I want to read this data into an userpreference object for each user. The userpreference object contains a userid, an itemid array and an ratings array. I chose an array because the performance needs to...

h5py: how to read selected rows of an hdf5 file?

python,numpy,dataset,h5py
Is it possible to read a given set of rows from an hdf5 file without loading the whole file? I have quite big hdf5 files with loads of datasets, here is an example of what I had in mind to reduce time and memory usage: #! /usr/bin/env python import numpy...

Get rid of kth smallest and largest values of a dataset in SAS

dataset,sas
I have a datset sort of like this obs| foo | bar | more 1 | 111 | 11 | 9 2 | 9 | 2 | 2 ........ I need to throw out the 4 largest and 4 smallest of foo (later then I would do a similar thing...

Join ekstra months to dataset sql

sql-server,join,sql-server-2012,dataset
First off, thanks to anyone who helps me solve this problem. I am using SQL 2012, I have a rows of data that look like such: | myPK | Name| Month | Value | 1 SB 1 500 2 SB 4 100 So what i now want is the month...

Strong Typed Dataset set variable TOP value

.net,dataset,typed
I've got a problem with a strong typed dataset query in my project. I have a query like this: SELECT * FROM dbo.PositionData WHERE [email protected]_Tracker Which works fine and the datatable function is correctly generated. Now I would like to add a TOP value to the query, which can be...

ASP.NET DataSet Queries - Warning is causing DataSet to not fill correctly

asp.net,ms-access,dataset,warnings,modulus
I've created a DataSet in ASP.NET and replaced the default Fill query with the following SQL statement: SELECT Resolved_Request.ResolvedReqID, In_Progress_Request.DateAssigned, Resolved_Request.DateResolved, Fix(((DATEDIFF('n', In_Progress_Request.DateAssigned, Resolved_Request.DateResolved) / 60 / 24))) & ' days, ' & ((DATEDIFF('n', In_Progress_Request.DateAssigned, Resolved_Request.DateResolved) / 60) Mod 24) & ' hours and ' & (DATEDIFF('n', In_Progress_Request.DateAssigned, Resolved_Request.DateResolved) Mod...

Merging data with text identifiers

categorical-data,dataset
I am trying to merge a bunch of datasets at the company level. The problem is my datasets only identify company name with a text string (i.e. "Ham and Cheese LLP") and further sometimes misspell or spell in alternative ways the names (i.e. "Ham and Cheese", "Ham, and Cheese", "Ham...

jQuery data with dynamically created elements and event handlers

jquery,events,dataset
I would like to know why updating data of dynamically created element affects other element's data created before. Here is example http://jsfiddle.net/bmq3sk9c/ var createComment = function(data) { var post = $("<div/>").addClass("com").html("lorem "+Math.floor((Math.random()*10)+1)).data("extra", data); var btn = $("<a/>", {href:"",class:"sbm"}).text("submit"); post.append(btn); post.on("submit", submitComment); post.appendTo("body"); }; var submitComment = function(e){ //ajax here $(this).data("extra").time...

Binding dataset to dynamic generated textbox in loop

vb.net,textbox,dataset
I'm unable to get the dynamically generated textboxes display the right data when binding it to a dataset. The dataset holds 2 tables. The Environments table has 4 rows with the values DEV, TST, ACC, PROD. Dim cma As CurrencyManager cma = CType(BindingContext(oConfData.dsJimConfig.Tables("Environments")), CurrencyManager) For i As Integer = 0...

Find the inflection point of a discrete dataset in Matlab

matlab,dataset,inflection
I have a dataset (an array with x and y values) to which I eventually want to fit a nonlinear model. In order to increase the chances that the fit will be good and that the model will converge, I want to supply initial parameters as close to the solution...

Create SQL Server DB from DataSet

c#,sql-server,xml,xsd,dataset
I read xsd and xml file in DataSet, now I want create db from this DataSet foreach (DataTable dt in temp.Tables) { foreach (DataColumn dc in dt.Columns) { //example for one column SqlCommand createtable = new SqlCommand( "create table " + dt.TableName + " (" + dc.ColumnName + " varchar(max))",...

Disaggregate one row of data to multiple rows

r,excel,statistics,dataset,google-adwords
Goodafternoon! I am having some trouble with my dataset. I am using a Google AdWords export for data analysis and I want to fit a logit regression model to the data to determine whether an experiment I have conducted impacts the conversion. The problem is that the data is aggregated...

How to remove datatable from dataset?

c#,asp.net,datatable,dataset
Aspx code: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SearchCustomer.aspx.cs" Inherits="WebApplication1.eyeofheaven.SearchCustomer" %> <!DOCTYPE html> <html lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" /> <link rel="stylesheet" type="text/css" href="StyleSheets/SearchCustomerStyle.css"> <link rel="stylesheet"...

Need To combine two date parts into a new date field without the results adding

sql,sql-server,sql-server-2008,data-structures,dataset
I am trying to get two date parts, day and year, to combine into one new data field without adding the results. I do not know what I am doing wrong and any help would be greatly appreciated. sELECT Convert(varchar,dbo.tblRpt291_AgingSnapshot.ReportDate)as DATEINT, Datepart(DAY,dbo.tblRpt291_AgingSnapshot.ReportDate)+ ''+''+DATEPART(YEAR,dbo.tblRpt291_AgingSnapshot.ReportDate) as Date, dbo.tblRpt291_AgingSnapshot.ReportDate, First.Age AS AvgAge, First.CountOfCalls...

Check if VB.net dataset table exists

vb.net,if-statement,dataset
I have the following code to check if my table exists before proceeding If ds.Tables(3).Rows.Count = 0 Then MsgBox("Nothing!!!!") Else DataGridView1.DataSource = ds.Tables(3) The trouble is I keep getting the error "Cannot find table 3." How in VB can I check if the table exists, rather than my application erroring...

OpenCV SVM training dataset

opencv,dataset,computer-vision,svm,training-data
Lets say I have a dataset of about 350 positive images and more than 400 negative images. They aren't the same size. Also their size is bigger than 640x320. What should I do to create a better dataset? Do I need the images to be smaller? If yes, why? Should...

ASP.Net datasource navigation

c#,asp.net,gridview,navigation,dataset
I've been looking for a while, and didn't find a proper solution; I'm trying to search in a DataSet (which is a source of a gridView) which consists of usernames & details in an ASP.Net page. If the user wants to find a specific row, he needs to insert the...

How to take variables in a column and make them into numerous columns

r,dataset,tidy
So I have this dataset which I have been cleaning for someone else but they want a specific column made into several columns by type of observation. For example this is a column of diagnoses and she wants this column to be expanded so it is one column for one...

Auto-generated code in WPF shows error. (C#, WPF, Visual Studio Community 2013)

c#,wpf,data-binding,visual-studio-2013,dataset
Recently i have started playing with C# in Visual Studio 2013 Community. I was creating a simple data binding while i encountered following error. What i was doing i was using drag-n-drop fr om my database to main window. Visual studio generated required XAML and .cs file. There was following...

How to Filter DataGridView with DataSet as DataSource

vb.net,datagridview,filter,dataset,rowfilter
Need some help. I retrieve data from a Database and fill it into a DataSet using a TableAdapter. MyTableAdapter.Fill(MyDataSet, "Table1") DataGridView1.DataSource=MyDataSet DataGridView1.DataMember="Table1" My Datagridview is such, that I can remove and add columns from the original dataset. I want to filter the DataGridView, so I use the following: Dim dv...

Get a variables value from one dataset if falling in a range defined by two variables in another dataset in R

r,date,statistics,dataset
I have a question regarding dates manipulation in R. I've looked around for days but couldn't find any help online. I have a dataset where I have id and two dates and another dataset with the same id variable, date and price. For example: x = data.frame(id = c("A","B","C","C"), date1...

Adding datatable to dataset creates 2 identical tables in dataset, is there another way to add?

c#,visual-studio-2010,dataset,datarow
Just an FYI, I know there are different ways to handle this, but I need it to work in this particular way for my project. I create a DataSet(DS) and a DataTable(DT) from a DataSet I created with the DataSetGenerator in VS2010, I then add a row to the DT...

how to update columns of datatable in dataset if the table is modified at the database file

c#,sql-server,datatable,dataset
I have created a SQL Server database file (.mdf) and added tables to it defining their columns. Then I added a dataset to my project linked to the database file, later on I found that I have to modify the db file and add some columns to the table, but...

How to loops over a dataset's table's DataRowCollection without null checking

.net,dataset,null-check,datarowcollection
I'm working with a dataset that is already populated. I am iterating over the rows in a table like so: foreach (DataRow row in this.dataSet.Tables["tablename"].Rows) { // do something } this works fine, unless there are no rows, in which case there is no table, so I get an 'object...

Creating XML using DataSet.WriteXml. How to change the node name?

c#,xml,c#-4.0,datatable,dataset
Is there any way to change the DataSet default node name? I am creating XML from a DataTable. This is my code: DataSet dataSet = new DataSet("Products"); dataSet.Tables.Add(tbl); dataSet.WriteXml(@"D:\Temp\test.xml"); This is the XML I'm getting: <Products> <Table1> <product_name>McWilliams Hanwood Chardonnay 750mL</product_name> <id>121385</id> <price>7.60</price> </Table1> <Table1> ... </Table1> <Table1> ... </Table1>...

Chunking, processing & merging dataset in Pandas/Python

python,pandas,merge,dataset,chunking
There is a large dataset, containing a strings. I just want to open it via read_fwf using widths, like this: widths = [3, 7, ..., 9, 7] tp = pandas.read_fwf(file, widths=widths, header=None) It would help me to mark the data, But the system crashes (works with nrows=20000). Then I decided...

How to refresh the bindingnavigator binding source in c#?

c#,dataset,bindingsource,tableadapter,bindingnavigator
I have a problem refreshing my bindingsource after I change the data on the database from an other form. now when I first run my program all the data is shown in textboxes and the bindingnavigator has same records as the database. With that being said, I'm trying to add...

`rbind` dataset by sequence in a directory

r,path,merge,dataset,rbind
I have a data set with identical row and row numbers. I want to rbind those data in a sequence of two. For example for data 5LSTT-test12_1.avgm and 5LSTT-test12_1_sum.avgm first I want to merge them by using rbind and save them with the new name let's say test12.avgm. This process...

How to clear the dataset rows based on the column headings in c#

c#,asp.net,.net,dataset
Suppose i have a dataset which contains a table having columns with headings like A,B,C and i need to clear the all contents of B column only. How can i do that? At present what i done is that, first i removed the column B Dataset.Tables[0].Columns.Remove(B); Then added back Dataset.Tables[0].Columns.Add(B);...

The value of TIME(2) column is shown with extra precision zeros while the query returns only 2

c#,mysql,sql,time,dataset
I am running a simple sql query using the following code. In my query there is a column called duration with type TIME(2). When I run the query normally on my MySQL Workbench the value of duration is correctly shown with only 2 precision points. But when I fill my...

Using LINQ to select distinct values between two tables

c#,linq,dataset
I have a DataSet that looks like the below information. What I am trying to do is populate an object with as much information as available. So I want to get UnitNum 65002 from the top dataset and the rest from the Single column table. My Code: foreach (DataRow row...

Find entry in dataset using dictionary

python,dictionary,dataset
I use dataset in python to create and query databases. It takes dictionaries to create an entry: entry1={}; entry[id]=1;entry[name]='a' DBd['data'].insert(entry1) I would like to make sure that I do not enter the entry if it already exists. However, the find method doesn't take dictionaries, but would work as follows: DB['data'].find(id=1,name='a')...

How to add items to existing database thru application form

c#,dataset
I currently have a dataset and would like to continually add new items to that dataset (like type a new entry in a textbox and add it with a button) and edit current items via the applications form I created. How would I go about tackling this issue? edit: This...

using WebServices to read Customers Tables

c#,asp.net,webforms,dataset,asmx
I want to make WebMethod to my WebForms, beforehand this is my function [WebMethod] public DataSet GetCustomersData() { using(SqlConnection conn = new SqlConnection("MyConnString")) { try { conn.Open(); string commandstr = "select * from Customers ORDER BY CustomerID"; SqlCommand cmd = new SqlCommand(commandstr, conn); SqlDataAdapter SqlDa = new SqlDataAdapter(cmd); DataSet SqlDs...

load_files in scikit-learn not loading all files in directory

python,machine-learning,dataset,scikit-learn,classification
I have a folder called 'emails' with two subfolders named after the label corresponding to the classification of files they have (spam or notspam emails, all are .txt files). There are 3000 files across the two subfolders. Using load_files: data = load_files('emails', shuffle='False') print len(data) print len(data.target) This prints '5'...

Make two random teams form dataset and get overall team score in R

r,random,dataset,subset
Lets say I have a soccer team of 10 players (players) from which I should make two subteams of 5 players each and then compute the overall score for each team. players <- read.table(text= "paul 3 ringo 3 george 5 john 5 mick 1 ron 2 charlie 3 ozzy 5...

Counting the number of records per month in an Access table which holds 25 years worth of data

sql,excel,ms-access,csv,dataset
This is probably a really simple question, but I couldn't find an answer which related to a dataset spread across such a long period of time. For starters, this carries on from an earlier post where I wanted to count the number of records from each month in a dataset...

How to bind EF dataSet with WPF datagrid?

wpf,linq,entity-framework,datagrid,dataset
I can't connect properly my dataSet (from EF) with WPF datagrid. My issue is that my datagrid shows : two selected column with correct column header (great :-) ! ) all other column (including two above) with column header from database (I don't want theses columns) Here is my code...

Writing a Dataset to xml including extra element

c#,xml,datatable,rss,dataset
Hi i am converting rss into xml using Datable. First i am reading the rss and converting into DataTable. Datatable is then converting into XML. try { DataTable tbl = new DataTable(); tbl.Columns.Add("id"); tbl.Columns.Add("product_name"); XmlDocument doc = new XmlDocument(); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(""); XmlNodeList itemNodes = xmlDoc.SelectNodes("//rss/channel/item"); foreach...

The source contains no DataRows

c#,linq,datatable,dataset
DataTable dt = ds.Tables[4].AsEnumerable() .Where(x => ((DateTime)x["EndDate"]).Date >= DateTime.Now.Date) .CopyToDataTable(); ds.Tables[4] has rows but it throws the exception "The source contains no DataRows." Any idea how to handle or get rid of this exception?...

How to merge two sets of data/array dynamically based on their count

php,arrays,algorithm,dataset,data-extraction
So, I have this requirement that I have two sets of data (stored in arrays, but can be anything). What I want to do is that I want to add these two sets together so that the final result count is 10. The scenarios are: Both sets can initially have...

Dataset Cannot find table 0

c#,asp.net,dataset
I have method below private DataSet passwordManagement(int reseller_ID, string username, string password, int processType, DateTime? PasswordResetDate, bool? IsPasswordReset, string newPassword) { DataSet passwordManagement = new DataSet(); SqlParameter[] PasswordManagementStoredProceduredParamaters = new SqlParameter[8]; PasswordManagementStoredProceduredParamaters = SqlHelperParameterCache.GetSpParameterSet(uf.SecretPass(strConn), "PasswordManagement"); dbconn.Open(); PasswordManagementStoredProceduredParamaters[0].Value =...

row is not getting added to table

c#,dataset
DataSet datare=new dataset1(); //global variable public partial class main_inherit : sphynx { public main_inherit():base(@"Data Source=PC5;Initial Catalog=clinic_Main;User ID=sa") { } string constr; public override SqlDataReader getval(string query) { constr = base.connector(); try { sqlcon.Open(); sqlask = new SqlCommand(query, sqlcon); rdr = sqlask.ExecuteReader(); } catch { } sqlcon.Close(); return rdr; } public...

Find All Rows in DataTable Where Column Value is NOT Unique Using Linq Query

c#,linq,linq-to-sql,dataset
I am attempting to write a Linq to SQL query that returns all rows in a DataTable where a columns value (TxnNumber) is not unique. So far, I have the Linq to SQL below where dt is the DataTable that contains the field TxnNumber. I think that I am pretty...

FlatXmlDataSetBuilder throw “java.net.MalformedURLException” when using a StringBuffer

java,xml,dataset,dbunit,in-memory-database
I'm trying to create a parser which can parse an XML database extract into a FlatXMLDataSet. I am using a StringBuffer to write my FlatXML and then convert it into FlatXmlDataSet but it throw me a "java.net.MalformedURLException : No protocol". So I tried to create a file from my StringBuffer...

to_char(Column_name) what would be the column name in dataset

sql,oracle,dataset,column-alias
I have a column name as CREATEDATE. I use this sqlcommand to get the information string sql = "SELECT USERID,USERNAME,USERPOSITION,UPDATEUSERID,USERSTATUS,TO_CHAR(CREATEDATE, 'DD-MM-YYYY HH24:MI:SS') FROM USERMASTER WHERE USERID ='" + stat[0] + "'"; I bind them in to dataset ds. when I want to get the data of TO_CHAR(CREATEDATE, 'DD-MM-YYYY HH24:MI:SS') I...

“External table is not in the expected format”

c#,excel,dataset,openxml,oledbdataadapter
I try to fill DataSet with Excel data (via OpenXML library to get sheet name), but some times i get error: "External table is not in the expected format". So, i use the same file= *.xlsx (i converted it from *.xls to *.xlsx via Excel 2010). Yesterday it works fine,...

How to apply ReliableSqlConnection's retry policy on SqlDataAdapter/DataSet

c#,ado.net,dataset,enterprise-library,enterprise-library-6
We applied Microsoft's Enterprise Library Transient Fault Handling Block on the Azure Sql connection and commands. For example, using(var sqlConnection = new ReliableSqlConnection(_connectionString, _connectionRetry, _commandRetry) { var command = sqlConnection.CreateCommand(); command.CommandText = "..."; sqlConnection.Open(); using(var reader = sqlConnection.ExecuteCommand<SqlDataReader>(command)) { ... } } It would work for such as command.ExecuteReader(), which...

fill command cannot be used

c#,dataset,oledb,fill
This Is my code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.SessionState; //db con using System.Data; using System.Data.OleDb; using System.Data.SqlClient; using System.Configuration; namespace SOMaintenance.App_Code { public class readdata { string sConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; public void selectdata(DataSet dataset1, string sqlcommand) { string strConString =...

Change the sequens of columns in datatable with linq

vb.net,linq,datatable,dataset
I have a Datatable with the columns Name|Age|Job I query that Datatable with Linq and do some manipulations. Dim query = From row in dt.AsEnumerable.where(...) The returned object is a datatable that I need for further procedures. But now I have to change the column sequence to Age|Name|Job and do...

SSRS - Fields working in Data Set, but won't appear in report

sql,sql-server,reporting-services,dataset,report
I have a data set that gets its values from a stored procedure, and I'm positive that the stored proc is working correctly since I'm getting results in SQL Server. However, when I call the fields in an expression (for example, =Fields!CustomerName.Value) and preview, it just displays a blank spot...

Binding DataGirdComboBoxColumn to DataSet doesn't work

wpf,datagrid,dataset
I want to create a simple master-detail view in a datagrid. I tried to bind a DataGirdComboBoxColumn to a DataSet, but it won't work. Here's my xaml code: <DataGrid x:Name="DataGrid1" Grid.Column="0" Grid.Row="0" AlternatingRowBackground="#FFF0F0F0" ItemsSource="{Binding}" Height="420" AutoGenerateColumns="False"> <DataGrid.Columns> <DataGridTextColumn Header="ID" Binding="{Binding AirplaneID}" IsReadOnly="True" MinWidth="30"/> <DataGridTextColumn Header="Model" Binding="{Binding Model}" IsReadOnly="True" Width="Auto"...

What is the difference between tables and datasets?

matlab,dataset
in my MATLAB code I mostly use datasets to store data and metadata of different types in a single container variable. However, I found out that coworkers use tables. It seems to me that the two data types are very similar: both can be accessed by column names or indices,...

Combobox SelectedValue Returning System.Data.DataRowView even Converted to String

c#,winforms,combobox,dataset,datasource
I am trying to change value of a TextBox control after the value of ComboBox changes. My code returns System.Data.DataRowView on the first time ComboBox value changes. That is why I am getting an Object instead of the actual value on first call to my combobox. private void radioButton2_CheckedChanged(object sender,...

Report Viewer multiple Datasets

c#,asp.net,dataset,reportviewer,multiple-tables
I have a web application that should display a report viewer. Here's my steps: 1) adding a script manager and a report viewer to a new web form 2) adding a report and bind it to a dataset called dataset1 3) create a parameter for the query 4) write code...

Distance and metrics between datasets

dataset,artificial-intelligence,distance,hierarchy
I have almost 30 different data-sets. Each of them contain a different number of variables and the dimension is around 46. I'm trying to measure the distance between these data-sets, rather than the distance between the items within each data set themselves. My proposal is to find the mean for...

crystal report got error when copy to datatable

c#,asp.net,datatable,crystal-reports,dataset
i got problem about reporting using crystal report here is my code protected void Page_Load(object sender, EventArgs e) { string Judul, Peminjam, Pinjam, Kembali; DataTable dtReturn = new DataTable(); SqlConnection con = data.getKoneksi(); con.Open(); SqlCommand Perintah = new SqlCommand(); Perintah.Connection = con; Perintah.CommandText = "SELECT DISTINCT Peminjaman.Katalog, Peminjaman.Pinjam, Peminjaman.Kembali, Pengguna.Nama,...

Inserting Dataset + additional columns into a table

sql-server,tsql,sql-server-2012,dataset
This seems like a pretty straightforward problem but for the life of me, I can't seem to figure out how to do this. I have a dataset [a combination of some UNION's] that needs to be inserted into a table. Dataset: SELECT COL1 AS A, COL2 AS B, COL3 AS...

Validation of a XML with same Tag name for multiple children

c#,xml,validation,dataset
I want get multiple values under a Tag called Default value.Ex <DefaultValue>One </DefaultValue> <DefaultValue>two</DefaultValue> <DefaultValue>three</DefaultValue> I want validate all three values in a single validation. That means my string may contain any one of the values One,two ,Three,..it should validate if it contains any one <?xml version="1.0" encoding="utf-8" ?> <ValidationList>...

Most efficient way to search large dataset for item

c#,linq,search,dataset,processing-efficiency
This has probably been asked before but I have not been able to find the same scenario. I have been given a huge SQL dataset of a single column of strings (ie. Cities containing branches of a company). I have also been given an even larger master dataset of strings...

dataGridView won't reflect updated dataset

c#,datagridview,visual-studio-2013,dataset
On my main form I have the following method: private void updateSet() { dsManager.fillPeriodSet(); dataGridView1.DataSource = null; dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = dsManager.mainSet; dataGridView1.DataMember = "nice_table"; } This method is called from the constructor when the form initializes and again after dataset is updated with an additional "period". It works...

Sql Exception related to DataSet in asp.net

c#,sql,sql-server,exception,dataset
I want to get values of a id specified row in my "Service Fees" table. When I try to execute following code an exception, which says "An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code.Additional information: Incorrect syntax near 'a34'." Is it about Dataset...

How to find the row number of a dataset vb.net

vb.net,dataset
I am trying to find the row number of a dataset that holds the item "Rushil" in the field "Name". I was researching how to do this and I came across the Datatable.Select method. What would the filter expression be to find the row number? How would I do this...

Handling concurrency exceptions in DataGridView

c#,vb.net,winforms,datagridview,dataset
This article here describes handling concurrency exceptions. The steps to reproduce the problem are: Create a new Windows Application project. Create a new dataset based on the Northwind Customers table. Create a form with a DataGridView to display the data. Fill a dataset with data from the Customers table in...

ASP.Net - constructing a Dataset from a single Grid Row

c#,asp.net,gridview,dataset
I`m making an ASP.Net site. One of the pages contains a GridView of users which I want to display. Each row represends a user. When a Search button is clicked, I want to find a specific user-row by their name (which I already implemented); Then, I want to pass to...

CheckBoxField in an ASP.Net Dynamic dataset loaded GridView

c#,asp.net,gridview,types,dataset
I`m making an ASP.Net webpage, which contains a dynamic gridView. The user is suppoused to be able to search for a specific row in the gridView by the username; One of the fields contains a checkbox, and I have problem loading it into the dataset. Here's a part of my...

How to use Like condition to get specific data from dataset to datarow?

vb.net,asp.net-mvc-4,dataset,datarow
I am using VB.Net language in .Net MVC 4.0 I am having a dataset with records like 1 David 05/31/2011 05/16/2011 2 Rassell 06/15/2011 06/01/2011 3 David 06/15/2011 06/01/2011 like vise thousands of records are there in dataset and I just want to get data of David using like condition...

PowerShell DataSet — array trimming and export to CSV

powershell,dataset,export-to-csv
I'm having some problem extracting values from this function: function Get-DatabaseData { [CmdletBinding()] param ( [string]$connectionString, [string]$query, [switch]$isSQLServer ) if ($isSQLServer) { Write-Verbose 'in SQL Server mode' $connection = New-Object -TypeName System.Data.SqlClient.SqlConnection } else { Write-Verbose 'in OleDB mode' $connection = New-Object -TypeName System.Data.OleDb.OleDbConnection } $connection.ConnectionString = $connectionString $command =...

R: Create dataset with specific correlation in r

r,random,dataset,correlation
How can i create a dataset with two columns having a specific correlation to each other? I want to be able to define the number of values which will be created and specify the correlation the output should have. The question is similar to this one: Generate numbers with specific...

Saving Data To DataSet That Has Been Set Up Programmatically

vb.net,datagridview,dataset
I am building a form where I need to programmatically set bindings and the dataset (as it is variable and different documents can be loaded in to it). I've managed to get the form to load any information in to a DataGridView and also load that information from the DataGridView...

Matlab - How to concat dataset name + i in for loop?

matlab,for-loop,dataset
I have a dataset containing several arrays which are identified by a generic name and a number. I would like to modify arrays independently from each other in a for loop like so: for i=1:length(dataset) dataset.GenericName_i(row,column)=f(x) end Do you know a way to do that? Thanks!...

SQL - Return all records if column value matches pattern?

sql,sql-server,tsql,dataset
I have a query below that returns a very large set of data: SELECT a.id, a.name, c.c_name, l.t_id, t.n_id, l.lr_id, l.created, l.am_id, e.e_name FROM l INNER JOIN e ON l.e_id=e.e_id INNER JOIN t ON l.t_id=t.t_id INNER JOIN a ON l.a_id=a.a_id INNER JOIN c ON a.p_c_id=c.c_id WHERE lower(c.c_name) LIKE 'XXX' and...

SQL Query not populating combobox in VB 2013

mysql,sql,vb.net,combobox,dataset
Can anyone provide insight as to why the first combobox get filled and the second one does not? I built the second query in the MySQL workbench and it works fine. But my application will not return any results into the combo box. 'populate my projects combo1 Dim da1 As...

C# Get String From Data set Exception

c#,string,datatable,dataset
I searched already & it isn't the issue to read Dataset , The issue is i done same but it is not working I Am trying to get complete name from Datasset, when i try following String Receiver_name = rec_Ds.Tables[0].Rows[0][First_Name].ToString() + " " + rec_Ds.Tables[0].Rows[0][Last_Name].ToString(); it gives ArgumentNullException was unHandeled...

FusionChart Multi-series dataset number prefix

dataset,number-formatting,fusioncharts
Is it possible to each dataset to have it's own numberPrefix? <graph caption='Product Sales' numberPrefix='$' > However this puts the same dollar sign for every dataset. What i want is to show for product A , totals in EUR / GBP / USD, and for product B EUR / GBP...

What is the advantage of the paperboat format in performance optimization of ML?

optimization,machine-learning,dataset
The paperBoat format claims to provide a better dataset representation for machine learning routines. I'd like to understand the nature of its optimization. I understand that using an integer representation for model attributes means a faster processing of the data set, what are the other improvements. Also, how to tune...

c# move a data grid view up or down using buttons

c#,datagridview,dataset
I have create a example program of the problem I am currently facing. Due to nature of windows object you cannot simply cast objects or integers into the data grid view as its read only, because of this I'm unable to copy the current position of the dataset and use...

changing the order of records in dataset

c#,winforms,datagridview,dataset
I'm trying to sort the records at a dataset according to users preference. I add a button (move up) to bump up the selected record 1 row higher and this is what i have done until now: private void btnMoveUp_Click(object sender, EventArgs e) { int index = dataGridView1.CurrentRow.Index; if (index...