Visual Basic

5-Jul-07 8:23

Hey all:

Can anybody give me ideas how can I lock the particular cell of the datagrids. I used Readonly properties of Datagrids, that makes whole datagrids uneditable.

I want only some particular cells of grids to be uneditable.

Thanks many for your advance help.

-- modified at 11:51 Friday 6th July, 2007

aphei5-Jul-07 17:07

aphei

5-Jul-07 17:07

you can try this code

first you must set your grid readonly property to false

Dim intI, intJ As Integer
With grid
For intI = 0 To .Rows.Count - 1
.Rows(intI).ReadOnly = True
if intI = x then
.Rows(intI).ReadOnly = False
For intJ = 0 To .Columns.Count - 1
if intJ = y then
.Columns(intJ).ReadOnly = False
end if
Next
End If
Next
End With

hope this can help to solve your problem

hsprasain6-Jul-07 5:45

6-Jul-07 5:45

Hey:

I'm using VB.NET 2003. I didn't find Datagrid1.Rows.count and Datgrids1.Columns.Readonly and ... features.

Can you help me how can add those features to grids to run your code?

Thanks for your help in advance.

Johan Hakkesteegt5-Jul-07 22:02

5-Jul-07 22:02

Assuming that your datagrid is bound to a dataset, you can simply use the readonly property of the dataset's columns instead of that of the entire datagrid:

<br />
MyDataSet.Tables("MyTableName").Columns("MyColumnName").ReadOnly = False 'or True<br />
MyDataGrid.DataSource = MyDataSet<br />
MyDataGrid.DataMember = "MyTableName"<br />

Good luck,

Johan

My advice is free, and you may get what you paid for.

hsprasain6-Jul-07 5:51

6-Jul-07 5:51

Hey thanks a lot!

I also thought in similar way that you thought. I still got some weird problems. I'm not allow to make the whole column unediatable. I can make only some of the cells of the column.

I'd appreciate if you could give me an idea how I can make a praticular cell unediatable rather than by whole coulumn. I'm sorry for my unclear questions

last time.

Thanks many for your help in advance

Johan Hakkesteegt8-Jul-07 19:56

8-Jul-07 19:56

As far as I know, I am afraid you will have to make a choice; by the same principle you can determine the row index and make the row read only. So either make the entire row, or else the entire column read only (or the other way around). I have never tried myself, but perhaps you could investigate the possibility to determine the selected cell and try to make only that cell read only.

Another thing you could try is to make all rows read only, then when a user selects a row, make only that row editable, and during the same event make all columns except the selected cell's column read only again. I have no idea though whether this would actually work...

Good luck with it,

Johan

My advice is free, and you may get what you paid for.

hsprasain9-Jul-07 18:07

9-Jul-07 18:07

Hey Johan:

Thanks a lot for good advice. Unfortunately, I was unable make a particular row uneditable. Below is my code.

Public Function CreateData(ByVal row As Integer, ByVal col As Integer)<br />
        <br />
<br />
        dt = New DataTable("sublayers")<br />
       <br />
        Dim i, j, k As Integer<br />
        ' col is used for determing column headers.<br />
<br />
        dt.Columns.Add(New DataColumn("Sublayer No", GetType(String)))<br />
        dt.Columns.Add(New DataColumn("Material Set No", GetType(String)))<br />
        dt.Columns.Add(New DataColumn("Thickness (m)", GetType(String)))<br />
<br />
        <br />
        dt.Columns(2).ReadOnly = True<br />
<br />
        <br />
<br />
        For i = 1 To row<br />
<br />
            dr = dt.NewRow()<br />
<br />
            For j = 0 To col - 1<br />
<br />
                <br />
                    dr(j) = " "<br />
                <br />
<br />
            Next<br />
            dt.Rows.Add(dr)<br />
        Next i<br />
<br />
        'creating a datase<br />
        Dim ds As New DataSet<br />
        ds = New DataSet<br />
<br />
<br />
<br />
        ds.Tables.Add(dt)<br />
       <br />
        'adding the table to dataset <br />
        DataGrid1.SetDataBinding(ds, "sublayers")

I'm using this function to dynamically create datagrids. I neber got options to make rows uneditable. Can you advise how shall do this.

Thanks a lot for your help.

Johan Hakkesteegt10-Jul-07 0:12

10-Jul-07 0:12

Hi,

My apologies, I misinformed you. I just mistakenly assumed there would be, but you are right, there isn't any direct option to make a row readonly.

The next option that comes to mind (and I don't see any alternatives), if you really need to lock only certain cells, is to set the readonly property of the datagrid to true, and bind the data from the selected datarow to regular textboxes or some other input system. This will allow you to control the input more easily, and to simply enable or disable a textbox when certain criteria are met.

Hope it helps,

Johan

My advice is free, and you may get what you paid for.

hsprasain10-Jul-07 5:29

10-Jul-07 5:29

Hey:

Thanks a lot: I appreciate your time and help. I think I should think of making custom Datagrid control to add readonly features for each cell. Do you have any ideas how shall I do that?

Johan Hakkesteegt10-Jul-07 20:25

10-Jul-07 20:25

I am sorry, I have no experience whatsoever in custom control making... Frown | :(

However there are plenty of people who have made custom datagrids, and I am sure Google could help you out with this subject. I seem to remember even seeing a few articles right here on the Code Project website with examples, etc.

Good luck,

Johan

My advice is free, and you may get what you paid for.

hsprasain12-Jul-07 17:54

View and Review my looping code

12-Jul-07 17:54

Hey friend>

Thanks, I appreciate your time and efforts. Thank your vey much for your suggestions.

steve_rm5-Jul-07 7:27

steve_rm

5-Jul-07 7:27

Hello,

[VS 2005]

I have developed some code that uses a nested for loop. This code works the way it is supposed to. However, for maintaining this code I think i have not developed it in a efficient manor.

The way that the code works is that I have a database table and I am looping through the records finding the matching incidentID that have been delivered, so an e-mail can be sent.

As I am new to programming I am looking for a better way to do the same job.
I am sure there is a better technique for doing this, using some advance features of visual studio.

I am not looking for anyone to write me any code, just to review and give me an idea of another better technique.

Private Sub IncidentPartsArrivedEmail()<br />
        Dim incidentID As Integer = 0<br />
        Dim parts As List(Of String)<br />
        Dim sentIncident As New List(Of Integer)<br />
        Dim sendEmail As Boolean = False<br />
        Dim orderID As Integer = CInt(Me.cboOrders.Text)<br />
<br />
        Try<br />
            'Loop through finding all the incidents that are ready to be sent.<br />
            For Each outerRow As dsAddComponetAndEquipment.OrderDetailsRow In Me.DsAddComponetAndEquipment.OrderDetails<br />
                'check to ensure that all the orders are for the same order.<br />
                If (orderID = outerRow.OrderID) Then<br />
                    If (outerRow.Status = "Delivered") Then<br />
                        incidentID = outerRow.IncidentID<br />
                        'Ensure that the incident is not going to be repeated again.<br />
                        If Not (sentIncident.Contains(incidentID)) Then<br />
                            parts = New List(Of String)<br />
                            'Add the incident to the array to check later that this incident has already been done.<br />
                            sentIncident.Add(incidentID)<br />
                            For Each innerRow As dsAddComponetAndEquipment.OrderDetailsRow In Me.DsAddComponetAndEquipment.OrderDetails<br />
                                'check to ensure that all the orders are for the same order<br />
                                If (orderID = innerRow.OrderID) Then<br />
                                    'Only the incidents with the same incidentID <br />
                                    If (innerRow.IncidentID = incidentID) Then<br />
                                        If (innerRow.Status = "Delivered" AndAlso innerRow.EmailStatus = "Waiting") Then<br />
                                            parts.Add(String.Format("{0} - {1}", innerRow.Manufacturer, innerRow.Model))<br />
                                            sendEmail = True 'Everything ok so send the email<br />
                                        Else<br />
                                            sendEmail = False 'Not all parts have been delivered <br />
                                            Exit For<br />
                                        End If<br />
                                    End If<br />
                                End If<br />
                            Next innerRow<br />
                            If (sendEmail) Then<br />
                                Me.SendPartsEmail(Me.EngineersEmail(incidentID), parts, Me.CurrentUsersEmail())<br />
                      Me.TA_OrderDetails_dsCodeRed1.UpdateEmailSent(incidentID, orderID)<br />
                            End If<br />
                            sendEmail = False 'Set the flag back to false again to start the new incident<br />
                        End If<br />
                    End If<br />
                End If<br />
            Next outerRow<br />
        Catch ex As Exception<br />
            MsgBox(ex.Message)<br />
        End Try<br />
    End Sub

Re: View and Review my looping code

Christian Graus5-Jul-07 7:33

Christian Graus

5-Jul-07 7:33

Looks to me like you're iterating through a data set when you could write a stored proc or SQL that does those comparisons in the data layer.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: View and Review my looping code

kubben5-Jul-07 7:33

kubben

5-Jul-07 7:33

Try using a DataView with RowFilter.

So something like
dim dv as DataView = Me.DsAddComponetAndEquipment.OrderDetails.DefaultView

dv.RowFilter = "columnname = 'somedata'"

Once you have set the rowFilter you will only see the datarowview that match that filter. You would need to set the rowfilter back to "" to get all rows again.

Hope that helps.
Ben

Visual Basic to Access

Ronak0855-Jul-07 6:49

Ronak085

5-Jul-07 6:49

I am using Visual Basic to make a website and I want a user to be able to enter things in a Textbox and have that information put into access. I am using a Inset statement but it does not work. I am useing:
INSERT INTO Results
(Application_contact)
VALUES (AC.[text])

And it does not work does anyone have any ideas how i can have the textbox information put into a access?? PLEASE HELP!!

Christian Graus5-Jul-07 7:19

Christian Graus

5-Jul-07 7:19

Ronak085 wrote:
INSERT INTO Results
(Application_contact)
VALUES (AC.[text])

What is AC, and how are you using this code, in Access ? What does 'does not work' mean ? Does it compile ? What does it do ?

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Ronak0856-Jul-07 1:21

Ronak085

6-Jul-07 1:21

AC.text is a textbox that a user can input information and I would like that information to be put into a access database.

jonathan155-Jul-07 7:52

jonathan15

5-Jul-07 7:52

Am i correct in thinking Application_contact is a field name and AC.[text] is the text within a textbox named AC?

If i am correct then the SQL code is wrong. This part

Ronak085 wrote:
VALUES (AC.[text])

will do nothing. For example if you wanted to insert the text 'AC.[text]' then the code would need to look like:

VALUES ('AC.[text]') (note a string literal must be enclosed '')

if AC.[text] is a variable (which i think it is) it needs to be:

VALUES ( '" & AC.[text] & "')

string variables must be enclosed '" & & "'
Numerics are " & & "
and with Access dates are #" & & "#

#EDIT#
And before anyone else nags me about it.
I know parameterized queries are better.
Jon

Ronak0856-Jul-07 1:33

Ronak085

6-Jul-07 1:33

Since AC is the text box name and i want to convert what the user inputs into the text box to be brought to the access database. None of the follow work for me.