I am using 3 tables and are trying to get the correct info belonging to the correct id. Like this: I go to a page and here i want to see the information from the 3 tables using a specific id.
I have written this so far in a query:
[Code]....
My problem is that the last line does not work and i am uncertain how to make this work? How to write it correctly that is.
I am doing a workshop , it has questions, and answers with radiobuttons, I need that when a click is made on a radiobutton a message appears saying that it is correct or it is not correct, how can a do it,
View 10 RepliesI am just not able to get the syntax right for the below code,
Dim HeaderCount As Integer = readerXML.HeaderCount()
Dim NewTable As String
NewTable = "CREATE TABLE " + tbCustomerFileName.Text +
" (" +
" RowId smallint" +
" IDENTITY(1,1)" +
" PRIMARY KEY CLUSTERED,"
For I = 0 To [HeaderCount]
NewTable = NewTable + readerXML.Item(I) + " DEFAULT 'New Position - title not formalized yet'," + " varchar(50) NOT NULL,"
Next [I]
+ ")" ...this part gives me an error ssaying incorrect syntax.
I am trying to upload an excel file and based on the number of headers in the file, I want to generate columns, however I am just not able to get this going because i am getting syntax error, the main problem being I am not able to put the brackets at the right place.
I'm using DAAB from MS Ent Library 4.1. I have this function in my DAL that returns a dataset.
[Code]....
However, it is failing with this error:Failed to convert parameter value from a String to a Boolean.
But if I use SqlDbType.VarChar instead it works fine. I want to use Char b/c that is the correct datatype in SQL.In my SP the param is @CUSTNMBR char(15). In my database table the field is also char(15).
I have the textbox input the double number like 0.5 or 2.1 then click the submit insert to database, but show the error. Server Error in '/' Application. Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
[Code]....
Source File: c:inetpubwwwrootInformationadd_detail_menu2.aspx.vb Line: 6 Stack Trace:
[Code]....
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
I currently have 3 tables and return an average value for the OverallRating Column on each to get a CombinedOverall, but what if one of the tables does not have data for a particular customer? if I divide by 3 the answer will not be the same, and I could get an answer that is over the max I want (5.0)
[Code]....
It will be possible that the Customer will not have any data in one of the tables.
How do I get around this?
I am using a SQL stored procedure to insert client records into multiple tables.
this is my datasource markup:
[Code]....
I am using a multiview to step through the input pages then on the last view there is a submit button that fires this:
[Code]....
this is my stored procedure:
[Code]....
What is the correct code syntax to insert Row of Data.
How do we remove the syntax errors (i.e., '>' expected, and 'declaration expected')?
What is the correct code?
Read example, below:
[Code]....
When I use Login control with integerated security and user instance to connect Sql Server 2008 Express. When I browser the web page in VS2010 in Solution Explorer's right click context menu "Browser in Explorer", it works correctly, but in IIS 7 get an error as follow:
User does not have permission to perform this action.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.
I use IIS 7, an administrator user credential, application pool's identity is Newwork Service.
I have a Gridview with a templated column that gets a True/False value from the SQL Datasource. The value displays as a string in a label in the template. I added a RadioButtonList and in the RowDataBinding event put in some logic to set the appropriate radio button based on the text value of the Label.
Now I want to be able to interrogate the RBL upon update and set the Label text accordingly. I tried the Row_Updating event but that doesn't have a handle on the row itself and the RBL is not in the NewValues or OldValues collection since it's not one of the bound fields. I tried the RBL_SelectedIndexChanged event but I can't get the current row (got a handle on the Gridview but Gridview.SelectRow and Gridview.SelectedDataKey are both null).
how to interrogate the RBL and set the Label so the correct value is passed back to the datasource for update?
I get the Erorr: Input String was NOT a correct format.
The first three controlparameters are STRINGS and they work fine.
However the last two populate the controlparameter from text boxes that can only accept numbers and decimal point.
First the text boxes for {3} and {4} string parameters in the SQL filterexpression:
[Code]....
And then the SQLDatasource control parameters[Code]....
The last two control parameters are the ones is question as they feed {3} and {4} parameters in the filter expression, NOTICE how I set the type="double".The data input is expected to be like 152.25 or 3.6 or 4 etc,So why am I getting this error: [Code]....
So, I have 3 table adapters in my dataset, and trying to configure the objectDataSource will not give me the option to select the correct table adapter.
I set up a temporary website to illustrate what I am talking about, along with pics, not much, just 4 pics.
https://sites.google.com/site/configuringobjectdatasource/
The first 2 pics are irrelevant but just in case anyone thinking I don't have it set up properly. The other table adapters are working fine, which I have gridviews being populated etc.
why it will not give me the option to select aspnet_GetRecordDatesTableAdapter?
"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?
[Code]....
I have a bound data field, a detailsview, one of the records I have formatted to currency in the item template. Yet when I go to delete a record, I get a error message "Input string was not in correct format". Take away the formatting and the page runs fine. I tried changing the datatype from int to money, it makes no difference.
View 3 RepliesAssigning a var with a value from a database grid
currentID = Convert.ToInt32(GridView_ABC.DataKeys[0].Value);
I get the error 'Input string was not in correct format' currentID is an integer var. When I hover over the GridView_ABC.DataKeys[0].Value it is """, it should be an integer.
I'm building a library of custom controls. My controls are inherited from CompositeControl. Depending on the user's answer I have to insert more custom control. I have a PlaceHolder (_ph) passed in from the client code. I insert my controls into that PlaceHolder.
My problem is the control I inserted in the event handler does not fire its event, but it fires the parent event. For example, if I have an EddDropDown A, and the user picks an answer, I have to create EddDropDown B and C in edd_SelectedIndexChanged. When I pick an answer for B, it fires SelectedIndexChanged for A instead of B.
I think it has something to do with entering the page cycle late.
this is an example of my controls:
using System;
using System.Collections.Generic;
using System.Collections;
using System.Linq;
using System.Text;
[Code]....
I am working on ASP.NET and not using any ASP.NET's AJAX framework. Now I am trying to update the contents of the textboxes and dropdowns in the Grid controls cell on client side using (classic JavaScript way)AJAX. But problem I am facing is that controls (textbox, dropdown) which I would like to update when rendered on the client side get prefixed by the User Controls id and row ids. So it becomes like UserContro_row_no_controlId. With this it is becoming difficult to keep track of controls ids on the client side to update them.
how this can be simplified? Can we get what exactly will be prefixed to control when it's rendered on client side? What is good way to get ID to client side ? I have tried using control.clientId but it's giving me only _controlId part not the UserContro_row_no part.
I am still studying to become a webintegrator and this is my private project to try and learn C# better.
I have a database with a table called Answers which holds AnswerID, Answer1, Answer2, Answer3 and CorrectAnswer + a table called Questions which holds QuestionID, QuestionNumber and QuestionText.
On a page i have a repeater that pulls the questions from the database and inside it i have another repeater with my 3 radiobuttons that pulls the 3 Answers from the database and are grouped so you can only check 1 of the radiobuttons as the user. See below:
<asp:Repeater ID="rptQuestions" runat="server">
<ItemTemplate>
<div>
<div>
Spørgsmål
<asp:Label ID="lblQuestionHeader" runat="server" Text='<%#Eval("QuestionNumber") %>'></asp:Label>
[Code]...
What i need to do, is somehow find each CorrectAnswer checked correctly in the repeater holding the radiobuttons and give 1 point for each CorrectAnswer chosen by the user (if theres 10 questions there will be 10 repeateritems with 3 radiobuttons in each one) and write this into aspnet_Profile. Problem is i have no idea how to do this since it already seems a bit complicated in my head and i haven't had much C# yet. So any help would do and notice i do not ask for the entire coding but simply a push in the right direction.
Im new in datalist and im trying to programmatically bind my database data to my datalistMy problem is, i only able to show the Property Name and description on the ItemTemplateWhen i click on one item to switch to SelectedItemTemplate, most of the information is nothing In my code behind, i got this
[Code]...
Label1.text = CType(GridView_MyAds.FindControl("ItemId")
I need this correctly done....
I am trying to get the delete to work on my gridview. I've added a
DataKeyNames="ID"
but when i click delete i get Input string was not in a correct format.
there is a template field in gridview this is basically for showing amount.
<asp:TemplateField HeaderText="Amount" ConvertEmptyStringToNull="False">
<ItemTemplate>
<%#GetQTY1(float.Parse(Eval("Sub_ContractAmt").ToString())).ToString("N2")%>
</ItemTemplate>
</asp:TemplateField>
if my data base field has any value then it shows no error. but if this fiels is null then it shows error
input string was not in correct format while binding the gridview.
so can you please tell me the method that if this field has null value then what should I do so that i dont get this error. this fields might be null.
I'm stumped on this one... it seems really simple, but I can't get around it. I am pulling 2 values (discount percent, discount amount) from a formview label control. I want to use these numbers in a calculation, but I can't seem to get the format correct.
I hit the error on this statement:
DiscountAmt = Convert.ToDouble(fvDiscountResults.FindControl(
"DiscountSubtotal1"
).ToString)
[Code]....
I have a listview (userid, users) and a checkbox. I would like to select the checkbox and store the userid in a textbox then into a session page. I am having issues with the code as it seems incorrect, due to the listview1.row.
[Code]....
[Code]....
I've used only linkbutton and I do not know if what influence it.