|
I have a stored procedure that returns the name of a tab based on the provided key.
I need to get the tab_name out of the dataset table (called rows) and put it in the NewTab.Text property.
I tried this which doesnt work:
NewTab.Text = DataBinder.Eval("ReturnedDataset.Tables["rows"].DefaultView.[0].tab_name");
I've been reading the documentation but cant seem to get it to work. What should I be using ?
|
|
|
|
|
Did you try it without quotes?
digsy_ wrote:
NewTab.Text = DataBinder.Eval("ReturnedDataset.Tables["rows"].DefaultView.[0].tab_name");
Literal "ReturnedDataset.Tables["rows"].DefaultView.[0].tab_name" is passed to Eval function. You want to pass value in tab_name.
NewTab.Text = DataBinder.Eval(ReturnedDataset.Tables["rows"].DefaultView.[0].tab_name);
Just noticed... You example shouldn't even compile - You cannot nest quotes!
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
I have the following database table. This is a list of department names.
DeptID Department
1 Administration
2 Information Technology
3 Product Development
4 Sales
5 Marketing
6 Partnerships
7 Contractor
From the Employees table I read in this record:
1001 7 4 Doe Jane M 12/24/2005 12:00:00 AM False
My problem is this: I’m using a web page to edit employee information. On this web form there are four drop down boxes, one each for Departments, Titles, Address Types and States. After I initialize the web page and populate the above mentioned drop down list with the necessary data. I want to take the employee record and set the drop down list to the right item in the list.
How can I make ASP.NET populate the dropdown lists based on the foreign ID number contained in the employee record?
I have a screen shot of what I want the data to look like in the web page, but I can't show it in this message.
Thank you,
Quecumber256
|
|
|
|
|
listControl.SelectedIndex = listControl.Items.IndexOf(listControl.Items.FindByValue(deptID))
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
hi,
can any one help me out...
i have developed one project in which the my contents are in the user control and am just exposing the click of the button to the page and by clicking on it a popup is opening. in the same user control i have a gridview which showing some data. but when i click on the button the popup opens the gridview content disappear for the case of mozila but working fine with IE.
can some one tell me the reason why is it so...
its urgent...
|
|
|
|
|
Warning - this is a dig at Microsoft!
Why on earth did MS use a variable called ToolTip to represent the title attribute of an image tag? Don't they know that only IE incorrectly uses this as a tooltip!?! Grrrrrr!!
/rant over
It always feels good to dis the big boys
|
|
|
|
|
Please forget about First One which I posted befere, And can you help me to solve the problem plase.
Server Error in '/' Application.
--------------------------------------------------------------------------------
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Source Error:
Line 1: <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="SingleDate.aspx.vb" Inherits="AuditLog_SingleDate" title="Untitled Page" %>
Line 2:
Line 3: <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Line 4: Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
Line 5: <asp:content id="Content1" contentplaceholderid="ContentPlaceHolder1" runat="Server">
Source File: /AuditLog/SingleDate.aspx Line: 3
Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Sarfarj Ahmed
|
|
|
|
|
A little more background might be useful. What are trying to do? What have you done?
only two letters away from being an asset
|
|
|
|
|
1. Pulling or Talking data from Server
2. Using Microsoft Reporting Service to create Report
3. VS2005-->>ASP.NET-->>REPORT.RDLC
Thanks
Sarfarj Ahmed
|
|
|
|
|
This is pretty obvious from the error message. Now how about giving some info that will actually help.
only two letters away from being an asset
|
|
|
|
|
Actually I dont know wot information you need.
Basically, Source File: /Lesson/Lessons.aspx suppose to show CustomerReports.rdlc report From the Server, Where Server got SQL SERVER DATABASE, When I will click SHOW button on that time report should be come but If I click .aspx file on that time Im getting error.
Thanks
Sarfarj Ahmed
|
|
|
|
|
Hi
Im Developing file upload /download process. i can upload 600 MB file when i run my application locally. i Can not achieve this on live sever. i updated my web.config file as
<httpRuntime executionTimeout="1800" appRequestQueueLimit="100" maxRequestLength="655600" useFullyQualifiedRedirectUrl="false" enableVersionHeader="true" minFreeThreads="8" minLocalRequestFreeThreads="4" />
r_palanivel83 10:01 4 Jan '06
|
|
|
|
|
I used this n its working fine for me ...pls check
<httpruntime
executiontimeout="90"
maxrequestlength="512000"
usefullyqualifiedredirecturl="false"
minfreethreads="8"
minlocalrequestfreethreads="4"
apprequestqueuelimit="100"
>
|
|
|
|
|
Hi actually i have done this on my web.config but its not working in my live server. is it working locally or online for u?
r_palanivel83 10:01 4 Jan '06
|
|
|
|
|
Its working for me locally as well as online too...
|
|
|
|
|
i m developing a web based application in c#. i just wanted to ask the most basic qn..
how to insert the current date in the database... how shud i provide the option on the webpage.. and wat all is required in the database.
till yet i have created a field named Dt and datatype datetime..
Kunal Piyush
|
|
|
|
|
Hi
You can insert Data in many ways . try to use stored procedures(for good programming).
here i give u some sample code
SqlConnection sqlCon=new SqlConnection("connection string");
sqlCon.Open();
SqlCommand insertCmd = new SqlCommand("stored procedure name", sqlCon);
insertCmd.CommandType = CommandType.StoredProcedure;
//Create parameter and Set values
insertCmd.Parameters.Add(<parameter name>, <DataType>,<size>);
insertCmd.Parameters[<parameter name>].Value = <Value>
insertCmd.ExecuteNonQuery();
sqlCon.Close();
r_palanivel83 10:01 4 Jan '06
|
|
|
|
|
hey
i m sorry if i cudnt clarify myself..
wanted a walthrough ragarding inserting a DATE...
thx..
Kunal Piyush
|
|
|
|
|
DateTime.Now is the .NET method of getting the current date object.
or if your using SQL Server you can use the GETDATE() SQL command directly in your query
|
|
|
|
|
HI
you just use this code
insertCmd.Parameters.Add("@DateVale", SqlDbType.DateTime,10);
insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")
r_palanivel83 10:01 4 Jan '06
|
|
|
|
|
r_palanivel83 wrote: insertCmd.Parameters["@DateVale"].Value = DateTime.Today.ToString("MM/dd/yyyy")
Why on Earth would you convert the date to a string?! Just pass it the DateTime object.
|
|
|
|
|
i am now able to add the date to the database.. bu there is on problem.. when i retrive the date when the employee was added.. it will also the time along the date..
i dont want the time to at all get into the database... is it possible.
Kunal Piyush
|
|
|
|
|
A date field also includes the time - I see no reason why you wouldn't want this information available even if you don't want to display it. Use DateTime.ToString(format) to format the output without time.
|
|
|
|
|
a lil bit of problem..
the date would be retrieved from the database... now how shud i fomat it without the time.. and in DD/MM/YYYY format..
to retrieve i m using this line of code
Label1.Text = "" + dread["dt"].ToString();
where dt is the datetime field in the database.
Kunal Piyush
|
|
|
|
|
Kunal P wrote: Label1.Text = "" + dread["dt"].ToString();
If you look in the documentation you'll see the ToString method is overloaded (has several different methods with different parameters). You can feed is a string format like this: (and you don't need the initial blank string - that just creates another object to be cleaned up by the GC)
Label1.Text = dread["dt"].ToString("dd/MM/yyyy");
You'll probably find you need to cast it to a DateTime object first:
Label1.Text = ((DateTime)dread["dt"]).ToString("dd/MM/yyyy");
This documents the possible formating strings:
Custom DateTime Format Strings
|
|
|
|