Comments by Member 10558090 (Top 13 by date)

DELETE statement require a condition.

For example: DELETE FROM [yourTableName] WHERE youcolumn = youvalue.

If you want to delete all data into your table, without remove columns, you can use TRUNCATE statement.

I think that you query works, because when I run it on my SQL Management Studio says: "(806 row(s) affected)".

But, if I do:

SELECT * FROM Table1

The column t1.Availability and t1.Price have data "NULL"

Why ?

Edit:

Now, using your query I had this error:
Msg 8114, Level 16, State 5, Line 1

Is a problem to convert data. Because in the first table Price and Availability are VARCHAR and in the second table are DECIMAL(18,4) and INT

Thank you for your answer. Using your code, output isn't correct.

For example, my first data for campi[14] is 0000000000000004.97.

If i using your code the variable "d" become 497.0 and "s" 497.

My output must to is 4.97.

And, if some price start with 0 like this 000000000000000.97 , I want to became 0.97

Ok, I solved all my problems.
Thank you.

Yes, but I have this error:

Error converting data type nvarchar to numeric.

SqlCommand value and columns in my SQL Table are the same.

int idfornitore = 6;

string connString = "Data Source=192.168.50.18,1433; Network Library=DBMSSOCN; Initial Catalog = Gestionale; User ID=sa; Password=netinfo;";

SqlConnection connessione = new SqlConnection(connString);

string inserimento = "INSERT INTO dbo.ecListinoFornitori (IDFornitore,CodiceArticolo,CodiceArticoloFornitore,Descrizione,Giacenza,GiacenzaData,Prezzo,PrezzoVendita) VALUES (@idfornitore,@codicearticolo,@codicearticolofornitore,@descrizione,@giacenza,@giacenzadata,@prezzo,@prezzovendita)";

SqlCommand cmd = new SqlCommand(inserimento, connessione);

connessione.Open();

using (TextFieldParser reader = new TextFieldParser(txtPercorsoNEXT.Text))
{
reader.SetDelimiters(new string[] { txtSeparatoreNEXT.Text.ToString() });
reader.HasFieldsEnclosedInQuotes = true;

reader.ReadLine();

string oggi = DateTime.Now.ToString("dd-MM-yyyy");

while (!reader.EndOfData)
{
string[] campi = reader.ReadFields();

cmd.Parameters.Add("@idfornitore", SqlDbType.Int).Value = idfornitore;

cmd.Parameters.Add("@codicearticolo", SqlDbType.VarChar).Value = campi[0].ToString();

cmd.Parameters.Add("@codicearticolofornitore", SqlDbType.VarChar).Value = campi[1].ToString();

cmd.Parameters.Add("@descrizione", SqlDbType.Text).Value = campi[4].ToString();

if (campi[5].Contains("N"))
{
int NoStock = 0;

cmd.Parameters.Add("@giacenza", SqlDbType.Int).Value = NoStock;
}
else if (campi[5].Contains("S"))
{
int inStock = 1;

cmd.Parameters.AddWithValue("@giacenza", SqlDbType.Int).Value = inStock;
}

cmd.Parameters.AddWithValue("@giacenzaData", SqlDbType.VarChar).Value = oggi.ToString();

cmd.Parameters.AddWithValue("@prezzo", SqlDbType.Decimal).Value = campi[9].ToString();

cmd.Parameters.AddWithValue("@prezzovendita", SqlDbType.Decimal).Value = campi[9].ToString();

cmd.ExecuteNonQuery();
}

Hi, can i do something like this ?
connString = "My connection string";
SqlConnection connect = new SqlConnection(connString)

string query = "INSERT INTO ecList (SKU,Description,Price) VALUES (@sku,@description,@price);

using (StreamReader file = new StreamReader(nomefile))
{
string line;

while ((line = file.ReadLine()) != null)
{
if (riga.Trim().Length > 0)
{
string[] columns = line.Split(Convert.ToChar(delimiter));

cmd.Parameters.AddWithValue("@sku", columns[2].ToString();
cmd.Parameters.AddWithValue("@description", columns[4].ToString();
cmd.Parameters.AddWithValue("@price", columns[9].ToString();
cmd.ExecuteNonQuery();
}
}
}

Yes, ok. But, I have to compare 4 different file, in different formats. Some are TXT and some are CSV.


You have a few examples that I can recommend?

Maybe someone who has done something like this ?

I give you an example. I sell a notebook that is available from 4 of my suppliers , but each has different prices. I sell the notebook for 3 £.

My vendor sell it at:

1 supplier --> 1 £
2 supplier --> 5 £
3 supplier --> 4 £
4 supplier --> 2 £

I want to update it's price from 3 £ to 1 £ (1 supplier has the best price).

Have you understand now?

I want to know how I can do this with a C# application.

Thank you for your reply.