I was wondering if there is any way that I could have a null value (or any other static value) appear at the top of a drop down list which is then populated from an AccessDataSource.I need it so that users can select a tag for their post (within a social networking system) if they wish to post to a group page or they can simply leave the list as null to post to their profile.
View 1 RepliesI have an .aspx file that has 3 drop down lists:
ddlMake
ddlModel
ddlColour
i have a Page_Load function but i cant acces them in the Page_Load function...
using System;
using System.Collections.Generic;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
namespace NorthwindCascading
{
public partial class _IndexBasic : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CarService service = new CarService();
List<string> Makes = service.GetCarMakes();
ddlMake.DataSource = Makes;
ddlMake.DataBind();
ddlMake.Items.Insert(0, " -- Select Make -- ");
}
}
}
}
I have added the code-behind file manually so i guess i am missing something... it just says that the ddlMake element is not defined in current context.
Basicly i have created a database in access with 2 tables the secind table has a drop down with the field infor from the first.
Now when i link the database to the VB and insert the combo box in form the selecetion is not there?
What do i have to further deffine to appear?
I have a formview on my aspx page containing various controls arranged using table. There is a DDL "cboClients" which i need to enable or disabled depending upon role within Edit mode.
The problem here is that i am not able to get that control using FindControl() method.
I have tried following code -
DropDownList ddl = null;
if (FormView1.Row != null)
{
ddl = (DropDownList)FormView1.Row.FindControl("cboClients");
ddl.Enabled=false;
}
Even I ave used the DataBound event of the same control -
protected void cboClients_DataBound(object sender, EventArgs e)
{
if (FormView1.CurrentMode == FormViewMode.Edit)
{
if ((Session["RoleName"].ToString().Equals("Clients")) || (Session["RoleName"].ToString().Equals("Suppliers")))
{
DropDownList ddl = (DropDownList)sender;
ddl.Enabled = false;
}
}
}
But this databound event occurs only once, but not when formview mode is changed.
I'm struggling with a web form where I have created one date field and couple of drop down lists. These drop down lists populate themselves from a backend MS ACCESS database file. My problem is that I am not able to make the two drop down menus dependent in a manner that when the first drop down menu is selected the second should be populated accordingly?
This is the code for the website form:
[Code].....
i am trying to search from 2 dropdown lit from my databse (sqlserver)
1st drop down list contain(Dr, Hospital, Bloodbank) and 2nd dropdown contain areas(like in hyderabd areas are HITECK CITY, VIDYANAGAR, DILSUKHNAGAR and so any)
how to serach from dropdown list.
I have a drop down list that has the initials of about 12 of our sales guys.How can I make it so that when they select their initials from the list, the next drop down list only shows their customers.In my database there is a column for customer name and salesman.
View 6 RepliesHere's a short explanation of my asp.net project.
1) the default page loads, it will read the Windows Login of the user opening the page.
2) I'll check if this login exists in a table stored on the webserver.
In this Access Database, there's a 2nd linked table, pointing to another access table on a network location. Now, I want to read data from this linked table. However, at this moment I receive an error:
"The Microsoft Jet database engine cannot open the file '\<ip><shared-folder>statistics.mdb'. It is already opened exclusively by another user, or you need permission to view its data".
Some extra info:
- The network folder has read and write permissions for everyone
- the user and group permissions on both access files are set to read/modify/administer for the Admin user (on the tables I want to read from)
- IIS authentication on the server is set to "Windows Authentication" (this is needed so I can read the Windows Login from the user). All other authentication modes are disables (like anonymous, ...)
- When the error occurs, no other program or process has access to the statistics.mdb (so, it can't be locked by someone else)
- the web.config files access connection string looks like:
<add name="AccessConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\<IP><shared-folder>statistics.mdb;User Id=admin; Password=;" />
Like I said before, in this statistics.mdb file, there are 2 tables. One normal table, and another linked table (pointing to a network location)
Searching for solutions, I discovered the following:
- if I don't use linked tables, everything works fine (however, I have to use this linked table)
- even if I connect directly to the table in the network I receive the error. So, I'm pretty sure I don't have sufficient rights to read from this table.
I read that not the Admin user is opening the file, but actually a user called ASP.NET. This user doesn't have the correct rights to do this. However, I'm not sure if this is true.
How can I have 2 Cascading Drop Down Lists for the same Drop Down List?here is my problemi have 3 drop down lists read from database1- Schools List 2- Classes List3- Teachers ListEvery School will have more than 1 Class and more than 1 TeacherWhat I want is when user select a School from Schools Drop Down List then BOTH (Classes and Teachers) should be refreshed based on the School Drop Down List
View 1 RepliesI have a check box list with some items. I want to make it a single selection. A Radio button list won't work because I need it to allow no selection. It may work if it has allows users to deselect the item selected(like in a check box). The second problem would be that instead of simple text I want a text with link.
View 3 RepliesIam trying to create web magazine, I finished the current issue page and the articles pages of it. What I need now is two things:
1. Creating cms for the web (Big Story! )
2. Finding the way to save the old issues and retreive them when click back issues button and choose the date of i. It is easy if I used db.but I can't!!! I need to save the aspx pages with code of each one! to use C# to create class contains linked list and save the issues in it but I don't know how to do it
how to start searching?
In school we have been making a website where we need to use .adp vbscript pages. But also Microsoft Access databases.
We've added the connection string etc and bindings - all that works fine but when we go to open the page we get page cannot be found. It loads sometimes but most of the time we get that page not found screen.
We are using IIS.
The teachers and another students one works fine, We have done exactly what they have but we get no luck with bringing up the pages.
We get error 500.100 and Error line 8.
I have a issue where I am trying to pull some records from an Access 2007 DB that has linked tables from a SQL 2005 Server. When I go to do this the browser IE8 just sits there and does nothing. THe little progress bar at the bottom moves about half way then that is it. It will sit there and show no errors or do anything. I have experience with connecting and manipulating Access and SQL server DB's but not through Access with linked tables from SQL Server. Here is test code below:
[Code]....
This does not produce an error or anything. The browser just sits there and sits there. Is there something I am missing?
I have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
View 2 RepliesI have the following Students class:
[Code]....
I need the 1 since it's a foreign key in another table. For the life of me, I can't get this to work like this.
I have a requirement in my application that, while saving the application, need to get all the value from drop down list and pass it to the view model. But application should not allow the user to select more than one item from drop down list manually, ie, only one value at a time. My view model is like ...
public class ListManagement
{
public IEnumerable<selectListItem> InactiveProduct { get; set; }
public string[] InactiveProductSelected { get; set; }
public IEnumerable<selectListItem> ActiveProduct { get; set; }
}
[code]...
I am getting this error yet I know it to be untrue.This is the code:
ddlPartnerOrganisation.DataSource = agency.AgencyGetListOfEYDN();
string temp = ddlPartnerOrganisation.SelectedValue.ToString();
ddlPartnerOrganisation.DataValueField = "AgencyID"
;
ddlPartnerOrganisation.DataTextField = "AgencyName"
;
ddlPartnerOrganisation.DataBind();
I have two drop down list on a page. The first one list projects and the second list users. The userlist is populated with an object datasourse that pulls a list of users for the selected Project.Whenever the Project list selection changes the second ddl Userlist always reverts to the first person in the list instead the person that was selected before a new Project was chosen.
View 1 RepliesI am trying to create an MVC List View that can be filtered by the value selected from a drop down list.
Selecting a value should repost the page ... Since there is no concept of view state data I am having some issues with this ... I can get the repost to take place but my drop down resets and I am not able to get the value that was selected.
ASSET CONTROLLER:
[Code]....
[Code]....
I have tried many of the posts that refer to setting up drop down lists but can't set them up in the content because this is a List View.
Public Function UploadExcelFile2003(ByVal excelSheet As String, ByVal filePath As String, ByVal header As String, ByVal dataTable As String) As Integer
Dim intRetValue As Integer
Try
dataTable = "Student"
strConnection = ConfigurationManager.ConnectionStrings("TDPdb").ToString
conn = New SqlConnection(strConnection)
cmd = New SqlCommand("stp_ImportFromExcel03", conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@SheetName", SqlDbType.VarChar).Value = excelSheet
cmd.Parameters.Add("@FilePath", SqlDbType.VarChar).Value = filePath
cmd.Parameters.Add("@HDR", SqlDbType.VarChar).Value = "Yes"
cmd.Parameters.Add("@TableName", SqlDbType.VarChar).Value = dataTable
cmd.Parameters.Add(New SqlParameter("@ReturnValue", SqlDbType.Int)).Direction = ParameterDirection.ReturnValue
conn.Open()
cmd.ExecuteNonQuery() - ERROR
conn.Close()
intRetValue = CType(cmd.Parameters("@ReturnValue").Value, Integer)
Catch ex As Exception
Session("LastErrorMsg") = ex.Message 'catch any last error message
End Try
Error msg:
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" does not contain the table "Sheet1$". The table either does not exist or the current user does not have permissions on that table. Is it because I do not have sufficient rights for my SQL? How do I configure them?
I have a SQL database. I am getting a datatable from SQL. In SQL Query the table is having null values in the output. But when it is coming to the front end, the null values are replaced by empty values.
So in the front end in the datatable i am having empty values in some cells. I am trying to insert this datatable into access. For this i am using following code...
OleAdpData.InsertCommand.Connection = OleConn; // OleConn is the OleDbConnection
OleAdpData.InsertCommand.Connection.Open();
OleAdpData.Update(dtData); // dtData is the datatable
OleAdpData.InsertCommand.Connection.Close();
It is inserting the datatable to access database. But it is inserting the empty spaces as present in the datatable. I want to insert NULL into the cells in access datatable where the cells are empty. Where should i add my logic for this.
on my aspx I have the below DDL
<asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"
DataTextField="Size" DataValueField="BustId" Width="150px"
AppendDataBoundItems="True">
<asp:ListItem Value="-1">(Optional)</asp:ListItem>
</asp:DropDownList>
If the user does not select an item I get an exception when i call the ObjectDataSource Method and DAL as below to insert into database
ProfileObj.InsertParameters["ColorId"].DefaultValue = ColorDDL.SelectedValue.ToString();
What I want to do is insert a database NULL instead.
I had ddl which in selected changed it execute some code but when i tried to do that it wasn't worked well WHEN i checked the reason i found that ddl in selected value =0 also i made all well and this is my code
protected void DDlProductFamily_SelectedIndexChanged(object sender, EventArgs e)
{
if (DDlProductFamily.DataValueField.Contains("ProductCategory_Id"))
using (SqlConnection Con = Connection.GetConnection())
{
SqlCommand Com = new SqlCommand("GetListViewByProductCategory", Con);
Com.CommandType = CommandType.StoredProcedure;
Com.Parameters.Add(Parameter.NewInt("@ProductCategory_Id", DDlProductFamily.SelectedValue.ToString()));
SqlDataAdapter DA = new SqlDataAdapter(Com);
DA.Fill(dt);
DataList1.DataSource = dt;
DataList1.DataBind();
}
}
i have a dropdownlist used like this
[Code]....
it is always returning the same value regardless of which one is selected from the list. How do I get the currently selected value of this list?
validating the drop down list, that list contains 5 values if it is not selected then it should give errormessage
View 2 Replies