Posts
 
Reputation
Joined
Last Seen
Ranked #828
Strength to Increase Rep
+6
Strength to Decrease Rep
-1
66% Quality Score
Upvotes Received
13
Posts with Upvotes
11
Upvoting Members
8
Downvotes Received
7
Posts with Downvotes
3
Downvoting Members
7
4 Commented Posts
0 Endorsements
Ranked #654
~18.4K People Reached
Favorite Tags
Member Avatar for prakashmca07

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.........

Member Avatar for rispy
0
110
Member Avatar for darkagn

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 …

Member Avatar for Ancient Dragon
0
461
Member Avatar for ksp_852005

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 …

Member Avatar for padtes
0
249
Member Avatar for Lokesh_S

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 …

Member Avatar for padtes
0
88
Member Avatar for Helium

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 …

Member Avatar for apegram
0
151
Member Avatar for Traicey

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 …

Member Avatar for Traicey
0
122
Member Avatar for campkev

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 …

Member Avatar for Ezzaral
0
205
Member Avatar for sasidhars

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 …

Member Avatar for padtes
0
107
Member Avatar for lebanese007

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 …

Member Avatar for JuhaW
0
102
Member Avatar for tqmd1

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

Member Avatar for tqmd1
0
135
Member Avatar for moggy4

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> …

Member Avatar for kadempalli
0
162
Member Avatar for Pari13

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) …

Member Avatar for Pari13
0
128
Member Avatar for RahulV

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 …

Member Avatar for padtes
0
834
Member Avatar for malinkam

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 …

Member Avatar for padtes
0
91
Member Avatar for Pari13
Member Avatar for padtes
0
69
Member Avatar for samuel_1991

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 …

Member Avatar for samuel_1991
0
172
Member Avatar for Troy382438

[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 …

Member Avatar for ChrisPadgham
0
200
Member Avatar for vbdotnetlover

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 …

Member Avatar for achieveSenthil
0
122
Member Avatar for bonnysammy

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 …

Member Avatar for padtes
0
126
Member Avatar for vbdotnetlover

Dear Developers How to enable "Autio Hide" command for Solution Explorer Window Please Help

Member Avatar for padtes
0
109
Member Avatar for wild_angel

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: …

Member Avatar for wild_angel
0
225
Member Avatar for manjunath_praj

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="&nbsp;Edit&nbsp;" ShowEditButton="true" …

Member Avatar for padtes
0
126
Member Avatar for hitro456

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 …

Member Avatar for hitro456
0
145
Member Avatar for Waddiwassi

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 …

Member Avatar for Waddiwassi
0
165
Member Avatar for tqmd1

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

Member Avatar for padtes
0
103
Member Avatar for makdu

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 …

Member Avatar for makdu
0
240
Member Avatar for bajanpoet

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 …

Member Avatar for bajanpoet
0
2K
Member Avatar for capiono

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

Member Avatar for mail2saion
0
187
Member Avatar for engisa

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 …

Member Avatar for engisa
0
151
Member Avatar for pecet

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 …

Member Avatar for pecet
0
88