Comments by jamesmc1535 (Top 135 by date)

thanks, i sortoff fixed it, the datagrid updates into the database now , without problems, but i cant delete a row in the datagrid ( as i have no collum as primary key , but when i set a collum to primary i get that null error

sda.Update(dt);

sda.Update(dt);

sda.Update(dt); <

thanks ill try that quickly

but where? XD , starting it over again as i dont see the null value,

very nice explanation , i have no idea where i went wrong , doing it over again :) thanks alot

okay makes sense ? but where do i change it? within the cod? and use the
Navigation.InsertPageBefore cmd?

what more information must i provide? basicly as the problem isnt with the code coz the changes take effect when running thru an emulator, but when i run thru a real device it doesnt show the changes,wether im just renaming the buttons, it doesnt take effect on the real device, only on the emulator

whaat part of the code? as the problem isnt with the code coz the changes take effect when running thru an emulator, but when i run thru a real device it doesnt show the changes

thanks alot :)

the dates are that because the login form is a open source project, its got a page afterwards the login with text " main app goes here. so i want to basicly just replace that "window" with my buttonlogger app

xmlns="http://xamarin.com/schemas/2014/forms" xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml" x:Class="LoginNavigation.LoginPage" Title="Login">
theres mine that i currently have.

do i need to change the schema of both of them to the same thing?

thanks , i will try this quickly :)

thanks it was exactly what i was looking for :)

thanks :) really appreciate it, will have a look at that quickly :)

very good example, sorry for not being able to be more precise,as im not fully certain on what precisly needs to be done, basicly for now id like to create an app that shows all the current processes/exe"s thats running, but the main idea is like for instance when playing a game , it must show the exe of the game and the runtime of the game running , example: so if you open chrome.exe it shows in the application chrome.exe : 1 hour

il get a device tomorow to test it on, thanks for all youre help i really apreciate it :)

i dont know, the emulator does have a gps setting as well as location services, and lattitude and stuff like that

thanks ill look into it , im using an emulator and not an actual android device? could that be the problem?

yes , i have it switched it on

nvm thanks for the help , fixed it , had to just sign in my xamarin acc

okay thanks :) , like do a recode? or is there an option/

nope not completly?

i fixed it now but now i get this message Error parsing XML:unbound prefix(APT0000)

<translate xmlns:android="http://schemas.android.com/apk/res/android"
android:fromXDelta="0" android:toXDelta="100%p"(get the error here)
anddroid:duration="500"/>

XD !!! thanks !! XD aaah feel stupid now

sorry , i havent done that code yet , because i dont know what methods to use , :)

XD !!!! sorry thanks for pointing it out ... now i feel stupid :(

thanks for all the help really appreciate it , got it sorted out ,i had the liniar on top as well it just didnt add it to the message , i closed the program and started over, my error was lack of xml knowledge, XD , like for instance i did not add

https://www.youtube.com/watch?v=tf2O_t-ayJ8 < this is the tutorial i was following and i did everything the same..

i changed it to on all the roots? but i got an error now saying , "not well informed"

i will change it quickly , this is from a tutorial i was following to get used to the xamarin layout ect ect

im not sure i understand what youre explaining to me XD .

sorry about that i tagged it with c# because i dont know what else i shouldve tagged it with , but i got it sorted , thanks anyways

just another question , android studio? is it for c# or java? bcoz so far all tutorials ive seen of c# leads to xamarin for some odd reason??

thanks alot :)

lol it wont be for comMercial use - im just doing it for myself , it wont be a full on browser, instead ill just redirect to googles address :) its just a fun project that i want to play with XD

oh okay now i understand lol

thanks alot :)

thanks for the help :) - im confused now, why did it get a downvote :x ??

okay ill try it like that , i want to make like a email thing that sends to my email address when my pc gets switched on, i have the email sending working but its with a button click - not auto click ,

dam xamarin is expensive !! 0_0

alright :) do u use the xamarin studio , or can u also just use the xamarin plugin for visual studios?

thanks , im going to look into those now :)
another small question , do i have to use xamarin? or what andriod sdk would u prefer?

thanx :) worked exactly as i wanted to

thanks sorry for the few detail , but i dont know how to type the problem XD

thanks :)

okay , thanks, uhm where would this be ? "Programs and Features > Visual Studio 2015 > Change)" ??

its for a point of sale system , so atm its for my "staff" table , so it generates a report showing all available staff - names-email ect ect
so basicly its for like a cash up? so end of the day you generate a report showing the days sales

thanks alot :)

okay i wil try that quickly , and this will also work on the filter? toshow enabled or disabled users

i did , asked them told them my problem but i havent gotten a reply yet

oh okay thanks, because for one of my future projects i want too try something like that out , so before im investing time into it i wanted to first understand the possibilities, bluetooth would be a problem id say because you might not always be in range, so ima try it with sms ;)

never mind fixed it , > listBox1.DataSource = empList;> was accidently removed

0 at the moment but i have an add option , when i add to the database it still does the same

how would i do it using a timer? added a timer. on events i added >
listbox1.indexchanged >
with the listbox1.refresh();
?

i have one more question? want to know if its possible to add like the .net framework 4 instalation in with my program
?

thanks man its working now

thanks for your effort, but those to tutorials show how to install it using vs 2010 which still has the template for setup installer, im using 2015 which doesnt have that template

thanks man , because at the moment getting the progam to install is harder than the actual program was :o // thanks alot for youre help

yes i want to create a setup for my program , so i can istall it on other computers

im using 2015 and ive read multiple times that visual studios doesnt support it no more

alright makes sense , but to what is it refering to as already installed,? coz this is the 1st instalation i did

oh thanks man now it makes more sense :) because i wondered what that was so now u cleared that up :)

yes its working now thanks

just another small follow up question>when i click delete it deletes but i have to close the form and reopen it again for the listbox to update is there a way to make it able to auto update so when i click remove its removed from the listbox instantly?

nevermind fixed it it worked i changed it 2 that but forgot to change
cmd.Parameters.AddWithValue("@id", listBox1.SelectedItem.ToString());
to
cmd.Parameters.AddWithValue("@name", listBox1.SelectedItem.ToString());

Must declare the scalar variable "@name"
lol XD

okay my code looks like this now >
SqlConnection con = new SqlConnection("Data Source=JAMES-PC\\SQLEXPRESS;Initial Catalog=staff;Integrated Security=True");
con.Open();

string sql = @"DELETE FROM staff1 where Id=@id;";

SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@id", listBox1.SelectedItem.ToString());

cmd.ExecuteNonQuery();
con.Close();<pre>
but i still get this error >
Conversion failed when converting the nvarchar value 'michsafj' to data type int.

i hate sql :D uhm im goin to tell you how i made my table /
started query > create database staff1
use staff1

>create table name(
id primary key identity < is that hat you were refering to ?

okay my table names are ass follows
name / surname / homead / location / position / cellnum / email listbox uses (name)
they all are varchar(50)

Conversion failed when converting the nvarchar value 'james' to data type int. get a error

thanks ill do that quickly

did that,ran the program , got error ? must declare a scalar variable @name

my friend helped me out with the code and he said i should add that part,so no i didnt insert that part i jus followed advice? / is it needed? how would i know if its needed?

its working, thanks alot man i apreciate it alot

thanks didnt notice i did it there, sorry if im asking stupid questions, but i might ask 1 more :) i remove the second part but i stil do get this>
The type arguments for method 'DataRowExtensions.Field<t>(DataRow, string)' cannot be inferred from the usage. Try specifying the type arguments explicity
code>var empList = Ds.Tables[0].AsEnumerable().Select(dataRow => dataRow.Field("username")).ToList();

comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox1.DataSource = empList;

my code >DataSet Ds = new DataSet();

string strConnectionString = "Data Source=JAMES-PC\\SQLEXPRESS;Initial Catalog=login1;Integrated Security=True";

SqlConnection objconnection = new SqlConnection(strConnectionString);
using (SqlCommand cmd = new SqlCommand("SELECT [username] FROM [user1]",
objconnection))
{
using (SqlDataAdapter adapter = new SqlDataAdapter(cmd))
{
adapter.Fill(Ds);
}
}

var empList = Ds.Tables[0].AsEnumerable().Select(dataRow => dataRow.Field("username")).ToList();

dataRow.Field<int>("username")).ToList();
comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox1.DataSource = empList;

comboBox1.SelectedIndex = 0;
my errors>The name 'dataRow' does not exist in the current context
The name 'ToList' does not exist in the current context
The type arguments for method
'DataRowExtensions.Field<t>(DataRow, string)'
cannot be inferred from the usage. Try specifying the type
arguments explicitly.

i entered it as u said but my datarow says does not exist , shud i create it or am i missing a refrence?

lol XD this sqls doesnt like me, struggle alot with it -_- my mind just doesnt want to learn thanks il go do a quick check :)

thanks for the advice i will check quickly , when i run it and i get te eror i have the options,, details and continue,and quit but when i quit it doesnt show the line thats faulty, if i say continue the combobox is still emty XD (oviously) but the details shows this


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Specified cast is not valid.
at System.Data.DataRowExtensions.UnboxT`1.ValueField(Object value)
at login_form.add_user.<>c.<add_user_load>b__2_0(DataRow dataRow) in C:\Users\james\New folder\POS\pos\login form\add user.cs:line 53
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at login_form.add_user.add_user_Load(Object sender, EventArgs e) in C:\Users\james\New folder\POS\pos\login form\add user.cs:line 51
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
login form
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Users/james/New%20folder/POS/pos/login%20form/bin/Debug/login%20form.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Data
Assembly Version: 4.0.0.0
Win32 Version: 4.6.81.0 built by: NETFXREL2
CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_64/S

i dont know visual studios starts perfectly , its when i run the program and open that form (add user) that i get that error

could it be that im using sql server 2012

i entered everything as u did and i changed all values > i get this error System.ArgumentException: Invalid value for key 'integrated security'.

so at this line >Library=DBMSSOCN;Initial Catalog=empdb;User ID=myusername;Password=mypwd;";
i should enter /Library=DBMSSOCN;Initial Catalog=login1;User ID=JAMES-PC\\SQLEXPRESS;Password=mypwd;"; dont have a password

thanks

thanks

i have another follow up question on this forms ect ect ect, theres a menu where u can edit n forms framework< rightclick properties if i recall perfectly but its not working

ive seen the rating system but didnt know what 5 ed meant lol thanks btw i have another follow up question on this forms ect ect ect, theres a menu where u can edit n forms framework< rightclick properties if i recall perfectly but its not working

i have a quiestion , on all my stuff that u replied u said 5ed. im curious
whats that mean?

yup bitmaps the right one so its workin now

thanks man lol

theres my full code
string barcode = textBox1.Text;
Bitmap bitmap = new Bitmap(barcode.Length * 40, 150);
using (Graphics graphics = Graphics.FromImage(bitmap))
{
Font oFont = new System.Drawing.Font("IDAutomationHC39M", 20);
PointF point = new PointF(2f, 2f);
SolidBrush black = new SolidBrush(Color.Black);
SolidBrush white = new SolidBrush(Color.White);
graphics.FillRectangle(white, 0, 0, bitmap.Width, bitmap.Height);
graphics.DrawString("*" + barcode + "*", oFont, black, point);
}
using (MemoryStream ms = new MemoryStream())
{
barcode.Save(ms, ImageFormat.Png);
pictureBox1.Image = bitmap;
pictureBox1.Height = bitmap.Height;
pictureBox1.Width = bitmap.Width;

like on products at a store, those stripy stuff\

thanks alot

no , as a matter of fact my program i made in framework 3.0 which isnt supported, so ima just change it to 4.5 then it will work,

i might lack basic understanding -_- , but if u read clearly you could see that i asked how do i _enable_ it ,

i know as you can see i asked how do i enable it , cos i cant find system.core under add > refrence

System.Core.dll < cant find it
refrence>add refrence>assemblies>framewor> its not there

thanks

thanks

the name library does not exist in the current context, using System.Linq; < i dont have that and when i type it it doesnt work , shud i add it as a refrence?

thanx but i have 2 follow up questions
!1!- Library = DBMSSOCN; Initial Catalog = staff; User ID = myusername; Password = mypwd; "; - i get a hell lot of errors there
!2!-empcode what do i replace it with coz empdb i figured i replace with my database name

yeah im doing research on it bt i have trouble understanding it,so im using this way to progress further in my program, until i fully understand the parametirized

thanks i did some research on the sql injection , this program im doin is just a test so sql injection aint a big threat at the moment but that@ params stuff is confusing me

the problem was with my connection string

THanx , no need to post it fixed it, see i copied the conection string from a previous connection and forgot to change the catalog= to staff XD

hey bud i just used the updated ,cmd.Parameters.AddWithValue(@username, textBox1.Text);
cmd.Parameters.AddWithValue(@password, textBox2.Text); but i get eror on username and password - does not exist

thanks for the advice, im stil reading up on parameterized .

JEEZ lotta help thanks man
something as simple as that :| and it works

check youtube , there is alot of login forms tutorials

i tried Application.Close(); lol close enuff i guess

Application.Exit(); found the one i was looking for , the thing with this.close(); it doesnt close the application it closes the form

thanks buddy , Application.Exit(); this was the one im looking for xD i remember application- lol -

i stated sqls 2day so im still new @ this. uhm i checked the sql injection - and query parameteriation. thanks alot . its very helpfull \M/ and confusing theres an example on that website of c# but im struggling 2 understand the layout ,if you can and have time , would you maybe try 2 quickly explain it?

okay it works (
\\ ) and the @ but i get another syntax error -
SqlCommand cmd = new SqlCommand("from user1 where username = '" + textBox1.Text + "' and password = '" + textBox2.Text + "'", cn); on the from .any fixes? or advice

lol XD visual studios is against me and you because its the 2nd error me and you have in common

sorry uhm i used that code it works perfect but ive seen now that it diesnt close the 1st form, how do i make it close the form when i click the button?

thanx man \m/ another question , do u perhaps know how i can make the printer selective/ so how to select active printer

thanks man . ill keep that in mind. i did change the name though but i changed it back,dont ask me why XD

aah thanks man

sorry "if (MessageBox.Show("Are You Sure To Exit ?", "Exit", MessageBoxButtons.YesNo) == DialogResult.Yes)
{" but its working now i left the "if" out

lol sorry for the string of question , uhm i added a message box "are you sure /yes no" if i click yes it closes and opens the login form , but when i click no it also closes and opens login
MessageBox.Show("Are you sure", "Logout/switch user", MessageBoxButtons.YesNo, MessageBoxIcon.Question); theres the code how do i add the no to function

tnx man \m/ very helpfull

okay uhm il try that code now, see cos in the 2nd form ill be having a switch user button which re opens the login form