I have a table that it's PK Field Type is autonumber I want to enter a record between another records.so the other records after it should increase once.how can i do it with query?

Hi I have the same problem if you find the answer please tell me

Hi First sorry because my english is not very good. I am a vb.net beginner , later I work with Visual C++.May be my problem is funny or maybe the datagrid is not a standard tool to work with data(add,remove,update,...) but I really have lots of problem with it. I want to design a form that user should enter many records and at a time see the previous and next records.This Table has many fields I think it must be easier for the user to enter some of the fields in the columns of the datagrid and some of it in the form(textbox,combo,..) below the datagrid. and also some of the datagrid should be like combo box and some of it textbox and some of it Timeformat.I can connect the datagrid to the base and read the data . but I have not any control on the DataGrid,for example set a special query or change the column appearance to combo box or Mask edit or tabbed from one row of the column to the fields of the form for entering another fields of the record.how can I do these? Can I use Ado not ado.net with VB.Net dataGrid ? if I can use ado and set the columns of the datagrid to the ado recordset it's so better.if I can do it please tell me how?Thanks a lot

Hi I want to write a program that user should enter the time and they don't like to enter : : for the time.only they like to enter the nuumber of the clock not : help me how can do it?

Hi How can I use a combo box in a column of datagrid ? I mean this column should word like a combobox

Hi I have aproblem using SQL Command in VC++. example: I have an int variable and I Want to say _T("select * from table where n= ? ") what should I say infront of n . for string variable I should say say something like this '"+x+"' but for int variable I cann't do this Please help me

yes but I cann't find something that help me. try { //update the current record //CGuard obj; piAdoRecordBinding->Update(&rsRecSet); //can we add a new record? if(m_pRs->Supports(adAddNew)) { piAdoRecordBinding->AddNew(&rsRecSet); } is it correct

yes I want to know how can I use this method in a dialog base application . please give me an example

I want to add new records with my program to my database but I don't know how to do this . please help me.