Comments by card_maruis

card_maruis 21-Feb-23 5:24am View

last night I found the problem to transfer the data to the datagridview, I used copy/paste with the following code

https://www.codeproject.com/Tips/208281/Copy-Paste-in-Datagridview-Control and I think it does not validate the cells, i insert in my code var result = sqlCmd.ExecuteNonQuery(); and every time I try to deleted multiple data only for the last one i get value 1 for the rest i get value 0. If i paste 1 by 1 is ok. I need to find a better solution for inserting data in datagridview pls help me if you have any suggestion

card_maruis 20-Feb-23 17:12pm View

i have a database table named Articol in this table i have 100 records like "Serial | Lot | Date"
and i need to delete records from table where "Serial" is like the first Column of a datagridwiew
every time i try to delete 3 or more records is deleting only the last Serial in datagridview

card_maruis 20-Feb-23 16:47pm View

I try .Trim(' ') same result only the last row was deleted

card_maruis 20-Feb-23 16:41pm View

Serial is nvarchar(MAX) and i fill the column from datagridviw with copy past from table to be the exact data

card_maruis 20-Feb-23 16:39pm View

MSSQL, i try to delete from textbox and 1 by 1 is ok when i try from datagridview is deleting only the last row

card_maruis 20-Feb-23 16:26pm View

I added FROM and had the same result, only the last line was deleted

card_maruis 23-Aug-21 9:26am View

Pls can i have an example

card_maruis 23-Aug-21 8:33am View

Deleted

in database i have
[id] [int] IDENTITY(1,1) NOT NULL,
[nr] [nvarchar](200) NOT NULL,
[serie] [nvarchar](200) NOT NULL,
[cui] [nvarchar](200) NULL,
[client] [nvarchar](200) NULL,
[sim] [nvarchar](200) NULL,
[data_inst] [date] NULL,
[activare] [nvarchar](200) NULL,
[data_exp] [date] NULL,
[telefon] [nvarchar](200) NULL,
[nr_activat] [nvarchar](200) NULL,
[nr_zile] [nvarchar](200) NULL,
[ob] [nvarchar](200) NULL,
[tip_client] [nvarchar](200) NULL,
[email] [nvarchar](200) NULL,
[datacurenta1] [date] NULL,
[semnatura] [nvarchar](200) NULL,

Comments by card_maruis (Top 8 by date)