Windoes 7 and SqlExpress 2005 Trust error

Question

I'm using Windows 7 64 bit and SQL Express 2005. I've created a database in a C# app and get the following error when attempting to access the database from the CreateUserWizard. I've got the ASPNET security set up properly as I can make changes to the database through the configuration manager. I've been all over the WEB and tried numerous solutions. None worked. Is this a W7 issue? I see where others are having the same problem, but nothing in the way of a "This will work" solution. Way too many speculations on try this or try that. Here's the error: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection. Sql exception 0x80131904.

Answer 1

Hi sarava,

 

 Try the following,

Add a list view control and text box  in your form and paste the following code

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
//Prem Anandh Natchatran
namespace ListVew
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
textBox1.Text = "0";
textBox1.Enabled = false;
listView1.View = View.Details;
listView1.GridLines = true;
listView1.FullRowSelect = true;

//Add column header
listView1.Columns.Add("ProductName", 100);
listView1.Columns.Add("Price", 70);

//Add items in the listview
string[] arr = new string[2];
ListViewItem itm;

//Add first item
arr[0] = "Tea";
arr[1] = "20";
itm = new ListViewItem(arr);
listView1.Items.Add(itm);

//Add second item
arr[0] = "Coffee";
arr[1] = "25";
itm = new ListViewItem(arr);
listView1.Items.Add(itm);
//Add Third item
arr[0] = "CoolDrinks";
arr[1] = "35";
itm = new ListViewItem(arr);
listView1.Items.Add(itm);
//Add fouth item
arr[0] = "Juice";
arr[1] = "55";
itm = new ListViewItem(arr);
listView1.Items.Add(itm);

}

private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection breakfast =
this.listView1.SelectedItems;

double price = 0.0;
foreach (ListViewItem item in breakfast)
{
price += Double.Parse(item.SubItems[1].Text);
}
price=int.Parse(textBox1.Text) + price;
// Output the price to TextBox1.
textBox1.Text = price.ToString();
}
}
}

Output form

 

  I have attached the source code also.. Keep trying all the best..

 

-------------------------------------------------------------------

If you find anything useful please accept my answer

 

 

 

 

 

 

Answer 2

Thanks for your appreciation..

 The code will work in VS2013 also

You did't triggered the event

listView1_SelectedIndexChanged(object sender, EventArgs e)

 choose the listview and double click the SelectedIndexChanged Event in property window then only the particular event will be generate.

It will work...

 

 

Answer 3

Thanks but, I am having visual studio express 2013. I am not getting the cost of the selected items in my textbox.