Comments by Lancy.net (Top 81 by date)

Hi Thanks for yr reply.Cells[1] i have the value what i need.
Every row has a button on button click i should get Cells[1] value.
when i chk with break point SelectedRow=null.
please correct.

Hi i tried with the example i can add a row after item template but not after header...Your help needed.

Hi Thanks for your reply....
I need to create a row after the header template could u pls assist?

Hi I am getting a error "The table width must be greater than zero.
"



Stack Trace:


[ArgumentException: The table width must be greater than zero.]
iTextSharp.text.pdf.PdfPTable.WriteSelectedRows(Int32 colStart, Int32 colEnd, Int32 rowStart, Int32 rowEnd, Single xPos, Single yPos, PdfContentByte[] canvases, Boolean reusable) +162
iTextSharp.text.pdf.PdfPTable.WriteSelectedRows(Int32 colStart, Int32 colEnd, Int32 rowStart, Int32 rowEnd, Single xPos, Single yPos, PdfContentByte canvas, Boolean reusable) +458
iTextSharp.text.pdf.PdfPTable.WriteSelectedRows(Int32 colStart, Int32 colEnd, Int32 rowStart, Int32 rowEnd, Single xPos, Single yPos, PdfContentByte canvas) +57
iTextSharp.text.pdf.PdfPTable.WriteSelectedRows(Int32 rowStart, Int32 rowEnd, Single xPos, Single yPos, PdfContentByte canvas) +53
Admin_Pages_DO_Management_Print.btnExport_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\Invoice\Admin_Pages\DO_Management\Print.aspx.cs:223
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Thanks Shiva for your reply i will try and let you know...

Hi I need it for pdf....

Thank you..

Thanks Edward you are right my question is why the whole page goes white when the box is shown?

Hi Amith thanks for yr reply ... i need for Lan...any suggestions...

Thanks..

Thanks for your reply Friend
i checked dont have any duplicate entries......
is their any other possibilities....
Thanks

Hi Rahul i am new to this..
would you mind in explaining this to me...
Thanks

Thanks...i will try and revert u soon..

sorry may be my question is not clear
what i need is count value should reset every year...
for example if i have 10 dos in jan starts with 2012scl001-Do--2012scl010-Do
feb one 2012scl011.........
2013 jan first do must 2013scl001

Its for Invoice below the main header need to add another row......

Hi Thanks for your comment...i want to use this to print invoice pdf using iTextsharp...
Reason for many dataset is Header,Footer,Item Details,Address..
I am planning to bring all in one xml then to print pdf..

hi i need your valuable suggestion how do i do this please?

Thanks Mika let me try....

Thanks jai

Thanks...
Could you pls have a look i have posted complete code

private void AddNewRowToGrid()
{
int rowIndex = 0;
float total;
float subtotal = 0;


if (ViewState["CurrentTable"] != null)
{
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];

DataRow drCurrentRow = null;

if (dtCurrentTable.Rows.Count > 0)
{
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)
{
//extract the TextBox values

TextBox box1 = (TextBox)ItemGv.Rows[rowIndex].Cells[0].FindControl("itemNotb");

TextBox box2 = (TextBox)ItemGv.Rows[rowIndex].Cells[1].FindControl("desctb");
TextBox box3 = (TextBox)ItemGv.Rows[rowIndex].Cells[2].FindControl("qtytb");
TextBox box4 = (TextBox)ItemGv.Rows[rowIndex].Cells[3].FindControl("upricetb");
TextBox box5 = (TextBox)ItemGv.Rows[rowIndex].Cells[4].FindControl("amounttb");

drCurrentRow = dtCurrentTable.NewRow();

drCurrentRow["ItemNo"] = box1.Text;
drCurrentRow["Description"] = box2.Text;
drCurrentRow["Qty"] = box3.Text;
drCurrentRow["UnitPrice"] = box4.Text;
drCurrentRow["TotalAmount"] = box5.Text;

for (int j = 0; j < ItemGv.Columns.Count; j++)
{
total = Convert.ToInt32(box3.Text) * Convert.ToSingle(box4.Text);
box5.Text = total.ToString();

}


for (int k = 0; k < ItemGv.Rows.Count; k++)
{

subtotal = subtotal + Convert.ToSingle(box5.Text);
subtotaltb.Text = subtotal.ToString();


}



rowIndex++;

}

Hi could you pls help GridViewRow iam able to use for GridViewColumn getting error as "Error 3 The type or namespace name 'GridViewColumn' could not be found (are you missing a using directive or an assembly reference? need to add any reference
"

Thanks Friend

Thanks if it is dynamic column how to do the multiplication?

Thanks

Thanks

Hi thanks for your reply
i used connection string pls see the code below

i dont know my question is correct or not? what the code u have given is for DDlist,Gview,detailview individually ... what i want is when i select let say dgg0001 as donumber in dropdown list in detail view it should display customer name,address for donumber related ,GRid view ---- item details please advice

hi thanks for your reply i have a doubt please
in one select statement we have to get all the values or
for grid view seperate and detail view seperate...

thanks for your reply
i need a line in that label should be the center aligned, sorry not underline..

Thanks karthik if i use this for example the text is Hi length of u is covering only hi my requirement is u must be longer and text center aligned in that

thanks prasad

Thanks for your reply ..issue not solved

Hi Eduard thanks for your reply
i tried the same DetailsView1.Rows.Count != 0 becoming false
i have given aspx code above could you please correct where it is going wrong

yes hi i will attach my aspx could you please chk am i doing any thing wrong
<asp:DetailsView ID="DetailsView1" runat="server" Height="50px"
Width="554px" AutoGenerateRows="False" BackColor="White" Visible="false"
BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4"
GridLines="Horizontal" >
<footerstyle backcolor="White" forecolor="#333333">
<rowstyle backcolor="White" forecolor="#333333">
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<fields>
<asp:TemplateField HeaderText="Company Name">
<itemtemplate>
<asp:Label ID="complbl" runat = "server" text='<%# Eval("CompName")%>'>


<asp:TemplateField HeaderText="Company Address">
<itemtemplate>
<asp:Label ID="addlbl" runat="server" Visible="true" text='<%# Eval("CompAdd")%>'>




<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
<editrowstyle backcolor="#339966" font-bold="True" forecolor="White">

Thanks sagar...again error is "Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index"

Thanks for your reply .. same error continuing

Thanks for your reply.. still the same

thanks it is not working

Thanks

Thanks

Thanks

Thanks Vinoth

Hi Anil thanks for your reply .. using dropdown list i have binded the value to detail view now my issue is grid view and textboxes, any suggestion how to link?

Thanks...

Thanks

Thanks for your reply? when you started learning that time some one reply to you like this how do you feel? why i should i want your approval???

Thanks for your reply

Thanks..

Hi Srinivas

Thanks for your reply.
string id = DetailsView1.Rows[0].Cells[1].Text.Trim(); is correct.
But i am able to take all row value and the cell value except what i want?
Rows[0].Cells[1].Text i am getting null value any suggestion?

thanks

Thanks

Hi Pranit and Hilmisu I am sorry this is my first project may be my question is wrong.
i am confused with this when i am adding the value of dynamic text box to datable can i add the value of other field also together? how to add? any links related to this?

Thanks Tushar for your repy .. the link is not opening .. do you know any other links like this?

Thanks a lot Prerak.
I have a query could you please help

My project is invoice Management
i have tables like customer details , Items & Calculation
i am confused with the Item Table since this is my first project not able to design properly

item table i have fields like Item No,Description,Qty,donumber,dodate i cannot make any fields us primary key from this(values not unique). these values i am taking from dynamic textboxes and saving into datatable then i am inserting it to database.i have two other field also like dono and doDate. I am planned Dono to make us primarykey.
But really no idea how to add donumber and dodate value to the item table.since i am inserting first 3 values from datatable to item.

could you pls advice how to do?

Thanks for your help

yes , i made few changes pls see below

const string insertsql = "INSERT INTO Items(Description,ItemNo,Qty)VALUES (";
sb.AppendFormat("{0}", insertsql);
foreach (string item in sc)
{
if (item.Contains(","))
{
splitItems = item.Split(",".ToCharArray());
sb.AppendFormat("'{0}','{1}','{2}');", splitItems[0], splitItems[1], splitItems[2]);


}
}

Now if i have one row of data i am able to save it to database.
if more than one row getting error as incorrect statement near '{2}' pls chk

Hi just i have started learning asp.net.. i hope you are well experienced.. thanks for your comments..one request pls read the question before answering..it is adding data table value to sql..

Hi thanks for your kind reply, i have tried your code also again i am getting the error as "AddItem Error:Incorrect syntax near 'INSERT INTO Items(Description,ItemNo,Qty)VALUES'." i will attach stack track also

Thanks Prerak,Timber my first cell is BoundField and done some changes bit confused bacause of that thanks...

thanks a lot this is the one what i am looking.but since i am new feeling some difficulties in adding references like System.Web.Mvc.dll(dont have in my Microsoft ASP.NET folder), Jason and Datatable could you please guide how to do that?

Thanks i will try..

thanks sriman my invoice consist of tables, textboxes, lines..
can i go ahead with crystal report?

thanks

Thanks prerak

Hi thanks for your reply first time trying this..

Hi Mukund thanks for your suggestion currently working on it..

Thanks i too find just now

Thanks Deepak let me try

Thanks Arun

Thanks

Database value to UI

yes deepak you are correct

Hi Arya thanks for your quick reply could you pls give a sample for SCOPE_IDENTITY()i feel this is better.

Thanks i will try for next option

Hi srimanch any updates?

hi sercan any updates?