Im doing one application that is Attendance Entry form. even if i dont enter the records and fire a select query it is not even reacting to it.. Mr.rahim i want to apply query on datagrid view acc to user need.. hello sir, i want to now when we give command as sql Data Adapter. ” and for id i got value as e.current Row Index, so its updating only 1 row .. Hi Rahim, I am getting “Dynamic SQL generation is not supported under multiple Base Tables”, the reason of the error is I am Joining multiple tables to get the data in the Data grid. Add(cls Col1); pls send me the code for adding col into database. HI sir, i’m filtering the data’s from the sql table and dislplaying in datagridview , now i want to save the filtered content displayed in the datagridveiw in another new sql table. pl send the code to [email protected] sir, i want to insert grid view data to another delete from current table in Sql Database.is my code…its always insert row no to table not the column value..please help me..current table is jobmain i want to job main row data to delete from jobmain. I wnt to display Admision no with checked box’s and checked means Present,unchecked means to do These values are will be directly insert aswell as update . for eg: user enter name in textbox and corresponding to dis textbox value related rows are selected and data is fetch in grid view.. Update(data Table); this will require update command text .. Now how should i write the insert command to insert into one table from the Data grid values. can we add a column in sqlserver database at run time using datagridview.
Now when you close the add form call that function. I want to know how to insert/update/delete in a Multiple tables in a single datagridview. thanks thendral HI Rahim, My Name is Raman ,as per the above comments , I understand you are very good at I am new to win app, but good SQL server, Can you tell me , I Can Solve the below querdy.
In case you are adding row by row, then clear the rows of datagridview first in the function How we can access the entry’s in another system using LAN while running software in both systems. i want to add, delete, update in my C# forms through DLL… I have 5 tables and one datagridview , which display the information from 5 different tables, now user is allowed add/update/delete opration in the grid with new information.
Tbl_report1 columns: Invoiceno,particulars,quantity,perprice,amount,invoicedate,ondate,invoiceid,orderno Tbl_report2 columns: Compname,compaddress,invoiceno(primarykey),orderno,ondate,invoicedate,amountstatus,netamount,netvat,tamount Tbl_customer columns: Custid,custname,custaddress,custcity,custstate,custstdcode,custphoneno,custmobileno in my form I am having these fields like I mentioned above two issue is if I select the compname it should display the remaining loading only companynames I wrote the code is below.
private void loadcompanies() But it shows the that I wrote the code in selectedindexchangedevent.
how can i set , update or insert or delete operation on one “SAVE” button.
Hi Rahim, First of all thanks for such a code,because i researched the entire google but found no single code for this ins,upd & del. cause i am only am be to retrieve the data to the datagridview for delete, i want to delete in the datagridview, meaning each row got it own delete button please provide me with the code….. which is: ” Dynamic SQL generation for the Update Command is not supported against a Select Command that does not return any key column information. So, if i click the button then it will show the result in Data Grid, against the customer_ID which will be given in the textbox. namespace Database private void button3_Click(object sender, Event Args e) private void Form6_Load(object sender, Event Args e) private void data Grid View1_Cell Content Click(object sender, Data Grid View Cell Event Args e) private void button1_Click(object sender, Event Args e) private void button4_Click(object sender, Event Args e) public void clear() } } Thanq so much for ur reply ..,, Here throws another exception if i use Ur code given .., Dynamic SQL Generation for the update command is not supported against a select command that doesn’t return any key column information ..,, Bhaia, I have done Insert, Update, Delete in data Grid View in the same way as urs. Update for the entire row is happening ..,, But for a single column it throws an exception ..,, Can U sort out this problem .. Update(datatable) Actually am using Oracle for the same thing i wrote like follwoing Oledb Data Adapter. hih saw your post, it really great, but if i have web service, how am i going to call the web service web method to the datagridview and do the update, insert and delete??? but in button click event for update, its showing an error. Thanks bhaia, I have created one column ‘cust_ID’ primary key in DB. But i tried to use a textbox in the form where i will give a customer_ID and also a button. :-) Hello Rahim .., I’m new to windows application n my coding here is C# ..,, I want to perform Edit , Delete n Update in data Grid View n data should b saved in DB ,, Used Ur code bt the update so far don in GRIDVIEW only and its nt saved in DB .., It is very easy to perform Update Delete in WEB Application ..,, Bt here it is hectic ..,, Want to complete the task ..,, Help m out of it ..,, Hoping for a reply soon !! Here is the following code that i did n nt effective !! App Settings[“connection String”]; underlined “Configuration Manager” this word please tell me its solution? i used your code in my application for insert,delete and update from datagridview to sql but it giving an error “The name ‘Configuration Manager’ does not exist in the current context” so please give a solution hello…. TX :) When i click on Add\update button, a dialog box showing syntax error INSERT INTO and when i click on Delete button it also shows a dialog “Dynamic SQL generation for the Delete Command is not supported against a Select Command that does not return any key column information” why it is happening like please give me reply…. please i need code of update and delete from gridview but as u given above code that is not understanding to me.. but how to restore mdf and ldf files in sql server HI rahim i am having doubt regarding sqldata Adapter. i used your whole code….still i found run time error on updating and deleting…….. Hi Anshu, before using above code make ensure that 1) one primary must be exist in ur data base. Method below it’s update all records, maybe slow down the system? Sql Client; namespace Windows Forms Application2 hey…..i want to ask that for the value “11.40” i have used decimal(18,2) but whenever i try to update the data at that time it’s give me the error like conversion faild when converting the nvarchar value “11.40” to data type int. Now if person donate some amount monthly and if he paid amount then i want to remove his notification and also the notification should get display in next month. I have created one page in in which i have taken 1 grid view which shows notification about person who will donate amount on particular day/date. Reading this post reminds me of my previous room mate! I just want to add new row, but do not update the old records. I have created one page in in which i have taken 1 grid view which shows notification about person who will donate amount on particular day/date. Configuration; Sql Connection con = new Sql Connection(Configuration Manager. To String()); protected void Page_Load(object sender, Event Args e) Hello Please help me.