UnawareModesty
UnawareModesty
PostsComments
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
:NPCNurseThumbsUp:
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
thank you tho
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
yeye i might read on that
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
:peepohappy:
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
thanks for the help
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
ill be sure to read the doc
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
thats kidna an easy solve tho to check and be able to create names for the files
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
well the path for mypath requires at teh end a name for the created file, example "c::\users\decoyuser\desktop\name_of_file.xlsx"
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
i guess i need to put a separate thing to be able to change the name of the file everytime cause it kinda doesnt work if you want to put one with a duplicate name
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
ok thank you it finally works
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
i guess more specificaly this is the code 
            string connectionString12 = null;
            SqlConnection cnn12;
            SqlCommand command12;
            SqlDataReader dataReader12;
            connectionString12 = GlobalConnection.decoyconnection;
            cnn12 = new SqlConnection(connectionString12);
            cnn12.Open();
            string sql12 = $"select ppi.LocationID, pl.Name as LocationName, ppi.ProductID, pp.Name as ProductName, ppi.Quantity from production.ProductInventory ppi\r\njoin production.Product pp\r\non ppi.ProductID = pp.ProductID\r\njoin production.Location pl\r\non pl.LocationID = ppi.LocationID\r\norder by ppi.LocationID";
            command12 = new SqlCommand(sql12, cnn12);
            SqlDataAdapter da12 = new SqlDataAdapter(command12);
            DataTable dt12 = new DataTable();
            da12.Fill(dt12);
            dataGridView1.DataSource = dt12;
            command12.Dispose();
            cnn12.Close();
            string connectionString12 = null;
            SqlConnection cnn12;
            SqlCommand command12;
            SqlDataReader dataReader12;
            connectionString12 = GlobalConnection.decoyconnection;
            cnn12 = new SqlConnection(connectionString12);
            cnn12.Open();
            string sql12 = $"select ppi.LocationID, pl.Name as LocationName, ppi.ProductID, pp.Name as ProductName, ppi.Quantity from production.ProductInventory ppi\r\njoin production.Product pp\r\non ppi.ProductID = pp.ProductID\r\njoin production.Location pl\r\non pl.LocationID = ppi.LocationID\r\norder by ppi.LocationID";
            command12 = new SqlCommand(sql12, cnn12);
            SqlDataAdapter da12 = new SqlDataAdapter(command12);
            DataTable dt12 = new DataTable();
            da12.Fill(dt12);
            dataGridView1.DataSource = dt12;
            command12.Dispose();
            cnn12.Close();
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
with a datareader
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
but idk what youre trying to explain to me rn
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
i mean the columns from the table im pulling are string and int
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
what is epplus and whats the line of code youre talking bout
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
its datagridview
28 replies
CC#
Created by UnawareModesty on 4/28/2024 in #help
✅ How to export data from datagridview into excel file
I guess note: I use Visual Studio 2022
28 replies
CC#
Created by UnawareModesty on 3/31/2024 in #help
✅ Swap between multiple forms on a single panel
thanks for the ideas and help anyway :peepohappy:
52 replies
CC#
Created by UnawareModesty on 3/31/2024 in #help
✅ Swap between multiple forms on a single panel
ehhh ill try smth maybe tommorow ive already been coding for like 10 hours today lol
52 replies
CC#
Created by UnawareModesty on 3/31/2024 in #help
✅ Swap between multiple forms on a single panel
ok so i tried this but when i overlap panels in the form design, every part of a panel that overlaps another panel hides aswell when i hide the panel i want gone
52 replies