Comments by Muhammad nur Ihsan

Muhammad nur Ihsan 16-Sep-18 4:15am View

can you explain that for?
what do i put inside here?

using (StreamReader sr = new StreamReader(openpath))
    {
        // read the text
    }

Muhammad nur Ihsan 5-Sep-18 0:40am View

Deleted

ok now this's my DAL.cs

namespace CS_Sistem_Managemen_Restoran
{
    class DataAccess
    {
        public SqlConnection con;

        public void Connection(string spName = null)
        {
            string strConnect = "Server=PC\\SQLEXPRESS;Database=MyLoginApp;Trusted_Connection=True;";
            SqlConnection conn = new SqlConnection();
            SqlConnection dt = new SqlConnection();
            

            try
            {
                //Connect to the database
                conn = new SqlConnection(strConnect);
                conn.Open();

                //Execute command
                SqlCommand cmd = new SqlCommand(spName, conn);
                SqlCommand command = conn.CreateCommand();
                SqlDataReader dr = cmd.ExecuteReader();

                


            }
            catch (Exception ex)
            {
                
            }
        }
         
    }
}

this's my form1 Button
private void btnHitung_Click(object sender, EventArgs e)
        {
            DataAccess conn = new DataAccess();
            conn.Connection();
            DataTable dt = new DataTable("Products");

            //declare
            Double BasoSUCost = Convert.ToInt32(dt.Rows[1]["price"].ToString());
            Double ItemBasoSU; Double HargaBasoSU;
            
 if (int.TryParse(txtBasoSU.Text, out NumberofOrder))
            {
                ItemBasoSU = Double.Parse(txtBasoSU.Text);
                HargaBasoSU = BasoSUCost * ItemBasoSU;

 txtTotal.Text = String.Format("Rp. {0:N} ", HargaBasoSU);    
}

gets me error after run in

Double BasoSUCost = Convert.ToInt32(dt.Rows[1]["price"].ToString());

IndexOutOfRangeException 'There is no row at Position 1.'

why is that

Muhammad nur Ihsan 4-Sep-18 11:32am View

please can you explain one more time?

Muhammad nur Ihsan 4-Sep-18 10:52am View

its rly hard to study a c# by self for me because in my universty doesn't give any clue about it :(

Muhammad nur Ihsan 4-Sep-18 10:49am View

cmon man Dx im still confuse with it give an example again please to connect my datatable to my Form1

Muhammad nur Ihsan 3-Sep-18 8:31am View

ExecuteScalar: Connection property has not been initialized
what did i miss?
im sorry for still questioning..!

protected SqlConnection conn;

private void btnHitung_Click(object sender, EventArgs e)
{
if (int.TryParse(txtBasoSU.Text, out NumberofOrder))
{
using (SqlCommand cmd = new SqlCommand("SELECT Price From Products WHERE Product = 'BasoSU'", conn))
{
double BasoSUCost = (double)cmd.ExecuteScalar();

ItemBasoSU = Double.Parse(txtBasoSU.Text);
HargaBasoSU = BasoSUCost * ItemBasoSU;
}
}

Muhammad nur Ihsan 3-Sep-18 7:57am View

can you explain the "double value = (double)cmd.ExecuteScalar();"

protected SqlConnection conn;

private void btnHitung_Click(object sender, EventArgs e)
{
using (SqlCommand cmd = new SqlCommand("SELECT Price From Products WHERE Product = 'BasoSU'", conn))
{
double value = (double)cmd.ExecuteScalar();
}

Muhammad nur Ihsan 3-Sep-18 7:50am View

dang.. can i give my source to ya and help me out xD or how can i upload a picture here.. thanks for the respond anyway but still confuse me

Muhammad nur Ihsan 3-Sep-18 7:36am View

yes my database name is MyLoginApp and the Table name is "Products"
please help i want to make the 2000 be BasoSUCost so i can make a calculate from it :(

i want to set the 2000 to be BasoSUCost in here

private void btnHitung_Click(object sender, EventArgs e)
{
if (int.TryParse(txtBasoSU.Text, out NumberofOrder))
{
ItemBasoSU = Double.Parse(txtBasoSU.Text);
TotalPriceOfBasoSU = BasoSUCost * ItemBasoSU;
}

Muhammad nur Ihsan 3-Sep-18 7:06am View

ok , what is con for?

private void btnHitung_Click(object sender, EventArgs e)
{
using (SqlCommand cmd = new SqlCommand("SELECT Price From Products WHERE Product = 'BasoSU'", con))
{
double BasoSUCost = (double)cmd.ExecuteScalar();
...
}

Muhammad nur Ihsan 3-Sep-18 6:51am View

yes a product column containing the text BasoSU
and a price column containing the text 2000 <-- i want to make a calculation like 2 * 2000 and set it to BasoSUCost in

"private void btnHitung_Click(object sender, EventArgs e)
{
if (int.TryParse(txtBasoSU.Text, out NumberofOrder))
{
ItemBasoSU = Double.Parse(txtBasoSU.Text);
TotalPriceOfBasoSU = BasoSUCost * ItemBasoSU;
}"

Muhammad nur Ihsan 3-Sep-18 6:44am View

before im using the sql server to make a data i just write the value in the cs form like this

public partial class Meja1 : Form
{

//HARGA - PRICE HARGA MAKANAN
double cBasoSU_PRICE = 20000;
double cBasoC_PRICE = 15000;
double cBasoM_PRICE = 15000;
double cBasoB_PRICE = 15000;
double cMieA_PRICE = 11000;
double cMieAB_PRICE = 15000;

public Meja1()
{
InitializeComponent();
}

private void btnHitung_Click(object sender, EventArgs e)
{

//DEKLARASI
// COST //angka inputmakan //var dijadikan dariatas
Double BasoSUCost; Double ItemBasoSU; Double HargaBasoSU;
Double BasoCCost; Double ItemBasoC; Double HargaBasoC;
Double BasoMCost; Double ItemBasoM; Double HargaBasoM;
Double BasoBCost; Double ItemBasoB; Double HargaBasoB;

//MIE
Double MieACost; Double ItemMieA; Double HargaMieA;
Double MieABCost; Double ItemMieAB; Double HargaMieAB;

//CONVERT
//MAKANAN
BasoSUCost = cBasoSU_PRICE;
BasoCCost = cBasoC_PRICE;
BasoMCost = cBasoM_PRICE;
BasoBCost = cBasoB_PRICE;
MieACost = cMieA_PRICE;
MieABCost = cMieAB_PRICE;

if (int.TryParse(txtBasoSU.Text, out NumberofOrder))
{
ItemBasoSU = Double.Parse(txtBasoSU.Text);
HargaBasoSU = BasoSUCost * ItemBasoSU;

if (int.TryParse(txtBasoC.Text, out NumberofOrder))
{
ItemBasoC = Double.Parse(txtBasoC.Text);
HargaBasoC = BasoCCost * ItemBasoC;

if (int.TryParse(txtBasoM.Text, out NumberofOrder))
{
ItemBasoM = Double.Parse(txtBasoM.Text);
HargaBasoM = BasoMCost * ItemBasoM;

if (int.TryParse(txtBasoB.Text, out NumberofOrder))
{
ItemBasoB = Double.Parse(txtBasoB.Text);
HargaBasoB = BasoBCost * ItemBasoB;

if (int.TryParse(txtMieA.Text, out NumberofOrder))
{
ItemMieA = Double.Parse(txtMieA.Text);
HargaMieA = MieACost * ItemMieA;

if (int.TryParse(txtMieAB.Text, out NumberofOrder))
{
ItemMieAB = Double.Parse(txtMieAB.Text);
HargaMieAB = MieABCost * ItemMieAB;

mcFoodTotal = HargaBasoSU + HargaBasoC + HargaBasoM + HargaBasoB + HargaMieA + HargaMieAB;

txtServisMakanan.Text = String.Format("Rp. {0:N} ", mcFoodTotal);
}
}
}
}
}
}
i want to use the sqlserver to store the data so i can modify the value easily but it actually hard as hell lol

Muhammad nur Ihsan 3-Sep-18 6:38am View

alright so i have 2 column there is "Products" and "Price" i only have 5 rows one of em is "BasoSU" it has "2000" for price, like i want to multiply his price with the whatever number inputed from the textbox.... pls give an example again.. what do evrything i need to add to the program.

and btw the class DAL is for the login & register form do i need to create a class again for this problm?

Muhammad nur Ihsan 3-Sep-18 5:51am View

its really hard to understand i just wanted to get the value from the datatable to my textbox..

Muhammad nur Ihsan 3-Sep-18 5:38am View

what is double value; for? how do i get the value from the sql server datatable exactly..

Muhammad nur Ihsan 22-Aug-18 21:33pm View

im wanted to deploy the database onto client i think.. , another problem of mine every i add prereqissites and choose to download from the same location as my application, i cant install the application and why there is no Windows Installer option in my prerequistes

Muhammad nur Ihsan 22-Aug-18 0:58am View

can you tell me how? to make my program work for my 2nd device do i need to install the server (sqlexpress) manually?

Muhammad nur Ihsan 19-Aug-18 7:58am View

im still getting error can you help to fix?

SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\testlogin.mdf;Integrated Security=True;Connect Timeout=30");
String Query = "Select Count(*)from LogInfo where UserName='@Uname" + TxtUsername.Text + "' and password='@pwd" + txtPassword.Text + "'";
SqlCommand cmd = new SqlCommand(Query, conn);
cmd.Parameters.Add(new SqlParameter("@Uname", TxtUsername.Text));
cmd.Parameters.Add(new SqlParameter("@pwd", txtPassword.Text));
DataTable dt = new DataTable();
if (dt.Rows[0][0].ToString() == "1")
{
this.Hide();
ListMeja lm = new ListMeja();
lm.Show();
}

Muhammad nur Ihsan 19-Aug-18 7:43am View

Deleted

SqlCommand does not contain a definition for 'Parameter' and no extension method 'Parameter' accepting a first argument of type 'SqlCommand' couldn't be found.. what does it mean..?

private void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\testlogin.mdf;Integrated Security=True;Connect Timeout=30");
String Query = "Select Count(*)from LogInfo where UserName=@uname and PassWord=@pwd";
SqlCommand cmd = new SqlCommand(Query, conn);
cmd.Parameter.Add(new SqlParameter("@Uname", TxtUsername.Text));
cmd.Parameter.Add(new SqlParameter("@pwd", txtPassword.Text));
}

Muhammad nur Ihsan 19-Aug-18 7:38am View

Deleted

do i put them in btn? like this?

private void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\testlogin.mdf;Integrated Security=True;Connect Timeout=30");
String Query = "Select Count(*)from LogInfo where UserName=@uname and PassWord=@pwd";
SqlCoomad cmd = new SqlCoomand(Query, conn);
cmd.Parameter.Add(new SqlParameter("@Uname", TxtUsername.Text));
cmd.Parameter.Add(new SqlParameter("@pwd", txtPassword.Text));
}

The type or namespace name 'SqlCoomad' could not be found().. what should i do now? tx

Muhammad nur Ihsan 18-Aug-18 22:20pm View

so.. any idea which the best way to make a login form? im new to this sry

Muhammad nur Ihsan 12-Aug-18 7:08am View

thanks man im stuck there finding solution about 5hours xD

Comments by Muhammad nur Ihsan (Top 22 by date)