No announcements
Found 3117396 threads
-
0 VotesData adapter with query based on two tables does not update in datagrid
I created a data source and chose the Reservations.acdb as the data source with 2 tables Customers and Reservations.Answered | 2 Replies | 2038 Views | Created by Dogbar - Saturday, August 25, 2012 1:43 PM | Last reply by calanghei - Monday, August 27, 2012 10:28 AM
-
0 Votes
Find records in a table
You cannot declare "qty" as an integer, and load it with a string, money data type is proprietary and does not do correct arithmetic ...Answered | 4 Replies | 581 Views | Created by Farhan1 - Tuesday, June 28, 2016 4:34 PM | Last reply by --CELKO-- - Wednesday, June 29, 2016 1:27 AM -
1 Votes
Any way to find all the table adapters on a form?
This does not work well with a TableAdapter because you have to keep regenerating all of that bloody code that it creates.Answered | 1 Replies | 3004 Views | Created by JasenGibson - Friday, August 14, 2009 2:56 PM | Last reply by DeborahK - Friday, August 14, 2009 3:46 PM -
0 Votes
SQL table adapter odd behavior
The data that gets loaded is not consistent; there are child records that have no parent record.Answered | 19 Replies | 1120 Views | Created by Justhininabouti - Friday, September 16, 2016 11:55 AM | Last reply by DA924x - Monday, September 19, 2016 12:18 AM -
0 Votes
Too many columns reported from table adapter
I was/am hoping for an answer similar to "dynamic stored procedures wont' work with table adapters/data tables because you have to do this...Answered | 10 Replies | 2954 Views | Created by sage4 - Tuesday, November 18, 2008 7:10 PM | Last reply by konikula - Tuesday, November 18, 2008 9:38 PM -
0 Votes
sql data adapter ports
Hi, For the SQL send port you set three things: The database connection string The target namespace of the schema The root ...Answered | 1 Replies | 7001 Views | Created by ahager - Thursday, January 29, 2009 6:30 PM | Last reply by Alan Smith MVP - Thursday, January 29, 2009 6:41 PM -
0 Votes
Generate a table in a multiple-dataset report from other tables that have been generated within the same report
Hi All, I am doing a report (rdlc) to display 3 list of tables. 1st table is to show confirmed data, 2nd table ...Answered | 1 Replies | 2796 Views | Created by FLukito - Thursday, October 20, 2011 8:14 AM | Last reply by Sharp Wang - Friday, October 21, 2011 8:13 AM -
0 Votes
table Adapter update method generate error Voilation of Primary Key Constraint
It helps others to find relevant posts to the same question.Answered | 5 Replies | 931 Views | Created by haqayyum - Thursday, June 30, 2016 6:58 PM | Last reply by Patrick Hurst - Monday, July 4, 2016 3:08 PM -
6 Votes
Find Data Corruption in table
Via Update and Insert trigger you could generate a value and later you can select all records where the newly generated value is different to the column value.Answered | 12 Replies | 5355 Views | Created by Kalpesh Chhatrala - Thursday, December 10, 2009 4:32 AM | Last reply by Tom Borgmann - Friday, May 25, 2012 2:18 PM -
2 Votes
XSD Table Adapter not populating results in Data Table
I had to go to the .ASCX and go to design mode and I found a bunch of data sources.Answered | 9 Replies | 871 Views | Created by Clarksss - Thursday, November 17, 2016 8:43 PM | Last reply by Clarksss - Monday, November 21, 2016 5:28 PM -
0 Votes
Duplicate records find in table
Based on that column Name, u need to find the columnNames with duplicate??Answered | 6 Replies | 3997 Views | Created by Rammohan Ammiti - Tuesday, August 31, 2010 11:00 AM | Last reply by ramireddy - Tuesday, August 31, 2010 2:02 PM -
0 Votes
Duplicate records in resulting table (report table)
On the Report designer, choose the columns that have repeating data and select the properties.Answered | 3 Replies | 4779 Views | Created by fasttrack - Wednesday, September 7, 2011 5:05 PM | Last reply by Elvis Long - Saturday, September 10, 2011 6:04 AM -
0 Votes
finding table with trace data
I have my results narrowed to down to around 500 and find would be time consuming.Answered | 3 Replies | 809 Views | Created by nickswoca - Tuesday, December 10, 2013 7:36 PM | Last reply by Saeid Hasani - Tuesday, December 10, 2013 8:15 PM -
0 Votes
Generating report off record table adapter not finding data but the mvc project does.
User-544325736 posted Hello community, I have an MVC project that is trying to print reports.Unanswered | 1 Replies | 54 Views | Created by Anonymous - Thursday, August 1, 2019 1:26 PM | Last reply by Anonymous - Monday, August 5, 2019 6:42 AM -
0 Votes
which is better -- separate tables for each Report's data, or one table for all reports data?
I think I will try both approaches -- 4 separate tables and the one table approach which would contain all the data for all the reports.Answered | 4 Replies | 2749 Views | Created by Rich P123 - Monday, November 7, 2011 7:07 PM | Last reply by Rich P123 - Tuesday, November 8, 2011 6:22 PM -
6 Votes
Generating report for 10,000 records (SSRS 2008)
All the reports have tables along with details section and grouping is not in all the tables but very few sub reports.Answered | 12 Replies | 27802 Views | Created by sa250281 - Thursday, November 25, 2010 10:38 AM | Last reply by prasad127 - Monday, November 26, 2018 7:02 PM -
0 Votes
WCF SQL adapter issue while inserting the records into a SQL 2008 Tables
Just import the StoredProc again using the add generated items.Answered | 3 Replies | 10845 Views | Created by BKTheDeveloper - Wednesday, September 30, 2009 10:12 PM | Last reply by vaibhav s - Thursday, March 31, 2011 3:40 AM -
1 Votes
Only Generate Email If Table Contains Data
0 BEGIN exec msdb.dbo.sp_send_dbmail @profile_name = 'MailTest', @recipients = 'your_name@firm.com', @subject = 'Successfully Production', @body = ...Answered | 3 Replies | 758 Views | Created by All-we-know-is-what-we-are-told - Wednesday, July 1, 2015 3:28 PM | Last reply by ryguy72 - Sunday, July 5, 2015 2:25 AM -
0 Votes
Override the new constructor of a table Adapter
That is the way the generated code works.Answered | 1 Replies | 1088 Views | Created by Dagz - Thursday, June 26, 2014 2:07 PM | Last reply by CoolDadTx - Thursday, June 26, 2014 3:41 PM -
6 Votes
WCF-SQL Adapter and reading Data from SQL
Does it mean that I can use WCF-SQL as one way receive and the parameters on adapter that I set will take care of time intervals it needs to run?Answered | 7 Replies | 5105 Views | Created by Rik_at_BTS - Wednesday, June 22, 2011 2:28 PM | Last reply by Rik_at_BTS - Thursday, June 23, 2011 2:59 PM - Items 1 to 20 of 3117396 Next ›
No announcements
