Problem in inserting from datagrid

[Krishna]

Hi, I have developed a for dataentry by using datagird in C# windows
application, I am using combocolumns, textbox columns for the same,
two readonly textboxcolumns for those readonly columns i will assign
the default value through nulltextpropert y. I am getting all these fine
it is inserting,updat ing without any problem.

But while inserting new rows it is not inserting values related to that
readonly textboxes, can some one help me regarding this, i have struck
in this....
Regards
Ramakrishna

[Loki117]

Whats probably happening is you haven't setup the parameter values in
your sql commands to point to those columns on the grid or that you
haven't set the "value" property you have simply set the text property.
Your SQL command parameters should have a Source column property
makesure that has been set.

[Krishna]

Hi, Thanks for the replay.

I specified sourse column and value for the same column, I am using the
following code, please go through the code.

_DataAdapterTit les.InsertComma nd = _Conn.CreateCom mand();
_DataAdapterTit les.InsertComma nd.CommandText =
"INSERT INTO transactions
(trans_id,ac_co de,trans_type,p ayment_type,tra ns_description, dbamount,cramou nt,uid,trans_da te)
" +
"VALUES(@i1 , @i2, @i3, @i4, @i5, @i6, @i7,@i8,@i9)";

// Add the parameters for INSERT
SqlParameter i1 = new
SqlParameter("@ i1",SqlDbType.C har,21,"trans_i d");
i1.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i1);

SqlParameter i2 = new
SqlParameter("@ i2",SqlDbType.C har,5,"ac_code" );
i2.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i2);

SqlParameter i3 = new
SqlParameter("@ i3",SqlDbType.C har,4,"trans_ty pe");
i3.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i3);

SqlParameter i4 = new
SqlParameter("@ i4",SqlDbType.C har,4,"payment_ type");
i4.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i4);

SqlParameter i5 = new
SqlParameter("@ i5",SqlDbType.C har,200,"trans_ description");
i5.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i5);

SqlParameter i6 = new
SqlParameter("@ i6",SqlDbType.D ecimal,0,"dbamo unt");
i6.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i6);

SqlParameter i7 = new
SqlParameter("@ i7",SqlDbType.D ecimal,0,"cramo unt");
i7.SourceVersio n = DataRowVersion. Current;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i7);

SqlParameter i8 = new SqlParameter("@ i8",SqlDbType.C har,10,"uid");
i8.SourceVersio n = DataRowVersion. Current;
i8.Value=clsGen eral.uid;
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i8);

SqlParameter i9 = new
SqlParameter("@ i9",SqlDbType.D ateTime,8,"tran s_date");
i9.SourceVersio n = DataRowVersion. Current ;
i9.Value=DateTi me.Now.ToString ("MM/dd/yyyy");
_DataAdapterTit les.InsertComma nd.Parameters.A dd(i9);