Comments by Boopalslm (Top 169 by date)

yes sir, i want above your details, i will try my DB.

I am use this query already, but I want I am entered ID no -1 10 bills and ID no-2 entered 8 bills
Here I want how to get 1st id last record(10th Bill), and 2nd id –last record(8th Bill), give me some suggestion.

I am use this below code, i am click a button all records are display in my data grid view,

SqlConnection con=new SqlConnection(db.Connectionstring());
DataSet ds = new DataSet();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM sales where cstname='"+txtFind.Text+"'", con);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];

dataGridView1.DataMember = "sales";

}
catch (Exception ex)
{
//Exception Message
}
finally
{
con.Close();
con.Dispose();
}


how to solve this problem.

i am using TVS Thermal printer - please suggestion some better font

This is my code, i am write this code my 2nd comboBox SelectedIndexChanged Event



SqlConnection con1 = new SqlConnection(db.Connectionstring());
con1.Open();

using (SqlCommand cmd1 = new SqlCommand("select * from pardetails where parname='" + comcredeb.Text + "'", con1))
{

using (SqlDataReader dr1= cmd1.ExecuteReader())
{



cmd1.CommandType = CommandType.Text;


using (SqlDataAdapter sda = new SqlDataAdapter(cmd1))
{
using (DataSet ds1 = new DataSet())
{


if (dr1.HasRows)
{




bool Empty = true;



foreach (DataGridViewRow row in dataGridView1.Rows)
{


for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
while (dr1.Read())
{


Empty = true;
for (int j = 0; j < dataGridView1.Columns.Count; j++)
{



if (dataGridView1.Rows[i].Cells[1].Value != null && dataGridView1.Rows[i].Cells[1].Value.ToString() != "")
{
Empty = false;
break;
}
}



if (Empty)
{

row.Cells[1].Value = dr1.GetString(19);
row.Cells[1].Value = dr1.GetString(21);


}



}
}

}

dr1.Close();
con1.Close();
sda.Fill(ds1);




}
}
}
}
}


dataGridView1.Focus();
}

this is windows application not a web application

k sir how to reset bill number every starts from one

how to start every day automatically reset in bill number starts from 1.

Thanks sir it's working good, thanks a lot..........................

I got a result thanks for your help........................Thanks a lot.

how to declare DATED in my gridview.

now i got a error from last line

Object reference not set to an instance of an object.


DataGridViewTextBoxColumn dgvtime = new DataGridViewTextBoxColumn();
dgvtime.HeaderText = "DATED";
dgvtime.Width = 100;
dataGridView1.Columns.Add(dgvtime);
dataGridView1.Columns["DATED"].DefaultCellStyle.Format = @"hh\:mm";

please guide me.

This is my code but not working


DataGridViewTextBoxColumn dgvtime = new DataGridViewTextBoxColumn();
dgvtime.HeaderText = "Time";
dgvtime.Width = 125;
dataGridView1.Columns.Add(dgvtime);
dataGridView1.Columns[1].DefaultCellStyle.Format = "hh:mm:ss tt";

please give me some ideas.

I got it, thanks a lot for your guidance............Thanks a lot....

error came on ImageFormat

The name ImageFormat does not exist in the current context how to solve this error

how to convert give me some ideas.

here i want for example i got a value in my text box 33.16 - i want 33.20 other wise less than ex 33.14 i want 33.10 - how to crate.

in my value <.13 here i want set to .1, other wise >.18 is set to .2

but i got another problem

once stored the data grid view values into database, again I am bind the grid values and Insert into new one row but data grid view calculation is working wrong, first time working is good, once stored and retrieve and insert new row calculation problem, and I am write the code CellEndEdit – Events.

now i got a solution, this is my code working good.

try
{

foreach (DataGridViewRow row in dataGridView1.Rows)
{

if (String.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[4].Value as String))

{
float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());


dataGridView1.Rows[e.RowIndex].Cells[5].Value = (iWei * iPer) / 100;


}

else if (row.Cells[4].Value != null)
{

dataGridView1.Rows[e.RowIndex].Cells[5].Value = "0";

float iWeis = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString
());

float iPers = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString
());

float iWass = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString
());



dataGridView1.Rows[e.RowIndex].Cells[6].Value = (iPers + iWass) * iWeis;


}
}
}
catch (Exception)
{
}

sir else part working perfectly, problem in if condition

if (row.Cells[2].Value != DBNull.Value && row.Cells[3].Value != DBNull.Value)
{

if (row.Cells[4].Value == DBNull.Value)
{
float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
dataGridView1.Rows[e.RowIndex].Cells[5].Value = (iWei * iPer) / 100;
dataGridView1.Rows[e.RowIndex].Cells[6].Value = null;//you can remove it if not needed
}

above code correct, but in 4th cell empty, that time cannot shown calculating values in 5th cell

that is my problem.

yes if condition code 4 cell null, but cannot result shown on 5th cell,

is not per-mentally null some times enter the values in cell 4

i am put a break point in foreach but the script cannot go to inside if condition jump on else part.

In your if condition code cannot multiplication value shown on cell 5, how to solve the error.

this is my code


foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[4].Value != DBNull.Value && row.Cells[6].Value != DBNull.Value)
{
float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());


dataGridView1.Rows[e.RowIndex].Cells[5].Value = (iWei * iPer) / 100;


}


else
{


float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());

float iWas = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());



dataGridView1.Rows[e.RowIndex].Cells[6].Value = (iPer + iWas) * iWei;

}
}
}

this is my code

foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[4].Value != DBNull.Value && row.Cells[6].Value != DBNull.Value)
{
float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());


dataGridView1.Rows[e.RowIndex].Cells[5].Value = (iWei * iPer) / 100;


}


else
{


float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());

float iWas = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());



dataGridView1.Rows[e.RowIndex].Cells[6].Value = (iPer + iWas) * iWei;

}
}
}

this is my code


foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[4].Value != DBNull.Value && row.Cells[6].Value != DBNull.Value)
{
float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());


dataGridView1.Rows[e.RowIndex].Cells[5].Value = (iWei * iPer) / 100;


}


else
{


float iWei = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());

float iPer = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());

float iWas = float.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());



dataGridView1.Rows[e.RowIndex].Cells[6].Value = (iPer + iWas) * iWei;

}
}
}

sir if you don't mind totally alter my code sir. i will spend more and more time sir, but cannot get result.

sir what can i do sir.

no sir, how to use foreach loop in my update query.

above your code

no error, i am bind my previous record, and enter second row but cannot stored second row in data base.

sir if you don't mind please above alter my command because i was already spend 4 days, till now i cannot get result.

sir give me some ideas.

so how alter my queries give me some ideas

i am alter my code your procedure but cannot add to data base second row in same empnames, how to solve this error

sir just guide me sir i will spend 4 days sir. but till now i cannot get result.

below line is correct

empnames=@empnames+'", categories=@categories, weight=@weight,per=@per,wastage=@wastage,customer=@customer,party=@party where date=@date ", con2);

bur error is start on categories=@categories, how to solve sir

what i am do now, sir please alter my update query and send me sir.

HariHari 1 chain 2 2 2 0.04 2 0.130 5 -4.87
Hari 2 chain 3 3 3 0.09 3 0.130 5 -4.87

This is my update qury
SqlCommand cmd2 = new SqlCommand("update sales set empnames=@empnames+'" + comboBox1.Text + "', date=@date, categories=@categories, weight=@weight,per=@per,wastage=@wastage,customer=@customer,party=@party,amtcst=@amtcst,amtparty=@amtparty,amtfinal=@amtfinal where date=@date", con2);

See empnames names cell in first row empnames add 2 times
How to solve this problem.

I got a result..... Thanks to any one trying to my doubt.

Sir i got a answer, thanks for your support.............

data's are stored perfectly to data base. only error is came

The parameterized query '(@customer float,@empname nvarchar(4000),@date nvarchar(10))upda' expects the parameter '@customer', which was not supplied.

i will change cmd2 as per your code

cmd2.Parameters.Add("@customer", SqlDbType.Float).Value = rows.Cells[7].Value;

but below error is came


The parameterized query '(@customer float,@empname nvarchar(4000),@date nvarchar(10))upda' expects the parameter '@customer', which was not supplied.

sir please give me ideas or alter to my total codes and send me sir

i am change cmd3 change on same way to cmd2 but below error is came

this is my else part code

else
{
SqlConnection con3 = new SqlConnection(db.Connectionstring());
con3.Open();



SqlCommand cmd3 = new SqlCommand("insert into stkdetails(customer,empname,date)values(@customer,@empname,@date)", con3);
cmd3.Parameters.AddWithValue("@customer", Convert.ToDouble
(rows.Cells[7].Value));

cmd3.Parameters.AddWithValue("@empname", rows.Cells[2].Value);
cmd3.Parameters.AddWithValue("@date", txtdate.Text);
cmd3.ExecuteNonQuery();
con3.Close();

}


but error is came give me some ideas.

The parameterized query '(@customer float,@empname nvarchar(4000),@date nvarchar(10))inse' expects the parameter '@empname', which was not supplied.

I am alter my code as per your way but below error is came

The parameterized query '(@customer float,@empname nvarchar(4000),@date nvarchar(10))inse' expects the parameter '@empname', which was not supplied.

customer is data grid view column name, data type float, and than below this is my full code

foreach (DataGridViewRow rows in dataGridView1.Rows)
{



SqlConnection con1 = new SqlConnection(db.Connectionstring());
con1.Open();
SqlCommand cmd1 = new SqlCommand("select * from stkdetails where empname='" + rows.Cells[2].Value + "'", con1);

SqlDataReader dr = cmd1.ExecuteReader();


if (dr.HasRows)
{


SqlConnection con2 = new SqlConnection(db.Connectionstring());
con2.Open();


SqlCommand cmd2 = new SqlCommand("update stkdetails set customer=customer+@customer where empname=@empname and date=@date", con2);
cmd2.Parameters.AddWithValue("@customer", rows.Cells[7].Value);
cmd2.Parameters.AddWithValue("@empname", rows.Cells[2].Value);
cmd2.Parameters.AddWithValue("@date", txtdate.Text);

cmd2.ExecuteNonQuery();
con2.Close();


}

else
{
SqlConnection con3 = new SqlConnection(db.Connectionstring());
con3.Open();
SqlCommand cmd3 = new SqlCommand("insert into stkdetails(date,empname,customer)values('" + txtdate.Text + "','" + rows.Cells[2].Value + "','" + rows.Cells[7].Value + "')", con3);
cmd3.ExecuteNonQuery();
con3.Close();

}


}

I am trying your code but below error is came

The parameterized query '(@customer nvarchar(4000),@empname nvarchar(4000),@date nvarchar' expects the parameter '@customer', which was not supplied.

how to solve above error. give me some ideas

The parameterized query '(@empname varchar(8000),@customer float)update stkdetails set cu' expects the parameter '@empname', which was not supplied.

now above error is came, what can i do give me ideas.

how to solve the error

below error is came

The parameterized query '(@customer nvarchar(4000),@empName nvarchar(4000))update stkdeta' expects the parameter '@customer', which was not supplied.

rows.Cells[2].Value - this is proper parameterized cell value. but error is came

sir it's working good, thanks a lot.

sir it's working good, but second text box add +2 i want +1 only, how to solve this error.
Ex

first text box : 115
sec text box : 11

your code result

first text box 11

second text box 13 (here i want +1 only so result 12 only but result come +2)

once first text box value greater than 100 it's adding +1 for second text box, it's working good now, but same time how to mines first text box value 100.

Ex
first text box having : 115
second text box having : 10

i want result
first text box :15
and then second text : 11

how to create, give me some ideas.

It's working good thanks for your help, it's same time minus 100 for textBox2 how to create.

Your above code already i am used it's working good and calculating single cell values, but how to calculate both cell values and result shown on same text box. and then i want second cell convert decimal values.


Ex:
slno mts cms
1 5 2
2 3 4

I want 8.6

How to Calculation in DataGridView column values. Shown on text box

I got answer..... Any one thanks to try my error.

your code is working good, but how to now update, i am adding new one row for data grid view now how to store same bill number for my new row.

sir one more doubt, how to bind null values in text box,

this is my text box bind code

txtstaff.Text = dr[0].ToString();

values cannot dispaly. Give me some ideas. Above text box having null values and some rows having text.

sir super, working fine,thanks a lot, i am spending more than 5 hrs above for this error,thanks a lot.

Above your query is working good, thanks for your query sir. Thanks a lot.

Sir thanks a lot working super and again thanks.

k its working fine , but shown value zero(0), but my grid view cells having some values.

i am change your if statement line but
before run error is came

invalid expression term '}'

Same error is came.

val += Convert.ToDecimal(item.Cells[9].Value);

Object cannot be cast from DBNull to other types.

i know, but my cell index is 9, i am set 9 for cell index, in 9th cell some empty cell are available so below error is came.

Object cannot be cast from DBNull to other types.

Error is came for below line

val += Convert.ToDecimal(item.Cells[1].Value);

Input string was not in a correct format.

k sir thanks, but give me idea where i am edit my code.

yes sir correct, but i am creating 3 rows but output time i am entered the values 2 rows only, because every time i not enter compulsory all 3 rows. Only enter alternatively.

If you possible help a code wise, because i am trying more than 2 days.

i am put a break point and check the line by line. And then i am entered the values first row only but error is came

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

I am write your code in cellvalidated event but empty cell not print in zero.
How to set empty cells zero.

how to set here i am using below code, but this code i am entered some values in cell[1] its also converting zero

if (dataGridView1.RowCount > 0 && dataGridView1.CurrentRow != null)
{
dataGridView1.CurrentRow.Cells[1].Value.ToString();

}

how to solve this error. I want i am skipped cells set as zero. how to create.

Thanks for your idea, but my data grid view columns I creating repeated columns
Here I am set data grid view allowed only 5 rows after complete enter 5 rows same columns are repeated again 5 rows.
Here how to get sum.

same my first columns display to second columns

my first columns
slno mts cms


how to create give me ideas.

error is came
There is no row at position 0.

cannot display message box,

Thanks, It' s working nice but hot to set line height same as to for my datagridview height

yes i was tried already by not working
out put
Slno
1
2
5
6
10
9
8
7

give me some ideas

how to this line convert decimal

decimal qty = Convert.ToSingle(dataGridView1.CurrentRow.Cells[6].Value);

how to convert my code.

yes i was but error is came

totqty = float.TryParse(sqldr[0].ToString());

sql server

any other solution, how to solve my error give me ideas.

k what i am using other controls, give me idea,

this is my login form code

private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection(db.Connectionstring());
con.Open();
SqlCommand cmd = new SqlCommand("select * from usercreation where username='" + txtuser.Text + "' and password='" + txtpassword.Text + "' and rights='" + comboBox1.Text + "'", con);
SqlDataReader dr = cmd.ExecuteReader();


if (dr.HasRows)
{

while (dr.Read())
{
string log = dr[3].ToString();



if (log == "User")
{


adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();

usercreation uc = new usercreation();
uc.find.Visible = false;

uc.Show();



this.Hide();





}



else if (log == "Admin")
{


adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();


usercreation uc = new usercreation();
uc.find.Visible = true;


uc.Show();


this.Hide();


this.Hide();
}

else
{
MessageBox.Show("Try Again");
}


}




}


dr.Close();
con.Close();
}

this is my login form code

private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection(db.Connectionstring());
con.Open();
SqlCommand cmd = new SqlCommand("select * from usercreation where username='" + txtuser.Text + "' and password='" + txtpassword.Text + "' and rights='" + comboBox1.Text + "'", con);
SqlDataReader dr = cmd.ExecuteReader();


if (dr.HasRows)
{

while (dr.Read())
{
string log = dr[3].ToString();



if (log == "User")
{


adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();

usercreation uc = new usercreation();
uc.find.Visible = false;

uc.Show();



this.Hide();





}



else if (log == "Admin")
{


adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();


usercreation uc = new usercreation();
uc.find.Visible = true;


uc.Show();


this.Hide();


this.Hide();
}

else
{
MessageBox.Show("Try Again");
}


}




}


dr.Close();
con.Close();
}

Another one doubt – I am creating login form (enter username (Text Box), password (Text Box) & rights(Using combo box) ,I am select a rights from user
That time my forms button disable, after that I again goes to login enter rights form Admin that time button visible, how to create in c# windows application 2010,
I am using MDI Parent form, without MDI parent working nice, but I am using MDI Parent forms not working (it means button visible both login), how to show my button control only admin login.

Another one doubt – I am creating login form (enter username (Text Box), password (Text Box) & rights(Using combo box) ,I am select a rights from user
That time my forms button disable, after that I again goes to login enter rights form Admin that time button visible, how to create in c# windows application 2010,
I am using MDI Parent form, without MDI parent working nice, but I am using MDI Parent forms not working (it means button visible both login), how to show my button control only admin login.

k now working fine,thanks a lot

k but i am restarted my computer how to get continues serial number

k it's working fine thanks a lot, but next day morning it's again starting from 1

k thanks i am waiting

yes its working fine thanks, but how to increment serial number every time submit the form vales and then next day when a login again serial number starting from 1

debugge error first line
'System.Text.StringBuilder' does not contain a definition for 'append' and no extension method 'append' accepting a first argument of type 'System.Text.StringBuilder' could be found (are you missing a using directive or an assembly reference?)

fist line error in Foramt, second line eror in append

how to display my serial in text box

yes this win forms, but i am write your code form page load event but error is came, first and second line.

where i am write this code, and then number shown on text box where to write above code

where i am write this code, and then number shown on text box where to write above code

yes

now i was set true but click mdi panel menu strip my form error is came

Form cannot be both an MDI child and MDI parent.
Parameter name: value

main form means which form

i got now another error

Form that was specified to be the MdiParent for this form is not an MdiContainer.
Parameter name: value

how to solve this error

very thanks

this is admin or user login code

private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection(db.Connectionstring());
con.Open();
//SqlCommand cmd = new SqlCommand("select * from login where username= '" + txtuser.Text + "'and password= '" + txtpassword.Text + "'", con);
SqlCommand cmd = new SqlCommand("select * from usercreation where username='" + txtuser.Text + "' and password='" + txtpassword.Text + "' and rights='" + comboBox1.Text + "'", con);
SqlDataReader dr = cmd.ExecuteReader();


if (dr.HasRows)
{

while (dr.Read())
{
string log = dr[3].ToString();
if (log == "User")
{
adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();






this.Hide();

}



else if (log == "Admin")
{



adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();



this.Hide();
}

else
{
MessageBox.Show("Try Again");
}


}




}


dr.Close();
con.Close();
}

no i am using mdipanel

i am using 3 control 2 text boxes, 1 combobox (inside combobox - 2 catagories admin & user), once user enter all correct details shown mdi panel, and click usercreation form that time find button disable for user enter the login, but again enter admin click same form button will be shown how to create.

no both login button will be shown

this is login form button script

private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection(db.Connectionstring());
con.Open();
//SqlCommand cmd = new SqlCommand("select * from login where username= '" + txtuser.Text + "'and password= '" + txtpassword.Text + "'", con);
SqlCommand cmd = new SqlCommand("select * from usercreation where username='" + txtuser.Text + "' and password='" + txtpassword.Text + "' and rights='" + comboBox1.Text + "'", con);
SqlDataReader dr = cmd.ExecuteReader();


if (dr.HasRows)
{

while (dr.Read())
{
string log = dr[3].ToString();
if (log == "User")
{
adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();






this.Hide();

}



else if (log == "Admin")
{



adminmdipanel adpanel = new adminmdipanel();
adpanel.Show();



this.Hide();
}

else
{
MessageBox.Show("Try Again");
}


}




}


dr.Close();
con.Close();
}

if condition is working else part not working

i am creating login form using combobox select user / admin rights - i thing login in form is any problem,

here is not working what can i do sir.

private System.Windows.Forms.TextBox txtuser;
private System.Windows.Forms.TextBox txtpassword;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Button button4;
private System.Windows.Forms.Button button3;
private System.Windows.Forms.Button clear;
private System.Windows.Forms.Button Submit;
public System.Windows.Forms.Button find;
}
}


OVER

this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(76, 27);
this.button4.TabIndex = 10;
this.button4.Text = "Delete";
this.button4.UseVisualStyleBackColor = true;
//
// button3
//
this.button3.Font = new System.Drawing.Font("Verdana", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button3.Location = new System.Drawing.Point(154, 14);
this.button3.Margin = new System.Windows.Forms.Padding(75, 3, 3, 3);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(76, 27);
this.button3.TabIndex = 9;
this.button3.Text = "Update";
this.button3.UseVisualStyleBackColor = true;
//
// clear
//
this.clear.Font = new System.Drawing.Font("Verdana", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.clear.Location = new System.Drawing.Point(308, 14);
this.clear.Margin = new System.Windows.Forms.Padding(75, 3, 3, 3);
this.clear.Name = "clear";
this.clear.Size = new System.Drawing.Size(76, 27);
this.clear.TabIndex = 11;
this.clear.Text = "Clear";
this.clear.UseVisualStyleBackColor = true;
//
// find
//
this.find.Font = new System.Drawing.Font("Verdana", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.find.Location = new System.Drawing.Point(78, 14);
this.find.Margin = new System.Windows.Forms.Padding(75, 3, 3, 3);
this.find.Name = "find";
this.find.Size = new System.Drawing.Size(76, 27);
this.find.TabIndex = 8;
this.find.Text = "Find";
this.find.UseVisualStyleBackColor = true;
//
// Submit
//
this.Submit.Font = new System.Drawing.Font("Verdana", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.Submit.Location = new System.Drawing.Point(0, 14);
this.Submit.Margin = new System.Windows.Forms.Padding(75, 3, 3, 3);
this.Submit.Name = "Submit";
this.Submit.Size = new System.Drawing.Size(76, 27);
this.Submit.TabIndex = 7;
this.Submit.Text = "Submit";
this.Submit.UseVisualStyleBackColor = true;
//
// usercreation
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(1370, 750);
this.Controls.Add(this.tableLayoutPanel1);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.panel3);
this.Name = "usercreation";
this.Text = "usercreation";
this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
this.Load += new System.EventHandler(this.usercreation_Load);
this.panel3.ResumeLayout(false);
this.panel3.PerformLayout();
this.tableLayoutPanel1.ResumeLayout(false);
this.tableLayoutPanel1.PerformLayout();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);

}

#endregion

private System.Windows.Forms.Label label3;
private System.Windows.Forms.Panel panel3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.ComboBox rigjtsbox;
private System.Windows.Forms.TableLayoutPanel tableLayoutPanel1;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.TextBox txtname

// rigjtsbox
//
this.rigjtsbox.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.rigjtsbox.FormattingEnabled = true;
this.rigjtsbox.Items.AddRange(new object[] {
"User",
"Admin"});
this.rigjtsbox.Location = new System.Drawing.Point(110, 116);
this.rigjtsbox.Name = "rigjtsbox";
this.rigjtsbox.Size = new System.Drawing.Size(182, 28);
this.rigjtsbox.TabIndex = 6;
//
// tableLayoutPanel1
//
this.tableLayoutPanel1.ColumnCount = 2;
this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 26.16137F));
this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 73.83863F));
this.tableLayoutPanel1.Controls.Add(this.label2, 0, 2);
this.tableLayoutPanel1.Controls.Add(this.label4, 0, 3);
this.tableLayoutPanel1.Controls.Add(this.rigjtsbox, 1, 3);
this.tableLayoutPanel1.Controls.Add(this.label1, 0, 0);
this.tableLayoutPanel1.Controls.Add(this.txtname, 1, 0);
this.tableLayoutPanel1.Controls.Add(this.label5, 0, 1);
this.tableLayoutPanel1.Controls.Add(this.txtuser, 1, 1);
this.tableLayoutPanel1.Controls.Add(this.txtpassword, 1, 2);
this.tableLayoutPanel1.Location = new System.Drawing.Point(300, 154);
this.tableLayoutPanel1.Name = "tableLayoutPanel1";
this.tableLayoutPanel1.RowCount = 4;
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 48.68421F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 51.31579F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 37F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 47F));
this.tableLayoutPanel1.Size = new System.Drawing.Size(409, 161);
this.tableLayoutPanel1.TabIndex = 0;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.Location = new System.Drawing.Point(3, 10);
this.label1.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(50, 18);
this.label1.TabIndex = 0;
this.label1.Text = "Name";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(3, 86);
this.label2.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(78, 18);
this.label2.TabIndex = 2;
this.label2.Text = "Password";
//
// txtname
//
this.txtname.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.txtname.Location = new System.Drawing.Point(110, 7);
this.txtname.Margin = new System.Windows.Forms.Padding(3, 7, 3, 3);
this.txtname.Multiline = true;
this.txtname.Name = "txtname";

// rigjtsbox
//
this.rigjtsbox.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.rigjtsbox.FormattingEnabled = true;
this.rigjtsbox.Items.AddRange(new object[] {
"User",
"Admin"});
this.rigjtsbox.Location = new System.Drawing.Point(110, 116);
this.rigjtsbox.Name = "rigjtsbox";
this.rigjtsbox.Size = new System.Drawing.Size(182, 28);
this.rigjtsbox.TabIndex = 6;
//
// tableLayoutPanel1
//
this.tableLayoutPanel1.ColumnCount = 2;
this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 26.16137F));
this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 73.83863F));
this.tableLayoutPanel1.Controls.Add(this.label2, 0, 2);
this.tableLayoutPanel1.Controls.Add(this.label4, 0, 3);
this.tableLayoutPanel1.Controls.Add(this.rigjtsbox, 1, 3);
this.tableLayoutPanel1.Controls.Add(this.label1, 0, 0);
this.tableLayoutPanel1.Controls.Add(this.txtname, 1, 0);
this.tableLayoutPanel1.Controls.Add(this.label5, 0, 1);
this.tableLayoutPanel1.Controls.Add(this.txtuser, 1, 1);
this.tableLayoutPanel1.Controls.Add(this.txtpassword, 1, 2);
this.tableLayoutPanel1.Location = new System.Drawing.Point(300, 154);
this.tableLayoutPanel1.Name = "tableLayoutPanel1";
this.tableLayoutPanel1.RowCount = 4;
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 48.68421F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 51.31579F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 37F));
this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 47F));
this.tableLayoutPanel1.Size = new System.Drawing.Size(409, 161);
this.tableLayoutPanel1.TabIndex = 0;
//
// label1
//
this.label1.AutoSize = true;
this.label1.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label1.Location = new System.Drawing.Point(3, 10);
this.label1.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(50, 18);
this.label1.TabIndex = 0;
this.label1.Text = "Name";
//
// label2
//
this.label2.AutoSize = true;
this.label2.Font = new System.Drawing.Font("Arial", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(3, 86);
this.label2.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(78, 18);
this.label2.TabIndex = 2;
this.label2.Text = "Password";
//
// txtname
//
this.txtname.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.txtname.Location = new System.Drawing.Point(110, 7);
this.txtname.Margin = new System.Windows.Forms.Padding(3, 7, 3, 3);
this.txtname.Multiline = true;
this.txtname.Name = "txtname";

this is me entire code

namespace bpexports
{
partial class usercreation
{
///

/// Required designer variable.
///

private System.ComponentModel.IContainer components = null;

///

/// Clean up any resources being used.
///

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}

#region Windows Form Designer generated code

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.label3 = new System.Windows.Forms.Label();
this.panel3 = new System.Windows.Forms.Panel();
this.label4 = new System.Windows.Forms.Label();
this.rigjtsbox = new System.Windows.Forms.ComboBox();
this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.txtname = new System.Windows.Forms.TextBox();
this.txtuser = new System.Windows.Forms.TextBox();
this.txtpassword = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.button4 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.clear = new System.Windows.Forms.Button();
this.find = new System.Windows.Forms.Button();
this.Submit = new System.Windows.Forms.Button();
this.panel3.SuspendLayout();
this.tableLayoutPanel1.SuspendLayout();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 35F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.SystemColors.ButtonFace;
this.label3.Location = new System.Drawing.Point(449, 24);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(325, 54);
this.label3.TabIndex = 30;
this.label3.Text = "User Creation";
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.DeepPink;
this.panel3.Controls.Add(this.label3);
this.panel3.Location = new System.Drawing.Point(-65, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(1500, 100);
this.panel3.TabIndex = 32;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.Location = new System.Drawing.Point(3, 123);
this.label4.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(55, 20);
this.label4.TabIndex = 12;
this.label4.Text = "Rights";
//
// rigjtsbox
//
this.rigjtsbox.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)

usercreation.designer.cs code


namespace bpexports
{
partial class usercreation
{
///

/// Required designer variable.
///

private System.ComponentModel.IContainer components = null;

///

/// Clean up any resources being used.
///

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}

#region Windows Form Designer generated code

///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.label3 = new System.Windows.Forms.Label();
this.panel3 = new System.Windows.Forms.Panel();
this.label4 = new System.Windows.Forms.Label();
this.rigjtsbox = new System.Windows.Forms.ComboBox();
this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.txtname = new System.Windows.Forms.TextBox();
this.txtuser = new System.Windows.Forms.TextBox();
this.txtpassword = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.button4 = new System.Windows.Forms.Button();
this.button3 = new System.Windows.Forms.Button();
this.clear = new System.Windows.Forms.Button();
this.find = new System.Windows.Forms.Button();
this.Submit = new System.Windows.Forms.Button();
this.panel3.SuspendLayout();
this.tableLayoutPanel1.SuspendLayout();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// label3
//
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Microsoft Sans Serif", 35F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.ForeColor = System.Drawing.SystemColors.ButtonFace;
this.label3.Location = new System.Drawing.Point(449, 24);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(325, 54);
this.label3.TabIndex = 30;
this.label3.Text = "User Creation";
//
// panel3
//
this.panel3.BackColor = System.Drawing.Color.DeepPink;
this.panel3.Controls.Add(this.label3);
this.panel3.Location = new System.Drawing.Point(-65, 0);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(1500, 100);
this.panel3.TabIndex = 32;
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.Location = new System.Drawing.Point(3, 123);
this.label4.Margin = new System.Windows.Forms.Padding(3, 10, 3, 0);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(55, 20);
this.label4.TabIndex = 12;
this.label4.Text = "Rights";
//
// rigjtsbox
//
this.rigjtsbox.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((

usercreation.cs code

namespace bpexports
{
public partial class usercreation : Form
{



public usercreation()
{
InitializeComponent();

}

string log = "Admin";

private void usercreation_Load(object sender, EventArgs e)
{

if (log == "Admin")
{


find.Visible = false;

}


else
{

find.Enabled = true;


}


}
}
}

if you possible edit my code and send me.

now i am doing same your way but button is visible, i am enter user or admin login button is visible.give me ideas

Submit, find, button3, button4, clear

5 buttons

i am several time doing, but not working give me ideas.

it means what can i do next, give me ideas

else part only working not goes to if section below this is my code

string log = "Admin";

private void usercreation_Load(object sender, EventArgs e)
{

if (log == "User")
{


find.Enabled = true;

}


else
{

find.Enabled = false;

}


}

give me ideas

else part only working not goes to if section below this is my code

string log = "Admin";

private void usercreation_Load(object sender, EventArgs e)
{

if (log == "User")
{


find.Enabled = true;

}


else
{

find.Enabled = false;

}


}

give me ideas

it is not working, both user & admin login shown on button, how to disable button on user login

It's working fine thanks a lot.

i got a answer thanks

Sir it's working fine and good thanks for your idea's, Thanks a lot.

k i will check once

if you possible please modify my above code and send me.

pnlProducts.Visible = true;

int CategoryID = Int16.TryParse((((LinkButton)sender).CommandArgument));
GetProducts(CategoryID);

Now i am use as per your ideas, but same line is error is came, please give me ideas.

pnlProducts.Visible = true;
int CategoryID = Convert.ToInt16((((LinkButton)sender).CommandArgument));
GetProducts(CategoryID);

k working but now above line are error, Input string was not in a correct format, how to solve this problem.

where i am using TryParse function

when i click a LinkButton at that time shown particulate products in my panel.

"paid" is my database table column name

k working, but data's are not saved in SaveCustomerDetails() table.

yes i am checking line by line my SaveCustomerDetails() table, but again same error is came.

string productids = string.Empty;
DataTable dt;

if (Session["MyCart"] != null)
{
dt = (DataTable)Session["MyCart"];

tkbsonsmerchant k = new tkbsonsmerchant()
{
CustomerName = txtCustomerName.Text,
CustomerEmailID = txtCustomerEmailID.Text,
CustomerAddress = txtCustomerAddress.Text,
CustomerPhoneNo = txtCustomerPhoneNo.Text,
TotalPrice = Convert.ToInt32(txtTotalPrice.Text),
ProductList = productids,
PaymentMethod = rblPaymentMethod.SelectedItem.Text
};

DataTable dtResult = k.SaveCustomerDetails();


for (int i = 0; i < dt.Rows.Count; i++)
{
tkbsonsmerchant SaveProducts = new tkbsonsmerchant()
{

//BELOW LIEN HERE IS ERROR CAME - INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED BY USER CODE - THERE IS ROW AT POSITION 0.
CustomerID = Convert.ToInt32(dtResult.Rows[0][0]),
ProductID = Convert.ToInt32(dt.Rows[i]["ProductID"]),
};
SaveProducts.SaveCustomerProducts();
}

Session.Clear();



lblTransactionNo.Text = "Your Transaction No :-" + dtResult.Rows[0][0];

pnlOrderPlacedSuccessfully.Visible = true;


sendOrderPlacedAlert(txtCustomerName.Text, txtCustomerEmailID.Text, Convert.ToString(dtResult.Rows[0][0]));




txtCustomerAddress.Text = string.Empty;
txtCustomerEmailID.Text = string.Empty;
txtCustomerName.Text = string.Empty;
txtCustomerPhoneNo.Text = string.Empty;
txtTotalPrice.Text = "0";
txtTotalProducts.Text = "0";
}




Again error came,please give me any one idea.

It's working thanks a lot

k- Thank you.

Again i got error from anther one form - please give me some suggestions.

This is my Error.

Compiler Error Message: CS1061: 'ShoppingHeart.BusinessLayer.ShoppingCart' does not contain a definition for 'GetAllProducts' and no extension method 'GetAllProducts' accepting a first argument of type 'ShoppingHeart.BusinessLayer.ShoppingCart' could be found (are you missing a using directive or an assembly reference?)

sir i am follow your steps but not working sir, give me some suggestions

Hello Sir, i am not understand below lins
If it won't work use ILDASM.exe to watch the shoppingcart class contains the property flag. If not remove the dll physically, build once and add it again. it works.

what can i do for please explain once sir.

No, sir i am not provide my project anywhere

yes sir, my compiled are correct, again once i am verify my files sir.

This is my error message sir,

Error Message: CS0117: 'ShoppingHeart.BusinessLayer.ShoppingCart' does not contain a definition for 'Flag'

Hello - are you find any errors my class file

namespace ShoppingHeart.BusinessLayer
{
public class ShoppingCart
{
public string CategoryName;
public int CategoryID;
public int ProductID;
public int CustomerID;

public string ProductName;
public string ProductImage;
public string ProductPrice;
public string ProductDescription;

public string CustomerName;
public string CustomerEmailID;
public string CustomerPhoneNo;
public string CustomerAddress;
public string ProductList;
public string PaymentMethod;

public string OrderStatus;
public string OrderNo;


public int TotalProducts;
public int TotalPrice;
public int StockType;


public int Flag { get; set; }




--------------------DB Coding ------------------------


internal DataTable GetOrderList()
{
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = DataLayer.DataAccess.AddParameter("@Flag", Flag, System.Data.SqlDbType.Int, 20);
DataTable dt = DataLayer.DataAccess.ExecuteDTByProcedure("SP_GetOrderList", parameters);
return dt; //i am write this line

}

now i am alter my ShoppingCart class file change to - public int Flag{get;set;} - But again i got same error. give me some suggestions.

How to convert a public in "Flag" - Give me ideas - Because i am beginner for .net.

ShoppingCart class file i was had "Flag" Proeprty - "public int Flag;" - This is my
ShoppingCart class Flag property script