Comments by diablo22 (Top 61 by date)

i cannot manage to do it, my code above not work at all

because i want to store it in program, cause when admin login will have stuff that he can see only in program others will not see it :)

Anyway i managed to do it another way and rebuild the code total :)

DataDisplay_SelectedIndexChanged i do not have SelectedIndexChanged only SelectionChanged, Datagridview doesn't has this

so you mean i do not need to use inc at the whole source, hmm but my question now is if i use selectedindexchange. For example if i run program and not touch the datagridview and directly click button next record to show, how does it will read to go next row? sorry for stupid question just need to understand logic :)

you didn't understand me correct i will not load pictures that are 1000x1000 or more.
The point of this is to load form and show the picture itself nothing else. Some pictures are small others are little more like little more is (200x150) for example.
Thats why i want the form to be resized as the picture size it is. Its like Preview image form display

i also readed about ? and @ and both methods works pretty fine for that and for me @ is much better to make the code

yeah i learn fast and manage to do it that is good ;)

i can fix this on later stage, currectly im interested on the function to do it

i readed about a little and also number order matter in this call, also the calls must before the command to get the names, also i fixed the parameters that makes problems too to database , now they are equal and correct too

i think i found the problem when i use :
.Parameters.AddWithValue("@uName", TextBox1.Text)
.Parameters.AddWithValue("@uNumber", TextBox2.Text)
.Parameters.AddWithValue("@uSupp", TextBox3.Text)
.Parameters.AddWithValue("@uStore", TextBox4.Text)
.Parameters.AddWithValue("@uCount", TextBox5.Text)
Works correct everything...So i need to check out the parameters

that is correct, and when i try to update it it fails and says needs 6 arguments, and i think that in picturebox fails to get the data

yes, my mistake in copy here, but its just for test i add this to see..that it doesnt recognize to have picture.
The problem comes when execute the query, it doesn run it because it expect 6 arguments

yes i sow that and i changed it to -
DatatableName As DataTable
DatatableName = dt
but in form2 doesnt display columns when load

if i make it (Datatable As DataGridView1) it will be underline this name as option

thanks for information it is usefull to know that cannot call the column name in query.
but any ideas how to then call only datagridview name to display the results even if i remove the table name

if i use like Datatable As DataGridView
it cannot do the function Datatable = dt.DefaultView

yes that why i write topic, for support how should be where is the problems tips to solve it.

i found this and used it with little edit anad the 3 options password is protected in database so if someone will need it can check it out too thats why i leave it.

You were right i total forgot about the "reserved name" thank you very much, also i sow another problem that i execute 2 times the code so i fix this too now.
About the password protection i didn't understand from the link how to do it.

If you could better explane me how to do it would appriciate it. Thank you.

already tried without class name or default the result was the same.
For my bad luck its not working well in vb.net as i need so i need to present everywhere manual dim's and reads. Or i cannot find a better solution for this strange. In c++ do not have that kind of problems, but i'm learning on vb.net now as hobby for me. Will search more if i found solution will write it here

i'm idiot maybe...
Public Sub CreateMe()
Dim source As New IniConfigSource(MyConfigFile)
'Read Strings From File
Dim fileName As String = source.Configs("Update").Get("Url")
Dim columns As String = source.Configs("Update").Get("Info")
End Sub
This make strings read correct now...

if i build new project and use my code it works...normal
but on my main project it doesn't ...that's what i want to find out why..

i sow this topics, but it doesn't describe how can i make it by module to store all stuff inside.
in c++ is easy to pass strings but on vb.net i'm not familar how to do it with module.
For me my code should work, but it doesn't for somehow it stuck on this when debug "Settings.BackUPFolder" looks like cannot read the string text

how to make with timer to automatically update listbox1 items inside?

For example in Listbox1 has 3 items (3 folders that are inside folder Created)
- Test1
- Test2
- Test3
this is displayed in listbox1 when form opens (get count of folders and their names and put it in listbox)

If I go to folder Created> and delete folder Test1
With timer inside the form to check does it has something else (to update the listbox items)
So it will check that now it has 2 folders inside Created, and will update Listbox1 with items
- Test2
- Test3

No use databound or other just simple get stuff. Program is vb.net winform.
If i use the tick to use the same function it just add non stop the folder names unlimited. I need some result how to do this in better way

as i mention in my post i have problem with excel stay in task manager, this is temporary fix and close it for sure.
I could not find any good library free for work with excel files thats why i try with default methods (witch is not good option)

the default code that comes with autoupdate .net is added in first post somehow i'm trying to figure it out how to make it in vb.net

When form loads after specific time to check for updates (to call this timer)

as you mention i looked around my code and you were right that i have left empty places for sql injection i just test it myself, so one idea that you mention i will give example so other people may found it usefull too.
Wrong and easy to sql injection query:
.CommandText = "SELECT * FROM users WHERE uname = '" & theForm.txtUsername.Text & "'"
must become like this:
.CommandText = "SELECT * FROM users WHERE uname = @UserName"
.Parameters.AddWithValue("@UserName", theForm.txtUsername.Text)

correctly i fixed it and i do not need using blocks method my mistake was that i was using the same definition 2 times and the catch ex found it and replace it now works like a charm creation of accounts without problems. If user exists = sorry , if not create it.

as far as i read the best option for anti-inject is to use parameters like i do in my function i don't know is it true so far or how to test to make sql inject to see is it going to work

great now all is fine i found that i cannot use here the same for bouth calls
.CommandText = "INSERT INTO users (uname,upassword,ucode,ucreate,utools,usearch) VALUES (@user,@pass,@ucd,@crt,@uto,@usrh)"
.Parameters.AddWithValue("@user", theForm.txtUsername.Text)
.Parameters.AddWithValue("@pass", theForm.txtPassword.Text)
.Parameters.AddWithValue("@ucd", theForm.AdminCheck.Checked)
.Parameters.AddWithValue("@crt", theForm.CreateCheck.Checked)
.Parameters.AddWithValue("@uto", theForm.ToolsCheck.Checked)
.Parameters.AddWithValue("@usrh", theForm.SearchCheck.Checked)
.ExecuteNonQuery()
.Parameters.Clear()
.CommandText = "INSERT INTO personal (pacc,pName,pEmail,pYazaki,pPhone,pPosition) VALUES (@userx,@name,@email,@yazaki,@phone,@position)"
.Parameters.AddWithValue("@userx", theForm.txtUsername.Text)
because it gives error parameter is already defined so i changed it to -> userx and all fine. Thank you

i found it the problem, just visual studio give errors some times and need restart to functional correct.
But your idea was perfect..to give in Function Public Sub RegisterUser(ByVal theForm As UsersAddCP) string to use
Then in button click i just use RegisterUser(me) ,because i cannot use same name it must be me, then the function is called correct and read correct the theForm.txtUsername.Text)
Perfect will make a little tests more to view it and will report back in few minutes

when i do it to change it to like this:
Public Sub RegisterUser(ByVal theForm As UsersAddCP)
...
' Instead of UsersAddCP.Control.Text, use theForm.Control.Text:
.Parameters.AddWithValue("@user", theForm.txtUsername.Text)
...
End Sub

i got underline txtUsername is not a member or UserAddCP

so i need something in form2 when enter fields and click button to use in register some public definitions so can access to form2 information, can you give me a little help or example what must i do for better make the stuff works? even if its other method to make the register working with the panel option. Thank you

i had viewed the video, but this is not what i need. I need when execute the module to read the textboxes information, and this video is to send information from 1 form to other in fact this is not what i need, i need when its called the form2 inside the form1 to read the information from textboxes when press the button inside the form2 to create the new account

Can you give more details or example what you mean, sorry I couldn't catch your point.
Thanks in advance.

thanks I will check it out when I get back at home, because now i'm at work and cannot view it. Maybe the problem is with read/write permissions between the forms and doesn't get what I type in form2 when its called and pressed the button while its active inside the form1. As you mention maybe there is solution for this with pass the values between forms

there is no way to solve this problem, because I want to make a more effected program not to display new forms and close previous and stuff like this, something like 1 main form and display features from other forms fill out the information save read that's it not possible?

What I want to do is like this:
New Project>VB.net>Form1
In Form1 I have added Panel1
In form1 I have added 1 button to open form2 inside the Panel1 (that in source Form1 is named as AdminMenu)
The code is above to call the form2 (that in source is named UsersAddCP)

So what I have in Form2 (UsersAddCP)
I have 7 textboxes + 4 checkboxes + 1 button to save

Okay so lets begin,
When I click in form1 the button to call the form2 inside the panel1 its working fine.
But when I try to write in the textboxes something and click the button.
The button calls for the function RegisterUser() and inside the database it create new record but with empty fields.
Okay what I try I try to put on Form2 all textboxes (Text = "some default text") and I run the program and without to write anything to the textboxes because they have now default value text and click the button it create in database the records correctly.

So how to fix this problem when I try to enter information to the textbox to record it to the database?

it gives error on msgbox(ex.message) this:
Additional information: Conversion from string "System.NullReferenceException: O" to type 'Integer' is not valid.

maybe code fails when run because in database i have integer for columns
ucode,ucreate,utools,usearch (they are integer) because need to insert only 1 or 0 in field
and code fail with error on integer maybe this is the roof problem?

i already write what error i got with the code above i have problem with the query it cannot execute bouth at the same time only the first one is runned the second one give me error ex.message msgbox and doest insert the information. i do not got any better clue or error that can help me, thats why if there is another way to execute 2 tables at the same time someone to help me out or give example for better way to do it right. Its not recommended to be the same code only to make it work need.
Thanks

any example because i do not understand how should it be?

in form loads i have this:
If My.Settings.Logs = False Then
enableLogs.Checked = False
Else
enableLogs.Checked = True
End If

i try like this:
Private Sub enableLogs_CheckedChanged(sender As Object, e As EventArgs) Handles enableLogs.CheckedChanged
'If enableLogs.Checked = False Then
' Logger.log("[Admin Name: " & lblGetName.Text & "]" & " Changed Option" & " " & "Disable Logs")
'End If
If enableLogs.CheckState = CheckState.Checked Then
Logger.log("[Admin Name: " & lblGetName.Text & "]" & " Changed Option" & " " & "Enable Logs")
ElseIf enableLogs.CheckState = CheckState.Unchecked Then
Logger.log("[Admin Name: " & lblGetName.Text & "]" & " Changed Option" & " " & "Disable Logs")
Else
'
End If
End Sub
and in my log when form loads it records the information when form loads
[10:03:24][Admin Name: admin] Changed Option Enable Logs
any ideas?

Okay thank you i didn't noticed how was it, but thank you for the remark will know now for sure.

i guest the only problem comes only from here but nobody noticed it
SQLRETURN Result = SQLConnect(this->m_hConnection, (SQLTCHAR *)m_szDatabase, SQL_NTS, (SQLTCHAR *)m_szUser, SQL_NTS, (SQLTCHAR *)m_szPassword, SQL_NTS);

Here if User,Password,Database are wrong return false, check my other topic there doesnt has a problem with connection or infinity loops of application, but it doesnt read database tables
http://stackoverflow.com/questions/34481334/read-custom-string-from-file-in-connection

isnt that:
if (SQLGetDiagRec(SQL_HANDLE_DBC, this->m_hConnection, sRecord, SqlState, &NativeError, SQLMsgError, sizeof(SQLMsgError), &MsgLen) != SQL_NO_DATA)
{
//cLog.ConsoleOutput("SQLSTATE:%s, Diagnosis:%s", SqlState, SQLMsgError);
}

i do not understand more , i cant fix it myself please help me out to fix the code all day and night i search for solutions on internet, nowhere can find how to fix this

so if(Result == SQL_SUCCESS_WITH_INFO)
{
Message(Same)
}
else
{
Message(Not Same Result)
}
It show message SAME..
But if i try like this:
if (Result == SQL_SUCCESS)
{
MessageBoxA(0, "Same!", "Error", MB_OK);
}
else
{
MessageBoxA(0, "Fail!", "Error", MB_OK);
}
Return FAIL , but even if i use correct information for login gives Fail

how to make this please provide me some code so i can test and fix this faster, thank

i have in call function this:
void ReadySQLConnect()
{
//cSQL.Connect();
if (cSQL.Connect() == FALSE)
{
MessageBoxA(0, "Failed to connect to Database!", "Error", MB_OK);
::ExitProcess(0);
}

}
But it doesnt work, if my username or password are wrong doesnt show message this is what i want to fix, help me out here

to change with what, give me idea, or please show me how it should be

so can someone help me to fix this code, i must use information from .ini to get user password and database

the problem is that even if i use wrong User and Password it still connect
but if i change Database Name to other wrong, Application is going on looopss.
To solve this i need an check IF USERNAME = WRONG ERROR
IF PASSWORD = WRONG ERROR
IF DATABASE = WRONG ERROR
Simply fix, if all are correct = CONTINUED