vb.net application with sql database
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I am newbie to vb.net and sql. and i tried to search info regarding my query but have not come to solution yet.
I have created vb.net-sql(express 2017) data application, now want to install on client's computer. Regarding installation of sql express is what clients going to do on there computer. so i am going to do database and table creation.
i have created this with first run basis i.e. if application is running for first time(which is in settings). Is it correct way to do it? and also how can i add that database as data source to application?
sql-server vb.net installation asked Nov 22 '18 at 8:39
ShitalShital
568
|
show 1 more comment
0
I am newbie to vb.net and sql. and i tried to search info regarding my query but have not come to solution yet.
I have created vb.net-sql(express 2017) data application, now want to install on client's computer. Regarding installation of sql express is what clients going to do on there computer. so i am going to do database and table creation.
i have created this with first run basis i.e. if application is running for first time(which is in settings). Is it correct way to do it? and also how can i add that database as data source to application?
sql-server vb.net installation asked Nov 22 '18 at 8:39
ShitalShital
568
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use theAttachDbFilenameattribute to specify the file to be attached.
– jmcilhinney
Nov 22 '18 at 8:49
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17
|
show 1 more comment
0
0
0
I am newbie to vb.net and sql. and i tried to search info regarding my query but have not come to solution yet.
I have created vb.net-sql(express 2017) data application, now want to install on client's computer. Regarding installation of sql express is what clients going to do on there computer. so i am going to do database and table creation.
i have created this with first run basis i.e. if application is running for first time(which is in settings). Is it correct way to do it? and also how can i add that database as data source to application?
sql-server vb.net installation asked Nov 22 '18 at 8:39
ShitalShital
568
I am newbie to vb.net and sql. and i tried to search info regarding my query but have not come to solution yet.
I have created vb.net-sql(express 2017) data application, now want to install on client's computer. Regarding installation of sql express is what clients going to do on there computer. so i am going to do database and table creation.
i have created this with first run basis i.e. if application is running for first time(which is in settings). Is it correct way to do it? and also how can i add that database as data source to application?
sql-server vb.net installation sql-server vb.net installation asked Nov 22 '18 at 8:39
ShitalShital
568
asked Nov 22 '18 at 8:39
ShitalShital
568
asked Nov 22 '18 at 8:39
ShitalShital
568
asked Nov 22 '18 at 8:39
ShitalShital
568
asked Nov 22 '18 at 8:39
ShitalShital
568
568
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use theAttachDbFilenameattribute to specify the file to be attached.
– jmcilhinney
Nov 22 '18 at 8:49
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17
|
show 1 more comment
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use theAttachDbFilenameattribute to specify the file to be attached.
– jmcilhinney
Nov 22 '18 at 8:49
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use the
AttachDbFilename attribute to specify the file to be attached.– jmcilhinney
Nov 22 '18 at 8:49
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use the
AttachDbFilename attribute to specify the file to be attached.– jmcilhinney
Nov 22 '18 at 8:49
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426847%2fvb-net-application-with-sql-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426847%2fvb-net-application-with-sql-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why not add a data file to your project and have it attached to the SQL Server instance on demand? That way, there's nothing be done other than install SQL Server Express. The data file is already part of your app and gets attached each time the app is run. Nothing changes within your app other than the connection string, which would use the
AttachDbFilenameattribute to specify the file to be attached.– jmcilhinney
Nov 22 '18 at 8:49
In case you aren't aware of it, program data should be stored in your own folder (e.g. company name/program name) within an appropriate folder from the Environment.SpecialFolder Enum, e.g. ApplicationData, CommonApplicationData, or LocalApplicationData. Those locations will have appropriate file permissions.
– Andrew Morton
Nov 22 '18 at 9:03
@jmcilhinney I will do reasearch on this but just a quick question, Will it possible to do crud operations on tables then? can i attach tables to datagridviews?
– Shital
Nov 22 '18 at 9:03
also will it be able to handle big data?
– Shital
Nov 22 '18 at 9:06
I already answered that question: "Nothing changes within your app other than the connection string". You're still using SQL Server Express and the data is still in an MDF data file. You're still using the same ADO.NET code to interact with the database. The only difference is that the database gets attached when you run your app and detached when you quit instead of being attached all the time. If you want multiple clients accessing the same database then it's not an option but your description indicates that that is not the case.
– jmcilhinney
Nov 22 '18 at 9:17