Comments by rajrprk (Top 32 by date)

Hello this is another post but relevant to that post

Thanks a lot

arrayOfStrings(1) for this i am getting YYYYMM. But i want the value ie.,200502. Here YYYYMM, ename,gae,sex all are field name i want the value of the field.

Here i m not passing value to row identity column. if one user insertings means no problem when N number of user inserting means that time alone problem with this trigger

i have created three string builder ie., SB,SB1,SB2
string BK_Code = ((ImageButton)sender).CommandName;
StringBuilder sb = new StringBuilder();
sb.Append("<Script language='javascript'>");
sb.Append("var m_Format = showModalDialog('Rpt_BL_Format.aspx','null','dialogHeight:150px,dialogWidth:150px,center:yes');");
sb.Append("if (m_Format == 'TTL')");
sb.Append("window.open('Rpt_BL_BKN_GBI.aspx?BK_Code=" + BK_Code + "&SMode=E&m_Format=TTL','childwindow','fullscreen,status=yes, scrollbars=1,TOP=0,LEFT=0,resizable=YES');");
sb.Append("</Script>");
ClientScript.RegisterStartupScript(typeof(string), "Print", sb.ToString());
StringBuilder sb1 = new StringBuilder();
sb1.Append("<Script language='javascript'>");
sb1.Append("var m_Format = showModalDialog('Rpt_BL_Format.aspx','null','dialogHeight:150px,dialogWidth:150px,center:yes');");
sb1.Append("if (m_Format == 'GBI')");
sb1.Append("window.open('Rpt_BL_BKN_GBI.aspx?BK_Code=" + BK_Code + "&SMode=E&m_Format=TTL','childwindow','fullscreen,status=yes, scrollbars=1,TOP=0,LEFT=0,resizable=YES');");
sb1.Append("</Script>");
ClientScript.RegisterStartupScript(typeof(string), "Print", sb1.ToString());
StringBuilder sb2 = new StringBuilder();
sb2.Append("<Script language='javascript'>");
sb2.Append("var m_Format = showModalDialog('Rpt_BL_Format.aspx','null','dialogHeight:150px,dialogWidth:150px,center:yes');");
sb2.Append("if (m_Format == 'AIC')");
sb2.Append("window.open('Rpt_BL_BKN_AIC.aspx?BK_Code=" + BK_Code + "&SMode=E&m_Format=TTL','childwindow','fullscreen,status=yes, scrollbars=1,TOP=0,LEFT=0,resizable=YES');");
sb2.Append("</Script>");
ClientScript.RegisterStartupScript(typeof(string), "Print", sb2.ToString());
But still not redirecting

i have tried that one also for this only i m getting this error
Input string was not in a correct format

" + Convert.ToInt32(dr("SAVINGS")) + "
ya sorry i have tried that one also for this only i m getting this error
Input string was not in a correct format

if i use like this " + dr("SAVINGS") + "'i m getting error follows
Input string was not in a correct format

While inserting at that time i want to convert that to numeric value

i have updated now

ya i have tried that one too (like this '" + dr("SAVINGS") + "'

not a same column name, XML file i m retriving using the tag name

Please post some sample code with this example i m new to this concept

i added the code but i didn't get data
whether i want to add the field in itemtemplate

reportData.ReadXml(Server.MapPath("report.xml"));
instead of the above code i want to select and upload the xml.file. but here it is statically declared as report.xml
My need is, i m having an fileupload control when i select a file then i want to insert the corresponding XML file into the table

here i m getting error 'object' does not contain a definition for 'Parent'

Better U can set as a varchar (or) nvarchar field

ok ...........

i want to show empty rows programmatically, If grid contain 15 records means pagesize=10 then it will take 2 pages. in the 2nd page contain only 5 records in that 2 page i want add 5 extra rows. This is my requirment. Not foe every page of the gridview

ok here i had applied but i m not getting any empty row the grid

private void BindGrid()
{
//int iPageSize = 0;
//int iRow = 0;
SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=Demo_eLogsVA4;Integrated Security=True");
cn.Open();
string q = "Select Convert(nVarchar,A.Rec_No) CRec,A.Acc_Name Descr,A.Quantity Qty,Convert(nVarchar,A.Sell_Rate) SRate,Sell_CName Sname , Sell_CCode SCCode, Sell_CValue SCValue ,Convert(numeric,A.Quantity*A.Sell_Rate*Sell_CValue) as SAmount, A.Service_Tax STax,Convert(nVarchar,(A.Quantity*A.Sell_Rate*Sell_CValue)* A.Service_Tax/100)Tax_Amount,Convert(numeric,((A.Quantity*A.Sell_Rate*Sell_CValue)+(A.Quantity*A.Sell_Rate*Sell_CValue)* A.Service_Tax/100)) as Net From eLogs_Invoice_Charges_Details A Where A.Invoice_Code='INV1'";
//string qq = "Select COUNT(*) From eLogs_Invoice_Charges_Details A Where A.Invoice_Code='INV1'";
DataSet dset = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(q, cn);
//DataTable dtable = new DataTable();
da.Fill(dtable);
if (dtable.Rows.Count < 5)
{
GridView1.DataSource = dtable;
GridView1.DataBind();
}
else
{
ShowNoResultFound(dt, GridView1);
}
object obj = dtable.Compute("Sum(Net)", "");
object amt=dtable.Compute("Sum(SAmount)","");
decimal value=0;
if (obj != null)
{
value = (Decimal)obj;
}
else
{
// obj is null.
}
//DataRow dr;
//for (int i = dt.Rows.Count; i < 10; i++)
//{
// dr = dt.NewRow();
// dr[0] = dr[1] = dr[2] = dr[3] = dr[4] = "";
// dt.Rows.Add(dr);
//}
//dt.AcceptChanges();
//object obj = dtable.Compute("SUM(Net)", string.Empty);
//dtable.Rows.Add(new object[] { "", "" });
//dtable.Rows.Add(new object[] { "", "" });
//iPageSize = Convert.ToInt32(GridView1.PageCount.ToString());
//iRow = Convert.ToInt32(GridView1.Rows.Count.ToString());
GridView1.FooterRow.Cells[1].Text = "Total:";
GridView1.FooterRow.Cells[7].Text = amt.ToString();
GridView1.FooterRow.Cells[10].Text = value.ToString();
//GridView1.FooterRow.Cells[2].Text = iRow.ToString();
//GridView1.FooterRow.Cells[3].Text = iPageSize.ToString();
GridView1.FooterStyle.Font.Bold = true;
cn.Close();
}

private void ShowNoResultFound(DataTable source, GridView gv)
{
source.Rows.Add(source.NewRow()); // create a new blank row to the DataTable
// Bind the DataTable which contain a blank row to the GridView
gv.DataSource = source;
gv.DataBind();
// Get the total number of columns in the GridView to know what the Column Span should be
int columnsCount = gv.Columns.Count;
gv.Rows[0].Cells.Clear();// clear all the cells in the row
gv.Rows[0].Cells.Add(new TableCell()); //add a new blank cell
gv.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell

//You can set the styles here
gv.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
gv.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red;
gv.Rows[0].Cells[0].Font.Bold = true;
//set No Results found to the new added cell
gv.Rows[0].Cells[0].Text = "NO RESULT FOUND!";
}

Here i m getting error ie., Object reference not set to an instance of an object.

private void BindGrid()
{
//int iPageSize = 0;
//int iRow = 0;
SqlConnection cn = new SqlConnection("Data Source=.;Initial Catalog=Demo_eLogsVA4;Integrated Security=True");
cn.Open();
string q = "Select Convert(nVarchar,A.Rec_No) CRec,A.Acc_Name Descr,A.Quantity Qty,Convert(nVarchar,A.Sell_Rate) SRate,Sell_CName Sname , Sell_CCode SCCode, Sell_CValue SCValue ,Convert(numeric,A.Quantity*A.Sell_Rate*Sell_CValue) as SAmount, A.Service_Tax STax,Convert(nVarchar,(A.Quantity*A.Sell_Rate*Sell_CValue)* A.Service_Tax/100)Tax_Amount,Convert(numeric,((A.Quantity*A.Sell_Rate*Sell_CValue)+(A.Quantity*A.Sell_Rate*Sell_CValue)* A.Service_Tax/100)) as Net From eLogs_Invoice_Charges_Details A Where A.Invoice_Code='INV1'";
//string qq = "Select COUNT(*) From eLogs_Invoice_Charges_Details A Where A.Invoice_Code='INV1'";
DataSet dset = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(q, cn);
//DataTable dtable = new DataTable();
da.Fill(dtable);
GridView1.DataSource = dtable;
object obj = dtable.Compute("Sum(Net)", "");
object amt=dtable.Compute("Sum(SAmount)","");
decimal value=0;
if (obj != null)
{
value = (Decimal)obj;
}
else
{
// obj is null.
}
DataRow dr;
for (int i = dt.Rows.Count; i < 10; i++)
{
dr = dt.NewRow();
dr[0] = dr[1] = dr[2] = dr[3] = dr[4] = "";
dt.Rows.Add(dr);
}
dt.AcceptChanges();
//object obj = dtable.Compute("SUM(Net)", string.Empty);
//dtable.Rows.Add(new object[] { "", "" });
//dtable.Rows.Add(new object[] { "", "" });
GridView1.DataBind();
//iPageSize = Convert.ToInt32(GridView1.PageCount.ToString());
//iRow = Convert.ToInt32(GridView1.Rows.Count.ToString());
GridView1.FooterRow.Cells[1].Text = "Total:";
GridView1.FooterRow.Cells[7].Text = amt.ToString();
GridView1.FooterRow.Cells[10].Text = value.ToString();
//GridView1.FooterRow.Cells[2].Text = iRow.ToString();
//GridView1.FooterRow.Cells[3].Text = iPageSize.ToString();
GridView1.FooterStyle.Font.Bold = true;
cn.Close();
}<pre lang="c#"><pre lang="c#"></pre></pre>

i have error in the above code.

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:


Line 50: }
Line 51: DataRow dr;
Line 52: for (int i = dt.Rows.Count; i < 10; i++)
Line 53: {
Line 54: dr = dt.NewRow();

The purpose of this for loop is to insert blank row if pagesize not equal to the pagerows in the grid view

Before the DataRow dr; what should i fill there. I have already filled the grid in the bind method itsely. Please let me know