Comments by Reden Rodriguez (Top 22 by date)

im using this EPPLUS, i even tried to do is where the client will just enter a certain date range and i will get the date range and get the data from the database and export it as excel and it's still have some errors so i tried to get the data from datagrid and add it in list<> then generate it as an excel data my maximum data is only 4400 i can't get anymore than that

it's just a little experiment, i was just curious if i can use table instead the usual gridview. :)

i finally get it now, my visual studio sucks haha, first i commented all my code the lunch the webapplication and i uncomment all my codes and it works hahaha

i can't run it because of the error that the method doesn't exist but it exist and the client side can't even detect it, btw i put my experiment code in my buddy's work and it goddamn work and i tried to create a new web form in his work and we got the same error again, and tried it in my past works and just insert the code in the client side and the code behind and it works but for some reason whenever i create a new webform or application it can be detected.

i even create a new web application and it is always like that.

I just created a new web form but it's always like that

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Test.aspx.cs" Inherits="WebApplication3.Test" %>




using System;
using System.Web.UI;

namespace WebApplication3
{
public partial class Test : Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
public string codeBehind()
{
string htmlStr = "";
SqlConnection thisConnection = new SqlConnection(dbConnection);
SqlCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText = "SELECT * from tableTest";
thisConnection.Open();
SqlDataReader reader = thisCommand.ExecuteReader();

while (reader.Read())
{
int id = reader.GetInt32(0);
string Name = reader.GetString(1);
string Pass = reader.GetString(2);
htmlStr += "" + id + "" + Name + "" + Pass + "";
}

thisConnection.Close();
return htmlStr;
}
}
}

Thanks Dave i'm really new to asp.net i still don't know that i can do this $"DateReceived >= #{date1}# AND DateReceived <= #{date2}#"; you're a big help.

here is the image of the data via hyper terminal https://imguh.com/image/eh36g

both machine is used for capturing the weight of the container

when i saw my app crashing i already used paging but it's still crash so i end up limiting my data.

i used paging sir, but it still crash, if i don't used paging it will load endlessly.

yea i change it, but how can i catch the raise error if i want to use it? or it is not good to use raiserror?

i'm sorry that my question lacks some information the error occurred in bm.Save("temp.gif"); the code.CreateDrawingImage the word code inside of it is where i put the random numbers that i generated and hid it in the image.

I tried this one but it doesn't work

what if i had a 2 million employee?