|
VS.Net 2005
I am displaying data in a datagrid and it looks great.
I want to have 1 column be comment column, that is always editable.
I tried to use a TemplateColumn, EditItemColumn, TextBox implementation
But everything I read says I have to have an Edit Button for each row.
That will waist the time of the user to click on every column before they can enter data. Every row requires that data be entered, how do I set the entire column to be a textbox ready for editing?
Thanks, Chuck...
Chuck...
|
|
|
|
|
Are you using a DataGridView control? If so then each column has a ReadOnly property you can use.
|
|
|
|
|
Thanks for your reply, I'm actually using just the DataGrid Control.
Can you send me a sample of the difference and how to set and get the edited data back to the application, please?
Chuck..
|
|
|
|
|
Sorry my friend but I am fairly new to programming and haven't had any experience using the DataGrid control, I've only used the DataGridView control. To get data out of the DataGridView can depend on how you populate the grid, if the grid is databound then you can get the data from the data source, otherwise using something like:
dgrMyGrid.Rows(2).Cells("Comments").Value will get data from the column named 'Comments' on the 3rd row for the DataGridView control, may well be different for the DataGrid control but a little Googling will explain all!
Sorry I can't be of more help.
|
|
|
|
|
Thanks, I'll try to find out if DataGridView is part of .net 2005
Chuck
|
|
|
|
|
Yes, it is. The DataGridView control replaced the DataGrid control that was in .NET 1.0 and 1.1. It's still in the .NET Framework, just there for backwards compatibility with older code.
If there is no specific requirement to use the old DataGrid control, drop it and use the DataGridView. You're life gets much easier and there is more support out on the web for it.
|
|
|
|
|
Is DataGridView available for WebForms?
|
|
|
|
|
If you're making a WebForms app, no. The WebForm grid control is called the GridView control.
|
|
|
|
|
Thanks Dave...
I created this asp code, with ReadOnly=False on the QtyLoaded field and it still will not let me edit this field. Is there something I am missing here?
-----------------------
<asp:gridview id="GridView1" autogeneratecolumns="False" runat="server" &="">
<columns>
<asp:boundfield datafield="QtyRequired" headertext="QtyRequired" readonly="True">
<asp:boundfield datafield="QtyUsed" headertext="Qty Used" ><="" asp:boundfield="">
<asp:boundfield datafield="QtyRemaining" headertext="Qty Remaining" ><="" asp:boundfield="">
<asp:boundfield datafield="QtyLoaded" headertext="Qty Loaded" readonly="False">
<asp:boundfield datafield="PartNumberDesc" headertext="Description" ><="" asp:boundfield="">
<asp:boundfield datafield="PartNumber" headertext="Part Number"> </asp:BoundField>
-----------
Chuck
|
|
|
|
|
That confirms it. You're in the wrong forum. Ask this in the ASP.NET forum. Your question has nothing to do with VB.NET, but rather the functionality of an ASP.NET control.
|
|
|
|
|
Sorry, since I am writing the application in VB.net I thought this was the correct place.
|
|
|
|
|
I am trying to find the DataGridView control and could not find it in the .Net tools is it part of VS.Net 2005?
Chuck
|
|
|
|
|
I'm using vb6 to invoke a function in a dll with the following argurments (int argc, _TCHAR* argv[])
in vb6:
this is how i call the function in the dll..
String command = "TEST 123 456"
module(3, command)
As you can see, command is of String type.. the parameter needed is _TCHAR*
_TCHAR* is in unicode. How do I convert my String to _TCHAR*??
|
|
|
|
|
All strings in V6 are already stored Unicode encoded. They are, in the C++ world, of type BSTR.
In VB6, or any VB for that matter, you cannot pass in a point to a TCHAR array, since VB has no idea what a pointer it, nor a TCHAR. IIRC, I think you had to declare that parameter as ByRef String in your VB6 Declare statement.
|
|
|
|
|
Could you change your DLL function signature? If you can't I think it will be very difficult...
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke
[My articles]
|
|
|
|
|
Hi All,
I am new to .net
can some one help me in writing a vb script to add the values in rows in an excel sheet.
say i have 5 rows with positive values.i want the result of addition of these 5 rows in the sixth row.
Thanks in advance
|
|
|
|
|
Just to be sure here,
IN VB.Net you want to get a figure from a spreadsheet?
Or...
Are you doing this with VBA within Excel?
It is useful to know, either way the answer is fairly easy, but I would need to know which so as not to waste your time and mine. 
------------------------------------
"When Belly Full, Chin Hit Chest"
Confucius 502BC
|
|
|
|
|
i want to get a figure from a spreadsheet
|
|
|
|
|
I know, but are you using VB.Net OUTSIDE of a sheet and just want to pick up the figure, Or are you using VBA Within the Spreadsheet?
------------------------------------
"When Belly Full, Chin Hit Chest"
Confucius 502BC
|
|
|
|
|
i want to run a script outside the sheet using which the contents of the sheet get updated
|
|
|
|
|
OK, This gets data from a closed book and puts it into datagrid view
Imports System.Data<br />
Imports System.Data.OleDb<br />
Imports ADODB<br />
Imports System.IO<br />
<br />
<br />
Public Class Form1<br />
<br />
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
'I made this to collect all data from a sheet, you can modify as per need<br />
'by declaring a range like [Sheet1$A1:B20"]<br />
Dim sqlData As String = "Select Data * From [Sheet1$]"<br />
<br />
'To put data in a table with fieldnames then HDR should Yes and if not then No.<br />
Dim xlCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=c:\Source.xls;" & _<br />
"Extended Properties=""Excel 8.0;HDR=YES"""<br />
<br />
Dim conn As New OleDbConnection(xlCon)<br />
Dim da As New OleDbDataAdapter(sqlData, conn)<br />
Dim dsXLData As New DataSet<br />
<br />
da.Fill(dsXLData, "Source")<br />
Me.DataGridView1.DataSource = dsXLData.Tables("Source")<br />
<br />
dsXLData.Dispose()<br />
da.Dispose()<br />
conn.Dispose()<br />
<br />
End Sub<br />
End Class<br />
------------------------------------
"When Belly Full, Chin Hit Chest"
Confucius 502BC
|
|
|
|
|
this doesn't seem to be a .vbs syntax...
|
|
|
|
|
My Mistake, Try this...
<br />
Imports System.Data<br />
Imports System.Data.OleDb<br />
Imports System.IO<br />
<br />
Public Class Form1<br />
<br />
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
'I made this to collect all data from a sheet, you can modify as per need<br />
'by declaring a range like [Sheet1$A1:B20"]<br />
Dim sqlData As String = "SELECT * FROM [Sheet1$]"<br />
<br />
'To put data in a table with fieldnames then HDR should Yes and if not then No.<br />
Dim xlCon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _<br />
& "Data Source= PATH\SHEETNAME.XLS
" _<br />
& "Extended Properties=""Excel 8.0;HDR=NO"""<br />
<br />
Dim conn As New OleDbConnection(xlCon)<br />
Dim da As New OleDbDataAdapter(sqlData, conn)<br />
Dim dsXLData As New DataSet<br />
da.Fill(dsXLData, "Source")<br />
Me.DataGridView1.DataSource = dsXLData.Tables("Source")<br />
<br />
dsXLData.Dispose()<br />
da.Dispose()<br />
conn.Dispose()<br />
<br />
End Sub<br />
End Class<br />
------------------------------------
"When Belly Full, Chin Hit Chest"
Confucius 502BC
|
|
|
|
|
|
No Worries, you can alter the range as necessary and it reports into a datagrid view, but obviously you can report it to other things too.
Sorry about the first code, don't know what happened there. Maybe my brain was running a little slow! 
------------------------------------
"When Belly Full, Chin Hit Chest"
Confucius 502BC
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
