Click here to Skip to main content
14,638,374 members
Home » Discussions » Visual Basic
   

Visual Basic

 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
Dave Kreskowiak3-Apr-19 10:30
mveDave Kreskowiak3-Apr-19 10:30 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
desanti3-Apr-19 11:16
Memberdesanti3-Apr-19 11:16 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
desanti4-Apr-19 0:41
Memberdesanti4-Apr-19 0:41 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
Dave Kreskowiak4-Apr-19 5:49
mveDave Kreskowiak4-Apr-19 5:49 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
desanti4-Apr-19 6:18
Memberdesanti4-Apr-19 6:18 
GeneralRe: Force entity framework to load new data from database without disposing the context Pin
Dave Kreskowiak4-Apr-19 9:22
mveDave Kreskowiak4-Apr-19 9:22 
Questioni want to import a text file to datatable or something like that Pin
Member 142077921-Apr-19 4:41
MemberMember 142077921-Apr-19 4:41 
AnswerRe: i want to import a text file to datatable or something like that Pin
David Mujica1-Apr-19 5:37
MemberDavid Mujica1-Apr-19 5:37 
You could import a text file directly to a datatable without storing it in a database.

However, the basic steps you need to perform:
1) Create a database table with columns defined to match the type of data that you want from the text file. Ex: Integer, date, Varchar, etc

2) create your VB program to loop through the text file parsing the data into the columns you want to store.

3) Execute a database INSERT statement to load the data on a line by line basis.

As you can see, this is a very vague solution. What area do you need help with?

Do you know how to create a database table? CREATE TABLE
Do you know know how to write a program to read a text file line by line?
Do you know how to parse a line into various fields?
Do you know how to execute an INSERT statement ?

Your question seems to be as vague as my proposed solution. Post a specific question so the group can answer it.

Good Luck.
Java | [Coffee]
GeneralRe: i want to import a text file to datatable or something like that Pin
Member 142077921-Apr-19 21:10
MemberMember 142077921-Apr-19 21:10 
AnswerRe: i want to import a text file to datatable or something like that Pin
Richard MacCutchan1-Apr-19 5:55
mveRichard MacCutchan1-Apr-19 5:55 
GeneralRe: i want to import a text file to datatable or something like that Pin
Member 142077921-Apr-19 21:08
MemberMember 142077921-Apr-19 21:08 
GeneralRe: i want to import a text file to datatable or something like that Pin
Richard MacCutchan1-Apr-19 21:20
mveRichard MacCutchan1-Apr-19 21:20 
GeneralRe: i want to import a text file to datatable or something like that Pin
Member 142077921-Apr-19 21:23
MemberMember 142077921-Apr-19 21:23 
QuestionDataGridView Mouse Hover Event Pin
Give me a break I'm new31-Mar-19 5:54
MemberGive me a break I'm new31-Mar-19 5:54 
AnswerRe: DataGridView Mouse Hover Event Pin
speedbump9931-Mar-19 7:45
Memberspeedbump9931-Mar-19 7:45 
QuestionJust wondering it this code is safe. Thanks for input. MESSAGE CLOSED Pin
speedbump9927-Mar-19 2:22
Memberspeedbump9927-Mar-19 2:22 
SuggestionRe: Just wondering it this code is safe. Pin
Richard Deeming27-Mar-19 2:44
mveRichard Deeming27-Mar-19 2:44 
AnswerRe: Just wondering it this code is safe. Pin
Dave Kreskowiak27-Mar-19 3:02
mveDave Kreskowiak27-Mar-19 3:02 
AnswerRe: Just wondering it this code is safe. Sorry To All Pin
speedbump9927-Mar-19 3:33
Memberspeedbump9927-Mar-19 3:33 
GeneralRe: Just wondering it this code is safe. Sorry To All Pin
Dave Kreskowiak27-Mar-19 5:28
mveDave Kreskowiak27-Mar-19 5:28 
GeneralRe: Just wondering it this code is safe. Sorry To All Pin
speedbump9927-Mar-19 5:47
Memberspeedbump9927-Mar-19 5:47 
QuestionA faster way to find an item in a bindingsource and return its index Pin
desanti26-Mar-19 14:45
Memberdesanti26-Mar-19 14:45 
AnswerRe: A faster way to find an item in a bindingsource and return its index Pin
Eddy Vluggen27-Mar-19 3:36
professionalEddy Vluggen27-Mar-19 3:36 
GeneralRe: A faster way to find an item in a bindingsource and return its index Pin
desanti27-Mar-19 4:25
Memberdesanti27-Mar-19 4:25 
GeneralRe: A faster way to find an item in a bindingsource and return its index Pin
Eddy Vluggen27-Mar-19 4:39
professionalEddy Vluggen27-Mar-19 4:39 

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.