Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Why is this so complicated in ASP.NET?
Options
Comments
-
-
-
If you want to use a data access layer you could play around with the Enterprise Library - that comes with a DAL ready baked for you. Although from a learning perspective you would benefit from writing your own.
Plus he will waste about 3 days trying to navigate that damn MSDN web library!
0 -
-
-
Advertisement
-
-
-
-
-
o.k a few things about the radiobuttonlist first. The radiobuttonlist by default uses a table for layout which is a big no-no as far as I am concerned. So this is where RepeatLayout comes in to play. Setting it to flow means no table. You can also set the repeat direction. So if you have a radiobuttonlist like the following:-
<asp:RadioButtonList ID="Trans_Type" runat="server" RepeatLayout="Flow" RepeatDirection="Horizontal"> <asp:ListItem Value="1" Text="Type 1" Selected="True"></asp:ListItem> <asp:ListItem Value="2" Text="Type 2"></asp:ListItem> </asp:RadioButtonList>
then Trans_Type.selecteditem.value will give me "1" or "2" depending on which one was selected. I've always had issues with selectedvalue even in the dropdownlist so I've gotten into the habit using selecteditem which seems to consistently return the correct value or text.
But the code you have above is for a HTML page. I need mine to go into a c# page...??? I'm lost, that might not have even made sense what I just said!
0 -
Advertisement
-
-
-
-
-
-
-
-
Trust me once you get your head around it you'll never look back. It's always fun to knock Microsoft but asp.net is one of the best things they have ever done imo.
Thats why I made the jump because I wanted to do it proper and professionally rather than just knock it together which was how I went at it until now! Patience patience!
0 -
-
-
Advertisement
-
-
-
-
-
Right, I've put:
<asp:RadioButtonList ID="RadioButtonList1" runat="server" Style="z-index: 102; left: 27px;
position: absolute; top: 215px">
<asp:ListItem Value="Install">Installation</asp:ListItem>
<asp:ListItem Value="Main">Maintenance</asp:ListItem>
</asp:RadioButtonList>
Into my aspx page and I've put:
string radioValue = RadioButtonList1.SelectedItem.Value;
into my .cs page,
and I've also added this to my code on the .cs page
sql += "'" + radioValue + "'";
And I'm not getting an error when debugging the project but when I try to post the data on the page using the button, I get an error at line 45 in my code
cmd.ExecuteNonQuery();
saying:
"String or binary data would be truncated.\r\nThe statement has been terminated."
And I must be learning something because I could work out that my character strings being posted were too long for the space I had assigned for them in my database!!!
:D:D 0 -
-
-
-
I'm trying to get the cascading dropdown list in this c# script to post on bottonclick to my database:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
using System.Web.Services;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
// Get selected values
string make = DropDownList1.SelectedItem.Text;
string model = DropDownList2.SelectedItem.Text;
string color = DropDownList3.SelectedItem.Text;
// Output result string based on which values are specified
if (string.IsNullOrEmpty(make))
{
Label1.Text = "Please select a make.";
}
else if (string.IsNullOrEmpty(model))
{
Label1.Text = "Please select a model.";
}
else if (string.IsNullOrEmpty(color))
{
Label1.Text = "Please select a color.";
}
else
{
Label1.Text = string.Format("You have chosen a {0} {1} {2}. Nice car!", color, make, model);
}
}
[WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static CascadingDropDownNameValue[] GetDropDownContentsPageMethod(string knownCategoryValues, string category)
{
return new CarsService().GetDropDownContents(knownCategoryValues, category);
}
}
My problem is that when I use the following code to handle that event, the page just refreshes but doesn't try to post to my database, or even try to do anything, it just refreshes the page...
protected void Button1_Click(object sender, EventArgs e)
{
string dropdown1 = DropDownList1.SelectedValue;
string dropdown2 = DropDownList2.SelectedValue;
string dropdown3 = DropDownList3.SelectedValue;
string sql = "insert into used_equipment (project_owner, project_status, creation_date)\n";
sql += "values(";
sql += "'" + dropdown1 + "',";
sql += "'" + dropdown2 + "',";
sql += "'" + dropdown3 + "',";
sql += "'" + MyCalander + "',";
sql += "'" + radioValue + "'";
sql += ")";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
conn.Close();
}
Anything obvious??? 0 -
Advertisement
-
Advertisement