|
City_DropDownList.Items.Add(New ListItem(inputtext,value)
|
|
|
|
|
Hi Experts,
I have this:
<asp:DropDownList ID="ddlLocation" runat="server" AppendDataBoundItems="True"
AutoPostBack="True" Width="140px">
<asp:ListItem Value="0">Choose Location</asp:ListItem>
</asp:DropDownList>
Then this sub on codebehind:
Public Sub BindData()
Dim oconn As New SqlConnection(sqlconn)
' AddHandler ddlLocation.SelectedIndexChanged, New EventHandler(AddressOf ddl_SelectedIndexChanged)
oconn.Open()
Dim ocmd As New SqlCommand("select l.locationid,l.Location, c.CourseId, i.instructorId,CourseName, i.instructorname, dbo.fnFormatDate(t.trainingDates, 'MON/DD/YYYY') trainingDates, t.trainingTime,CourseDescription from tblCourses c, tblLocations l, tblTrainingDates t, tblInstructors i, tblCourseInstructor ci where l.locationid = c.locationid and c.dateId = t.dateId and i.instructorid = ci.instructorId and c.courseid=ci.courseid and YEAR(t.trainingDates) = YEAR(getDate()) and l.locationId = " & ddlLocation.SelectedValue, oconn)
Dim oda As New SqlDataAdapter(ocmd)
Dim builder As New SqlCommandBuilder(oda)
Dim ds As New DataSet()
oda.Fill(ds)
gv1.DataSource = ds
gv1.DataBind()
End Sub
We would like to select a value from the ddlLocation dropdownlist and display records associated with that value.
Any ideas how to handle this?
Thanks a lot in advance
modified 21-Sep-14 21:41pm.
|
|
|
|
|
Call Binddata()method from ddlLocation selected Index Change event
it will solve your problem
|
|
|
|
|
Sorry it didn't work.
Oh, I got it working and your suggestion was right.
Thanks for your assistance.
modified 21-Sep-14 21:41pm.
|
|
|
|
|
For each loop to item find
for example
foreach item as listitem in dropdownlist.item
......
...
next
|
|
|
|
|
I think you missed my last post where I said the problem is solved and I thanked you for it.
Thanks again.
|
|
|
|
|
I have a register form to make. But client side validation not working properly. Can anyone help me out.
Thanks in Advance.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="Register" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script language="javascript" type="text/javascript">
function Validate() {
var summary = "";
summary += isValidName();
summary += isValidEmail();
summary += isValidMobile();
if (summary != "") {
return false;
}
else {
return true;
}
}
function isValidName() {
var Name = document.getElementById("TxtName");
if (Name.value == "") {
alert('Please provide a valid Name');
Name.focus;
return false
}
else {
return "";
}
}
function isValidEmail() {
var email = document.getElementById('TxtEmail');
var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;
if (!filter.test(email.value)) {
alert('Please provide a valid email address');
email.focus;
return false;
}
}
function isValidMobile() {
var Mobile = document.getElementById("TxtMoible");
if (Mobile.value == "") {
alert('Please provide a valid Mobile');
Mobile.focus;
return false
}
else {
return "";
}
}
</script>
</head>
<body>
<%----%>
<form id="form1" runat="server">
<div>
<table style="width:100%;">
<tr>
<td>
Name
</td>
<td>
<input id="TxtName" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
Email ID</td>
<td>
<input id="TxtEmail" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
Confirm Email ID</td>
<td>
<input id="TxtConfirmEmail" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
Password</td>
<td>
<input id="TxtPass" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
Confirm Password</td>
<td>
<input id="TxtConfirmPass" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
Mobile No.</td>
<td>
<input id="TxtMobile" type="text" /></td>
<td>
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="BtnSubmit" runat="server" onClientClick="return Validate();"
onClick="Button1_Click" Text="Register Now" />
</td>
<td>
</td>
</tr>
</table>
</div>
</form>
</form>
</body>
</html>
|
|
|
|
|
In case all values are valid you get 'undefined' in summary, and that because your isValidEmail method has not defined return value in case of valid input!!!
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
|
|
I am developing an ASP.net application wherein I am trying to connect to Oracle database using sqldatasource. While defining new connection, when i click on test connection button on the dialog box, I am getting error:
Error 12541 - TNS: no listener.
My oracle listener is up. Kindly help me in getting rid of this error.
|
|
|
|
|
Are you connecting to a remote Oracle server, or is the Oracle server running on your desktop computer?
If your connecting to a remote Oracle Server, there is a long process you have to go through to setup the listener.
I think there are 2 programs you have to load to complete the listener for asp.net. I haven't done it in couple of years, but it required some research and implementation.
http://docs.oracle.com/cd/E51173_01/win.122/e17733/IntroInstallation.htm#ASPNT116[^]
|
|
|
|
|
Thanks for the info friend.
I have already installed ODAC and as per your guidance also followed the instructions given on the page provided by you. But unfortunately it didn't work.
|
|
|
|
|
Your gonna have to check if the listener is even running, check the port on the firewall, and so forth in order to get it working.
But you never said if the Oracle database software is running remote or local, 2 different sets of items to check.
It's really no different than configuring MySQL or SQL Server. You may want to start searching post on the oracle website to get some ideas of what to do.
https://community.oracle.com/thread/371929?tstart=0[^]
|
|
|
|
|
My oracle is running on local machine. It is a project which i am doing as a part of my training on asp .net.
So i have installed Oralce 11g server and client on my laptop. Also installed ODAC and configured it according to the instructions given on the page provided by you. But unfortunately it didn't work out.
I think I need to do some more research on Internet for this issue.
Thanks for help.
|
|
|
|
|
I remember the first time I loaded up SQL software and tried to connect. I t took me awhile to get it working. Basically you have a
Protocol
Port Number
that have to match in asp.net and Oracle.
So you start with the Oracle Database Manager, make sure it can connect to the database.
Make sure you have an account with permission to connect, Select, insert, update, delete
Make a database with the manager,
Then start with the asp,net, and do the same thing again, test your connection string
Try the Oracle native client first, you have to import it or register it.
When that works, then you can try the ODBC or whatever you plan to use.
|
|
|
|
|
|
Hi There,
Can anyone help, I am having trouble posting a form to a Table in my database. I am getting a ERROR "Procedure or function SPInsertIndividual has too many arguments specified.", Can anyone help it would be very much appreciated.
My SP Code is:
CREATE PROCEDURE [dbo].[SPInsertIndividual]
(
@IndividualID int OUTPUT,
@TypeName nvarchar(200),
@RankName nvarchar(200),
@TitleName nvarchar(200),
@FamilyName nvarchar(200),
@FirstName nvarchar(200),
@MiddleName1 nvarchar(200),
@MiddleName2 nvarchar(200),
@MiddleName3 nvarchar(200),
@Gender nvarchar(20),
@DOB nvarchar(200),
@CountryName nvarchar(200),
@StateName nvarchar(200),
@CityName nvarchar(200),
@Verification nvarchar(200),
@DateCreated DateTime
)
AS
BEGIN
SET NOCOUNT ON
INSERT INTO dbo.tblIndividual(TypeName, RankName, TitleName, FamilyName, FirstName, MiddleName1, MiddleName2, MiddleName3, Gender, DOB, CountryName, StateName, CityName, Verification, DateCreated, IndividualID)
VALUES(@TypeName, @RankName, @TitleName, @FamilyName, @FirstName, @MiddleName1, @MiddleName2, @MiddleName3, @Gender, @DOB, @CountryName, @StateName, @CityName, @Verification, @DateCreated, @IndividualID)
END
Aspx.cs Code is
protected void btnSubmit_Click(object sender, EventArgs e)
{
String strConnString = ConfigurationManager.ConnectionStrings["AspGenealogy"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SPInsertIndividual";
var id = new SqlParameter("IndividualID", System.Data.SqlDbType.Int);
id.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(id);
cmd.Parameters.Add("@IndividualID", SqlDbType.Int);
cmd.Parameters.Add("@TypeName", SqlDbType.VarChar).Value = ddlType.SelectedItem.Text.Trim();
cmd.Parameters.Add("@RankName", SqlDbType.VarChar).Value = ddlRank.SelectedItem.Text.Trim();
cmd.Parameters.Add("@TitleName", SqlDbType.VarChar).Value = ddlTitle.SelectedItem.Text.Trim();
cmd.Parameters.Add("@FamilyName", SqlDbType.VarChar).Value = txtFamilyName.Text.Trim();
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = txtFirstName.Text.Trim();
cmd.Parameters.Add("@MiddleName1", SqlDbType.VarChar).Value = txtMiddleName1.Text.Trim();
cmd.Parameters.Add("@MiddleName2", SqlDbType.VarChar).Value = txtMiddleName2.Text.Trim();
cmd.Parameters.Add("@MiddleName3", SqlDbType.VarChar).Value = txtMiddleName3.Text.Trim();
cmd.Parameters.Add("@Gender", SqlDbType.VarChar).Value = ddlGender.SelectedItem.Text.Trim();
cmd.Parameters.Add("@DOB", SqlDbType.VarChar).Value = txtDOB.Text.Trim();
cmd.Parameters.Add("@CountryName", SqlDbType.VarChar).Value = ddlCountry.SelectedItem.Text.Trim();
cmd.Parameters.Add("@StateName", SqlDbType.VarChar).Value = ddlState.SelectedItem.Text.Trim();
cmd.Parameters.Add("@CityName", SqlDbType.VarChar).Value = ddlCity.SelectedItem.Text.Trim();
cmd.Parameters.Add("@Verification", SqlDbType.VarChar).Value = txtVerification.Text.Trim();
cmd.Parameters.Add("@DateCreated", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
Response.Redirect("Details.aspx");
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
My .aspx code is:
<body>
<form id="form1" runat="server">
<div style="font-family:Gabriola">
<fieldset style="width:380px">
<legend><h3>Individual Builder: Stage 1</h3></legend>
<tr>
<td>
Type:
</td>
<td>
<asp:DropDownList ID="ddlType" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlType_SelectedIndexChanged" DataTextField="TypeName" DataValueField="TypeID"></asp:DropDownList>
<br />
</td>
</tr>
<tr>
<td>
Rank:
</td>
<td>
<asp:DropDownList ID="ddlRank" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlRank_SelectedIndexChanged" DataTextField="RankName" DataValueField="RankID"></asp:DropDownList>
</td>
</tr>
<tr>
<td>
<br />
Title:
</td>
<td>
<asp:DropDownList ID="ddlTitle" AutoPostBack="true" runat="server" DataTextField="TitleName" DataValueField="TitleID"></asp:DropDownList>
</td>
</tr>
______________________________________________________________________________________________________________________________________________
<br />
<tr>
<td>
Family Name:
</td>
<td>
<asp:TextBox ID="txtFamilyName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<br />
First Name:
</td>
<td>
<asp:TextBox ID="txtFirstName" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Middle Name:
</td>
<td>
<asp:TextBox ID="txtMiddleName1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Middle Name:
</td>
<td>
<asp:TextBox ID="txtMiddleName2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Middle Name:
</td>
<td>
<asp:TextBox ID="txtMiddleName3" runat="server"></asp:TextBox>
</td>
</tr>
<br />
______________________________________________________________________________________________________________________________________________
<br />
<tr>
<td>
Gender:
</td>
<td>
<asp:DropDownList ID="ddlGender" runat="server">
<asp:ListItem Value="0">Male</asp:ListItem>
<asp:ListItem Value="1">Female</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<br />
Date of Birth:
</td>
<td>
<asp:TextBox ID="txtDOB" runat="server"></asp:TextBox>
</td>
</tr>
<br />
______________________________________________________________________________________________________________________________________________
<tr>
<td>
Country of Birth:
</td>
<td>
<asp:DropDownList ID="ddlCountry" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged" style="height: 22px" DataTextField="CountryName" DataValueField="CountryID"></asp:DropDownList>
</td>
</tr>
<tr>
<td>
<br />
Province or State of Birth:
</td>
<td>
<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlState_SelectedIndexChanged" DataTextField="StateName" DataValueField="StateID"></asp:DropDownList>
<br />
</td>
</tr>
<tr>
<td>
City of Birth:
</td>
<td>
<asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="true" DataTextField="CityName" DataValueField="CityID"></asp:DropDownList>
</td>
</tr>
<br />
______________________________________________________________________________________________________________________________________________
<tr>
<td>
Source:
</td>
<td>
<asp:TextBox ID="txtVerification" runat="server"></asp:TextBox>
</td>
</tr>
<br />
______________________________________________________________________________________________________________________________________________
<tr>
<td>
<asp:Button ID="btnClear" runat="server" Text="Clear" />
</td>
<td>
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click"/>
</td>
</tr>
</fieldset>
</div>
</form>
</body>
Can anyone help me? I am sure it is something minor.
Thanks, I look forward to hearing from you.
|
|
|
|
|
Member 9142936 wrote: var id = new SqlParameter("IndividualID", System.Data.SqlDbType.Int);
id.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(id);
cmd.Parameters.Add("@IndividualID", SqlDbType.Int);
You've added the @IndividualID parameter twice.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
don't know if this is due to poor db design or not but I have been struggling since last night to update some records from by selecting the values of records to be updated from a dynamically populated dropdownlist from a lookup table.
Essentially, we have three tables called Courses, Instructors and CourseInstructor tables.
CourseInstructor table is a bridge table between Courses and Instructor tables.
So, when adding courses and instructors to their various tables, their foreign keys are automatically added to the bridge table.
This seems to work fine so far.
However, users are having difficulties making changes to these tables.
For instance, if a user wishes to replace one instructor with another, she has not been to do so for far. After an update, the message indicates successful update the instructor names don't change.
Any ideas what I could have done wrong with the code below?
<asp:TemplateField HeaderText="Instructor">
<EditItemTemplate>
<asp:DropDownList ID="ddlInstructors" runat="server" AppendDataBoundItems="True" DataSourceID="SubjectDataSource"
DataTextField="InstructorName" DataValueField="InstructorId">
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblInstructors" runat="server" Text='<% #Bind("InstructorName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:SqlDataSource ID="sqlDataSourceloc" runat="server"
ConnectionString="<%$ ConnectionStrings:DBConn %>"
SelectCommand="SELECT locationId, Location FROM Locations order by location asc"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DBConnectionString %>"
UpdateCommand = "Update tblCourseInstructor Set CourseId = @CourseId where (CourseId =@CourseId) Update tblCourseInstructor set InstructorId=@InstructorId where (instructorId=@instructorId and courseId = @courseId)"
SelectCommand="select l.locationid,c.CourseId, i.instructorId,CourseName, i.instructorname, dbo.fnFormatDate(t.trainingDates, 'MON/DD/YYYY') trainingDates, t.trainingTime,CourseDescription from Courses c, tblLocations l, TrainingDates t, Instructors i, CourseInstructor ci where l.locationid = c.locationid and c.dateId = t.dateId and i.instructorid = ci.instructorId and c.courseid=ci.courseid and YEAR(t.trainingDates) = YEAR(getDate())"
FilterExpression="LocationId = '{0}'" >
<FilterParameters>
<asp:ControlParameter ControlID="ddlLocation" Name="LocationId" PropertyName="SelectedValue" Type="Int32" />
</FilterParameters>
<UpdateParameters>
<asp:Parameter Name="CourseId" Type="Int32" />
<asp:Parameter Name="instructorId" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SubjectDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DBConn %>"
SelectCommand="SELECT instructorId, InstructorName FROM dbo.Instructors order by InstructorName">
</asp:SqlDataSource>
Then I tried updating it from codebehind with code below
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Handles GridView1.RowUpdating
Dim ddAssigned As DropDownList = DirectCast(GridView1.Rows(e.RowIndex).FindControl("ddlInstructors"), DropDownList)
e.NewValues("instructorId") = ddAssigned.SelectedValue
SubjectDataSource.DataBind()
End Sub
but got the following error:
'SqlDataSource1' unless UpdateCommand is specified.
Any ideas how do I fixt this one?
|
|
|
|
|
I'm taking a big guess here on this, but I think this is your problem.
I wanna say that it's a bad design, but I haven't seen the design, but the CourseID should say the same if your just updating the teacher
UpdateCommand = _
"Update tblCourseInstructor Set CourseId = @CourseId where (CourseId =@CourseId) " & _
"Update tblCourseInstructor set InstructorId=@InstructorId where (instructorId=@instructorId and courseId = @courseId)"
<pre>
UpdateCommand = _
"Update tblCourseInstructor set InstructorId=@InstructorId where courseId = @courseId)"
</pre>
|
|
|
|
|
Hi,
Thanks for your time responding to my question.
My design idea was based on the fact that this is a many to many relationship between teacher and course.
A teacher can teach more than one courses just as a course can be thought by more than one teacher.
This made it many to many. So, there is one way I know to bridge them and that's by creating a third table that has foreign key for both tables.
How would you have designed them?
|
|
|
|
|
I think you have it backwards, and should try flipping them around.
Set the teacher id, then set the course id
If you change the course id first, then the teacher id will not change because you changed the course id, and your using the same parameter @courseid which is static or the same value.
As far as design goes, I'd have to see the map, or see the whole picture to tell. Jorgen is really good at that, you would have to prepare a well worded question in database forum for that.
I think it's a SQL or database issue here.
|
|
|
|
|
Just my opinion, I'm not the best at this.
I think a course is a course, like a shoe being sold online.
You can have the same course, like shoe sizes,
The teacher is just a category, or a shoe size, and the time and day of the course is like the color of a shoe.
So take a course marketing 101,
marketing101-time-teacher
1 table
1 record marketing 101 with time and teacher id
Join 1 more table time represented by time id
Join 1 more table teacher represented by teacher id
Then just update the marketing 101 with the correct time and teacher.
|
|
|
|
|
I want to insert some JavaScript code for validation. Here it is :
script language="javascript">
function checkEmail() {
var email = document.getElementById('txtEmail');
var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;
if (!filter.test(email.value)) {
alert('Please provide a valid email address');
email.focus;
return false;
}
}</script>
and the code in body is :
<input type='text' id='txtEmail'/>
<input type='submit' name='submit' onclick='Javascript:checkEmail();'/>
Now I want to check for validation on submit button but I also want to run code written in .cs page for
<asp:Button ID="BtnSubmit" runat="server" onclick="Button1_Click" Text="Register Now" />
|
|
|
|
|
Hi,
Something like this should do it:
<asp:Button ID="BtnSubmit" runat="server" onClientClick="return checkEmail();" onClick="Button1_Click" Text="Register Now" />
If your checkEmail routine returns true, then a post back occurs - which will run the serverside code in Button1_Click.
If the validation fails, then no postback will occur.
Hope it helps.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
