Comments by ruby kaur (Top 28 by date)

yes mistakenly i write 201-300 its 201-500.

The logic is a truck is arrived in depot having some material in it ,suppose having 200 boxes this 200 is inserted in total _qty column in table,
now i have to allot depot_No to each box,now if this is the first record for this depot then i have to allot 1-200 depot_no for this record.
and when next truck arrive if it's having total no of boxes 300 then i have to allot him depot_no from 201-300.like this for each item come in depot i have to give depot_No .
form every 1st of October this depot_no no starts from 1.
i hope now you get the logic



there is Total _Qty column in table in which material's total_Qty is inserted.

hi i use comparevalidator like this:
<asp:CompareValidator runat="server" id="cmpNumbers" controltovalidate="txtTIN"
ValueToCompare="000000000" operator="GreaterThan" type="Integer" errormessage="Invalid Tin Number" />

but it shows error msg in both condition weather i enter 00000000000 or 12345678912 why so.
and i am checking foe 11 digit no. and you suggest value to compare only 9 digit 000000000.
pls explain, and help.

where to put this check.

this also not work.

code is not giving any error in compilation but when i give value <25 in the text box its not disabling that part of the page.

hi your code is goving error:
System.Web.UI.WebControls.TextBox' does not contain a definition for 'value' and no extension method 'value' accepting a first argument of type 'System.Web.UI.WebControls.TextBox' could be found (are you missing a using directive or an assembly reference?)


i have written this code like this in aspx.cs page:
protected void txtContractorBusinesscapacity_TextChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtContractorBusinesscapacity.value))
{
int value = 0;

bool isParsed = int.TryParse(txtContractorBusinesscapacity.value, out value);

if (isParsed && value <= 15000)
{
txtTIN.Enabled = false;
}
}
}
textbox defanation in aspx page is like this.
<asp:TextBox ID="txtContractorBusinesscapacity" runat="server" öntextchanged="txtContractorBusinesscapacity_TextChanged"
Width="250px">
<asp:RequiredFieldValidator ID="rvtContractorBusinesscapacity" runat="server"
ControlToValidate="txtContractorBusinesscapacity" Display="Dynamic"
SetFocusOnError="True">*
<asp:CompareValidator ID="cvContractorBusinesscapacity" runat="server"
ControlToValidate="txtContractorBusinesscapacity" Display="Dynamic"
Operator="GreaterThanEqual" SetFocusOnError="true" Type="Double"
ValueToCompare="0">Enter numeric value
</td>

thankyou this will work for me.

i think replication is not useful in my case.because my task is to make centralized database for all the master tables. right now every application is using its own set of master tables which is causing data redundancy now i have to shift all master tables in centralized database and application specific and transnational tables in applications own database.

Thanks Mr. Zafar
I execute my procedure explicitly and got the mistake. Thanks for reminding me this step.

Thanks for the solution.
I make changes in the procedure and it is working successfully. I tried the first solution as i wanted to learn it. It is giving me a message "operator == cannot be applied to operands of type 'int' and 'string'". Can you please guide me about that.

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

This is code from .cs file code

Collapse | Copy Code
protected void btnAdd_Click(object sender, EventArgs e)
{

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))
{
lblStatus.Text = Resources.Language.Common_Record_Add;
}
BindGrid(Session["Language"].ToString());
clearfields();
}

This is business logic code
Collapse | Copy Code
public bool Insert(string Depot_Code, string Lot_Code, string Depo_stackno, string SPECIES_Ename, string SPECIES_Uname, string SPECIES_Kname, string Grade,
int No_of_pieces, string Length_class, string Girth_class, double Cubic_meter,double Upset_price,double Sale_Price,int DIV_ID)
{
bool res = false;
System.Collections.ArrayList sel = new System.Collections.ArrayList();

sel.Add("SP_m_LotCreation_Insert");
ArrayList lstParam = new System.Collections.ArrayList();

SqlParameter param;

param = new SqlParameter();
param.ParameterName = "@Depot_Code";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Lot_Code";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = Lot_Code;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Depo_stackno";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Ename";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Ename;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@SPECIES_Uname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Uname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@SPECIES_Kname";
param.SqlDbType = SqlDbType.VarChar;
param.Value = SPECIES_Kname;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Grade";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Grade;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@No_of_pieces";
param.SqlDbType = SqlDbType.Int;
param.Value = No_of_pieces;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Length_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Depo_stackno;
lstParam.Add(param);


param = new SqlParameter();
param.ParameterName = "@Girth_class";
param.SqlDbType = SqlDbType.VarChar;
param.Value = Girth_class;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Cubic_meter";
param.SqlDbType = SqlDbType.Float;
param.Value = Cubic_meter;
lstParam.Add(param);

param = new SqlParameter();
param.ParameterName = "@Upset_price";
param.SqlD

if (objLotCreation.Insert(ddlDepot.SelectedValue, txtlotcode.Text.Trim(), txtDepo_stackno.Text.Trim(), txtSPECIES_Ename.Text.Trim(),
txtSPECIES_Uname.Text.Trim(), txtSPECIES_Kname.Text.Trim(), txtGrade.Text.Trim(), Convert.ToInt32(txtNo_of_pieces.Text),
txtLength_class.Text.Trim(), txtlblGirth_class.Text.Trim(), Convert.ToDouble(txtCubic_meter.Text), Convert.ToDouble(txtUpset_price.Text),
Convert.ToDouble(txtSale_Price.Text), Convert.ToInt32(Session["OfficeID"].ToString())))

Cubic_meter and Upset_price are the column in database which allow Null values .

i am already doing like this :

protected void lstLotBided_SelectedIndexChanged(object sender, EventArgs e)
{
txtsaleprice.Text = "People Records : " + lstLotBided.Items.Count.ToString();

if ((lstLotBided.Items.Count > 0 && lstLotBided.SelectedIndex >= 0))
{
dt = objEmd.SelectSale_Price(lstLotBided.SelectedValue);
double tempsaleprice = 0;
for (int i = 0; i < lstLotBided.Items.Count; i++)
{
if (lstLotBided.Items[i].Selected)
{
tempsaleprice = tempsaleprice + Convert.ToDouble(lstLotBided.Items[i].Text);

}
}
txtsaleprice.Text = tempsaleprice.ToString();
}
else
{
txtsaleprice.Text = "";
}
}

But it is not working. if u suggest any improvement pls make them.
thanks

please explain with example,
i am using textbox control for auction date and it is having ajax clender control to select date,and my lotcode is multiselect listbox.
on selection of date by user the list box has to be filled with all the lotcode of that auction date.

pls help me out.
thanks

i mean accepting data from single textbox and inserting them into different column of sql server 2008

if i am trying to do this getting error;
Error 60 Cannot implicitly convert type 'double' to 'string' .

and its not giving error here but on btn add button block.

it will not open in note pad or word

Is there any other way of doing this in same table

Thanks a lot