hi, i had a gridview to insert records into database i created detailsview here i had to update textbox when DropDownList's selected item is changed.i,e if i click an item in dropdownlist that item has to be displayed in textbox of detailsview waiting for ur replies

hai, my req is i need to add items from database into dropdownlist my code follows this way: form id="form1" runat="server">

.

hai, my req is i need to add items from database into dropdownlist my code follows this way: form id="form1" runat="server">

.

i need to write trigger for this

i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible i need to insert new row into another database this to be done in sql express can anybody give solution for this padma padma

i am having one database and the data will be comming through a device and i need to copy the newly generated row to another database how is it possible i need to insert new row into another database this to be done in sql express can anybody give solution for this padma padma

in sql express How we know that user has inserted new row or update old row, is there any keyword to find out. regards padma

in sql express How we know that user has inserted new row or update old row, is there any keyword to find out. padma

thank you

hi i havae to insert data from one record to another for that i created a trigger CREATE TRIGGER trigInsertion on master AFTER insert as INSERT into child SELECT Convert(varchar(50),master_date,105) FROM inserted in this i need to convert varchar to datetime and insert these values into child table but it is not working padma

thanks for reply but in my master table i had 10 coloums and in that i need to check three coloums so how can i do it padma padma

Hi can anybody give solution for my req i had a mastertable and i need to copy generated recordsd to my child table my code follows in this way: CREATE TRIGGER trigInsertion on GlobalScan AFTER insert as INSERT into GlobalScanNew SELECT * FROM inserted end but here in my mastertable coloums data type is different from child table now i need to convert this and place it in my new table plz can anybody give solution for this Regards padma padma

hi till now i wrote CREATE TRIGGER trginsert AFTER INSERT ON table1 FOR EACH ROW INSERT INTO table2(unit,id) values('888','999'); i will get data through a device whenever a record is inserted into the master table the same record has to be added into another table this is my req hope i was clear padma

Hi, can anyboby tell how to write triggers as my req is if a row is inserted in table1 the same row has to be inserted on table2.. regards padma padma

thanks for ur reply but what i mean is if a row is inserted in table1 after insert the same row has to be Inserted in table2. can u give solution for this Regards padma padma

hi i had to create Rowlevel triggers and my req is-- if a new row is added in table1 then the same current row has to be updated in my table2.please can anybody help me padma

hi i had got crystal report i want to add frameset to this can anybody guide me in this Regards padma padma

hi i had date in he form of ddmmyy and it is dispalyed as 141107 but i want it to be in the form of 14-11-07 Regards padma padma

now it is not getting that problem this is not generating any error or report

yes it is throwing exzeption as invalid virtual path and sometimes it is not generating any error but report is not displayes