I have a gridview with 2 columns. the first column is a textbox an the other column depending of some conditions (it may be dropdownlist, textbox or checkbox column)
how to declare a gridview?
[Code]....
This is my programs complete code, the only problem is i want to fix the amount of decimal places that show up in my gridview. The problem is if i do this on the asp side the location of the column gets thrown off and the column is duplicated. I figured if i just remade the table on the asp side it would work only problem is if i remove the sql for that particular column the asp side column cannot get data.
[code]....
I want to import a spreadsheet into SQL. The import/export wizard forces Column A to be a double. In Excel, the column is formatted as text. When I try to convert from double to text/varchar/nvarchar, the import process fails. Why can't I convert a number to text in SQL?
View 3 RepliesI attempted to change a table columns data type and in the process caused a lot of issues. I had a date column in one of my tables and stupidly changed it from varchar to date. When I tried to run queries on it I keep getting the 'cant find column 3 error'. Now that tables structure is :
[Code]...
So column 4 is actually the date column. All other queries work for this table. I then tried to change it back and then copied all data to a new table and now I am using the new table and converting the dates as needed but I am still getting the error.
SELECT * FROM postlinks WHERE postlinks.date >= CONVERT(datetime,CONVERT(varchar(10),GetDate(),112))
I have the following statement, I want to turn it into a Public Shared Function :
If isEmployee Then
Dim employeeInstance As New Employee
employeeInstance = GetEmployeeInstanceByUserId(userId)
Return employeeInstance
Else
Dim studentInstance As New Student
studentInstance = GetStudentInstanceByUserId(userId)
Return studentInstance
End If
Public Shared Function GetWorkerInstance(Byval isEmployee as Boolean) As ...(not sure what to write here)...
There two possible return Type. I'm not sure what I should declare for the function return type.
How do I select a column with the latest "datetime" data type, in Visual Web Developer 2008, ASP.NET 3.5 ?
In the config data source WHERE option my options are greater than cookie, control, etc... but I would like to select where the datetime is the latest in the table.
in my gridview i bound Duecode,DueType,DueAmount and Due Fine and also a checkbox.
Requirement
when i check one checkbox then Dues Amount is display in dueamount textbox(from database) and Duesfine is calculate and display in Duefine textbox and along with there is a Due Name "Late Fees" and DueType is "FINE" and i save "F" in database.so sum of all Dues Fine amount is calculated and show in Late fee column.it should be change if any fine amount is change.
problem
Problem is ,how can i calculate the Dues fine amount and display it in where due type is "F" column.
in which event i calculate and display it?
[code]....
I am getting this error. I have included my code below.
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Web.UI" %>
<html lang="en">
<head>
<title>Test Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<script runat="server" language="VB">
Sub Page_Load()
End Sub
</script>
</head>
<body>
<form id="Form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
</form>
</body>
</html>
I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me? I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview. I have more than 1 data to input. Do i need to use loop to bind?
View 7 RepliesI have the following code:
[Code]....
As you can see, I have two variables @total and @euclidDist, and I have declaring them and defining them using DECLARE and SET respectively. This query works in VB and MSSQL and returns the required results, however when I try to great a Gridview, and I paste the above query in the query builder, it asks me to input the values to @total and @euclidDist, ie it ignores the fact that I already defined them in the statement itself...how do I get around this?
I'm pretty new at ASP .NET but not to ASP. I've got a form I need to create where I don't know how many entries will be added. It has the following format:
"Age" "Duration" "Period of Duration" "etc..."
Last30Days
1-5 Months ago
6-11 Months ago
Age
Age
Age
etc.
So the Age column always has the first 3 options and then an unknown number of Age values that can be inserted. I've created a table that has the first four fields (Last30days, 1-5months, 6-11months, age) and I was thinking I could just order by those 4 columns for display. The problem I have is I'm not sure on how to proceed. Does anyone have any good ideas on how to handle this situation? Ideally data entry people could use the same form for both entering and displaying the data.
I have a column in my datatable named "Active" having Bit value 0 or 1.
I have a gridview and a detailsview too. I want to display the same column in gridview an detailsview as a dropdown having a listvalue Yes/No..A dropdown/gridview should show Yes or No on the basis of key.
Is it possible to declare custom commands within a listview control? For example, if I want to have a "Pay Now" link for each item in the listview, how would I do that?
View 2 RepliesI have a FormView that allows a user to register for a company event. I want to do a couple of things with this form.
1. I need to write this data to a MS SQL database
2. I need to send an email confirmation of their registration to their email.
I know how to do both of these things, but i am having trouble doing both at the same time.
It would be nice if I could do it in one click, but I coded it into two pages to try to help simplify it.
The first page allows the user to input their information into a formview and when they click the submit button, it places those answers into session variables:
[Code]....
[Code]....
The Second page confirms the users information by taking those session variables and placing them into labels:
[Code]....
[Code]....
However, after I place information into the formview on the first page, it throws up this error:
"Conversion from type 'TextBox' to type 'String' is not valid".
I have a gridview which I'm trying to get the display of phonenumbers listed in a certain display format; (xxx) xxx-xxxx.If I have the code such as this, it displays the unformatted phone number and (000) 000-0000 for the null items.
[Code]....
i 'm working on AIRLINE RESERVATION PORTAL and it's ok how to do this ?
the user most select the number of passenger and passenger's type (Adult,Child,Infant) for example he select 2-adult,3child,1-Infant
and go next , in the next page i have to generate three type of multi application form for each passenger type
2 adult application form
3 Child application form
1 Infant application form
depend on last selected vales , to save the applications in database
I am having problem with rowdatabound, want to add if conditions intact, i am using teh following two if conditions and they don't look right. i found them on google.
If e.Row.RowState = DataControlRowState.Normal Or e.Row.RowState = DataControlRowState.Alternate Then end if
If e.Row.RowState = DataControlRowState.Edit Or e.Row.RowState = 5 Then end if
With datagrids i use these and they work excellent:
If e.Item.ItemType = System.Web.UI.WebControls.ListItemType.Item OrElse e.Item.ItemType = System.Web.UI.WebControls.ListItemType.AlternatingItem Then
end if.....
I'm trying to pass email addresses from an array to a stored procedure, then display the results in my gridview. I get the following error:No mapping exists from object type System.String[] to a known managed provider native type.On this line: Dim DR As SqlDataReader = MyCommand.ExecuteReader
[Code]....
This is SQL Server 2008 database. I have a tables which has a XML datatype column, Is XML Document = true, and ScemaCollection = InternalAttributeCollection.This is my schema
[Code]....
This is my table
[Code]....
I inserted this:
[Code]....
Now, the xml column is nullable and is currently is null for the John Doe record. I tried this update:
[Code]....
I get this error: "XML Validation: Declaration not found for element 'InternalAttributes'. Location: /*:InternalAttributes[1]"
I have 1,2,3,4,5,6,7,8,9 stored as nvarchar inside Level in my db.
I then have a dropdownlist with values 1,2,3,4,5,6,7,8,9. When a user makes a selection (i.e 1) (Level.SelectedValue.ToString). This builds an sql query via a param like this:
"Select things From MBA_EOI Where level = 1"
When I run the select I get the following error:
Syntax error converting the nvarchar value '1,2,3,4,5,6,7,8,9' to a column of data type int.
I was under the impression that I was dealing with an Nvarchar field and the selected value as string, where does the int conversion come in?
p.s I have also tried Level.SelectedItem.ToString
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 RepliesI am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesI am using asp.net grid view which has is populated dynamically that means it has auto generated columns at run time.
I just want to know db type of these columns whether a column is text , date or int type.
I am using an adapter to get a list with IN where clause as:
[Code]....
I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5
However, it returns error of Error converting nvarchar value.
I'm going to design a database for an image gallery in ASP.NET Web App . Because of some reasons I've decided to store the image in Data Base , Not the address .
In the application i need two or more different size and weight image for each image that the admin insert .For instance , One of them is small and lightweight thumbnail , and the other is Original big one .
My question is : Should i have two column ( one for lightweight and small thumbnail and one for big and full size one ) in DataBase Or Is there any way i could load different size and wight image from Big and original image column ?