Sunday, June 1, 2025
Friday, May 30, 2025
A network-related or instance-specific error occurred while establishing a connection to SQL Server. Error
>First open services.msc from wondow + r (Window Services)
> Then right click on sql server (SQL express)
>go to Properties.
Then go to Log On tab and select Local System account.
Click on Ok button and start the service.
Thursday, May 29, 2025
Sunday, May 25, 2025
How to call two insert queries on one button in click in asp.net C#
protected void Unnamed_Click(object sender, EventArgs e)
{
//TextBox t = DetailsView1.FindControl("TextBox1") as TextBox;
string conStr = ConfigurationManager.ConnectionStrings["testdbConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(conStr))
{
if (ddlSelect.SelectedValue == "1")
{
abc(txt1.Text, con);
}
if (ddlSelect.SelectedValue == "2")
{
abc(txt1.Text, con);
abc(TextBox2.Text, con);
}
}
}
void abc(string value, SqlConnection con)
{
SqlCommand cmd = new SqlCommand();
cmd = new SqlCommand("INSERT INTO BookMaster(BookName) VALUES (@BookName)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@BookName", value);
con.Open();
cmd.ExecuteReader();
con.Close();
}
Friday, May 23, 2025
Visual studio is not running - Giving error Windows cannot access the specified device, path, or file" error when you try to install, update or start a program or file
> Give full control access to the visual studio file devenv.exe
Also in shortcut you can check Run as administrator option.
https://www.getfishtank.com/insights/automatically-run-visual-studio-as-administrator