Comments by Rohit.Net100 (Top 45 by date)

I put my button which cause redirect outside AjaxPanel.
Now works fine.
Thanks for help.

I am using path to my reports server, actually on my button click where i am doing redirect/transfer, it genegates pdf reports.

I am getting below error when using server.transfer---
Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Invalid path for child request 'http://defaultwebsite.aspx'. A virtual path is expected.

no..its not.

how to refresh session item after postback.

No luck !
Modified code:

Page.ClientScript.RegisterStartupScript(GetType(Page), "close", "<script language="'javascript'" type='text/javascript'>" & _
"window.close(); if (window.opener && !window.opener.closed) {" & _
"window.opener.location.reload(true) return false; } </script>")

I get my soultion. Thanks for help. This is what i changed.

function show(TxtSTUPort, TxtAAPort, STD_NUM_OF_SERVING) {
var TxtSTUPort = document.getElementById(TxtSTUPort);
var TxtAAPort = document.getElementById(TxtAAPort);
var STD_NUM_OF_SERVING = document.getElementById(STD_NUM_OF_SERVING);
STD_NUM_OF_SERVING.value = parseInt(TxtSTUPort.value) + parseInt(TxtAAPort.value);
if (!parseInt(STD_NUM_OF_SERVING.value)) {
STD_NUM_OF_SERVING.value = '';
}
}

Hi tried with below code, but getting error 'Conversion from string "return show('" to type 'Double' is not valid.'
please help...
vb code:
Private Sub GD_Prod_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles GD_Prod.ItemCreated
If TypeOf e.Item Is GridDataItem Then
Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)
Dim txtbox1 As TextBox = DirectCast(item.FindControl("TxtSTUPort"), TextBox)
Dim txtbox2 As TextBox = DirectCast(item.FindControl("TxtAAPort"), TextBox)
txtbox1.Attributes.Add("onblur", "return show('" + item.ItemIndex & "')")
txtbox2.Attributes.Add("onblur", "return show('" + item.ItemIndex & "')")
End If
javascript:
function show(index) {
var grid = $find("<%=GD_Prod.ClientID %>");
var MasterTable = grid.get_masterTableView();
var row = MasterTable.get_dataItems()[index];
var Value1 = row.findElement("TxtSTUPort").value;
var Value2 = row.findElement("TxtAAPort").value;
var cellValue = parseInt(Value1) + parseInt(Value2);
MasterTable.getCellByColumnUniqueName(row, "STD_NUM_OF_SERVING").innerHTML = cellValue;
}

i checked, 'ContentPlaceHolder1_GD_Prod_ctl00_ctl04_TxtPPort' wasn't exists on my page.
if i need to add it where should i add ?

no luck :(

tried above code also, by eliminating double quotes. but still no luck.

i change my JScript function:-


function Total(TxtPPort, TxtBFPort, TxtLOPort, TxtTSPort) {
var gridID = "<%= GD_Prod.ClientID %>";
var grid = document.getElementById(gridID);
var RowCount = parseInt("<%= GD_Prod.Items.Count %>");
var selection="";
for (var i = 2; i <= RowCount + 1; i++) {
var rowID = gridID + '_ctl' + (i > 9 ? i.toString() : '0' + i.toString());
var TxtPPort = document.getElementById(rowID + '_TxtPPort');
var TxtBFPort = document.getElementById(rowID + '_TxtBFPort');
var TxtLOPort = document.getElementById(rowID + '_TxtLOPort');
var TxtTSPort = document.getElementById(rowID + '_TxtTSPort');
TxtTSPort.value = parseInt(TxtPPort.value) + parseInt(TxtBFPort.value) - parseInt(TxtLOPort.value);
}

still i am getting same error, after using above javascript code.

ci have checked. controls are there.

But, where should i define 'ContentPlaceHolder1_GD_Prod_ctl00_ctl04_TxtPPort' in my code.

Hi,

I am using below code for calculation column values in grid.
But i am getting Jscript error:
Microsoft JScript runtime error: 'ContentPlaceHolder1_GD_Prod_ctl00_ctl04_TxtPPort' is undefined.

Private Sub GD_Prod_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles GD_Prod.ItemCreated

If TypeOf e.Item Is GridDataItem Then
Dim item As GridDataItem = DirectCast(e.Item, GridDataItem)
Dim T1 As TextBox = TryCast(item.FindControl("TxtPPort"), TextBox)
Dim T2 As TextBox = TryCast(item.FindControl("TxtBFPort"), TextBox)
Dim T3 As TextBox = TryCast(item.FindControl("TxtLOPort"), TextBox)
Dim T4 As TextBox = TryCast(item.FindControl("TxtTSPort"), TextBox)
T1.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
T2.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
T3.Attributes.Add("onblur", ((("Total(" + T1.ClientID & ",") + T2.ClientID & ",") + T3.ClientID & ",") + T4.ClientID & ")")
End If

End Sub

Client side code:
function Total(TxtPPort, TxtBFPort, TxtLOPort, TxtTSPort) {
TxtTSPort.value = parseInt(TxtPPort.value) + parseInt(TxtBFPort.value) - parseInt(TxtLOPort.value);
}

Any sample example ?

Can we store all Grid data in session. If So How? If Not, Then what is the alternate

protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
DateTime SelectedDeate = Calendar1.SelectedDate;
Label1.Text = SelectedDeate.DayOfWeek.ToString();
}

i am binding grid on grid_load event
and saving grid on btn_save_click event.
Bound columns data is saving,and i can see values in debug.
But problem is item template(textbox) values are not saving, while debuging it shows me value = "".
How to avoid grid rebinding on page_load. Can you show me an example.

i am binding grid on grid_load event
and saving grid on btn_save_click event.
Bound columns data is saving,and i can see values in debug.
But problem is item template(textbox) values are not saving, while debuging it shows me value = "".
Please help

records in database field is more than 100+

I changed my code as per your suggestion.
But now i got an FormatException of Input String was not in correct format.
Error was in line-
Dim str5 As String = Integer.Parse(item.Cells(5).Text.Trim)
If String.IsNullOrEmpty(str5) Then
str5 = "0"
End If
Itried many method to convert string in integer, but nothing worked

thanks dave

How to validate user input and allow textbox with empty values.

Here's my code
In Insert command, i need to pass my pk value also, which will come from a label control on page.
Public Sub btnsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsave.Click
If True Then
Dim rowIndex As Integer = 0
Dim sc As New StringCollection()
If ViewState("CurrentTable") IsNot Nothing Then
Dim dtCurrentTable As DataTable = DirectCast(ViewState("CurrentTable"), DataTable)
If dtCurrentTable.Rows.Count > 0 Then
For i As Integer = 1 To dtCurrentTable.Rows.Count
'extract the TextBox values
Dim box1 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(4).FindControl("TxtSTUPort"), TextBox)
Dim box2 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(5).FindControl("TxtAAPort"), TextBox)
Dim box3 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(7).FindControl("TxtFPort"), TextBox)
Dim box4 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(8).FindControl("TxtQoFUsed"), TextBox)
Dim box5 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(9).FindControl("TxtPPort"), TextBox)
Dim box6 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(10).FindControl("TxtBFPort"), TextBox)
Dim box7 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(11).FindControl("TxtLOPort"), TextBox)
Dim ddl As DropDownList = DirectCast(GD_Prod.Items(rowIndex).Cells(12).FindControl("ddlLOCode"), DropDownList)
Dim box8 As TextBox = DirectCast(GD_Prod.Items(rowIndex).Cells(13).FindControl("TxtTSPort"), TextBox)

'get the values from the TextBoxes
'then add it to the collections with a comma "," as the delimited values
sc.Add(box1.Text + "," + box2.Text & "," + box3.Text & "," + box4.Text & "," + box5.Text & "," + box6.Text & "," + box7.Text & "," + ddl.SelectedValue & "," + box8.Text)
rowIndex += 1
Next
'Call the method for executing inserts
InsertRecords(sc)
End If
End If
End If
End Sub

Private Sub InsertRecords(ByVal sc As StringCollection)
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("FOOD_AND_NUTRITIONConnectionString").ConnectionString)
Dim sb As New StringBuilder(String.Empty)
Dim splitItems As String() = Nothing
For Each item As String In sc
Const sqlStatement As String = "INSERT INTO FNProdRecDetails (PL_Student_Portions_Planned, PL_Adults_ALC__Portions_Planned, PL_Factor_Portions, DOC_Quantity_Of_Food_Used, DOC_Portions_Prepared, DOC_Portions_Brought_Forward, DOC_Portions_Leftover,DOC_Leftover_Code, DOC_Total_Portions_Served) VALUES"

If item.Contains(",") Then
splitItems = item.Split(",".ToCharArray())
sb.AppendFormat("{0}('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}'); ", sqlStatement, splitItems(0), splitItems(1), splitItems(2), splitItems(3), splitItems(4), splitItems(5), splitItems(6), splitItems(7), splitItems(8))
End If
Next
Try
conn.Open()
Dim cmd As New SqlCommand(sb.ToString(), conn)
cmd.CommandType = CommandType.Text
cmd.ExecuteNonQuery()
'Display a popup which indicates that the record was successfully inserted
Page.ClientScript.RegisterClientScriptBlock(GetType(Page), "Script", "alert('Records Successfuly Saved!');", True)
Catch ex As System.Data.SqlClient.SqlException
Dim msg As String = "Insert Error:"
msg += ex.Message
Throw New Exception(msg)
Finally
conn.Close()
End Try
End Sub

I tried the code mention in link which you send me.
But i have one issue.
In my insert query, i want to insert an additional field(PKey Value) which is not related to my grid columns.
Since when i run insert command it shows me error, that primary key can't be null.
on same webform i have one label which have that primary key value, now how can i insert this value using code above.

Please help.

i tried to merge but, my grid displays data only from 1st dataset.

I removed the condition, but still no change.

yes i debug it. can you plz help me what i am missing in code.

Firstly, i want to check who log in on my page using directoryservices. Secondly according to log in user, i want to populate my data from sql database on label/grid controls using databinding.
Now my question is which way i will do this.

Checked everything..still no change.

Tried it...but no change. Any alternates

Any alternate Ideas.

On BtnClick, what code should i put to hit DB and get the data.
Any sample code is helpful.

Thank you. Really Helpful.