Search results for query: *

Hi , I have created datagrid and added a link to export the content of the datagrid to excel. All format was lost when I export the data. Is there a way to keep the same format in the datagrid in the exported excel. Please click on the link to have a visual snap shot of the problem...

hi, I have one store procedure and one Dts package. The store procedure process data and I would like to be able to once the store procedure is completed, to run the DTS Package, How can I do that, thanks for your help. Al

Hi, I have created 3 store procedure and one DTS. I would like to schedule those code and run them in sequential order. Those are the code: sp_A sp_B DTS_moveData sp_C Once sp_A is completed sucessfully, I want sp_B to run then once sp_B is completed sucessfully, I want DTS_moveData to run[...

Hi, this is a code when I execute it from sql server query window , it runs. Does anyone knows how I can reverse the function so instead of zipping the files I need to unzip them into a new folder..... thanks for your help and support Al declare @varcmd varchar(255), @CurrentDate...

hi I have fast internet provider, Cox roadrunner + PC at home + a wirless router. I want to be able to set up my PC to do the following: 1. Allow Public to access my web page in my PC 2. Allow some people to access my ftp server in my PC 3. Allow one or two people to use remote Desktop...

hi, I have created a simple 3 pages application. Input form and 2 datagrid. back end is access database. I need to deploy the application to a host company. since I am doing this for the first time, Is there any consideration that I need to account for before I send the 3 aspx pages. What...

hi I have created a link as follow: http://168.125.1.1/xzy/report/projectCost.pdf in a web page in which a user can access the link after he/she provide user name and password. after the user is approved to enter the site, he/she can click on the above link to view the content of the pdf...

hi I have downloaded Sql server sp3 from http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en and installed the following in my server sql2kasp3.exe 44617 KB sql2kdesksp3.exe 70815 KB sql2ksp3.exe I ran sql2ksp3.exe and then...

hi, Is there a way to create a function that is smart enough to do all kind of form validation . Basically, I can pass form elements one at a time , then the function can validate for the following: check if field is either integer ,string or date Once the datatype is determined, it validates...

hi, I have a datagrid that contain a date field. if the field has a adate before I update the row, it make the update, but if a edit a record that has no date in the column field, I get the following error, any idea how to fix it. thanks Al Cast from type 'DBNull' to type 'Date' is not valid...

hi, I have created a table that capture profit distributions from projets, what I need to do is to create a bottom to iterate throw profit distribution table and print checks to the investors, can I do that in asp.net? and if I can what approach I can take. thanks Al

I have installed sql server with Arabic collation and I was able to create a table with two fields that has nvarchar datatype and I was able to insert data into that table. I did the same thing with default sql server , when I insert data into same table structure, it worked, but when I...

hi, is there a way where I can check a specifit field in a datagrid once it changed, I can capture old value and new value and process those info. thanks Al

hi, I have created a datagrid that pull record from one table. The table called contact_log and it has a field called followupAction. For every change in any record, I want to capture the old data for the followup filed to be archived in another table, so client_call_log table...

hi I am new to asp.net. I appreciate your assistance in clarifying the following: Which Data type I should use 1. Ado type vs .net type vs sqlDbType vs sqlType I did the following in visual studio Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlDbType Imports...

Falling back on cursors because they remind you of datasets will result in poor performance " Hi, The above quote was from an article which advice to use store procedure and avoid T-sql in the body of a webpage. Anyway, To me, I always use cursor when I want to process one row at a time. Is...

hi, I have created a project in Visual Studio.net (vs.net) and created one aspx page called salesreport.aspx that pull data into a datagrid. That is done in the development PC. I ran the salesreport.aspx from within vs.net and it worked. Now I want to publish it in the production server so I...

hi, I used to create aspx in one page, the html and the code. everytime I am done with an aspx page,I upload it to the server and I am able to view it via the browser. I never used visual studio before. Someone recommended me to use it and I did. My question, when I create one aspx page in my...

hi, I wonder how can I view all available database in Oracle. I want to be able to identify specific database then view its tables so I can create store procedures to pull data in a reporting format. I have not worked with Oracle before, but I have a client who gave me access to his plsql...

hi, I am not an oracle developer and never used it before. I only know MS Sql server 2000. I want to be able to create a storeprocedure in Oracle database for reporting purposes. I have visual studio .net 2003. My question, can I create storeprocedure in Oracle database via visual Studio .net...