TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
dilip rayar
NA
1
1.4k
Display Sql data in Wpf gridview
May 5 2013 6:11 AM
Hello,
I'm new to WPF and trying some hands on with wpf.
I'm trying to publish all my table data on the wpf datagrid on form load.
Here is what I had learnt from internet and tried to implement.
I had written my connection string in App.config file.
<connectionStrings>
<add connectionString="Data source = Dilip; user id = (local); Intital Catalogue =True;" name="AppCs"/>
</connectionStrings>
This is my Main window
<Grid>
<DataGrid Name="Prices"></DataGrid>
</Grid>
Under the code behind.
public MainWindow()
{
InitializeComponent();
MessageBox.Show("I came till here");
FillDataGrid();
}
private void FillDataGrid()
{
string UsingCs = ConfigurationManager.ConnectionStrings["AppCs"].ConnectionString;
SqlConnection _Conn = new SqlConnection(UsingCs);
_Conn.Open();
string qry = string.Empty;
qry = "SELECT * FROM prices";
SqlCommand cmd = new SqlCommand(qry);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable("price");
sda.Fill(dt);
Prices.ItemsSource = dt.DefaultView;
}
This is the very basic code written to disaply 4 rowed table data on grid view.
On execution the message box, is being displayed but the following error is shown.
TargetInvocationException was unhandled.
Exception was thrown by the target of an invocation.
Trubleshooting tips:
.....
InnerException: Use the "new" keyword to create an object instance.
InnerException: Check to determine if object is null before calling the method.
unfortunately, I had no idea, where to check and what to replace the null :(
I had eliminated the app.config, written directly but still I don't see the result.
Please help me to solve this.
Thanks in advance.
Dilip.
Reply
Answers (
1
)
How to get code written behind my .cs file in Windows .net.
graph creating in real time