Thanx

Arun Singh INDIA-Noida. My limit is sky and sky is too high.

HI, I have a grid control which has three columns viz.quantity, unit price, and total Amount column. Quantity column can have only integer value. I want to validate quantity column in a way so that as soon as user insert value other than integer, a message box should display showing error and return the focus to the cell. OR System should not allow any value other than integer into the cell. Is there any keypress/keydown/keyup event for datagrid's cell also? If yes than please provide me code or any hint... Please help.

Arun Singh Noida.

Yes it is possible Set your control's width in percentage ("width=100%"). Set your tamplate column's width to 100% again.

Arun Singh Noida.

Set the tooltip property of control to the text you want to display.

Arun Singh Noida.

Use body tag for any kind of farmatting on form level. E.g.

Arun Singh Noida.

HI 1)Set selectionmode="multiple" of list box to enable multiple selection. 2) You can select multiple names using ctr+mouseclick. 3)To retrive all selected names from listbox you can use: Request.Form("listbox_Name").ToString() function, which will return all selected items in a listbox into a string. :laugh:

Arun Singh Noida.

use this : 'flUpload is the name of File Upload control flUpLoad.PostedFile.ContentLength it will return the size of posted file in bytes... :)

Arun Singh Noida.

I want to insert text in gridview but i dont have any data source. How can I insert text values in dataGridview? for example if i want to insert value in textbox i will user textBox1.text="Adfsr" like in the same way i want to create a gridview i have two columns viz Name and description in datagridview and I want to insert in "Arun" in name field and "Healthy person" in description. please suggest. I want to use dataGridview only....

Arun Singh Noida.

there are two ways to achieve it either from sql server by using Convert(varchar(30),getdate(),101) it will convert your date to desired format. other one is use Format(XXX, "dd MMMM, yyyy") function in .NET ...

Arun Singh Noida.

The sp_who2 internal procedure provides the following information: Spid—The system process ID. status—The status of the process (e.g., RUNNABLE, SLEEPING). loginame—Login name of the user. hostname—Machine name of the user. blk—If the process is getting blocked, this value is the SPID of the blocking process. dbname—Name of database the process is using. Cmd—The command currently being executed (e.g., SELECT, INSERT) CPUTime—Total CPU time the process has taken. DiskIO—Total amount of disk reads for the process. LastBatch—Last time a client called a procedure or executed a query. ProgramName—Application that has initiated the connection (e.g., Visual Basic, MS SQL Query Analyzer) You can use them.

Arun Singh Noida.

Yes Seesion Id is unique for every user....:)

Arun Singh Noida.

Use height, width for setting height and top left attribute to set the position.....

Arun Singh Noida.

Thanx now it is solved

Arun Singh Noida.

HI all, I am creating a Procedure in which i need to take table name from user as input I m trying to achieve this but getting some errors please help me out. here is the code.... set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[apo_GetQuestionsByInqTransId] --Passing inventory id as input variable --Generate all the questions of it @InqTransId int, @appId int, @option nvarchar(20), @schema nvarchar(30) As Begin if @option='All' begin select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo from QuestionMaster qm,InquiryTransaction it, InquiryQuestionLinkage itql where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId and it.InquiryTransId=@InqTransId order by QM.ParentQID end else begin declare @AnswerDetailTable as nvarchar(40) set @AnswerDetailTable =@schema+'.AnswerDetalTable' select qm.QID,qm.[name],QM.ParentQID,itql.SequenceNo from QuestionMaster qm,InquiryTransaction it,InquiryQuestionLinkage itql where itql.qid=qm.qid and it.InquiryTransId=itql.InquiryTransId and it.InquiryTransId=@InqTransId and qm.QID not in(select QID **from @AnswerDetailTable** where appId=@appId) order by QM.ParentQID end End In the above code I need ur help in the else statement where I am using @AnswerDetailTable in from clause. I m geetin error "Msg 102, Level 15, State 1, Procedure apo_GetQuestionsByInqTransId, Line 33 Incorrect syntax near '@AnswerDetailTable'." wating for suggestions....:)

Arun Singh Noida.

Can you also write the error which you are getting?

Arun Singh Noida.

Dim sText as string For Each row As GridViewRow In gvAttachFile.Rows as string For Each = CType(row.FindControl("textBox1"), textBox).Text Next Make some changes in syntax for c#.:->

Arun Singh Noida.

Syntax will go like this: Begin Try Begin Transaction --Your Line of code Commit Transaction End Try Begin Catch RollBack Transaction End Catch --Your line of code You will have to call commit or rollback for your transaction.....:-D

function getTextValue(control) { for (i = 0 ; i-1) { //get the value of textbox document.frmName.elements[i].text; } } } I hope this will help u out .......

hi may be this will give you much clear Idea, try this.... DropDownList1.Items.Add(New ListItem("--Select-One--", "")) For iCount = 0 To dataTable.rows.Count - 1 DropDownList1.Items.Add(New ListItem(dt.row(i)(0).tostring(),"") Next It might contain some syntax errors as I am writing it without using IDE.:-D

@ parameter are defined by user they are local variables in Sql. but @@ variables are global and defined by system only....