Solved

VB.Net DataGrid - Row Add coding questions

Posted on 2007-03-29
1
346 Views
Last Modified: 2010-04-23
Hello,
 
I'm looking for a way to smarten up my DataGrid in VB.Net 2005.
 
On the initial load of data into my DataGrid, I set columns 0 and 1 to ReadOnly, but for a RowEnter event I plan to change the ReadOnlly of Column(0) to False and then back to True again on RowLeaving Event.

This DataGrid has a DataSource of a DataTable in VB.  

What I'd like to do is default zero's in all DataGrid columns from index 2-14 so they don't leave these as null values in a DataTable\Column that does not allow null.

Can I set DataGrid cells to a value or do I need to create this row in my DataTable source and then refresh my DataGrid?

Thanks!
JMO9966
0
Comment
Question by:JMO9966
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 34

Accepted Solution

by:
Sancler earned 250 total points
ID: 18817854
You can set this in your datatable.  Try this

        For i As Integer = 2 To 14
            <myDataTable>.Columns(i).DefaultValue = 0
        Next

Then, when a user goes into edit the new row in the datagrid, all the columns from 2 to 14 will have 0s in them.

Roger
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question