Click here to Skip to main content
15,906,574 members
Home / Discussions / Database
   

Database

 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Jörgen Andersson18-Jan-18 9:17
professionalJörgen Andersson18-Jan-18 9:17 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Chris Quinn18-Jan-18 22:13
Chris Quinn18-Jan-18 22:13 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
Eddy Vluggen19-Jan-18 4:12
professionalEddy Vluggen19-Jan-18 4:12 
AnswerTable of straight text Pin
jkirkerx19-Jan-18 7:30
professionaljkirkerx19-Jan-18 7:30 
AnswerRe: Possible to use Linq to query a column that contains a description and remove the whitespaces? Pin
jschell20-Jan-18 6:06
jschell20-Jan-18 6:06 
QuestionEntity Framework 6 - Set Connection String at Runtime Pin
Kevin Marois12-Jan-18 7:17
professionalKevin Marois12-Jan-18 7:17 
AnswerRe: Entity Framework 6 - Set Connection String at Runtime Pin
Richard Deeming12-Jan-18 8:23
mveRichard Deeming12-Jan-18 8:23 
QuestionProblem with Access Pin
JackMisani10-Jan-18 7:51
JackMisani10-Jan-18 7:51 
Hello everybody, i'm writing here because i'm really becoming crazy, i read every kind of internet pages but I'm not able to find a solution but i'm also sure that the solution is behind the corner.

I have an Access database with different tables. The main table has different foreign keys to other tables. I do an example with 2 tables to make the problem easier:

Table Products
Field1 - Primary Key: Product Code - text
Field2: Description - text
Field3: Product Type - integer

Table ProductTypes
Field1: Primary Key - ID - integer - FK on Field3 of "Table Product"
Field2: Description - Text

Now, I open Visual Studio, I add my database and I drag&drop the table "Product" on my Windows Form as a DatagridView. The wizard create for me, the tableAdapter, bindinsource ecc....

If I start my app the DatagridView is populate with the correct data but in the column "Product Type" I see the number from the PK of the table "ProductTypes" while I'd like to see the Description.

I created a new TableAdapter query that give me the result i want to see but when I confirm I get the message that i'm created a query that give a different result from the original schema. If I continue the query is created but i'm not able to retrieve data using this new query.
THe only way I've to retrieve datas as I want is to modify the original Fill query but in this case the relation between the 2 tables will be removed and also the TableAdapter Insert method will be removed.

So, I will see the data in datagridview as i'd like to see but I don't have anymore the insert method.

Can someone help me by telling I could I retrieve the data in the way I desider without losing the chance to insert new record in the table?

Thanks
Giacomo
AnswerRe: Problem with Access Pin
Tim Carmichael12-Jan-18 3:50
Tim Carmichael12-Jan-18 3:50 
GeneralRe: Problem with Access Pin
JackMisani12-Jan-18 4:23
JackMisani12-Jan-18 4:23 
GeneralRe: Problem with Access Pin
Tim Carmichael12-Jan-18 5:13
Tim Carmichael12-Jan-18 5:13 
GeneralRe: Problem with Access Pin
JackMisani16-Jan-18 22:07
JackMisani16-Jan-18 22:07 
GeneralRe: Problem with Access Pin
Tim Carmichael17-Jan-18 2:24
Tim Carmichael17-Jan-18 2:24 
QuestionOLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs2-Jan-18 11:38
kmoorevs2-Jan-18 11:38 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
PIEBALDconsult2-Jan-18 14:12
mvePIEBALDconsult2-Jan-18 14:12 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 8:33
kmoorevs4-Jan-18 8:33 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
Joe DiNatale4-Jan-18 11:10
Joe DiNatale4-Jan-18 11:10 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
kmoorevs4-Jan-18 11:33
kmoorevs4-Jan-18 11:33 
GeneralRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 11:35
professionalS Douglas7-Mar-18 11:35 
AnswerRe: OLEDB connection to a SQL server database hosted in an availability group (repost) Pin
S Douglas7-Mar-18 11:31
professionalS Douglas7-Mar-18 11:31 
QuestionMore than interesting... Pin
Kornfeld Eliyahu Peter31-Dec-17 21:05
professionalKornfeld Eliyahu Peter31-Dec-17 21:05 
AnswerRe: More than interesting... Pin
Jörgen Andersson1-Jan-18 3:44
professionalJörgen Andersson1-Jan-18 3:44 
GeneralRe: More than interesting... Pin
Kornfeld Eliyahu Peter1-Jan-18 4:31
professionalKornfeld Eliyahu Peter1-Jan-18 4:31 
GeneralRe: More than interesting... Pin
Jörgen Andersson2-Jan-18 5:28
professionalJörgen Andersson2-Jan-18 5:28 
SuggestionRe: More than interesting... Pin
Richard Deeming8-Jan-18 7:22
mveRichard Deeming8-Jan-18 7:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.