Asp.net C# Tutorial 13 - How to Insert and Retrieve data from PostgreSQL Database using ASP.NET C#

[email protected] Chirag's ASP.NET C# Tutorial https://www.chirags.in
***********************************************************************************************How to Insert and Retrieve data from PostgreSQL Database using ASP.NET C#
***********************************************************************************************
Steps:
1. Create a new ASP.NET Web Application in Visual Studio.
2. Add the PostgreSQL NuGet package to your project by right-clicking on the project in Solution Explorer and selecting "Manage NuGet Packages."
3. In your Web Form, create a form with input fields for the data you want to insert into your PostgreSQL database.
4. In the code-behind file (e.g., Default.aspx.cs), add the following using statement to include the Npgsql namespace.
5. In the code-behind file, add the following code to connect to your PostgreSQL database and insert data into a table.
6. Call the Insert Data method when the user submits the form. For example, you could add a button to your form and call the method in the button's click event handler.
*******************************
Web.config
﹤connectionStrings﹥
﹤add name="PostGreconString" connectionString="Server=localhost;Port=5432;User Id=postgres;Password=admin@123;Database=WebTest;" providerName="Npgsql" /﹥
﹤/connectionStrings﹥


*****************************************************
.aspx page

﹤table style="margin-left: auto;margin-right: auto;"﹥
﹤tr﹥
﹤td﹥
﹤asp:Label ID="lblMsg" runat="server" Text=""﹥﹤/asp:Label﹥
﹤h1﹥User information﹤/h1﹥﹤br /﹥
﹤asp:TextBox ID="first_name" runat="server" Placeholder="Enter your First Name" ﹥﹤/asp:TextBox﹥﹤br /﹥﹤br /﹥
﹤asp:TextBox ID="last_name" runat="server" Placeholder="Enter your Last Name" ﹥﹤/asp:TextBox﹥﹤br /﹥﹤br /﹥
﹤asp:TextBox ID="email" runat="server" Placeholder="Enter your Email" ﹥﹤/asp:TextBox﹥﹤br /﹥﹤br /﹥
﹤asp:Button ID="SbtBtn" runat="server" Text="Submit" OnClick="SbtBtn_Click" /﹥
﹤/td﹥
﹤/tr﹥
﹤/table﹥
﹤table style="margin-left: auto;margin-right: auto;"﹥
﹤tr﹥
﹤td﹥
﹤asp:GridView ID="GridView1" runat="server"﹥﹤/asp:GridView﹥
﹤/td﹥
﹤/tr﹥
﹤/table﹥


*************************************************
.aspx.cs page
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Npgsql;
using System.Configuration;
using System.Data;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
NpgsqlConnection con = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["PostGreconString"].ConnectionString);
con.Open();
NpgsqlDataAdapter PgSQLAdapter = new NpgsqlDataAdapter("Select * from userinfo", con);
DataTable DT = new DataTable();
PgSQLAdapter.Fill(DT);
GridView1.DataSource = DT;
GridView1.DataBind();
}

protected void SbtBtn_Click(object sender, EventArgs e)
{
/*Inline connection call*/
//string connString = "Server=localhost;Port=5432;User Id=postgres;Password=admin@123;Database=WebTest;";
//NpgsqlConnection conn = new NpgsqlConnection(connString)

NpgsqlConnection con = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["PostGreconString"].ConnectionString);
con.Open();
string query = "INSERT INTO userinfo (first_name, last_name, email) VALUES (@val1,@val2,@val3)";
NpgsqlCommand cmd = new NpgsqlCommand(query, con);
cmd.Parameters.AddWithValue("@val1", first_name.Text);
cmd.Parameters.AddWithValue("@val2", last_name.Text);
cmd.Parameters.AddWithValue("@val3", email.Text);
cmd.ExecuteNonQuery();
con.Close();
lblMsg.Text = "Data Inserted successfully.";
lblMsg.ForeColor = System.Drawing.Color.Red;
}


}

Note: Flow the Process shown in video.

?Subscribe and like for more videos:
https://www.youtube.com/@chiragstutorial
?Don't forget to, ?Follow, ?Like, ?Share & ?Comment

Tutorial Link:
https://www.chirags.in/tutorials/asp_dot_net_c_sharp_programming

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_____________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#aspdotnet
#aspdotnettutorial
#chirags
#chiragsdatabasetutorial
#chiragsdbatutorial
#chiragspostgresqldbtutorial