2
votes
2answers
69 views

Building Session-Variables from a sql stored procedure

I have been advised to submit my code here by a fellow Stack contributer as it was suggested the code could be further improved; Calling Code and attempt at building session variables: DataTable ...
1
vote
2answers
70 views

Is there a simpler way to write a row from one table to another?

I have the following code: const String sqlSelect = "SELECT * FROM UserPasswords WHERE username='System Administrator';"; const String sqlInsert = "INSERT INTO UserPasswords VALUES ...
7
votes
3answers
331 views

How to optimize this code to get a instant/better result instead of waiting at least 10 seconds every time?

I have the following code that unfortunately is really slow: private void FilterSessionByDate() { SessionsFilteredByDate = ...
0
votes
2answers
192 views

Critique my Database design/help me simplify my C# code please

I wish to create a database for a webpage where users are able to add their own events to a timetable. Users will be able to decide if the events should be recurring (weekly) or not. Users should be ...
4
votes
10answers
848 views

Is there a better way to do this database insert? Looking for best-practice example.

I wrote the following code to insert records into a database. The user selects the rows from the RadGrid and the insert command is executed when that user clicks the button. I've been spending a lot ...
10
votes
5answers
1k views

ASP.net c# class design (simple)

Here's a class I'm designing: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; namespace Artworking.classes { ...