Hi there, you got any workaround for this problem..? or any solution..?? i'm also facing the same problem.. :(

Integrator: <Select name=Integrator id=Integrator Size=1 onChange= <% dim sqlTemp dim arrRSTemp dim ConnTemp : Set ConnTemp = cf_OpenConnection() sqlTemp = "Select * from Integrator where atnINtegratorID = 1" set arrRSTemp = Conn.Execute(sqlTemp) Response.Write "Integrator Address: " & arrRSTemp("txtIntegratorAddress") Response.Write "<br>" %>> <option value=''>**No Integrator**</option> <% do until arrRS_Integrator.EOF Response.Write "<option value='" & arrRS_Integrator.Fields(0).value & "'" Response.Write ">" & arrRS_Integrator.Fields(1).value & "</option>" & vbcrlf Call arrRS_Integrator.moveNext() loop %> </select> </code> I have a combo which is used to dropdown some info. Now i want do some coding in the onchange event, as shown above. is this possible? please help me in this, because the code above is not working a bit. NB: I'm a beginner

Just a simple question :) Is System.Array a collection ? If it is, then why doesnt it come in the System.Collections namespace ??

The name is Sandeep

hi, thnx for the reply..

The name is Sandeep

hi there, I have a simple WPF window with a button in it. now during runtime, i pass this button control to another function, and there, i want to know the parent of this control. ie the window, with the full namespace. any way for this thru C#

The name is Sandeep

thanks guys.. :)

The name is Sandeep

Hi guys, I want to start doing some samples in Silverlight. Was just wondering whether i shud have knowledge in ASp.net, for getting started in Silverlight. Pls give me a hint, from where shud i begin.?? Thnkx Sandeep

The name is Sandeep

i think this is what you meant.

select top 1 len{your string column} from order by len{your string column} desc
Or
select max{len{your string column}} from

hope it helps.

The name is Sandeep

Hi guys, Back with another question :) Create Table TestTable ( TestTableId Int Not Null, TestTableName Varchar(100), Primary Key (TestTableId) ); Now i want to alter the TestTableId column and change it to an Identity Key. I heard that theres no direct syntax for this as such. But is this possible through SQL Server 2008?

The name is Sandeep

thanx buddy, but isnt this the query to list the foreign keys of a table? anyways, i think i got my answer select * from sys.objects where object_id in (select parent_object_id from sys.foreign_key_columns where parent_object_id = referenced_object_id) Thanks for your effort guys..:)

The name is Sandeep

thanks for the reply man. but that's not what i asked. :) I don't want to select any DATA from any table. I just wanted to know whether there are any other tables in my database, which have self references within themselves [just like the reference established in TestTable] I wanted a query which shows those type of tables.

The name is Sandeep

Hi all. Please guide me thru this. I have a large database with many tables having self references. for eg: TestTable: TestId int, TestName varchar(100), ParentTestId int, Primary Key (TestId), Foreign Key (ParentTestId) References TestTable(TestId) I just wanted to query out the tables which are having similar type of relationships within themselves. Thanks in advance.

The name is Sandeep

thanks buddy. i think i got it somewhat clear.

kissdznuts wrote:

Using data readers def has its place and is very quick when used appropriately.

can u please give a scenario in which the above said is satisfied..?

The name is Sandeep

Hi man, Thanx for the reply. But i hv one more query. If disconnected architecture is more reliable and scalable than the connected one, then why do we need the Connected Arch? why does ADO.NET provide both of them..?

The name is Sandeep

Hi everyone, Can anyone guide me thru this? I'm quite bit confused with the ADO.NET connected & disconnected architectures The working method is not the prob, but i just wanted to know the real SIGNIFICANCE of both. ie, if connected Arch is better than disconnected arch, then why do we need disconnected arch in ADO.NET Or Vice versa. I hope u guys got me.. Thanks in advace. "Nothing goes unknown, unless.... " i think u know the answer :)

There is another way to check the date.. try this.. Select * From .... Where Convert(DateTime, @ParameterDate, 103) = Convert(DateTime, GetDate(), 103) This is for checking with current date(GetDate()). For more precision yo can add the following lines of code with the above code. And Year(@ParameterDate) = Year(GetDate()) And Month(@ParameterDate) = Month(GetDate())

The name is Sandeep

Hi all, I'm sorry to post the same question twice..but i hv no other go.. I want to enter some ids (4 or 5) into a new address group in outlook express thru VB. I searched whereever i could but could'nt find any help.. Plz help me out.. Thnx in advance.

The name is Sandeep

Hi all, I want to enter some ids (4 or 5) into a new address group in outlook express thru VB. Can anyone help me out..?? Thnx in advance.

The name is Sandeep

Hello Rahul, Thnx for your reply. Let me tell you what I have understood by Indexes. Please verify my points. Indexes should be only used in tables used for data retrieval and not in tables where frequent INSERT & UPDATE take place. When an Index is created over a table, then there is no need for defining a PrimaryKey for that table. Indexes are best suited for Views. Are these correct? The name is Sandeep

Can anyone give me some help regarding Creation of Indexes in SQL Server. I also need to know its advantages and most importantly, its difference when compared to Primary Key Constraints.

The name is Sandeep