Click here to Skip to main content
14,697,992 members

Comments by breaker-code (Top 81 by date)

breaker-code 6-Apr-16 0:05am View
   
Any One please give me the solution
breaker-code 11-Sep-15 4:02am View
   
i never delete records.automatically jump auto increment Number.
breaker-code 26-Mar-15 1:25am View
   
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">
breaker-code 6-Feb-15 2:45am View
   
Deleted
txtMAWB.Text = "";
txtMAWBDate.Text = "";
txtFlight.Text = "";
txtFlightDate.Text = "";
txtNoOfPkgs.Text = "";
txtWeight.Text = "";
lblError.Text = "";


List<string[]> testParse = null;


string[] row =null;

try
{
FileUpload1.PostedFile.SaveAs(System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "source.txt");

testParse = parseCSV(System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "source.txt", 24);

BAL.CSV_temp.newTable1 = new DataTable();
BAL.CSV_temp.newTable = new DataTable();

//HAWBDetails.DataSource = BAL.CSV_temp.newTable1;
//HAWBDetails.DataBind();

foreach (string column in testParse[0])
{
BAL.CSV_temp.newTable.Columns.Add();
BAL.CSV_temp.newTable1.Columns.Add();
}


row = testParse[0];
BAL.CSV_temp.newTable.Rows.Add(row);


txtMAWB.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(1).ToString();
txtMAWBDate.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(2).ToString();
txtFlight.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(3).ToString();
txtFlightDate.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(4).ToString();
txtNoOfPkgs.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(5).ToString();
txtWeight.Text = BAL.CSV_temp.newTable.Rows[0].ItemArray.ElementAt(6).ToString();

List<string[]> testParse1 = testParse.GetRange(1, testParse.Count - 1);


foreach (string[] row1 in testParse1)
{

BAL.CSV_temp.newTable1.Rows.Add(row1).ToString().Trim();

}

//Label3.Text = BAL.CSV_temp.newTable1.Rows[0].ItemArray.ElementAt(6).ToString();

HAWBDetails.DataSource = BAL.CSV_temp.newTable1;
HAWBDetails.DataBind();


lblError.Text = "";
}
catch (Exception ex)
{
lblError.Text = "File contents are not in the correct format";
ErrorLog el = new ErrorLog();
el.ErrorRegistry(ex, "CSV_reader.aspx", "Selecting File", "NA", "NA");
}
breaker-code 6-Feb-15 2:45am View
   
After Lemon word.
breaker-code 16-Dec-14 4:42am View
   
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
breaker-code 16-Dec-14 3:38am View
   
I wont to fllowing Output,

Page 1
1
2
3
.
.
30

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

Like This
breaker-code 15-Dec-14 12:20pm View
   
Deleted
I wont to fllowing Output,

Page 1
1
2
3
.
.
30

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

Like This
breaker-code 12-Dec-14 5:59am View
   
My table Inside the Rectangle i wont to stop expanding Rectangle height using limit Rows in table.
breaker-code 8-Dec-14 6:11am View
   
I allready give path my Floder.
breaker-code 8-Dec-14 5:40am View
   
only Working LocalHost Dear.
breaker-code 8-Dec-14 4:52am View
   
I allready Create OUTBOUND Floder in my server C drive.
breaker-code 5-Dec-14 6:09am View
   
I search.i try you link.it's NOt working.
breaker-code 3-Dec-14 3:01am View
   
Thank you DamithSL
breaker-code 3-Dec-14 2:41am View
   
Seq Number not display .flowing result display
UNITED ARAB EMIRATES


801106875 81409702
breaker-code 3-Dec-14 1:37am View
   
I wont to Flowing Answer

. UNITED ARAB EMIRATES
1. 81409702
2. 81410891
. CANADA
3.81410452
breaker-code 3-Dec-14 1:28am View
   
am faceing same error.
breaker-code 3-Dec-14 1:26am View
   
Error Line.
#Error UNITED ARAB EMIRATES
1. 81409702
2. 81410891
#Error CANADA
3.81410452
breaker-code 18-Nov-14 7:25am View
   
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
breaker-code 5-Aug-14 4:52am View
   
but not Download the file
breaker-code 5-Aug-14 3:09am View
   
Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack. pop up this exception
breaker-code 5-Aug-14 2:20am View
   
successfully debug but not Download the File.
breaker-code 31-Mar-14 2:42am View
   
I all ready check this links.I can't understand.
breaker-code 31-Mar-14 2:37am View
   
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();
breaker-code 31-Mar-14 1:39am View
   
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();
breaker-code 28-Mar-14 6:10am View
   
yes
breaker-code 28-Mar-14 6:03am View
   
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
breaker-code 26-Mar-14 3:52am View
   
How client get Create Files.Client Need This File.
breaker-code 11-Mar-14 2:28am View
   
I need to witout using css changes.
breaker-code 24-Feb-14 22:54pm View
   
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'
breaker-code 24-Feb-14 8:12am View
   
I show my Table and output in the quetion.it's not Clear.
breaker-code 10-Feb-14 4:22am View
   
I try Not working
breaker-code 10-Feb-14 4:00am View
   
yes
breaker-code 13-Dec-13 3:34am View
   
<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">
breaker-code 13-Dec-13 3:27am View
   
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;


}
breaker-code 7-Dec-13 2:04am View
   
User Enter same values ex: 826147.40 I need to convert 826,147.40 format and bind my gridview.
breaker-code 7-Dec-13 1:59am View
   
this formt values 826,147.40
breaker-code 2-Dec-13 1:08am View
   
tnx a lot
breaker-code 2-Dec-13 1:00am View
   
error (Incorrect syntax near the keyword 'COALESCE'.
)
breaker-code 2-Dec-13 0:42am View
   
i try Not working dear
breaker-code 2-Dec-13 0:24am View
   
plz Any one can help me??
breaker-code 28-Nov-13 1:52am View
   
yes.but this one is not working
breaker-code 27-Nov-13 5:58am View
   
Not inside a griview
breaker-code 25-Nov-13 2:26am View
   
Thanx a lot dear
breaker-code 22-Nov-13 2:34am View
   
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();
breaker-code 22-Nov-13 2:29am View
   
i try not working
breaker-code 22-Nov-13 2:21am View
   
//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.
breaker-code 22-Nov-13 2:17am View
   
http://msdn.microsoft.com/en-us/library/0c899ak8%28v=vs.110%29.aspx
breaker-code 22-Nov-13 2:01am View
   
i try dear getting same error.Input string was not in a correct format.
breaker-code 22-Nov-13 1:40am View
   
decimal point value
breaker-code 22-Nov-13 1:24am View
   
yes,it's without Decimal point answer.i Change Decimal tott into Double tott same answer
breaker-code 7-Nov-13 2:53am View
   
i run and test source code localhost not face this error.
breaker-code 28-Oct-13 0:17am View
   
Thahk Dear
breaker-code 28-Oct-13 0:16am View
   
Thahk Dear
breaker-code 3-Oct-13 2:12am View
   
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();
}



}
breaker-code 2-Oct-13 3:49am View
   
faceing This error.how to fix.
Object reference not set to an instance of an object.
breaker-code 2-Oct-13 3:39am View
   
Thanx i try this code
breaker-code 1-Oct-13 5:17am View
   
How to pass the null value store procedure
parameters[1].Value = Decimal.Parse(txtAirfreight.Text);

This code is not working.
breaker-code 23-Sep-13 1:56am View
   
plase help me.
breaker-code 16-Sep-13 6:47am View
   
Deleted
hosting provider is google
breaker-code 11-Sep-13 6:01am View
   
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();
breaker-code 11-Sep-13 4:57am View
   
plz any one can help me
breaker-code 10-Sep-13 2:52am View
   
my tool box dock as taabbed right side.i need to get left side this tool box.
breaker-code 2-Jul-13 3:34am View
   
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.
breaker-code 27-Jun-13 11:20am View
   
yes
breaker-code 27-Jun-13 10:31am View
   
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),
breaker-code 26-Jun-13 2:39am View
   
i want to show.
breaker-code 26-Jun-13 2:29am View
   
i want to stop modalpopup hide.
breaker-code 15-Jun-13 6:52am View
   
decimal.Parse(txtvalue.Text.Replace("'", "''")); am try to this way it's not working
breaker-code 7-May-13 1:15am View
   
PLZ anyone can help me
breaker-code 7-Mar-13 2:09am View
   
Deleted
I need a using tblTempDiff it's working for hall table.i want to hide same rows,
breaker-code 28-Feb-13 1:17am View
   
Tnx a lot dear..
breaker-code 28-Feb-13 0:25am View
   
<asp:DropDownList ID="DropDownPackType" runat="server" Width="100%" Height="20px"
CssClass="input" AutoPostBack="true"
onselectedindexchanged="DropDownPackType_SelectedIndexChanged"
TabIndex="23" onblur="LoseFocus(this);">
breaker-code 26-Feb-13 4:06am View
   
anyone of you please help me
breaker-code 26-Feb-13 1:47am View
   
Deleted
i try ur code.i have a problum.HOw to call this function LoseFocus in dropdownlist

<asp:DropDownList ID="DropDownCountry" runat="server" AutoPostBack="true" CssClass="input"Height="20px"onselectedindexchanged="DropDownCountry_SelectedIndexChanged" TabIndex="18" Width="99%" >
breaker-code 19-Feb-13 5:56am View
   
(40,857 online) plz help me?
breaker-code 18-Feb-13 23:45pm View
   
1 texbox
breaker-code 12-Feb-13 1:49am View
   
k .am sry
breaker-code 12-Feb-13 1:35am View
   
Help me plz
breaker-code 12-Feb-13 1:24am View
   
i Need a how to write a method.
breaker-code 11-Feb-13 5:01am View
   
I am try to all of this links..same erro..