16,016,477 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by LordVovin (Top 17 by date)
LordVovin
13-Jul-15 6:35am
View
Data here are static, if it's already in the database, user is not able to change it. This is only to present already 'logged tickets'.
LordVovin
25-May-15 3:49am
View
:) big thanks for you support :)
Sure, I will add more info in a minute
LordVovin
25-May-15 3:36am
View
No:) Me.Second.Add() was added to the ViewModel. Everything what I'm doing here is done in EmployeeViewModel. I'm not touching auto-generated classes. This one is harder than I thought ;)
LordVovin
25-May-15 2:44am
View
I want to get values from that column. I don't want to add anything to CustomObservableCollection. Once I get my stored procedure executed, I want to show records only for particular column here (SecondActivity).
I wrote that wrongly, my bad, apologies - I need to call that column in property to get values only for this one.
I have Two columns there: FirstActivity, SecondActivity. I want to create cascading comboboxes here. When I bind everything to the combobox and set DisplayMemberPath as 'FirstActivity' or 'SecondActivity', I will get the result but multiplied as many time as records are for particular column. That's why, I understand' I need to set particular column to get distinc values here.
LordVovin
25-May-15 1:16am
View
Sure, I've add Second property as well. This one is ObservableCollection of that stored procedure.
LordVovin
25-May-15 1:07am
View
this one was autogenerated by entity frameworks. I will edit my question and add the code.
LordVovin
18-May-15 4:28am
View
Great! Thank you very very much! Appreciate!
LordVovin
11-Apr-14 17:42pm
View
Well, I could fiter DataGrid first to get only row with regarding ID and then select it as a 0 row, but I need DataGrid with all records (management request...).
I will read this for sure. Thank you!
LordVovin
11-Apr-14 17:27pm
View
Hi,
I was trying to get the row index first, then get cell value. (for each item as DataRowView in dgMyKaizens.ItemsSource). There was no error when I was trying to get cell value to textbox.
To select row I used:
Dim cel As Integer = item.Item("ID")
' If id = cel Then
' dgMyKaizens.SelectedItem = cel
' dgMyKaizens.ScrollIntoView(item)
' End If
Without any progress on that...
LordVovin
8-Jul-13 9:39am
View
yes, but no connection as well.
LordVovin
4-Jul-13 3:25am
View
for DbNullOrStringValue i have this code:
Public Function DbNullOrStringValue(ByVal value As String) As Object
If String.IsNullOrEmpty(value) Then
Return DBNull.Value
Else
Return value
End If
End Function
but unfortunately - no effect
Thanks!
LordVovin
4-Jul-13 3:24am
View
Hi John,
thanks for your solution. I've done it already :)
My code is like this:
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim con As SqlConnection = New SqlConnection("Data Source=SZYNDLEM2\DHLSERVER;Initial Catalog=TimerTool;Integrated Security=True")
'Dim affectedRows As Integer
If CheckBox1.Checked = True Then
txtInvTcheck.Text = "true"
Else
txtInvTcheck.Text = "false"
End If
If CheckBox2.Checked = True Then
txtAddCheck.Text = "true"
Else
txtAddCheck.Text = "false"
End If
Dim acc As String = Me.txtCountry.Text
Dim tow As String = Me.txtTower.Text
Dim pro As String = Me.txtProcess.Text
Dim ich As String = Me.txtInvTcheck.Text
Dim ach As String = Me.txtAddCheck.Text
Dim usr As String() = Me.txtUserAdd.Text.Split(New [Char]() {","c, "."c, ":"c, CChar(vbTab), CChar(vbCrLf)})
Dim typ As String() = Me.txtCity.Text.Split(New [Char]() {","c, "."c, ":"c, CChar(vbTab), CChar(vbCrLf)})
Dim inv As String() = Me.txtInvoiceAdd.Text.Split(New [Char]() {","c, "."c, ":"c, CChar(vbTab), CChar(vbCrLf)})
Dim add As String() = Me.txtAddActiv.Text.Split(New [Char]() {","c, "."c, ":"c, CChar(vbTab), CChar(vbCrLf)})
If con.State <> ConnectionState.Open Then
con.Open()
'MsgBox("Open")
Else
'MsgBox("Error!!")
End If
For Each user As String In usr
If user.Trim() <> "" Then
For Each Type As String In typ
If Type.Trim() <> "" Then
For Each invo As String In inv
If invo.Trim() <> "" Then
For Each addi As String In add
If addi.Trim() <> "" Then
Dim constr As String = "INSERT INTO tblAdministratorData (TimerAccount, TimerTower, TimerProcess, UserT, CityT, InvoiceType, [Additional], InvoiceCheckT, AdditionalCheckT) VALUES (@Account, @Tower, @Process, @User, @CityT, @Invoice, @Additional, @InvCheck, @AddCheck)"
Dim cmd As SqlCommand = New SqlCommand(constr, con)
cmd.Parameters.AddWithValue("@CityT", DbNullOrStringValue(type))
cmd.Parameters.AddWithValue("@Invoice", DbNullOrStringValue(invo))
cmd.Parameters.AddWithValue("@Additional", DbNullOrStringValue(addi))
cmd.Parameters.AddWithValue("@User", DbNullOrStringValue(user))
cmd.Parameters.AddWithValue("@process", DbNullOrStringValue(pro))
cmd.Parameters.AddWithValue("@Tower", DbNullOrStringValue(tow))
cmd.Parameters.AddWithValue("@Account", DbNullOrStringValue(acc))
cmd.Parameters.AddWithValue("@InvCheck", DbNullOrStringValue(ich))
cmd.Parameters.AddWithValue("@AddCheck", DbNullOrStringValue(ach))
cmd.ExecuteNonQuery()
End If
Next addi
End If
Next invo
End If
Next Type
End If
Next user
con.Close()
MsgBox("Closed, Saved!")
End Sub
Now I'm fighting with DBnull.Value...;/....
for DbNullOrStringValue I have this code:
Public Function DbNullOrStringValue(ByVal value As String) As Object
If String.Is
LordVovin
3-Jul-13 16:06pm
View
the thing is that, they're updating it using excel file, which we get from the market (vendor). We have Country, City, Invoice type, activity type, additional type. And there are few records with the data. So I would liek to add data from "excel columns" (for example City) to multiple textbox City, and other data from other columns using metod - Copy Paste ;) After the employee will put all the data into the form, I can see it, and then, I can mamange their work. After my "check" in the form with comboboxes that I mentioned earlier, They will use their version with values that I will assign for them (using user name)...so it's a little bit more complicated ;)
hehe, I'm from Wroclaw :)
Nice to meet you :) - virtually, but always :)
Thank you!
LordVovin
3-Jul-13 14:51pm
View
Well, I've made insert into statement with parameters for upload, and it works, but after upload to the database (to the table), I have my form, where I can choose the data from the comboboxes (I will choose Poland for example, then Warsaw, and in third combobox I can see all items for Warsaw), but when I want to change the item in City combobox, they're getn' multiplaying in it...
LordVovin
30-Jun-13 18:31pm
View
Okay, not necessary, thank you for your help Mike!
LordVovin
30-Jun-13 17:08pm
View
Thank you Mike! okay, so now my questions is, how to put all items from Multiline textbox (it was previously used to fill MySettings with items for the combobox), to table in access? I cannot find any code, how to do that...
thank you in advance!
LordVovin
30-Jun-13 7:10am
View
do you mean, to put all the data to the database and store them, for example in table? (Combobox1 to table1, combobox2 to table2...) and then do make databinding for comboboxes?
Show More