Comments by breaker-code (Top 81 by date)

i never delete records.automatically jump auto increment Number.

you mean this path,
C:\inetpub\wwwroot\Antron
OR
<add name="AntronERP_DBConnectionString" connectionstring="Data Source=WIN-QBTC29S7939;Initial Catalog=ERP_DB;User ID=sa;Password=h@123" providername="System.Data.SqlClient">

After Lemon word.

yas I try lot of expression.I can't get my Out put.

am use this one.Int((RowNumber(Nothing)-1)/30) Out Put is

Page 1

1

Page 2

2

Page 3
3
......

page 30

30

Like this

I wont to fllowing Output,

Page 1
1
2
3
.
.
30

Page 2
31
32
.
.
60
Page 3
61
.
.

Like This

My table Inside the Rectangle i wont to stop expanding Rectangle height using limit Rows in table.

I allready give path my Floder.

only Working LocalHost Dear.

I allready Create OUTBOUND Floder in my server C drive.

I search.i try you link.it's NOt working.

Thank you DamithSL

Seq Number not display .flowing result display
UNITED ARAB EMIRATES


801106875 81409702

I wont to Flowing Answer

. UNITED ARAB EMIRATES
1. 81409702
2. 81410891
. CANADA
3.81410452

am faceing same error.

Error Line.
#Error UNITED ARAB EMIRATES
1. 81409702
2. 81410891
#Error CANADA
3.81410452

am using =RowNumber(Nothing) expression.results like this

1. CHINA,PEOP
2. 8140969X 814096xx CAN
3. 8140887X 814088xx SHA
4. 8141451X 814145xx SHA
5. CAMBODIA
6. 8139966X 813996xx PNH
7.HONG KONG
8.8140533X 814053xx HKG


This is not my output

but not Download the file

Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack. pop up this exception

successfully debug but not Download the File.

I all ready check this links.I can't understand.

can you give me sample code or chage my Code correct way.

string date = DateTime.Now.ToShortDateString();
string newdate = date.Replace("/", ".");
string filePath = Server.MapPath(@"~/C:/OUTBOUND/" + newdate + ".TXT");

string FileName = "" + newdate + ".TXT";

Response.ContentType = "Application/TXT";
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + FileName + "\"");
Response.TransmitFile(Server.MapPath(@"~/C:/OUTBOUND/"+ newdate + ".TXT"));
Response.End();

i try this one not Working,where is the error.
string date = DateTime.Now.ToShortDateString();
string newdate = date.Replace("/", ".");
string filePath = ""+ newdate + ".TXT";

Response.ContentType = "Application/TXT";
Response.AppendHeader("Content-Disposition","attachment;filename="+filePath);
Response.TransmitFile(Server.MapPath("~/C:/HKGOUTBOUND/"+ filePath));
Response.End();

yes

Am facing same problem.My Text file Genarate Every day.I create file name

string date = DateTime.Now.ToShortDateString();
string newdate = date.Replace("/", ".");

File name is " + newdate + ".TXT"

How to applly this file name your Code,i try this one

Response.AppendHeader("Content-Disposition", "attachment; filename="+ newdate +".TXT");
Response.TransmitFile(Server.MapPath("~/C:/HKGOUTBOUND/"+ newdate + ".TXT"));


it's not working

How client get Create Files.Client Need This File.

I need to witout using css changes.

I try,query working but I want TO get sum of this 3 types separately.

SELECT CASE WHEN DATEDIFF(DAY,CreateDate,GETDATE()) BETWEEN 0 AND 30 THEN TotalDuePaid END AS [0-30 days],
CASE WHEN DATEDIFF(DAY,CreateDate,GETDATE()) BETWEEN 31 AND 45 THEN TotalDuePaid END AS [31-45 days],
CASE WHEN DATEDIFF(DAY,CreateDate,GETDATE()) > 45 THEN TotalDuePaid END AS [over 45 days]
FROM tblOutboundInvoiceHeader
WHERE CusCode='00097' AND Confirm='0'

I show my Table and output in the quetion.it's not Clear.

I try Not working

yes

<asp:GridView ID="Cusinvoicegrid" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
CellPadding="3"
Width="100%" onselectedindexchanged="Cusinvoicegrid_SelectedIndexChanged">
<columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="InvoiceNo" HeaderText="InvoiceNo" />
<asp:BoundField DataField="InvAmtLKR" HeaderText="InvAmt" />
<asp:BoundField DataField="TotalDuePaid" HeaderText="Last Payment" />
<asp:BoundField DataField="TotalPaid" HeaderText="Out Standing" />
<asp:TemplateField>
<itemtemplate>
<asp:CheckBox ID="CheckBox1" runat="server" />



<footerstyle backcolor="White" forecolor="#000066">
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<rowstyle forecolor="#000066">
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<sortedascendingcellstyle backcolor="#F1F1F1">
<sortedascendingheaderstyle backcolor="#007DBB">
<sorteddescendingcellstyle backcolor="#CAC9C9">
<sorteddescendingheaderstyle backcolor="#00547E">

DataTable dt = new DataTable();
String ReceptNUm = txtinvoice.Text.ToString().Trim();
dt = RE.getinvoicedetailsINV(ReceptNUm);

if (dt != null && dt.Rows.Count > 0)
{
Cusinvoicegrid.DataSource = dt;
Cusinvoicegrid.DataBind();
dt.Clear();
btn_Cash_Ok.Visible = true;


}

User Enter same values ex: 826147.40 I need to convert 826,147.40 format and bind my gridview.

this formt values 826,147.40

tnx a lot

error (Incorrect syntax near the keyword 'COALESCE'.
)

i try Not working dear

plz Any one can help me??

yes.but this one is not working

Not inside a griview

Thanx a lot dear

i think this one is error .this is my databind method to grid.gridview colum value without decimel point.how to slove this one.

Double SR = Math.Round((Double.Parse(Cusinvoicegrid.Rows[i].Cells[4].Text)) * (surcharge/ 100), 2);
dr["Fuel"] = SR ;
dt1.Rows.Add(dr);
Cusinvoicegrid0.DataSource = dt1;
Cusinvoicegrid0.DataBind();

i try not working

//get sum of fuel
Double sum = 0;
for (int j = 0; j < Cusinvoicegrid0.Rows.Count; ++j)
{
sum += Convert.ToDouble(Cusinvoicegrid0.Rows[j].Cells[6].Text);
}


Double tot = Math.Round(sum, 2);
Label2.Text = tot.ToString("00.00",System.Globalization.CultureInfo.CreateSpecificCulture("da-DK"));

getting this error Input string was not in a correct format.

http://msdn.microsoft.com/en-us/library/0c899ak8%28v=vs.110%29.aspx

i try dear getting same error.Input string was not in a correct format.

decimal point value

yes,it's without Decimal point answer.i Change Decimal tott into Double tott same answer

i run and test source code localhost not face this error.

Thahk Dear

Thahk Dear

This is my Code

protected void btn_Cash_Ok_Click(object sender, EventArgs e)
{
try
{
TAXGridview0.Visible = true;
TAXGridview.Visible = false;





for (int i = 0; i < TAXGridview.Rows.Count; i++)
{
if ((TAXGridview.Rows[i].Cells[10].FindControl("CB_CHECK") as CheckBox).Checked == true)
{




if (Session["dt1"] != null) dt1 = (DataTable)Session["dt1"];
DataRow dr = dt1.NewRow();
dr["HAWB"] = TAXGridview.Rows[i].Cells[1].Text;//1
dr["Value"] = TAXGridview.Rows[i].Cells[2].Text;//2

TextBox Duty = (TextBox)TAXGridview.Rows[i].Cells[3].FindControl("txtduty"); //Just change the index of the Cells to which your TextBox resides in the column
dr["Duty"] = Convert.ToDouble(Duty.Text);//3

TextBox PAL = (TextBox)TAXGridview.Rows[i].Cells[4].FindControl("txtPAL");
dr["PAL"] = Convert.ToDouble(PAL.Text);//4

TextBox VAT = (TextBox)TAXGridview.Rows[i].Cells[5].FindControl("txtVat");
dr["VAT"] = Convert.ToDouble(VAT.Text);//5

TextBox UHDAmt = (TextBox)TAXGridview.Rows[i].Cells[6].FindControl("txtUHD");
dr["UHDAmt"] = Convert.ToDouble(UHDAmt.Text);//6

TextBox SUR = (TextBox)TAXGridview.Rows[i].Cells[7].FindControl("txtSUR");
dr["SUR"] = Convert.ToDouble(SUR.Text);//7

TextBox EIC = (TextBox)TAXGridview.Rows[i].Cells[8].FindControl("txtEIC");
dr["EIC"] = Convert.ToDouble(EIC.Text);//8

TextBox SRL = (TextBox)TAXGridview.Rows[i].Cells[9].FindControl("txtSRL");
dr["SRL"] = Convert.ToDouble(SRL.Text);//9







dt1.Rows.Add(dr);
TAXGridview0.DataSource = dt1;
TAXGridview0.DataBind();
}


protected void TAXGridview0_RowDataBound(object sender, GridViewRowEventArgs e)
{

try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
String sponsorBonus = ((TextBox)e.Row.FindControl("txtduty")).Text;
String pairingBonus = ((TextBox)e.Row.FindControl("txtPAL")).Text;
String staticBonus = ((TextBox)e.Row.FindControl("txtVat")).Text;
String leftBonus = ((TextBox)e.Row.FindControl("txtUHD")).Text;
String rightBonus = ((TextBox)e.Row.FindControl("txtSUR")).Text;
decimal totalvalue = Convert.ToDecimal(sponsorBonus) + Convert.ToDecimal(pairingBonus) + Convert.ToDecimal(staticBonus) + Convert.ToDecimal(leftBonus) + Convert.ToDecimal(rightBonus);
e.Row.Cells[10].Text = totalvalue.ToString();
sumFooterValue += totalvalue;
}

if (e.Row.RowType == DataControlRowType.Footer)
{
Label lbl = (Label)e.Row.FindControl("lblTotal");
lbl.Text = sumFooterValue.ToString();
}



}

faceing This error.how to fix.
Object reference not set to an instance of an object.

Thanx i try this code

How to pass the null value store procedure
parameters[1].Value = Decimal.Parse(txtAirfreight.Text);

This code is not working.

plase help me.

I use this one.gettng error.help me fix this one
Input string was not in a correct format.


decimal Total = 0;

for (int i = 0; i < Cusinvoicegrid0.Rows.Count; i++)
{
Total += Convert.ToInt32(Cusinvoicegrid0.Rows[i].Cells["Value"].Value);
}

Label2.Text = Total.ToString();

plz any one can help me

my tool box dock as taabbed right side.i need to get left side this tool box.

am using Select index event am i correct??
protected void Cashgrid_SelectedIndexChanged(object sender, System.EventArgs e)
{
Cashgrid.DeleteRow(Cashgrid.SelectedIndex);

}

Genarate this error
The GridView 'Cashgrid' fired event RowDeleting which wasn't handled.

yes

My data table,
@InvoiceNo int,
@H varchar(50),
@value Numeric ( 18,2),
@ExchangeRate Numeric ( 18,2),
@HAWBamount Numeric ( 18,2),
@HAWBAmountLKR Numeric ( 18,2),
@Discountamount Numeric ( 18,2),
@DisType int,
@CurrencyType varchar(10),
@InvoiceDatetime datetime,
@fuel Numeric ( 18,2),
@Invoicecode varchar(50),
@InvoiceTotal Numeric ( 18,2),
@compCode varchar(30),
@CreateUserID varchar(20),

i want to show.

i want to stop modalpopup hide.

decimal.Parse(txtvalue.Text.Replace("'", "''")); am try to this way it's not working

PLZ anyone can help me

Tnx a lot dear..

<asp:DropDownList ID="DropDownPackType" runat="server" Width="100%" Height="20px"
CssClass="input" AutoPostBack="true"
onselectedindexchanged="DropDownPackType_SelectedIndexChanged"
TabIndex="23" onblur="LoseFocus(this);">

anyone of you please help me

(40,857 online) plz help me?

1 texbox

k .am sry

Help me plz

i Need a how to write a method.

I am try to all of this links..same erro..