Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void GetRootDirectory()
- {
- p.Con.Open();
- Console.WriteLine("Üdv {0}!n", GetUsersFullName());
- DataTable dt = new DataTable();
- var query = "SELECT Mappa_id FROM Mappastruktúra WHERE (Parent_id IS NULL OR Parent_id = 0) AND username = @username";
- var sda = new SqlDataAdapter(query, p.Con);
- //SQL Injection Protection
- sda.SelectCommand.Parameters.AddWithValue("@username", SqlDbType.VarChar);
- sda.SelectCommand.Parameters["@username"].Value = p.Getlgduser();
- sda.Fill(dt);
- if (dt.Rows.Count == 0)
- {
- Console.WriteLine("Még nincsenek feltöltött elemek!");
- }
- else
- {
- sorszam = dt.Rows.Count;
- oszlopszam = dt.Columns.Count;
- for (int j = 0; j < sorszam; j++)
- {
- IdList.Add((int)dt.Rows[j][0]);
- }
- //Thats where i get system out of range exception
- for (int i = 0; i < IdList.Count; i++)
- {
- FolderList[i] = GetFName(IdList[i]);
- }
- Console.WriteLine("FolerList:");
- foreach (var a in FolderList)
- {
- Console.WriteLine(a);
- }
- FolderList.Add("---------");
- FolderList.Add("Új Mappa");
- FolderList.Add("Feltöltés");
- FolderList.Add("Letöltés");
- m.DebugTable(dt);
- }
- p.Con.Close();
- }
- public string GetFName(int fname)
- {
- p.Con.Open();
- var dt = new DataTable();
- string query = "SELECT FolderName FROM Mappastruktúra WHERE Mappa_id = @mappa_id";
- string query2 = "SELECT FolderName FROM Mappastruktúra WHERE Mappa_id = @mappa_id";
- SqlCommand cmd = new SqlCommand(query,p.Con);
- //SQL Injection Protection
- cmd.Parameters.AddWithValue("@mappa_id", SqlDbType.Int);
- cmd.Parameters["@mappa_id"].Value = fname;
- try
- {
- string name = cmd.ExecuteScalar().ToString();
- p.Con.Close();
- return name;
- }
- catch (Exception e)
- {
- p.Con.Close();
- Console.WriteLine(e);
- return null;
- }
Add Comment
Please, Sign In to add comment