Re: Using 4D linked List make a Full functional Noted Pad on Winform - C# Discussion Boards

Re: What is the way to connect and stream IP camera

Richard MacCutchan4-Jan-21 0:31

Richard MacCutchan

4-Jan-21 0:31

Member 13327366 wrote:
Is there any free resources to achieve all these requirements?

Yes, and Google is the place to find them.

Re: What is the way to connect and stream IP camera

Member 133273664-Jan-21 0:56

Member 13327366

4-Jan-21 0:56

hello Richard MacCutchan,
I don't mean like that.
You got my post in the wrong way.

I request to you too please read the edited question.

Re: What is the way to connect and stream IP camera

OriginalGriff4-Jan-21 0:31

OriginalGriff

4-Jan-21 0:31

What have you tried?
Where are you stuck?
What help do you need?

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Re: What is the way to connect and stream IP camera

Member 133273664-Jan-21 0:58

Member 13327366

4-Jan-21 0:58

I want to stream the IP cameras of my client into my Windows application.
Please read the edited question for more details.

Re: What is the way to connect and stream IP camera

RickZeeland4-Jan-21 0:40

RickZeeland

4-Jan-21 0:40

Take a look at the open-source iSpy software, it is written in C#
GitHub - ispysoftware/iSpy: Open source surveillance software[^]

Using 4D linked List make a Full functional Noted Pad on Winform

Member 150308153-Jan-21 12:39

Member 15030815

3-Jan-21 12:39

I am creating a data structure project. My task is to use a 4D linked list and display Linked List in Windows form.
How can I display my linked list data in Winform and How can I use Cut Copy paste functions?

Re: Using 4D linked List make a Full functional Noted Pad on Winform

OriginalGriff3-Jan-21 20:22

OriginalGriff

3-Jan-21 20:22

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind - we only get exactly what you type to work with.

So show us relevant code fragment, explain where you are stuck, tell us what the "4D linked list" contains and what it is used for - we can't help you without information!

Re: Using 4D linked List make a Full functional Noted Pad on Winform

Member 150308154-Jan-21 4:37

Member 15030815

4-Jan-21 4:37

Okay... 4 D linked is a linked list that contains 4 pointers (up,down, right, left)
I want to connect the upper text with lower line text and the second line will connect with 1st line down pointer and the down pointer will be linked with lower line upper pointer. If a delete a node It will remove the node and rearrange the linked list. How I can design data structure in c# like this.

Re: Using 4D linked List make a Full functional Noted Pad on Winform

Mycroft Holmes4-Jan-21 11:26

Mycroft Holmes

4-Jan-21 11:26

Ah that still does not make much sense - for a data structure use a list with 4 fields.

Connecting text to a field in the selected item of the list text.property = selectedlistitem.up. Can't help with the text property.

Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

How to make DataGridView scrolling smooth (flickers problem)?

Alex Dunlop3-Jan-21 6:15

Alex Dunlop

3-Jan-21 6:15

I have a DataGridView in my project which loads hundreds of rows from SQL CE file. It contains colorful texts and comboboxes. I searched online and found some solutions. Many of them says that I need to use double buffer. One of those solutions was this:

public static class ExtensionMethods
{
   public static void DoubleBuffered(this DataGridView dgv, bool setting)
   {
      Type dgvType = dgv.GetType();
      PropertyInfo pi = dgvType.GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic);
      pi.SetValue(dgv, setting, null);
   }
}

and:

this.dataGridView1.DoubleBuffered(true);

I use following reference:

using System.Reflection;

My problem is that: 1) DataGridView in above class gives CS0118 error (has red underline)
2) Where should I use

this.dataGridView1.DoubleBuffered(true);

modified 3-Jan-21 22:26pm.

Re: How to make DataGridView scrolling smooth (flickers problem)?

Maciej Los3-Jan-21 23:47

Maciej Los

3-Jan-21 23:47

Take a look at this article Double Buffering a DataGridview to find out out how to enable DoubleBuffered.

Re: How to make DataGridView scrolling smooth (flickers problem)?

Alex Dunlop4-Jan-21 5:46

Alex Dunlop

4-Jan-21 5:46

I pasted this code at the end of my code lines but IDE gives error.

public partial class myDataGridView : DataGridView
{
    public myDataGridView()
    {
        InitializeComponent();
        DoubleBuffered = true;
    }    
}

The CS0118 eror code for DataGridView
The CS0103 for InitializeComponent and DoubleBuffered
How can I solve the problem? Confused | :confused:

Re: How to make DataGridView scrolling smooth (flickers problem)?

Maciej Los4-Jan-21 6:34

Maciej Los

4-Jan-21 6:34

Based on this piece of code you provided, i can't tell you what is wrong. If you replaced your DataGridView control with myDataGridView, you should be able to use DoubleBuffered.

An alternative...
How to: Reduce Graphics Flicker with Double Buffering for Forms and Controls - Windows Forms .NET Framework | Microsoft Docs
Control.SetStyle(ControlStyles, Boolean) Method (System.Windows.Forms) | Microsoft Docs

Re: How to make DataGridView scrolling smooth (flickers problem)?

Alex Dunlop4-Jan-21 6:46

Alex Dunlop

4-Jan-21 6:46

I provided an screenshot:
Untitled — ImgBB[^]

Re: How to make DataGridView scrolling smooth (flickers problem)?

Maciej Los4-Jan-21 7:38

Maciej Los

4-Jan-21 7:38

Seems, you don't understand what this code is doing...

Please, read about Inheritance - C# Programming Guide | Microsoft Docs and Polymorphism - C# Programming Guide | Microsoft Docs

Tip:
Go to the designer of Main class. Find 2 lines of declaration of dataGridView1:

this.dataGridView1 = new DataGridView();
//and 
private DataGridView dataGridView1;

Above code means that you've created an instance of standard DataGridView.

But(!) you need to create an instance od myDataGridView!

this.dataGridView1 = new myDataGridView();
//and
private myDataGridView dataGridView1;

For further details, please see: Inherit from Existing Controls - Windows Forms .NET Framework | Microsoft Docs

Good luck!

Re: How to make DataGridView scrolling smooth (flickers problem)?

Maciej Los6-Jan-21 21:46

Maciej Los

6-Jan-21 21:46

If you would like to get "working" doublebuffered datagridview component, you can download necessary files from this repository: GitHub - losmac/DoubleBufferedDataGridView: DataGridView (DoubleBuffered = true)

Good luck!

i have a problem in treeview Additional information: Index was outside the bounds of the array.

Member 1376816331-Dec-20 6:05

Member 13768163

31-Dec-20 6:05

this is my code
====================

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace AccountsTree
{
    public partial class Form1 : Form
    {
        clsAccounts cls = new clsAccounts();
        public Form1()
        {
            InitializeComponent();
            
        }
      
        public void filltree()
        {
            treeView1.Nodes.Clear();
            DataTable dt = new DataTable();
            dt = cls.getAccounts();
            treeView1.Nodes.Add("0", "Accounts");

                foreach (DataRow dr in dt.Rows)
                {

                    TreeNode [] node = treeView1.Nodes.Find(dr["MainAccount"].ToString(), true);
                 
                   
                  if (node != null)
                    {


                        node[0].Nodes.Add(dr["AccountCode"].ToString(), dr["AccountCode"].ToString() + dr["Name"].ToString());
                      
                      
                        
                    }
                    

                  
            }
          
                 }

        private void button4_Click(object sender, EventArgs e)
        {
            filltree();
        }
    }
}

=====================
and this is my sql script

USE [master]
GO
/****** Object:  Database [tree]    Script Date: 12/31/2020 19:01:01 ******/
CREATE DATABASE [tree] ON  PRIMARY 
( NAME = N'tree', FILENAME = N'E:\MyProjects\AccountsTree\tree.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'tree_log', FILENAME = N'E:\MyProjects\AccountsTree\tree_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [tree] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [tree].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [tree] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [tree] SET ANSI_NULLS OFF
GO
ALTER DATABASE [tree] SET ANSI_PADDING OFF
GO
ALTER DATABASE [tree] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [tree] SET ARITHABORT OFF
GO
ALTER DATABASE [tree] SET AUTO_CLOSE ON
GO
ALTER DATABASE [tree] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [tree] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [tree] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [tree] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [tree] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [tree] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [tree] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [tree] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [tree] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [tree] SET  DISABLE_BROKER
GO
ALTER DATABASE [tree] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [tree] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [tree] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [tree] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [tree] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [tree] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [tree] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [tree] SET  READ_WRITE
GO
ALTER DATABASE [tree] SET RECOVERY SIMPLE
GO
ALTER DATABASE [tree] SET  MULTI_USER
GO
ALTER DATABASE [tree] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [tree] SET DB_CHAINING OFF
GO
USE [tree]
GO
/****** Object:  Table [dbo].[Accounts]    Script Date: 12/31/2020 19:01:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Accounts](
	[AccountID] [int] IDENTITY(1,1) NOT NULL,
	[AccountCode] [varchar](50) NOT NULL,
	[MainAccount] [varchar](50) NOT NULL,
	[Name] [varchar](100) NULL,
	[AccountType] [tinyint] NOT NULL,
	[Debit] [real] NULL,
	[Credit] [real] NULL,
 CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED 
(
	[AccountID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_Accounts] UNIQUE NONCLUSTERED 
(
	[AccountCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=1800 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'كود الحساب' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'الحساب الرئيسى' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'MainAccount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=2655 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'اسم الحساب' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Name'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'2 حساب رئيسى1   : حساب فرعى' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'AccountType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'مدين' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Debit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnHidden', @value=N'False' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnOrder', @value=0 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_ColumnWidth', @value=-1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'دائن' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DisplayControl', @value=N'109' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Format', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_IMEMode', @value=N'0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts', @level2type=N'COLUMN',@level2name=N'Credit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DefaultView', @value=0x02 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Filter', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_OrderBy', @value=N'Accounts.AccountName' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Orientation', @value=NULL , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_TableMaxRecords', @value=10000 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Accounts'
GO
/****** Object:  StoredProcedure [dbo].[selectAc]    Script Date: 12/31/2020 19:01:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create proc [dbo].[selectAc]
as
select * 
from
Accounts
GO
/****** Object:  Default [DF_Accounts_MainAccount]    Script Date: 12/31/2020 19:01:03 ******/
ALTER TABLE [dbo].[Accounts] ADD  CONSTRAINT [DF_Accounts_MainAccount]  DEFAULT ('') FOR [MainAccount]
GO
/****** Object:  Default [DF_Accounts_AccountType]    Script Date: 12/31/2020 19:01:03 ******/
ALTER TABLE [dbo].[Accounts] ADD  CONSTRAINT [DF_Accounts_AccountType]  DEFAULT ((2)) FOR [AccountType]
GO
/****** Object:  Default [DF_Accounts_Debit]    Script Date: 12/31/2020 19:01:03 ******/
ALTER TABLE [dbo].[Accounts] ADD  CONSTRAINT [DF_Accounts_Debit]  DEFAULT ((0)) FOR [Debit]
GO
/****** Object:  Default [DF_Accounts_Credit]    Script Date: 12/31/2020 19:01:03 ******/
ALTER TABLE [dbo].[Accounts] ADD  CONSTRAINT [DF_Accounts_Credit]  DEFAULT ((0)) FOR [Credit]
GO

=====================================

need fix for this error

Index was outside the bounds of the array.

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

Richard MacCutchan31-Dec-20 6:15

Richard MacCutchan

31-Dec-20 6:15

You are using a value to access the elements of an array. The value is either negative, or greater than the index value of the last item. You need to use the debugger to catch the exception and find out why it happens.

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

BillWoodruff31-Dec-20 23:05

BillWoodruff

31-Dec-20 23:05

fyi: the TreeNode [] returned by 'Find can never be null. However, in .NET 5, this method will throw an ArgumentNullException if the Key is null or empty: [^]

«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

Richard MacCutchan31-Dec-20 23:13

Richard MacCutchan

31-Dec-20 23:13

I think this message was meant for the OP.

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

BillWoodruff1-Jan-21 0:00

BillWoodruff

1-Jan-21 0:00

no, Richard, it was meant for Thee.

«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

Richard MacCutchan1-Jan-21 0:24

Richard MacCutchan

1-Jan-21 0:24

I don't think I referred to that point in my response to OP; so I am a bit confused.

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

Gerry Schmitz31-Dec-20 9:15

Gerry Schmitz

31-Dec-20 9:15

Maybe you should try .Count instead of null.

Quote:
The Count property holds the number of TreeNode objects assigned to the collection. You can use the Count property value as the upper bounds of a loop to iterate through a collection.

TreeNodeCollection.Count Property (System.Windows.Forms) | Microsoft Docs

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

BillWoodruff31-Dec-20 22:58

BillWoodruff

31-Dec-20 22:58

You have confused the get-only Count Property of a TreeNodeCollection with the Count Method of an Array. Using the Length Property of the Array works fine.

Down-voted.

«One day it will have to be officially admitted that what we have christened reality is an even greater illusion than the world of dreams.» Salvador Dali

Re: i have a problem in treeview Additional information: Index was outside the bounds of the array.

Gerry Schmitz2-Jan-21 9:28

Gerry Schmitz

2-Jan-21 9:28

You got lucky.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.