>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.
>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.
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();
}
> 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
>Open sql server
>Right Click on database >click on task>restore>database
>From device >select database bak file
>In option tab > Check overwrite the existing database (with replace)
or > in file tab click on reallocate all files to folder