- Strength to Increase Rep
- +6
- Strength to Decrease Rep
- -1
- Upvotes Received
- 13
- Posts with Upvotes
- 11
- Upvoting Members
- 8
- Downvotes Received
- 7
- Posts with Downvotes
- 3
- Downvoting Members
- 7
Could anyone tell me whether datagrid in asp.net can be used without database bcos if it is used means not visible during runtime.. anyone can advise if u know in this regard......... |
|
Personally I prefer the Reputation as a measure of one's helpfulness/popularity on DaniWeb, and truthfully I haven't paid much attention since the introduction of the Up/Down Voting system. But lately one thing is starting to bug me about it - if someone up/down votes a post, it is completely anonimous … |
|
below is my code....i m gettng "System.InvalidCastException: Specified cast is not valid." error in my code...m new on asp.net n sql...m trying to build login area....but unless n until i solve this error i can't move forward n as m new, m not gettng y m gettng dis error... can … |
|
Hi all, I've hosted my application at shared server. So, after 10 - 15 minutes my session object "userid" is expiring and throwing error "Session object userid is not instantiated" I want to check my session object exists or not. I've already used if(Session["useid"]=="") but it is throwing error. Is … |
|
Hi I have a table with two columns (ID,ROW) I need to make the ID COLUMN unique and increase it value by 1 for each row. ----------------------- ID ROW 1 NULL 1 NULL 1 NULL 1 NULL How can I replace the each 1 with sequentially increased value? to be … |
|
Hi All I have datagrid with a dopostback javascript, right now it looked click-able, when I hover with a mouse it select the entire row, except one thing when I click it doesnt do anything, I need to select a row in my datagrid and pass the values of the … |
|
Ok occasionally I get the following error message on my site System.String Substring(Int32, Int32) Error: Length cannot be less than zero. Parameter name: length here's the wierd part, I don't use that Substring function, I use System.String Substring(Int32) whose only parameter is start. So I am getting an error from … |
|
i write the procedure for login in this user can give username or emailid for the login. this is my code.... please check is there any change is required for this [code=text] ALTER procedure [dbo].[users_login] (@username varchar(50),@password varchar(50), @emailid varchar(50),@ret int output) as begin select username,password,emailid from users where( username=@username … |
|
hi all, i have a database called DB with a table called Menu_reporting that logs when the user selected through calling the server (See below) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USE [DB] GO /****** Object: Table [dbo].[Menu_Reporting] Script Date: 01/31/2010 17:07:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO … |
|
Dear Developers SQL, Table CODE has data as following Code------product 1-----------Mango 2-----------Potato 3-----------Orange SQL, Table SALE has following data Code------Product 2----------- 3----------- I want to fill sale.product column with code.product columns as Code------Product 2-----------Potato 3-----------Orange What query should I USE? Please help |
|
Hi All i am quite new to mssql db and would like to find someone to help me with some errors i keep getting i have uploaded my new db and when i try to open my website i get the following errors [code] <!-- Web.Config Configuration File --> <configuration> … |
|
Have nice Evening! I have an error message of "[B]Overflow Exception was Unhanded by User code[/B]"when i am trying to exceute below very simple code. [CODE] Partial Class zeesant Inherits System.Web.UI.Page Dim x As Integer Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load x = (Val(TextBox1.Text) … |
|
Hi Friends, Can there be a query that will SELECT fields of a table and group a column (say "CustomerID") and show all its rows along with its subtotals and then its Grandtotal in the result returned? For Example, CustID Items Cost ExtraCharges --------------------------------------------------------------------------------------- A1 Cofee 15.00 2.00 A1 Tea … |
|
I have this sql code which works fine : [CODE]sql = "select count(city) as cx from NY where CITY='New York'" set rs=conn.execute(sql) response.write(rs("cx")) [/CODE] The above counts all records with New York city. I have been trying to put this on a dynamic .asp page and modify line 1 to … |
|
Hey, Can anybody give me the code to find Serach on text written by user in textbox? |
|
Hi I have a ASP.Net code below that need to query with MS SQL database. [code] "select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem " & _ "Inner Join Product " & _ "On ShopCartItem.ProductID = Product.ProductID " & _ "Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID" [/code] The MS SQL query … |
|
[CODE]See current output starting at page DROP TABLE EMPLOYEE; DROP TABLE JOB_TITLE; Create Table EMPLOYEE ( EMP_ID int NOT NULL, LAST_NAME varchar(20) NOT NULL, FIRST_NAME varchar(20) NOT NULL, EMP_ADDRESS varchar(25) NOT NULL, EMP_CITY varchar(25) NOT NULL, EMP_STATE char(2) NOT NULL, AREA_CODE int NOT NULL, PHONE_NUM int NOT NULL, HIRE_DATE datetime … |
|
Hello Sqlserver MyTable has following data Vou---------date---------qty 1-------25/12/2009------5 2-------25/12/2009------4 1-------26/12/2009------8 2-------26/12/2009------3 3-------26/12/2009------2 [CODE] str = "SELECT date, SUM(Qty) AS Qty, FROM mytable GROUP BY Date" dt = GetTable(str) [/CODE] These codes display following result date--------------qty 25/12/2009------9 26/12/2009------13 Now I want to add sno column in result as Sno--------date---------qty 1------25/12/2009------9 2------26/12/2009------13 … |
|
Hi! I'm using C# and SQL Server. I need to take data from one table, display it to the user, allow the user to modify anything, and then when they click save, have the record added to a new table and deleted from the old. I have the first table … |
|
Dear Developers How to enable "Autio Hide" command for Solution Explorer Window Please Help |
|
Hi All! I have a table that there is a combo box inside the table. For example, the combo box consist of item codes. And then, whenever user choose item from combo box, the next column inside the table will show name of the item. Here is my example coding: … |
|
Hi 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 <asp:GridView ID="GV_Money" DataKeyNames="ID" ShowFooter="true" runat="server" DataSourceID="SqlDataSource1" AlternatingRowStyle-BackColor="AliceBlue" AutoGenerateColumns="False"> <RowStyle CssClass="test" /> <Columns> <asp:CommandField EditText=" Edit " ShowEditButton="true" … |
|
Hi everyone I am executing a query on sqlreader object i.e. rdr = cmd.executereader(); now I get a value rdr[0] = 100; but this value is in reader object. I want to transfer that value rdr[0] to integer variable how can I do that? I tried int.parse, int.tryparse, convert.int32..etc it … |
|
Hi, I'm in my second year of computer science and we're currently learning about design patterns. As part of this we have been given an assignment to include the Abstract Factory design. I'm having trouble understanding exactly how it fits together so I was wondering if someone could explain, in … |
|
Dear Experts Sqlserver Table1holds data as follows date---------------sno 01/01/2010-------1 01/01/2010-------2 01/01/2010-------4 01/01/2010-------5 01/01/2010-------7 02/01/2010-------1 02/01/2010-------2 02/01/2010-------6 02/01/2010-------8 How to findout missed sno in 01/01/2010? I want to get this result 3 6 Please help |
|
Hi, My application needs to run without any window poping up. Also the application needs to detect the shutdown from computer. Based on the input from this forum, i have used a form in the appliction. But i want this form to be hide from the user. Is there a … |
|
The code snippet below is the beginning of a script I've been working on. What I need to figure out is make sure that I can generate the corresponding day last year. The business logic is such that I am supposed to compare sales data from the last business day … |
|
I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this |
|
Hi all, I wanted to execute the query stored in a table with given intervals. I have a table called "calculations". it has the following structure: id | period | sql | result | now, in the sql field, I store the sql clause to be executed. In the period … |
|
I started to learn SQL recently. I downloaded some kind of assignment, where the goal is to design small database. I have two tables listed below: [CODE]create table SEA ( SEA_NAME varchar(50)constraint sea_prj_key primary key, AREA numeric(18, 0), );[/CODE] and: [CODE]create table NATION ( CTRY_NAME varchar(50)constraint sea_prj_key primary key, AREA … |