Web Forms :: Unable To Get Data From SQL?
Jan 4, 2010
I've come into a company and we're redoing a very, very poorly designed website. I'm bringing it up to speed using asp.net built in membership and roles and all. Well I've got everything working flawlessly for anyone who signs up for the system now.
My problems is all the older users. The passwords for the old users are encrypted in the database so I can't just copy profiles over on the SQL side of things. I was thinking my best plan would be use the create user wizard in asp.net so it could take all their information and create an account on the new system.
My planned solution is direct the old users to a page where their UserID is confirmed and all the information pulled from the old database into the create user form. At which point they enter a new password, along with two other pieces of information that are new to the new site then submit and the system makes them a new account...
Problem... I can't get seem to pull the data from SQL and populate the createuserwizard. (I get the wonderful "Object reference not set to an instance of an object" for the line in the code behind setting the Text peroperty of UserNameTextBox.Text)
[Code]....
[Code]....
I removed some of the addition behind code to keep this reasonably short.
View 3 Replies
Similar Messages:
Feb 16, 2011
i am unavble to update the data in nested data lists in asp.net, if any one have the code
View 3 Replies
Mar 4, 2010
I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )
View 1 Replies
Mar 16, 2010
i am still stumped with this operation: i am trying to retrieve a GridView selected row data..here is my code.. the commented part that gives me the selectedindex works just fine....but the one giving the selected row cell value does't work and there is no error.. The update operation is done successfully...weired. i need to assigned selected row cells values to variables ..do some calculations and then re-assign the result calculation to cell[9]..
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string s = GridView1.SelectedRow.Cells[5].Text;
TextBox1.Text = s.ToString();
//string s2 = GridView1.SelectedIndex.ToString();
//TextBox1.Text = s2.ToString();
}
View 5 Replies
Feb 16, 2010
i m unable to bind data inside checkbox list. this is my code
protected void dlBreeds_ItemDataBound(object sender, DataListItemEventArgs e)
{
try
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
CheckBoxList cbl = e.Item.FindControl("cblAnimaltype") as CheckBoxList;
if (cbl != null)
{
cbl.DataTextField = DataBinder.Eval(e.Item.DataItem, "BGName").ToString();
cbl.DataValueField = DataBinder.Eval(e.Item.DataItem, "ID").ToString();
}
}
}
catch (Exception ex)
{
pnlStatus.Visible = true;
lblMessage.Text = ex.Message.ToString();
}
}
protected void BindAnimals()
{
//*********************************************************************************
// Purpose : To bind breeds in listbox
// Inputs : Nothing
// Returns : Nothing
//*********************************************************************************
DataSet ds = new DataSet();
try
{
ds = InvertebrateProviders.GetBreedsName_Invertebrate(1);
if (ds.IsInitialized)
{
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "ID<>0";
dlBreeds.DataSource = dv;
dlBreeds.DataBind();
}
}
catch(Exception ex)
{
pnlStatus.Visible = true;
lblMessage.Text = ex.Message.ToString();
}
}
<asp:DataList id="dlBreeds" runat="server" DataKeyField="BGName" OnItemDataBound="dlBreeds_ItemDataBound" RepeatDirection="Vertical">
<ItemTemplate>
<asp:Panel ID="pnbBreed" BorderColor="#7f9db9" Height="129px" Width="220px" ScrollBars="Vertical" BorderWidth="1px"
BorderStyle="solid" runat="server" Visible="true">
<asp:CheckBoxList ID="cblAnimaltype" DataTextField='<%#Eval("BGName") %>' DataValueField='<%#Eval("ID") %>' AutoPostBack="True" runat="server" Height="129px" CellPadding="0" CellSpacing="0"
OnSelectedIndexChanged="cblAnimaltype_SelectedIndexChanged" Width="200px" >
</asp:CheckBoxList></asp:Panel>
<asp:CheckBoxList ID="cblBreeds" Height="90px" Width="200px" runat="server" ></asp:CheckBoxList>
</ItemTemplate>
</asp:DataList>
View 5 Replies
Nov 7, 2010
check the VB behind code for any syntax errors.Unable to add new rows of data to a database using the DataGrid control.Compilation Error message is located at http://cforedu.com:View snap shot images of each line error at http://cforedu.com/snap.pdfThe VB code behind reads (revision 1.3):
[Code]....
View 6 Replies
Sep 15, 2010
I have a slight issue I awas trying to fix for 2-3 days, but nothing I try works.
The scenario:
DetailsView control in edit mode, I pass parameters to the SqlDataSourceProducts (edit.aspx?id=2) and the data source selects the appropriate data and fills in the DetailsView form.
Except two drop down lists. These two DDLs (DDL2 and DDL3) are dependent on the previous DDL (DDL1) in the DetailsView.
when the selected value of the DDL1 changes, DDL2 and 3 change their lists and get bound to the database.
The problem is: when I edit something from the database, DDL2 and 3 appear empty and when I update any other field and leave these, they get blanked in the database.
My goal is to set the selected value of DDL2 and 3 to the values in the database WHERE ID = QueryStringField="id".
I can go for not binding the data unless the field is changed, but does not sound professional and user friendly.
code:
The SqlDataSource used to select the parameters from the table and populate the DetailsView
[Code]....
The code of the fields that hold the DDLs in the DetailsView control
[Code]....
The codebehind:
[Code]....
View 10 Replies
Feb 13, 2011
I got a table in a formview where i placed lots of textboxes and dropdownlists inside the table because I need these textboxes and dropdownlists on a background image.
the data on textboxes and dropdownlists that are inside the table is unable to be saved into the database when i pressed the "submit" button. Other textboxes and dropdownlists that are not inside the table work fine. Here are the HTML code for the table:
<asp:Table ID="Table1" runat="server" BackImageUrl="~/images/DRAWING.jpg">
View 9 Replies
Jul 19, 2010
Here is the code for my page:
[Code]....
For some reason I seem to be unable to update my DB through the datasource. Is there anything obvious as to why this wouldn't be working?
I even added static values to the update string to see if this works but it still has an issue.
View 1 Replies
Apr 26, 2010
I'm having a problem sorting a dropdown that I've bound to a SQL Server data source. I've narrowed the problem down to the fact that I have a static item at the top of the dropdown with the data-bound items appended afterwards. If I remove the static item (<asp:ListItem Value="-1" Text="All" />) the ORDER BY part of the select clause works fine. How can I get around this issue? What I would like is to have the "All" static item at the top of the list with the data-bound items sorted alphabetically afterwards. I'm using Visual Studio 2010 and ASP.NET 4 if it makes any difference.
[Code]....
View 1 Replies
Sep 7, 2010
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines.I think I'm missing to set some property or somethnig ehwn exporting.
View 6 Replies
Jul 7, 2010
Trying to explain this clearly. I have a dropdown listbox where user can select multiple names. These names are then selected/inserted into db table in a loop. Table is displayed in an editable gridview. I have a main sqldatasource1 on my aspx page with select/insert/update permissions, but because select command doesnt work with parameters of multiple values (or does it?), i resorted to using an alternative sql datasource in the codebehind in order to run the select query on the multiple values chosen from the dropdownlist to see if they were in my table.I now get this error when I go to select multiple names from the dropdown list
Unable to cast object of type 'System.Data.Common.DataRecordInternal' to type 'System.Data.DataRowView'.
View 2 Replies
May 15, 2010
I retreive data from database but not able to bind it to a repeater control. this is the error i get.
[Code]....
View 4 Replies
Apr 30, 2010
unable to enter data into database
View 4 Replies
Dec 1, 2010
I have the following code, however I am not able to see the table data using placeholder,
The dataset shows the column info but no data. the query shows the data from query builder.
protected void btn_save_click(object sender,
EventArgs e)
{
string host;
[Code]....
View 7 Replies
Mar 25, 2010
I have a grid view. I added the edit and save buttons to th grid view. when I click on the edit I am seeing the text boxes and able to edit the data.But when I click on save I was getting the data before edit. How can I get the data i.e. edited ?eg: Before edit If my data is Chris(firstName) burton (lastname) and if click on edit and change the first name to christopher and click on save
in my if(e.commandname=="save")
{
string arg =
[code]...
View 10 Replies
Feb 25, 2011
I am working on the project where I have converted GridView to enter values into textboxes. Now I am unable to see it, dont know what exactly is happening.
[Code]....
View 4 Replies
Mar 30, 2010
i am having trouble to set a new value to a specific GridView cell.
The value is passed from a javascript to the c# code behind where it should update a specific Gridview cell []:
I am not using editedtemplate.
code c# :
[code]....
In other hand I am using a JS code that set a GridView cell value.. The new value is set but as soon as i select another row on the GridView ..the Updated cell comes back to its original.
JS code1 :
setCellValue(selectedIndex,5);
JS code2 :
[code]....
What i need is a simple way to set a specific gridview cell with my passed JS variable.
View 8 Replies
Jan 20, 2010
I mean I have a GridView with a HyperLink field here is it:
<asp:Button id="OKButton" runat="server" text="OK"><br />
<asp:GridView ID="GridView1" Width="100%" runat="server" AutoGenerateColumns="False" DataKeyNames="CatID">
<Columns> [code]...
I want the first column of the selected row be passed to a variable for further processing.
View 3 Replies
Jan 20, 2010
I am unable to update the gridview because it is interfering with the footer textboxes. Can I know how to disable the footer when i click on edit button, so that it can update
[Code]....
View 5 Replies
Feb 16, 2010
I've got the problem with a simple e-mail form, it uses the simple.aspx and ASPEMAILLib.dll from the persits aspemail installation.The application is hosted on IIS 7, the application pool is a .NET 1.1. I followed the guide on http://blogs.iis.net/bills/archive/2008/06/02/installing-asp-net-1-1-with-iis7-on-vista-and-windows-2008.aspx
View 3 Replies
Jan 19, 2010
I am developing a project in ASP.Net and C#. As per its requirement I have used CreateUserWizard control in FormView's InsertItem template to register a School just like a user registration to get rid of writing the code manually to register a schnool.
well, in CreateUserWizard control there is not any textbox control named username in its content Template because I have no need of this.
when I run this page I get following error.....
[Code]....
how to fix this?
I dont want, indeed I dont need, the username text field that's why I have removed this.
I have customized this control as per my requirements hence few default fields have been removed like username textbox field, therefore it may result more errors when I fix first one.
View 1 Replies
May 11, 2010
I had a gridview with checkboxes in all rows.If I check one check box in the row remaing checkboxes in that row should also be checked and If I uncheck one check box in the row remaing checkboxes in that row should also be unchecked . my problem is I am unable to identify on which row the action is done(menas on which row the checkbox is checked or unchecked).In the Checked change event i wrote the code but i cant identify which row is checked..
View 7 Replies
Jun 15, 2010
My page has a gridview, and the gridview has a TemplateField called "Acciones" (Actions). The column Acciones has a ImageButton with CommandName "Select" and CommandArgument "Tutor". Thus, the GridView has controlled event "SelectedIndexChanged". The idea is that in GV_SelectedIndexChanged, I must to set DropDownList's SelectedValue property. But, the value seted in this function don't affect the rendered dropdownlist. The debugger talk's that the value is correctly seted, but the visual result don't.
View 4 Replies
Sep 18, 2010
I need to set the value of TextBox in a FormView when the mode changes to Insert. But when I was trying to get it to work, neither one of the code blocks below worked. The value was not set, despite the TextBox being found. Furthermore, the 'test' label text wasn't being set. I know for certain that both events are firing. I had added the test label to disploay the mode or newmode of the FormView but the label wasn't being set at all.
[Code]....
View 3 Replies
