DataGridTextBoxColumn

[harini]

hi,

i am trying to make some columns of my datagrid editable by making them become textboxes once clicked on any cell in the column. i m trying to use DataGridTextBoxColumn... i m trying to code it in c# in VS.NET....but i have no idea how to go abt it...can anyone pls provide me the code snippet for this if u hv....plsss helllppppp!!!! thanks

[radcaesar]

Public Class DataGridCurrencyColumn

Inherits System.Windows.Forms.DataGridTextBoxColumn

Dim TB As System.Windows.forms.TextBox

Public Sub New()

MyBase.New()

TB = Me.TextBox

TB.CausesValidation = True

AddHandler TB.KeyPress, AddressOf CurrencyKeyPress

AddHandler TB.Validating, AddressOf CurrencyValidating

End Sub


Protected Sub CurrencyValidating(ByVal Sender As Object, ByVal e As System.ComponentModel.CancelEventArgs)

Dim Val As Decimal

Try

Val = Decimal.Parse(TB.Text)

Catch ex As Exception

Val = 0

End Try

TB.Text = Microsoft.VisualBasic.Format(Val, "0.00")

End Sub

Protected Sub CurrencyKeyPress(ByVal Sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs)

Dim keyascii As Integer

keyascii = Asc(e.KeyChar)

Select Case keyascii

Case 45, 46, 48 To 57, 8, 13 'numbers, decimal, backspace, return, minus

Case Else

keyascii = 0

End Select

If keyascii = 0 Then

e.Handled = True

Else

e.Handled = False

End If

End Sub


End Class

[MCPD]

i make this code

this view your table in a data grid

u can change any cell u want

but u must to click at the button to save the changes

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        SqlConnection con = null;
        SqlDataAdapter da = null;
        DataSet ds = null;
        SqlCommandBuilder cb = null;
        private void Form1_Load(object sender, EventArgs e)
        {
            con = new SqlConnection("Data Source=.;Initial Catalog=CDDB;Integrated Security=True");
            da = new SqlDataAdapter("select * from CDS",con);
            cb = new SqlCommandBuilder(da);
            ds = new DataSet();
            da.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            da.Update(ds);
        }
    }

[harini]

hi,

thanks all for ur valuable replies!

@radcaesar- i m trying to code it in c# in visual studio.net....i want the code snippet in c#....pls do provide me the c# code if u hv....tnx a lot!

@mcpd- hey tnx for the code...but the prob here is i wrote a similar code like u hv given...in this case what it does is, it transports the table into the grid box and ALL the cells of ALL columns are editable...but i dont want that...i want only some columns of my table to be editable...the rest of the columns i shud NOT be able to edit...and the cells of the columns that i want to edit must be displayed in text boxes so that i can edit those values...pls try to give me the code snippet for this functionality...

pls help!

[harini]

@mcpd- when i wrote the code u gave me for data update it says the name ds is not available in the class or namespace. ds is the dataset object i hv given. i hv made sure it is within the scope of the class and namespace and still the same error persists. kindly help!

[wertqt]

hi harini ,
can u share with me the source code for this function? My program requires this part as well. By the way, do u know how to to copy information from some columns in datagridview1 and show it in datagridview2?
For e.g, :
in database1, i have a field(column) called 'Date'. I want to pull this column information into database2 under a column name 'StopDate'

Sorry to trouble. Im quite new to C#.

Thanks!

[harini]

@wertqt- i m still not done with the code...still figuring out stuff! will help u out once i get something concrete...sorry abt that!

@mcpd- ur code is perfect...so how did u set the datagrid TableStyle property? from the properties box or did u hard code the datagrid tablestyles? and only if we set the styles for the datagrid and the columns will this code of urs run right?

[radcaesar]

Follow this link, Here you can get all stuffs regarding Edit and update of grid

http://www.codeproject.com/csharp/practicalguidedatagrids4.asp?df=100&forumid=33944& exp=0&select=1284249

:)

[latitude]

Maybee this helps?

private void MYGrid_EditCommand(object s, DataGridCommandEventArgs e)
{
MYGrid.EditItemIndex = e.Item.ItemIndex;
}
 

[harini]

@wertqt- sorry for the late reply but i just now wrapped up with things. for ur first ques the source code is the same as what MCPD has provided, just mk sure u make all the connections again in the update button if u havent made ur connection global.

as for ur 2nd ques of copying certain columns 4m one datagrid to another i havent tried it...ill try it n if i get the output will share it with u!

[harini]

@wertqt- and if u want to mk some columns in ur datagrid editable and not some other, then go and change the TableStyle property in the property window for ur datagrid...in that set ur table style and also ur columns styles accordingly...if u want to mk a column uneditable then set the read only property of that column as true and vice versa! hope this helps!

[wertqt]

hi harini,

i wrote the code as below to save the changes made to the datagridview textboxes but nothing happen. What i had written into these cells are not saved to the database. Can u detect any errors in it?

C# code :

private void button1_Click(object sender, EventArgs e)
        {
 
            string strSerialNumber = textBox1.Text;
            string strSQL2 = "SELECT * FROM Module_Repair_Info WHERE SerialNo = '" + strSerialNumber + "'";
            string Provider2 = "Provider=Microsoft.Jet.oledb.4.0;Data Source=C:\\Documents and Settings\\Evelyn.Chin\\Desktop\\Repair_database\\Hart\\Temperature_Repair_Database.MDB";
            OleDbConnection myConn2 = new OleDbConnection(Provider2);
            OleDbCommand myCmd2 = new OleDbCommand(strSQL2, myConn2);
            OleDbDataAdapter da2 = new OleDbDataAdapter(strSQL2, myConn2); 
            OleDbCommandBuilder cb = new OleDbCommandBuilder(da2);
            DataSet ds2 = new DataSet();
            da2.Fill(ds2, "Module_Repair_Info");
            BindingSource BS2 = new BindingSource();
            BS2.DataSource = ds2;
            BS2.DataMember = "Module_Repair_Info";
            dataGridView2.DataSource = BS2;
 
            da2.Update(ds2, "Module_Repair_Info");
            ds2.AcceptChanges();
 
 
 
        }

Thanks a million!

[harini]

well i cant say what error ur code has...looks fine! but i can tell u two things that is in ur code which i didnt use in my code...u can mk those changes n try if it works...

1.) i didnt use a BindingSource in my code.
2.) i didnt use an AcceptChange() also...

the foll is the code snippet i iused and it works fine for me

DataSet ds = new DataSet(); .............1
DataTable da = new DataTable();.........2
dadapter.Fill(ds, "table_name");...........3
da = (DataTable)datagrid.DataSource;..4
dadapter.Update(da);..........................5

i used a DataTable because i was getting a "cast not valid" exception when i used a dataset in line 4....line 5 is the only line to update changes back to the dataset and also the database...

hope it helps!

[wertqt]

hi,
I tried ur cpde but it gave me this error : "Unable to cast object of type 'System.Windows.Forms.BindingSource' to type 'System.Data.DataTable'."

my new code looks like this :

string strSerialNumber = textBox1.Text;
            string strSQL2 = "SELECT * FROM Module_Repair_Info WHERE SerialNo = '" + strSerialNumber + "'";
            string Provider2 = "Provider=Microsoft.Jet.oledb.4.0;Data Source=C:\\Documents and Settings\\Evelyn.Chin\\Desktop\\Repair_database\\Hart\\Temperature_Repair_Database.MDB";
            OleDbConnection myConn2 = new OleDbConnection(Provider2);
            OleDbCommand myCmd2 = new OleDbCommand(strSQL2, myConn2);
            OleDbDataAdapter da2 = new OleDbDataAdapter(strSQL2, myConn2); 
            OleDbCommandBuilder cb = new OleDbCommandBuilder(da2);
 
            DataSet ds3 = new DataSet(); 
            DataTable dt = new DataTable();
            da2.Fill(ds3, "Module_Repair_Info");
            dt = (DataTable)dataGridView2.DataSource;
            da2.Update(dt);

Thanks =P

[harini]

this code works fine for me...donno y its throwing errors for u...

DataSet ds = new DataSet(); .............1
DataTable da = new DataTable();.........2
dadapter.Fill(ds, "table_name");...........3
da = (DataTable)datagrid.DataSource;..4
dadapter.Update(da);..........................5

ok then try like this...comment out the 2nd line ...i.e dont use a DataTable...and change the 4th line to either

1.) ds = (DataSet)datagrid.DataSource; or
2.) datagrid.DataSource = ds;

hope this works!

[wertqt]

ok i will try it and keep u updated thanks =D