C# Masters

[GRO_MAX]

Machanla mata help ekak ona c# danna ayagen,

meka mage final project eka, ekata machan Uniqe ID ekak (Primary key eka) widiyata use karanna ona me wage ID ekak

LGR0001 , SML0002, EXL0003

oya wage ID ekak machan, oke issaraha thiyana akuru thuna change wenna ona caterary thiyana drop down list eke

Large
Small
Extra Large

kiyana value thuna wenas karanawath ekkama, Udinma thiyenne categary combobox eka machan eken categary eka select karata passe thamai code eka generate wela Item ID kiyana text field eka fill wenna ona

mama danna wada okkoma damma machan eth kara ganna bari una Please mata help ekak dendooo

 

[GRO_MAX]

table name eka addItems
column name eka itemId type varchar[50]

 

[chikoo]

try this,


String temp = Convert.ToString(capitaL_MSTTableAdapter1.MAX_ID());
String id = temp.Substring(0);
int id2 = int.Parse(id);
textBox9.Text = (LGR0001),(++id2).ToString();

_________ >LGR0001,LGR0002,LGR0003

 

[GRO_MAX]

try this,


String temp = Convert.ToString(capitaL_MSTTableAdapter1.MAX_ID());
String id = temp.Substring(0);
int id2 = int.Parse(id);
textBox9.Text = (LGR0001),(++id2).ToString();

_________ >LGR0001,LGR0002,LGR0003

machan code eka enter karanna ona save button click event ekatada? Textfield ekatada?

 

[GRO_MAX]

Error 2 The name 'capitaL_MSTTableAdapter1' does not exist in the current context
Error 3 The name 'LGR0001' does not exist in the current context
Error 4 Invalid expression term ','
Error 5 ; expected

 

[**මරුසිරා**]

bump

 

[nuni]

Database connectivity class ekak thiyenawada? naththam form ekemada karanna hadanne?

 

[smother]

ඉතින් බන් size category එක Table එකකින්නෙ උබ ගන්නෙ.
si ze එක select කරාම query එකක් pass කරපන් SQL වලින්

like ' LGR%'

 

[prazadx]

meka balapan.. idea ekak ganna puluwan wei
http://www.dotnetspider.com/resources/37448-Generating-Sequence-No-for-Primary-Key-Columns.aspx

 

[amila.ela]

kkkkkkkkkk

 

[amarawansadinith]

ithin machan,


private void cmbx_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbx.SelectedValue == "Large")
Textbox1.text = "LGR";
else if (cmbx.SelectedValue == "Small")
Textbox1.text = "SML";
else if (cmbx.SelectedValue == "Extra Large")
Textbox1.text = "EXL";

}

 

[chikoo]

machan code eka enter karanna ona save button click event ekatada? Textfield ekatada?

na na oka generate id kiyana button ekata enne ..oke capital_MST kiyanne sql table ekak.umbe table eka dataset ekakata dagena eken max ID eka ena qury ekak hada ganin.habai aniwara yena table eke umbata ona column eke value ekak tiyenna ona

ex : LGR+(COLOUM MAX VALUE+1) = if column max value eka 0001 num
ANS = LGR00002

 

[chikoo]

Error 2 The name 'capitaL_MSTTableAdapter1' does not exist in the current context
Error 3 The name 'LGR0001' does not exist in the current context
Error 4 Invalid expression term ','
Error 5 ; expected

"LGR " eka string ekak widihata pass karapan double quotes athule

 

[GRO_MAX]

Database connectivity class ekak thiyenawada? naththam form ekemada karanna hadanne?

claz ekak naha machan form ekema connection eka hadala thiyenne machan

 

[GRO_MAX]

ithin machan,


private void cmbx_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbx.SelectedValue == "Large")
Textbox1.text = "LGR";
else if (cmbx.SelectedValue == "Small")
Textbox1.text = "SML";
else if (cmbx.SelectedValue == "Extra Large")
Textbox1.text = "EXL";

}

thanks machan oya tika mamath goda da gaththa machan but machan e unata ara format ekata no eka da ganna thamai mata bari machan

 

[GRO_MAX]

na na oka generate id kiyana button ekata enne ..oke capital_MST kiyanne sql table ekak.umbe table eka dataset ekakata dagena eken max ID eka ena qury ekak hada ganin.habai aniwara yena table eke umbata ona column eke value ekak tiyenna ona

ex : LGR+(COLOUM MAX VALUE+1) = if column max value eka 0001 num
ANS = LGR00002

table eka dataset ekakata dagena eken max ID eka ena qury ekak hada ganin

macho mama c# beginner kenek poddak mata oya tika karana widiya kiyala denna puluwanda nathnam machan tute ekak dunnath kamak naha,

Thaks machan rep+

 

[madbuddy]

thanks machan oya tika mamath goda da gaththa machan but machan e unata ara format ekata no eka da ganna thamai mata bari machan

Den mee ID eka kohenda enne machan? code eken generate karanna ooneda?DB eken gannawada?

 

[GRO_MAX]

Den mee ID eka kohenda enne machan? code eken generate karanna ooneda?DB eken gannawada?

oka machan primary key eka widiyata use karanne oka categary eka select karanawath ekkama generate wela database eke table eke itemId kiyana column eke store kara gannai one machan

 

[madbuddy]

idapan machan mama solution eka dannam. 5 min deepan

 

[GRO_MAX]

idapan machan mama solution eka dannam. 5 min deepan

uba nam deiyek machan, Thankss machan