ASP.NET MVC database connection using a form

» asp.net-mvc » ASP.NET MVC database connection using a form

By : Paulo Neves

Date : November 28 2020, 11:01 PM

This might help you You don't connect the actual form itself, you connect your backend to the DB, and you connect the form to your backend. Make some sort of route to handle the form request and then connect to your database in that route, and use it to input the data to the database.
Related links: https://docs.asp.net/en/latest/tutorials/first-mvc-app/working-with-sql.html

code :

Share :

How to set a Database Connection for all the Form in MDI?

By : Luca Pisano

Date : March 29 2020, 07:55 AM

like below fixes the issue In your MDI Form create a module level variable to hold the connection:

code :

Private m_Conn as ADODB.Connection

Public Property Get CurrentConnection() as ADODB.Connection
     Set CurrentConnection = m_Conn
End Property

Dim oConn As ADODB.Connection

Set oConn = MainForm.CurrentConnection

Does every Form in c#.net needs a new connection to be established with sql database?

By : user2774008

Date : March 29 2020, 07:55 AM

Hope that helps No, I'd say that in general, for a thick (single-threaded) client, you probably want only one connection open (probably for the lifetime of the client).
You can keep the parameterless constructor for Form2 (which will be needed for the VS designer to continue to work), but you can create a second constructor for Form2 that is passed the open connection and continues to work with it, e.g.:

code :

public Form2()
{
    InitializeComponent();
}
private SqlConnection _conn;
public Form2(SqlConnection conn)
    : this()
{
    _conn = conn;
}

Swing form database connection

By : Tobias

Date : March 29 2020, 07:55 AM

Hope this helps To literally answer your question: your getConnection method is a public static method so you can call this from anywhere. Just call ConnectionManager.getConnection() where-ever you need that connection.
Some other remarks about your code:

Passing database user name and password through a form, for database Connection in Flask App

By : tomy

Date : March 29 2020, 07:55 AM

To fix this issue You have to substitute the username and password in your DSN with the form data:

code :

conn = ibm_db.connect("DATABASE=WDLAB; HOSTNAME=127.0.0.1; PORT=10000; PROTOCOL=TCPIP;UID={};PWD={};".format(USER_ID, USER_PASS), "", "")

form to database connection

By : Ramya Pendem

Date : March 29 2020, 07:55 AM

this will help I have a form that is not working correctly with the database. Please help I used a newsletter.php code that I already had and edited the login information to fit this clients needs. Any help is appreciated. , Try: