Search:

Hi Friends

I've already written a query to retreive specific values from SQL server DB and I want to use that values one by one to be passed in stored procedure

Is that possible?

Thanks,,,

Thank you jmcilhinney for your quick response

I am using SQL Server 2000, we had some type of users who want to create thier views to retrieve thier own data and at the same time we can't give...

Hi Friends

I am trying to create new role at the server to allow users to create new view.

Please can anyone help?

Thank you so much for helping

Yes I am

I was trying to see if every cell in columns A through F on one sheet are the same as A through F on the other sheet and counting if the code find out the...

The code dose not go inside if condition and give error message.

Hi Friends

I'm trying to compare two ranges from different sheets:


UniqueItems
AllItems


but when I run the following code I get error message in IF condition (type mismatch)

Hi Friends;

I have a crystal Report that have a formula field to make simple summation of three fields from DB as follow:

93333

when I try to preview the report, it shows fine but when I...

Hi Friends;

I have a web application that uses crystal reports that have been put at specific folder named Reports.

the problem that make me crazy :(, some of reports apply any modification...

Thank you so much for your quick response

I've found a simple solution for that issue as follow:

<tr>
<th>City1</th>
<td><%=string.Format("{0:0}", dtHour.Compute("max(field1)",...

Hi Friends

I've a datatable that developed by my colleague and filled at HTML table (old stayle programming)



<tr>
<th>City1</th>
<td><%=string.Format("{0:0}",...

Thank you so much for quick reply but unfortunately that is not my desired.

Hi everybody

I had a calender in my web page but I am facing difficulty to browse months and years quickly like what is happening in ajax calender.

can anyone help me to facilitate browsing of...

Hi all

I am asking if I can make dynamic for next according filled range because most of my friends are using standard for next loop as the following:



for i = 0 to 1000


I want for loop...

Hi Friends

I have used for next to loop through range but I got subscript out of range

here is my code.



Dim i As Long
For i = 1 To Sheets("Sheet2").Range(A1, S1000).Rows

Hi friends

I am trying to filter rows by value which is available in cell (as a variable) then after result returned I want to delete these rows by vba.

thank you

SQL Server

Hello,

thank you so much for help I am still learning

I am talking about user defined database which is given by developers.

regarding "troubles" I mean for example: to make server slow or...

Hi everybody

I was discussing that pint with my friends.

If I am database administrator and get troubles in my server from some of databases.

What can I do to monitor or observe that...

Hello
please forget that idea to clean caching, I explain my problem in the beginning after updating user picture and re-login the user can't see the new picture which has been updated except...

sorry to being late

the problem still have not been solved

I want to clean Caching to be able to display new picture.

bintaleb

Hi all

markup and code:


<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="test.aspx.vb" Inherits="CubeEval.test" %>
<asp:Content...

thank you danasegarane for help

but the problem not working.

bintaleb

Hi everybody

I had a page to update user picture and redirect user to login page, the problem is when a user re-login, the old picture is still available until user refresh the page.

notes: I...

thank you koolsid for your concern

in the beginning I was thinking to use VBA to achieve my task but our friends have adviced me to use macro or Excel Formulas if I am correct, I would like to...

Hello opus

my data source is an Excel file, but I think I am going to use macro because most of our friends have suggested that.

bintaleb

Hi Sid

yes I want to do that by native Excel formulas.

regarding sample data I need to convert it to english first but let me tell what I am thinking, I going to use for loop to check record by...

Hello there,

thank you so much for help

you are definitely correct the concept of writing code is same but in excel you are dealing with cells that is different.

I am going to try macro.
...

Hi everybody

I have already defined range named Table1 in Sheet1 and I have other sheet to retrieve data from named range by three keys:


Status
date
Nationality

Thank you so much that is what I exactly looking for.

bintaleb

Hello there

Thank you so much for help but also not OK.

bintaleb

Hi everybody

In my case I just want trigger to work after row inserted when status = 16 or row updated to status 16 but the problem is when any modification is made in any column the trigger will...

thank you so much.

Hello Gary

here is what I have used to check a new email is already exist or not.



Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnUpdate.Click
Dim...

Hi everyone

I am trying to make actual Book Stories by javascript and connect that with sql server DB, I can imagine that as follow:
there is a cover page which will be filled by user.
table of...

thanks sap and gary

now it is working good.

Hello Gary
thank you for quick response
Yes I have already used membership Providers in my project and I have prevented any new user to type duplicate email but let me clear my question.
...

I think you are trying to connect to your web app not from localhost, here is what I suggest to change because I have faced same problem :

<add name="Hostingconnection" connectionString="Data...

Hi everyone

I have already done from register.aspx and works fine but I want to validate updated email to avoid any dulicated email.

can anyone help to do that?

bintaleb

hello sap

to my mind I think when you use Separate control better than web service and after make required steps and browse a web page I found recaptcha control on the top of page while I put it...

that is amazing but it is not comfortable to use it inside CreateUserWizard control, Do you agree?

bintaleb