Witam,
Słuchajcie mam taki mały problem ponieważ potrzebuje aplikacji na zaliczenie ;/ muszę stworzyć aplikacje która będzie posiadała bazę danych kształtek wentylacyjnych i do Tego interface w którym będę miał możliwość wpisania wymiarów tej kształtki. Na końcu ta aplikacja ma wygenerować mi listę tych kształtek wraz z podanymi wymiarami do exsela ! Macie jakieś pomysły jak się za to zabrać albo jakoś pomożecie bo mam dwa tygodnie na to a nie wiem za bardzo co robić ;/
Skoro potrzebujesz w końcu: - "... wygenerować ... listę tych kształtek wraz z podanymi wymiarami do exsela ..." to wpisz od razu w excelu.
Sądząc po tagach musi to zrobić w 3 wersjach
Ale to ma być aplikacja która generuje dane wprowadzone w aplikacji do exsela. Musi być tam zabezpieczenie że jeśli wpisze się np literę albo pozostawi puste pole to program nie zaakceptuje Tego. Nie wiem czy da się zrobić to w exselu nawet z dodatkiem VBA ;/ może ma ktoś podobny program ?
C++ ->Qt creator -> Design Drag&Drop (jak dla mnie to tutaj dwa buttony sa potrzebne i jedno QTable - button dodaj, eksportuj i tabela z kształtkami)-> definiowanie sygnałów/slotów (dodawanie do tabeli, eksport do csv). Projekt skończony.
A reszta typu poprawność pól? Zabawa albo z własnymi sygnałami/slotami albo właściwościami danego widgetu.
EDIT: To oczywiście funkcjonalna wersja minimum (chociaż jak znam życie to i tak mógłby być jeden z lepszych projektów ;)).
Słuchajcie zrobiłem coś takiego i nie wiem co dalej, jakby ktoś mógł powiedzieć mi jak wstawić zabezpieczenie żeby nikt nie mógł wpisać litery tylko cyfry i jak zapisywać to do excela?
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class Form1
Inherits System.Windows.Forms.Form
'Form overrides dispose to clean up the component list.
<System.Diagnostics.DebuggerNonUserCode()> _
Protected Overrides Sub Dispose(ByVal disposing As Boolean)
Try
If disposing AndAlso components IsNot Nothing Then
components.Dispose()
End If
Finally
MyBase.Dispose(disposing)
End Try
End Sub
'Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer
'NOTE: The following procedure is required by the Windows Form Designer
'It can be modified using the Windows Form Designer.
'Do not modify it using the code editor.
<System.Diagnostics.DebuggerStepThrough()> _
Private Sub InitializeComponent()
Me.TextBox1 = New System.Windows.Forms.TextBox()
Me.TextBox2 = New System.Windows.Forms.TextBox()
Me.TextBox3 = New System.Windows.Forms.TextBox()
Me.TextBox4 = New System.Windows.Forms.TextBox()
Me.TextBox5 = New System.Windows.Forms.TextBox()
Me.TextBox6 = New System.Windows.Forms.TextBox()
Me.PictureBox1 = New System.Windows.Forms.PictureBox()
Me.GroupBox1 = New System.Windows.Forms.GroupBox()
Me.Label9 = New System.Windows.Forms.Label()
Me.Label8 = New System.Windows.Forms.Label()
Me.Label7 = New System.Windows.Forms.Label()
Me.Label6 = New System.Windows.Forms.Label()
Me.Label5 = New System.Windows.Forms.Label()
Me.Label4 = New System.Windows.Forms.Label()
Me.Label3 = New System.Windows.Forms.Label()
Me.Label2 = New System.Windows.Forms.Label()
Me.Label1 = New System.Windows.Forms.Label()
Me.TextBox9 = New System.Windows.Forms.TextBox()
Me.TextBox8 = New System.Windows.Forms.TextBox()
Me.TextBox7 = New System.Windows.Forms.TextBox()
Me.ListBox1 = New System.Windows.Forms.ListBox()
Me.Button1 = New System.Windows.Forms.Button()
Me.ComboBox1 = New System.Windows.Forms.ComboBox()
Me.ComboBox2 = New System.Windows.Forms.ComboBox()
Me.ComboBox3 = New System.Windows.Forms.ComboBox()
Me.ComboBox4 = New System.Windows.Forms.ComboBox()
Me.Label10 = New System.Windows.Forms.Label()
Me.Label11 = New System.Windows.Forms.Label()
Me.Label12 = New System.Windows.Forms.Label()
Me.Label13 = New System.Windows.Forms.Label()
Me.GroupBox2 = New System.Windows.Forms.GroupBox()
CType(Me.PictureBox1, System.ComponentModel.ISupportInitialize).BeginInit()
Me.GroupBox1.SuspendLayout()
Me.GroupBox2.SuspendLayout()
Me.SuspendLayout()
'
'TextBox1
'
Me.TextBox1.Location = New System.Drawing.Point(49, 23)
Me.TextBox1.Name = "TextBox1"
Me.TextBox1.Size = New System.Drawing.Size(100, 20)
Me.TextBox1.TabIndex = 1
'
'TextBox2
'
Me.TextBox2.Location = New System.Drawing.Point(194, 23)
Me.TextBox2.Name = "TextBox2"
Me.TextBox2.Size = New System.Drawing.Size(100, 20)
Me.TextBox2.TabIndex = 3
'
'TextBox3
'
Me.TextBox3.Location = New System.Drawing.Point(346, 23)
Me.TextBox3.Name = "TextBox3"
Me.TextBox3.Size = New System.Drawing.Size(100, 20)
Me.TextBox3.TabIndex = 5
'
'TextBox4
'
Me.TextBox4.Location = New System.Drawing.Point(49, 51)
Me.TextBox4.Name = "TextBox4"
Me.TextBox4.Size = New System.Drawing.Size(100, 20)
Me.TextBox4.TabIndex = 7
'
'TextBox5
'
Me.TextBox5.Location = New System.Drawing.Point(194, 51)
Me.TextBox5.Name = "TextBox5"
Me.TextBox5.Size = New System.Drawing.Size(100, 20)
Me.TextBox5.TabIndex = 9
'
'TextBox6
'
Me.TextBox6.Location = New System.Drawing.Point(346, 51)
Me.TextBox6.Name = "TextBox6"
Me.TextBox6.Size = New System.Drawing.Size(100, 20)
Me.TextBox6.TabIndex = 11
'
'PictureBox1
'
Me.PictureBox1.Location = New System.Drawing.Point(449, 156)
Me.PictureBox1.Name = "PictureBox1"
Me.PictureBox1.Size = New System.Drawing.Size(250, 250)
Me.PictureBox1.TabIndex = 6
Me.PictureBox1.TabStop = False
'
'GroupBox1
'
Me.GroupBox1.BackColor = System.Drawing.Color.Silver
Me.GroupBox1.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None
Me.GroupBox1.Controls.Add(Me.Label9)
Me.GroupBox1.Controls.Add(Me.Label8)
Me.GroupBox1.Controls.Add(Me.Label7)
Me.GroupBox1.Controls.Add(Me.Label6)
Me.GroupBox1.Controls.Add(Me.Label5)
Me.GroupBox1.Controls.Add(Me.Label4)
Me.GroupBox1.Controls.Add(Me.Label3)
Me.GroupBox1.Controls.Add(Me.Label2)
Me.GroupBox1.Controls.Add(Me.Label1)
Me.GroupBox1.Controls.Add(Me.TextBox9)
Me.GroupBox1.Controls.Add(Me.TextBox8)
Me.GroupBox1.Controls.Add(Me.TextBox7)
Me.GroupBox1.Controls.Add(Me.TextBox6)
Me.GroupBox1.Controls.Add(Me.TextBox5)
Me.GroupBox1.Controls.Add(Me.TextBox4)
Me.GroupBox1.Controls.Add(Me.TextBox3)
Me.GroupBox1.Controls.Add(Me.TextBox2)
Me.GroupBox1.Controls.Add(Me.TextBox1)
Me.GroupBox1.ForeColor = System.Drawing.Color.Black
Me.GroupBox1.Location = New System.Drawing.Point(232, 12)
Me.GroupBox1.Name = "GroupBox1"
Me.GroupBox1.Size = New System.Drawing.Size(467, 131)
Me.GroupBox1.TabIndex = 1
Me.GroupBox1.TabStop = False
Me.GroupBox1.Text = "Wymiary"
'
'Label9
'
Me.Label9.Location = New System.Drawing.Point(301, 80)
Me.Label9.Name = "Label9"
Me.Label9.Size = New System.Drawing.Size(39, 17)
Me.Label9.TabIndex = 16
Me.Label9.Text = "x="
Me.Label9.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label8
'
Me.Label8.Location = New System.Drawing.Point(155, 80)
Me.Label8.Name = "Label8"
Me.Label8.Size = New System.Drawing.Size(39, 17)
Me.Label8.TabIndex = 14
Me.Label8.Text = "x="
Me.Label8.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label7
'
Me.Label7.Location = New System.Drawing.Point(8, 80)
Me.Label7.Name = "Label7"
Me.Label7.Size = New System.Drawing.Size(39, 17)
Me.Label7.TabIndex = 12
Me.Label7.Text = "x="
Me.Label7.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label6
'
Me.Label6.Location = New System.Drawing.Point(301, 54)
Me.Label6.Name = "Label6"
Me.Label6.Size = New System.Drawing.Size(39, 17)
Me.Label6.TabIndex = 10
Me.Label6.Text = "x="
Me.Label6.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label5
'
Me.Label5.Location = New System.Drawing.Point(155, 54)
Me.Label5.Name = "Label5"
Me.Label5.Size = New System.Drawing.Size(39, 20)
Me.Label5.TabIndex = 8
Me.Label5.Text = "x="
Me.Label5.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label4
'
Me.Label4.Location = New System.Drawing.Point(8, 54)
Me.Label4.Name = "Label4"
Me.Label4.Size = New System.Drawing.Size(39, 17)
Me.Label4.TabIndex = 6
Me.Label4.Text = "x="
Me.Label4.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label3
'
Me.Label3.Location = New System.Drawing.Point(301, 26)
Me.Label3.Name = "Label3"
Me.Label3.Size = New System.Drawing.Size(39, 17)
Me.Label3.TabIndex = 4
Me.Label3.Text = "l="
Me.Label3.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label2
'
Me.Label2.Location = New System.Drawing.Point(155, 26)
Me.Label2.Name = "Label2"
Me.Label2.Size = New System.Drawing.Size(39, 17)
Me.Label2.TabIndex = 2
Me.Label2.Text = "b="
Me.Label2.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'Label1
'
Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 8.25!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(238, Byte))
Me.Label1.Location = New System.Drawing.Point(8, 26)
Me.Label1.Name = "Label1"
Me.Label1.Size = New System.Drawing.Size(39, 17)
Me.Label1.TabIndex = 0
Me.Label1.Text = "a="
Me.Label1.TextAlign = System.Drawing.ContentAlignment.MiddleRight
'
'TextBox9
'
Me.TextBox9.Location = New System.Drawing.Point(346, 77)
Me.TextBox9.Name = "TextBox9"
Me.TextBox9.Size = New System.Drawing.Size(100, 20)
Me.TextBox9.TabIndex = 17
'
'TextBox8
'
Me.TextBox8.Location = New System.Drawing.Point(194, 77)
Me.TextBox8.Name = "TextBox8"
Me.TextBox8.Size = New System.Drawing.Size(100, 20)
Me.TextBox8.TabIndex = 15
'
'TextBox7
'
Me.TextBox7.Location = New System.Drawing.Point(49, 77)
Me.TextBox7.Name = "TextBox7"
Me.TextBox7.Size = New System.Drawing.Size(100, 20)
Me.TextBox7.TabIndex = 13
'
'ListBox1
'
Me.ListBox1.FormattingEnabled = True
Me.ListBox1.Items.AddRange(New Object() {"Kanał", "Kolano"})
Me.ListBox1.Location = New System.Drawing.Point(12, 12)
Me.ListBox1.Name = "ListBox1"
Me.ListBox1.Size = New System.Drawing.Size(214, 394)
Me.ListBox1.TabIndex = 0
'
'Button1
'
Me.Button1.Font = New System.Drawing.Font("Microsoft Sans Serif", 10.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(238, Byte))
Me.Button1.Location = New System.Drawing.Point(251, 359)
Me.Button1.Name = "Button1"
Me.Button1.Size = New System.Drawing.Size(157, 47)
Me.Button1.TabIndex = 3
Me.Button1.Text = "Test"
Me.Button1.UseVisualStyleBackColor = True
'
'ComboBox1
'
Me.ComboBox1.FormattingEnabled = True
Me.ComboBox1.Location = New System.Drawing.Point(40, 24)
Me.ComboBox1.Name = "ComboBox1"
Me.ComboBox1.Size = New System.Drawing.Size(151, 21)
Me.ComboBox1.TabIndex = 0
'
'ComboBox2
'
Me.ComboBox2.FormattingEnabled = True
Me.ComboBox2.Location = New System.Drawing.Point(40, 51)
Me.ComboBox2.Name = "ComboBox2"
Me.ComboBox2.Size = New System.Drawing.Size(151, 21)
Me.ComboBox2.TabIndex = 1
'
'ComboBox3
'
Me.ComboBox3.FormattingEnabled = True
Me.ComboBox3.Location = New System.Drawing.Point(40, 78)
Me.ComboBox3.Name = "ComboBox3"
Me.ComboBox3.Size = New System.Drawing.Size(151, 21)
Me.ComboBox3.TabIndex = 2
'
'ComboBox4
'
Me.ComboBox4.FormattingEnabled = True
Me.ComboBox4.Location = New System.Drawing.Point(40, 105)
Me.ComboBox4.Name = "ComboBox4"
Me.ComboBox4.Size = New System.Drawing.Size(151, 21)
Me.ComboBox4.TabIndex = 3
'
'Label10
'
Me.Label10.AutoSize = True
Me.Label10.Location = New System.Drawing.Point(17, 27)
Me.Label10.Name = "Label10"
Me.Label10.Size = New System.Drawing.Size(16, 13)
Me.Label10.TabIndex = 4
Me.Label10.Text = "f1"
'
'Label11
'
Me.Label11.AutoSize = True
Me.Label11.Location = New System.Drawing.Point(17, 54)
Me.Label11.Name = "Label11"
Me.Label11.Size = New System.Drawing.Size(16, 13)
Me.Label11.TabIndex = 5
Me.Label11.Text = "f2"
'
'Label12
'
Me.Label12.AutoSize = True
Me.Label12.Location = New System.Drawing.Point(17, 81)
Me.Label12.Name = "Label12"
Me.Label12.Size = New System.Drawing.Size(16, 13)
Me.Label12.TabIndex = 6
Me.Label12.Text = "f3"
'
'Label13
'
Me.Label13.AutoSize = True
Me.Label13.Location = New System.Drawing.Point(17, 108)
Me.Label13.Name = "Label13"
Me.Label13.Size = New System.Drawing.Size(16, 13)
Me.Label13.TabIndex = 7
Me.Label13.Text = "f4"
'
'GroupBox2
'
Me.GroupBox2.Controls.Add(Me.Label13)
Me.GroupBox2.Controls.Add(Me.Label12)
Me.GroupBox2.Controls.Add(Me.Label11)
Me.GroupBox2.Controls.Add(Me.Label10)
Me.GroupBox2.Controls.Add(Me.ComboBox4)
Me.GroupBox2.Controls.Add(Me.ComboBox3)
Me.GroupBox2.Controls.Add(Me.ComboBox2)
Me.GroupBox2.Controls.Add(Me.ComboBox1)
Me.GroupBox2.Location = New System.Drawing.Point(232, 156)
Me.GroupBox2.Name = "GroupBox2"
Me.GroupBox2.Size = New System.Drawing.Size(211, 145)
Me.GroupBox2.TabIndex = 2
Me.GroupBox2.TabStop = False
Me.GroupBox2.Text = "Rodzaj połączenia"
'
'Form1
'
Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
Me.BackColor = System.Drawing.SystemColors.ActiveBorder
Me.ClientSize = New System.Drawing.Size(716, 557)
Me.Controls.Add(Me.GroupBox2)
Me.Controls.Add(Me.Button1)
Me.Controls.Add(Me.ListBox1)
Me.Controls.Add(Me.GroupBox1)
Me.Controls.Add(Me.PictureBox1)
Me.Name = "Form1"
Me.Text = "Elementy"
CType(Me.PictureBox1, System.ComponentModel.ISupportInitialize).EndInit()
Me.GroupBox1.ResumeLayout(False)
Me.GroupBox1.PerformLayout()
Me.GroupBox2.ResumeLayout(False)
Me.GroupBox2.PerformLayout()
Me.ResumeLayout(False)
End Sub
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
Friend WithEvents TextBox2 As System.Windows.Forms.TextBox
Friend WithEvents TextBox3 As System.Windows.Forms.TextBox
Friend WithEvents TextBox4 As System.Windows.Forms.TextBox
Friend WithEvents TextBox5 As System.Windows.Forms.TextBox
Friend WithEvents TextBox6 As System.Windows.Forms.TextBox
Friend WithEvents PictureBox1 As System.Windows.Forms.PictureBox
Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
Friend WithEvents Label9 As System.Windows.Forms.Label
Friend WithEvents Label8 As System.Windows.Forms.Label
Friend WithEvents Label7 As System.Windows.Forms.Label
Friend WithEvents Label6 As System.Windows.Forms.Label
Friend WithEvents Label5 As System.Windows.Forms.Label
Friend WithEvents Label4 As System.Windows.Forms.Label
Friend WithEvents Label3 As System.Windows.Forms.Label
Friend WithEvents Label2 As System.Windows.Forms.Label
Friend WithEvents Label1 As System.Windows.Forms.Label
Friend WithEvents TextBox9 As System.Windows.Forms.TextBox
Friend WithEvents TextBox8 As System.Windows.Forms.TextBox
Friend WithEvents TextBox7 As System.Windows.Forms.TextBox
Friend WithEvents ListBox1 As System.Windows.Forms.ListBox
Friend WithEvents Button1 As System.Windows.Forms.Button
Friend WithEvents ComboBox1 As System.Windows.Forms.ComboBox
Friend WithEvents ComboBox2 As System.Windows.Forms.ComboBox
Friend WithEvents ComboBox3 As System.Windows.Forms.ComboBox
Friend WithEvents ComboBox4 As System.Windows.Forms.ComboBox
Friend WithEvents Label10 As System.Windows.Forms.Label
Friend WithEvents Label11 As System.Windows.Forms.Label
Friend WithEvents Label12 As System.Windows.Forms.Label
Friend WithEvents Label13 As System.Windows.Forms.Label
Friend WithEvents GroupBox2 As System.Windows.Forms.GroupBox
End Class
Haha jaja sobie robisz :D
Tagi: C,C++,Java.
Kod: Basic (matko, ja to 'kodem' nazwałem).
Podejście: ...
Może jeszcze frytki do tego?