how to write connection string automatically in web.config f

How to use this form for creating an connection string in the web.config file on the press of "Submit & Continue" button. As I want to develop an application where any user can create a database connection just by entering database type, URL and authentication details. Please help me in all possible ways.

<div class="box box-info box-solid">
<div class="box-header with-border">
<h3 class="box-title">Add Database to Your Storeh3>
div>
<div class="box-body">
<label class="text-info text-bold">First Create a Database on Your Server. If You need help in creating database on server then <a href="#" target="_blank">Click Herea>label><br /><br /><br />
<label class="col-sm-3 col-md-3 col-lg-3">Database Type : label>
<div class="col-md-9 col-sm-9 col-lg-9" style="margin-bottom:10px;">
<asp:DropDownList ID="LanguageDropdown" runat="server" CssClass="form-control">
<asp:ListItem>MS SQL Serverasp:ListItem>
<asp:ListItem>MY SQLasp:ListItem>
<asp:ListItem>Oracle DBasp:ListItem>
asp:DropDownList>
div>
<label class="col-sm-3 col-md-3 col-lg-3">Host : label>
<div class="col-md-9 col-sm-9 col-lg-9" style="margin-bottom:10px;">
<asp:TextBox ID="DatabaseHost" runat="server" CssClass="form-control" placeholder="Write 'localhost' if Database Server & Web Server are same.">asp:TextBox>
div>
<label class="col-sm-3 col-md-3 col-lg-3">Database Name : label>
<div class="col-md-9 col-sm-9 col-lg-9" style="margin-bottom:10px;">
<asp:TextBox ID="TextBox1" runat="server" CssClass="form-control">asp:TextBox>
div>
<label class="col-sm-3 col-md-3 col-lg-3">User Name : label>
<div class="col-md-9 col-sm-9 col-lg-9" style="margin-bottom:10px;">
<asp:TextBox ID="TextBox2" runat="server" CssClass="form-control">asp:TextBox>
div>
<label class="col-sm-3 col-md-3 col-lg-3">Password : label>
<div class="col-md-9 col-sm-9 col-lg-9" style="margin-bottom:10px;">
<asp:TextBox ID="TextBox3" runat="server" CssClass="form-control" TextMode="Password">asp:TextBox>
div>
div>
<div class="box-footer">
<asp:Button ID="Next" runat="server" Text="Submit & Continue" CssClass="btn btn-success pull-right" OnClick="Next_Click" />
div>
div>

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa8y ago
https://stackoverflow.com/questions/48995226/how-to-write-connection-string-automatically-in-web-config-file-using-a-web-form
0
Laxmidhar Sahoo8y ago
Look the URL Https://stackoverflow.com/posts/2260335/revisions
0
Amit Gupta8y ago
Since it is an xml file, it can be modified easily.

Have a look
https://www.aspsnippets.com/Articles/Programmatically-Add-or-Update-Connection-String-in-ASPNet-WebConfig-File.aspx

Try to take advantage of google, you will almost find your solution.
0