Torna al Thread

public string Carica(string campo_1, string campo_2, string campo_3) { string campo_4 = "0"; SqlConnection conn = new SqlConnection(); SqlCommand com = new SqlCommand(); conn.ConnectionString = "Data Source=***\\SQLEXPRESS;Initial Catalog=***;Integrated Security=True"; com.Connection = conn; com.CommandText = "SELECT * FROM Timesheet WHERE ID_Dipendente = '" + campo_1 + "' and Data_Timesheet = '" + campo_2 + "' and ID_Commessa = '" + campo_3 + "'"; conn.Open(); SqlDataAdapter DA = new SqlDataAdapter(); DataSet DS = new DataSet(); DA.SelectCommand = com; DA.Fill(DS, "TAB"); conn.Close(); if (DS.Tables["TAB"].Rows.Count > 0) { foreach (DataRow riga in DS.Tables["TAB"].Rows) { campo_4 = riga["Ore"].ToString(); } } return campo_4; }
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5