C#

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

CrimeanTurtle2008 wrote:

How would I remedy this?

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

public partial class Caching_ApplicationCaching : Page
{
	const string QUERY = "SELECT firstname, lastname FROM customers";
	const string CACHE_KEY = "Client";

	protected void Page_Load(object sender, EventArgs e)
	{
		DataTable source = GetCustomersTable();

		DropDownList1.DataSource = source;
		DropDownList1.DataTextField = "FirstName";
		DropDownList1.DataBind();
	}

	private DataTable GetCustomersTable()
	{
		DataTable source = (DataTable)Cache[CACHE_KEY];

		if (source == null)
		{
			source = PopulateCustomersCache();
		}

		return source;
	}

	private DataTable PopulateCustomersCache()
	{
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			using (SqlCommand command = new SqlCommand(QUERY, conn))
                        {
			    conn.Open();
			    command.CommandType = CommandType.Text;

			    SqlDataAdapter adapter = new SqlDataAdapter(command);

			    DataSet ds = new DataSet();
			    adapter.Fill(ds, "Customers");

			    DataTable dt = ds.Tables["Customers"];
			    Cache.Insert(CACHE_KEY, dt);

			    return dt;
                        }
		}
	}
}

KaptinKrunch wrote:

and is working. Currently I'm not making this call or similar in any of the service events.

string FilledDate = GridView2.Rows[e.RowIndex].Cell[3].Text;
if (FilledDate != null)
    cmd.Parameters.AddWithValue("@filleddate", FilledDate);
else
    cmd.Parameters.AddWithValue("@filleddate", ""); // or give appropriate error messege instead of inserting blank values.

EliottA wrote:

pay a real coder over at rentacoder[^]