Hai

I am new to dotnetnuke and Sql

I tried to insert "UserID" value in to the field of a table. But i am getting error message. The sql statment is as follows.

INSERT INTO [ttttt]
([EDIT:ColumnName:1]) VALUES ([UserID])

I need sugeestions to save the UserID in the table.

thanks

shashi

Thanks for the reply

SqlGridSelectedView is free tool provided by the developer for dotnetnuke community.

It is really wonderfull Module. I am thnkfull to the devolper for devolping such a nice module and giving it to dotnetnuke community.

I was trying to insert [DNN;UserID] value in the table.

As per the help file, the UserID value was replaced for the value of [DNN;UserID].

I would like to know

1) How the DNN values like DNN:UserID, DNN;PortalNo etc is used while inserting in to table.

a few t-sql syntax example will help me.

2) Is there any module for creating table,inserting data into table and updating data in to the table.

As I understand , Userdefined table will not create new table. I feel it is difficult to manipulate data using sql in the context of

UserdefinedTable.

UserDefinedTable is not created to maintain default SQL tables, as it uses its own serialized data structures - our "trick" to store multiple different custom table structures inside 3 common physical tables.

AFAIK there are a number of different solutions around to display SQL data (e.g. core module Reports), a smaller number of modules, that are also able to edit data (e.g. free Advanced DataGrid) and for sure not many modules, that are able to create/alter tables (to be honest, a have not checked out the example stated before).