i want to get dynamically the Data Source value from which system iam acessing the website and concatenate in connection String
but still showing null value
[Code]....
This problem is driving me nuts. I have labels inside a gridview. When i reference them, i keep getting a null error. This is definatly that it cant find the labels inside the template. below is my code that i am using.
[Code]....
I'm selecting table data of the current user:
SELECT [ConfidenceLevel], [LoveLevel], [HappinessLevel] FROM [UserData] WHERE ([UserProfileID] = @UserProfileID)
I have set a control to the unique user ID and it is getting the correct value:
HTML: <asp:Label ID="userID" runat="server" Text="Labeluser"></asp:Label>
C#: userID.Text = Membership.GetUser().ProviderUserKey.ToString();
I then use it in the where clause using the Configure Data Source window unique ID = control then controlID userID(fills in .text for me)
I compile and run but nothing shows up where the table should be.
Here is the code it has created:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ConfidenceLevel" HeaderText="ConfidenceLevel"
[Code]....
I'm trying to retreive values entered by users in the textboxes in the footer of the gridview and insert these values into another sql table.My code is as follows :-
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("addnew"))
{
TextBox t1 = (TextBox)GridView2.FooterRow.FindControl("tfrm");
string frm = t1.Text;
TextBox t2 = (TextBox)GridView2.FooterRow.FindControl("tsub");
string sub = t2.Text;
string cmd = "insert into suggestions values('" + frm + "','" + sub + "','c','c')";
con.Open();
SqlCommand com = new SqlCommand(cmd,con);
int a = com.ExecuteNonQuery();
GridView2.DataBind();
con.Close();
}
}
But the strings 'frm' and 'sub' returns null values.
I have a gridview with daatsource from MembershipUserCollection. When my collection doesn't contain any records the gridview just disappears. I want to display the empty gridview indicating no records exist rather than the grid just become invisible.
How to make gridview always visible ?
i am working on a website,As i am new to coding i got a problem in it. It was,I hav a gridview in which i am adding the details about a college, and in that i had a buton ("btnReservation") on clicking it another grid will be appeared in which, i hav to enter the reservation details so, till this step it is working fine, but if i enter one college details and clicking on the btnReservetion the grid is being dispalyed and i am able to enter and save the data, But if i enter the details of another college and clicking on the btnReservation, the rows which i hav already entered in the Reservation grid for the previous record are not being Refreshed and are remaining the same,So now i hav to make the gridview datasource null.
[code]...
I have 3 radio buttons op1, op2, op3 working as a group. In the code behind I check to see if a paticular button is checked, then do some processing. The problem is all the buttons return null. Checked in the debugger and all values are null even op1 which value is set to true.
Front end code for the buttons are:
<asp:RadioButton ID="op1" runat="server" AutoPostBack="True" Checked="True"
GroupName="searchOPT" oncheckedchanged="op1_CheckedChanged" />
<asp:RadioButton ID="op2" runat="server" AutoPostBack="True"
GroupName="searchOPT" oncheckedchanged="op2_CheckedChanged" />
<asp:RadioButton ID="op3" runat="server" AutoPostBack="True"
GroupName="searchOPT" oncheckedchanged="op3_CheckedChanged" />
The test in the code behind is:
if (op1.Checked)
{.....do stuff...}
if (op3.Checked)
{.....do stuff...}
if (op3.Checked)
{.....do stuff...}
I have a SQLDataSource on an ASP.Net C# page. I want the ability to add a Control Parameter based on a DropDown List that will either display records that are either NULL or Not NULL In a Column. I have the following Code Snippet:
SelectCommand="SELECT [PATID], [LastName], [FirstName], [UIN], [Rate], [Account], [Project], [Supervisor], [HireDate], [Assistantship], [Hourly], [FundingStartDate], [FundingEndDate], [TerminationDate], [Citizenship], [TitleCode], [Email], [Notes],
[SupervisorUpdateEnabled], [SupervisorTargetSemesterCode], [PATCertDate] FROM [PATAccounts] WHERE TerminationDate @Terminated ORDER BY [LastName]"
I need to export a pdf using Report viewer.I have not to use .xsd(dataset). Instead i have to use the normal stored procedure and i can use data set and get the table.I need to assign the data table to the table in the report viewer in VS 2010.
View 1 Replies[URL] .....
I have an error with this tutorial.
Line 13:
Line 14: Private Sub BindGrid()
Line 15: Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Line 16: Using con As New SqlConnection(constr)
Line 17: Using cmd As New SqlCommand("Customers_CRUD")
Imports System.Data
Imports System.Configuration
Imports System.Data.SqlClient
Public Class tessatusatu
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code] ......
Once again i am faced with an issue. I must allow a user to add as many pieces of data as they wish. I have therefore employed some javascript from an tutorial
[URL]
I would now like to return the data from the dynamic fields through the c#(.cs page)
I am tryting to reach controls in the gridview rows by RowCommand event. I can take values of controls which are binded to gridview source successfully . But for all other controls which is not binded to gridview returns NULL value. All controls run at server. Why is that?
View 7 RepliesI have been trying for two months to get this code working, and I am close, but still confused. I want the JQuery UI Autocomplete function to call an web service which returns JSON data and display that data for selection, and on selection put the selected value into a hidden field.
There are several issues:
1) The autocomplete function is not firing
2) The source: "/AutoSuggest.asmx/DOTFind?" line throws an invalid object exception
3) The service requires two parameters: (string prefixText, int count) - count tells it how many records to return.
4) I am not at all certain that this code will accept JSON data that comes back from the service
Here is the code:
[code]....
I am trying to return the table of Users and display it on a page which uses a masterpage.
My master page file called AjaxMaster.Master looks like this -
[code].....
This is regarding GetPreloadedEntityBody() function of HttpWorkerRequest class . I am using this method to get perloaded data of requested page. but GetPreloadedEntityBody() function alway returns me null value , while same code is working for server with IIS6.0
1) I have Application_PostAcquireRequestState event . on which i do all user releated validation.
2) After Sucessful validation i am creating object like below code snippet of worker process.
Dim hwr As HttpWorkerRequest =
CType(context.GetType.GetProperty("WorkerRequest", Reflection.BindingFlags.Instance
Or Reflection.BindingFlags.NonPublic).GetValue(context,
Nothing), HttpWorkerRequest)
3) AFter That checking where request has body or not and the calling GetPreloadedEntityBody() which is returning null alway for IIS7.0 ,while in IIS6.0 same code is working fine.
if hwr.HasEntityBody
Then
Dim preloadedBufferData
As Byte() = hwr.GetPreloadedEntityBody()
end if
what more do i have to do so that i can get return value form GetPreloadedEntityBody() function.
My model include this attribute
public class RegisterModel
{
//blah blah Attribute[code]....
before run into the view , i check the field , see it contain value . But after running through this view
[Code]....
The output field is null , while other attribute still ok , why is it ?how can i resolve this ?
[Code]....
iam using asp.net2.0 with c# with sql server 2000 when iam executing the procedure in local system it is working fine.but when iam executing in client system procedure returns null value, i have checked all connection string , and session value all are working
I have an ASP.NET web service which returns an XMLDocument. The web service is called from a Firefox extension using XMLHttpRequest.
var serviceRequest = new XMLHttpRequest();
serviecRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
I consume the result using responseXML. So far so good. But when I iterate through the XML I retrieve nodeValue - nodeValue is always null. When I check the nodeType the nodeType is type 1 (Node.ELEMENT_NODE == 1).
Node.NodeValue states all nodes of type Element will return null.
In my webservice I have created a string with the XML i.e. xml="Hank"
I then create the XmlDocument
XmlDocument doc = new XmlDocument();
doc.LoadXML(string);
I know I can specify the nodetype using using CreateNode. But when I am just building the xml by appending string values is there a way to change the nodeType to Text so Node.nodeValue will be "content of the text node".
I have a reportViewer control and I dynamically setting the report path and dataset in the page load event if it is not a post back. This first report displays without issue. However, when I attempt to change the report path / dataset via the onChange event from a dropdown list I get the following error:
A data source instance has not been supplied for the data source "Summary_DataTable1".
This code works fine and the summary report is displayed the first time the page is loaded.
[code]....
Im currently experincing some difficulties with the viewState. The scenario is that i have a datagrid that has a column of buttons that when pressed will store a value in the viewState. I have already done this on one occasion in the same page, but for some reason the second item in the view state is always returning null, even when i hardcode in a number in before the postback. Im at a loss as to why this is happening, anyone expericened this and know what is wrong.
EDIT: Ive found out the cause, Its due to when you click a button in a data grid it does the postback code first, then fires the event handler, so of course the view state would be empty as it is coded to be set in the event handler for the button click. Is there any way to avoid that? So the event code is fired before the postback code?
I am using
SqlHelper.ExecuteDataset(MyConnectionString, CommandType.StoredProcedure, "GetInformation", new SqlParameter("@ID", ID));
In my stored Procedure, I am doing a lot of calculation with joins and it took 19 sec to execute at my sql Server 2008. My application had been working perfectly for 5 days but now as database increases, I found a problem that my connection is breaking at that point. At Sql Server, it execute fine but when I add a breakpoint and watch the stored procedure is returning null.
I have this code in my code behind class. I keep getting this error that "Value cannot be null, parameter name source"
[Code]....
I want to change source of iframe dynamically. i.e by request.query the url will be assigned.
View 1 RepliesI'm making a html document by using a StringBuilder, the document is used at a messageBody for a email.
I want to add a Image to the document. Bu no matter how I'm doing it the image dosen't show up in the email.
The image is available from the site, I've tried pasting the address in the browser and the image shows up fine.
[Code]....
How can i get the values even when the Source or url is null from the below query
SELECT a.id,
isnull((SELECT STUFF((SELECT
'<li><a href="'+url+'">'+Source_Name+'</a>
<span>(' + k.Source +')</span></li>' end
FROM table1 i, table2 k, table3 j where
i.CategoryID = j.Category_ID and i.CategoryID = c.Category_ID and i.Source = k.ID
FOR XML PATH('')),1, 0, '')), '') AS Source_url,
FROM @table4 c INNER JOIN table5 v
on c.Category_ID = v.Category_ID