No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
22 Posted Topics
 | i have a dataset [code] Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection) Dim ds As New DataSet query1.Fill(ds)[/code] how can i refer to specific column for example if i want to search for column QuestionNum=1 in table AnswerList … |
| | hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number … |
| | hi..good day to all.. i want to ask.. i have a page "coverletter.aspx".. in the page_load, i would like to [B]check whether the surveyID contains any cover letter or not[/B]..if there is any, i wanted to load the cover letter and display into textbox letter.text...else..i want to load the default … |
| | hi.. i wonder, what is wrong with my code? i want to let user update their previous question based on question number they selected. i have a dropdownlist called [B]qnum[/B]. when the qnum index changed, it should load respective question to textbox [B]question[/B]. however, i don't manage to update in … |
| | hi..good day to all i have a table: Question atttributes: SurveyID(FK),QuestionID(PK),QuestionNum,Question and QuestionTypeID if i have a dropdown list specifying the list of QuestionNum in my ASPX page and a delete button besides the list, how can i delete one QuestionNum? after delete, how can i shift the Question Number … |
| | i have a problem.. i just can't see where i did go wrong.. when my page loads, i want the name and email appear in the textbox so that user can edit their name and email...but then, it doesn't update the record, but continue to save the old value of … |
| | i've got this code to create control at runtime.. the problem is that i've forgotten the link and i can't refer to its documentation.... the problem is...i don't understand this line: Dim parent As String = CStr(ds.Tables(1).Rows(0)("Parent")) what does this parent refer to? [code] Dim options As New RadioButtonList For … |
| | hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL … |
| | hi.. i've created a table named :Survey [code]CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [DateCreated] AS (getdate()) , [coverletter] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL … |
| | hi..i'm doing my final year project on creating Questionnaires template. i have problem with viewing my OptionLIst. I have 2 dataset..all i want to do is to preview all my Question & Answer..i can view them, but i need to create textboxes or checkboxes besides the OptionList.. [code] Private Sub … |
| | hi.. i'm having a table called "Survey". Whenever user create survey, it will store the date and time the survey was created. [code] CREATE TABLE [dbo].[Survey] ( [CustomerID] [int] NOT NULL , [SurveyID] [int] IDENTITY (1, 1) NOT NULL , [SurveyTitle] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SurveyDescription] [varchar] … |
| | hi.. i wanna ask...how can i add controls such as RadioButton @ CheckBoxes @ TextBox into panel? i need to view my OptionList based on my QuestionType [code] Dim sql As SqlCommand=("SELECT Question.QuestionTypeID,AnswerList.OptionID,AnswerList.OptionList FROM QUESTION, AnswerList WHERE AnswerList.SurveyID = 83 AND AnswerList.QuestionNum=1",MyConn) Dim readQ As SqlDataReader = sql.ExecuteReader() While readQ.Read … |
| | what is wrong with my code? [code] Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MyConnection.Open() Dim strSQL As String = "SELECT * FROM Question WHERE SurveyID=83 Order By QuestionNum" Dim cnCommand1 As SqlCommand = New SqlCommand(strSQL, MyConnection) Dim Rdr As SqlDataReader = cnCommand1.ExecuteReader() 'execute reader …  |
| | what is wrong with my code? Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MyConnection.Open() Dim strSQL As String = "SELECT * FROM Question WHERE SurveyID=83 Order By QuestionNum" Dim cnCommand1 As SqlCommand = New SqlCommand(strSQL, MyConnection) Dim Rdr As SqlDataReader = cnCommand1.ExecuteReader() 'execute reader to …  |
| | hi.. i have draft.aspx at first time view, i want the draft.aspx to take value QuestionNum in the database...so, at first time viewing, the draft.aspx shows QuestionNum.text=1 i have a button - "Next". i want user to click the button and they will be redirected to the draft.aspx displaying the … |
| | hi.. is anyone knows..how to add controls dynamically in a page according to user input? at page 1, user will define their data (OptionList) and its data representation style(eg checkbox,listbox,radiobutton or whatsoever) for each question..then when user click submit, all data sets by user in Page 1 will be previewed … |
| | hi.. i have problem...which i don;t know how to perform this action.. i have a page...named "preview.aspx". this page should preview all the Question with their Answer List example of Question: What is the temperature of boiling water? example of Answer : 100 degrees Celcius, 120 degrees Celsius, 80 degrees, … |
| | hi.. i want to ask if anyone knows how to do this.. i have a datagrid at my "home.aspx" with attribute 'Survey Title' and 'Description' i also have an edit button that will redirect user to "surveyeditor.aspx" in "surveyeditor.aspx", there are 2 textbox..which can be used to edit the 'Survey … |
| | hi..good day to all.. i have a datagrid that combines 2 related tables as below: <body> <asp:datagrid id="dlQuestion" runat="server"> <ItemTemplate> <b>Question :#</b> <%# Container.DataItem("QuestionNum") %><br> <%# Container.DataItem("Question") %> <asp:DataList runat="server" Id="ChildDataList" datasource='<%#Container.DataItem.Row.GetChildRows("myrelation") %>' RepeatColumns="1"> <ItemTemplate> <%# Container.DataItem("OptionList") %> </ItemTemplate> </asp:DataList> </ItemTemplate> </asp:datalist> </body> the code behind as shown below: Dim … |
| | hi.. is anyone know..i have all the information about how a question should be displayed from database so that customer may review their survey question? for examples: [B][COLOR=Red]Table 1: Question - [/COLOR][/B] QuestionID, QuestionNum, Question, QuestionStyle [B][COLOR=Red]Table 2: Answer - [/COLOR][/B] AnswerID, QuestionID, QuestionNum, AnswerList eg: QuestionID=from 1 to 10 … |
| | [I]hi..[/I] my system should select the maximum QuestionNum from one of the my table in the database. after all, i would like to increment the value QuestionNum to 1... but i keep on receiving error [B]"[I]Cast from type 'DBNull' to type 'String' is not valid." [/I][/B]this is my code... Public … |
| | hi..i'm new in using ASP.NET application. Please guide me as i've only about 30% knowledge on developing web application in .NET ok..my problem is.. i have a textbox.. i wanted user to create multiple option by entering each option per line in the textbox... in other words..if user want to … |
The End.