Search results for query: *

hi all, i had a request about creating a grid type report which will show the result of several calculation of my db fields in .NET section and a good suggestion was to use sql for this. So sql will make all calculations and i ll show the results in a grid. The problem is i dont have much...

hi all i have such scenerio: i have my data in db and i will be creating a report. the first column of the report will keep the number of some item, second column will be the number of another item etc. so there is no tabular data, i have several calculations and the tricky part is i have to...

Hi all, I have a case where i have to show some data along with some custom columns derived from other data. Here is an example: in my database i have 5 columns but i dont want to show them the way they are. I want to show 5 of them and use the rest 2 to create 2 custom columns. the output...

hi, i have html formatted text coming from my database and i want to show it as formatted in a textbox. assigning it to a label works fine but getting the db content in a textbox gets the html text, not the formatted text. Ex: <b> test </b> shows as it is and i want to show a bold "test" in...

Hi all, i have a bunch of checkboxes (not checkbox list for some reason) and i collect all their data under a field. So if user selects cbA and cbC; A,C is sent to database. Now i want to load my form so user can make some changes. Everthing works fine but i m doomed with the checkboxes. Here...

Hi, i will be doing an update then an insert so i want to use the transaction to make sure if one fails the other wont do what its supposed to do. But there is a little problem, in my insert function i call the update function first. How can i run the same transaction while calling a function...

hi all, i have a table that keeps some table names. Depending on the given ID i go to this table get the table name and want to run a select statement over this table. Here is what i did so far(this is running in a stored procedure): ....... DECLARE @TABLENAME VARCHAR(50) set @TABLENAME =...

Hi all, is the below scenerio possible? user submits the form that will insert in db but before the data is written in db i want to make a check. The check function will run and find out if the form data exist in db or not. If it exists a confirmation box will appear and ask user "similar data...

Hi all, i am trying to create a database user who has access to a database but not full access. I want him to be able to write (create new tables, stored procedures, views etc) but i want to restrict his rights over some tables. If i have 10 tables i want him to access 6 of them and not be able...