4

My article, SumColumn, has been updated.

by Syed Aziz ur Rahman 8. March 2006 00:27

Few days back, I have informed about my article, SumColumn published on codeproject. Now It has been updated incorporating the users comments. You can visit it here. Your comments are welcomed.

Tags: ,

ASP.Net | ASP.Net | DotNet | DotNet

6

My first article has been published on codeproject

by Syed Aziz ur Rahman 10. February 2006 06:57

"A normal requirement in any asp.net application is to sum up the values in a DataGrid column to the footer. In this article we will try to compare the normal methods of achieving this task and later we will do this by creating our own custom DataGrid column “SumColumn”, derived from BoundControl column so that we don’t have to write the same code again and again......"

This is the introduction of my first article; a very basic one. It is still in unedited mode but I hope it will be in a proper section soon. You can check it here. Your comments will be highly appreciated. (specially from Nasir who is an expert) :)..

 

 

Tags:

ASP.Net

0

DotNetNuke vs. SharePoint

by Syed Aziz ur Rahman 4. February 2006 01:03

Great detailed post comparing the two
http://weblogs.asp.net/bsimser/archive/2006/01/31/437023.aspx http://aspadvice.com/blogs/rjdudley/archive/2006/01/18/14755.aspx

Tags:

ASP.Net | SharePoint

2

Outsourced opportunity – SMS / MMS application

by Syed Aziz ur Rahman 27. December 2005 00:22

A Saudi Arabia based e-news/stock company wants to outsource an application dealing with SMS/MMS. The bird's eye view of the application is like.

 

1) User can subscribe to the SMS/MMS service through the website or by sending SMS with a given code to a given number

          E.g. SMS 195 BN i.e. user wants to subscribe to BN (breaking news)

 

2) SMS can be scheduled to send according to subscriptions.

 

3) User can ask something using SMS and get reply like

          E.g. SMS 195 SR 1010 i.e. user want the SR (stock rate) of the company (no 1010). He should be instantly replied back with the current stock value.

 

Above listed are some of the features that the company wants to have in the application. Please contact if your company has experience of developing these kinds of applications OR you have any out of the box solution. Urgent replies will be appreciated.

Tags:

ASP.Net | DotNet | General

1

Credit Card Processing

by Syed Aziz ur Rahman 12. October 2005 02:24

Situation is that I have to implement an ecommerce website based in Saudi Arabia with credit card processing facility. User should not go to some other site for transactoion i.e it must be done on our website. After a little googling I came to know that it can be done in two ways.

1) Website--> Gateways--> Processor--> Merchant Account--> Bank
2) Website--> Processor--> Merchant Account--> Bank

The top most rank gateways i came to know are
1)Authorize.Net (providing AIM service)
2)PayPal ( providing PayPalPro for US only)
3)VeriSign (providing PayFlowPro)
4)anyother you recommend

The top most processors
1)PayPal
2)Nava
3)anyother you recommend

Now there are two main problems. All of the above services require a US bank account to correspond with the merchant account. There is a service 2Checkout that can work with Saudi bank account but for that you have to go to their site for transaction.
Can anyone put some light on the issue? Am i missing something? Is there anything I missunderstood?
Am i wrong with the US bank account thing?
Is there any service that can work with any gulf account like UAE, Bahrain?

Last but not the least, Anyone who has worked with credit card processing in ASP.net, can tell the best practice and the services he used successfully so that It will be easy for me to choose between services. Did you have to use a US bank account? I think Khurram works for an ISP company so may be he can point something?????

Does anyone use .NetCharge, a product to facilitate transaction processing in ASP.Net?

AAAHHHhhhhh just doing brainstorming... to find a solution.

Tags:

ASP.Net

0

Compression in Dot Net (Zip format).

by Syed Aziz ur Rahman 9. July 2005 06:33

Like many of you out there, I have also used #ZipLib (pronounced as SharpZipLib) to do compression programmatically. For those who do not know about #ZipLib, it is an open source compression library for zip formats, written in C#. The code is available at their website. I was thinking that how it is possible that Microsoft did not provide any type of compression APIs in Dot Net Framework. After googling for some time, I came to know that........(read more)

Tags:

ASP.Net | DotNet

0

Ten tools in 10 minutes

by Syed Aziz ur Rahman 11. June 2005 04:53
Just find this blog on weblogs.asp.net. Posting it here so that who missed it there get it from here .Scott Hanselman collection of useful tools.

Tags:

DotNet | ASP.Net | ASP.Net | DotNet

3

My First WebPart for Share Point

by Syed Aziz ur Rahman 14. May 2005 04:34
Ahhhhhh. After seven hours of doing just one thing i am tired and frustated. Doing developemt on a virtual PC is a headache, so slow. My be I should upgrade my PC. I have started learning sharepoint nowadays and today I made my first web part. I tried to upload the web part following the same steps in the MSDN article but alas. As soon as i try to drag and drop my webpart on the page, an error comes that this web part is not registed as safe. I have spent hours on just registring it as safe but no success. I donot know what i am doing wrong. May be I am too tired right now to see the mistake. I will see it tomorrow with a fresh mind. I will let you know about my foolish mistake if I find one.. Words under frustation.

Tags:

DotNet | ASP.Net | ASP.Net | DotNet

0

How to generate web forms in a good way?

by Syed Aziz ur Rahman 10. February 2005 03:44

We, in our software house, use a custom build code generator (thanx to my friend Syed Umar Anis).  It generates stored procedures, and (some what intelligent) business classes using the database schema. I want to extend this generator and want it to generate web forms as well.

I was thinking about some way so that i have to do minimal work and should be a flexible solution so that it remains compatilbe with the next version of web server controls.

I started by searching how to get the XML in aspx pages i.e. when we drag and drop some control like textbox on a aspx page, its xml will automatically be generated by the visual studio. i was searching for some method that i can do it programatically e.g.

dim txtName as textbox
txtName.Id = “txtName”
txtName.Width = “250”

these lines shoule “somehow” generate xml like this
<asp:textbox id=txtName runat=server Widht=250px></asp:TextBox>

the server control has a render method but it will give the HTML like
<input type=text ......

It seems that i have to do it manually. Anybody have some good idea? OR good solutionjQuery152012277863352197138_1327390651601
Waiting for replies and searching and thinking of a solution

Allah Hafiz

 

Tags:

ASP.Net | DotNet

1

Passing Parameters to Stored Procedures

by Syed Aziz ur Rahman 20. July 2004 23:33

Reports that use stored procedures as their data source are no different than reports that use any other data source. When you open the report, it automatically calls the stored procedure, retrieves the data, and populates the report with this data. The difference between using a stored procedure and using a table is that stored procedures accept parameters as input.

When a report is designed to get its data from a stored procedure, Crystal Reports examines the stored procedure to see if it requires parameters. If so, the designer automatically creates a report parameter that corresponds to each parameter in the stored procedure. There is a one-to-one mapping of report parameters to the parameters in a stored procedure. When the report runs, the report engine takes the value of each of these parameters and automatically passes them to the stored procedure.

As you know, the user is always prompted to enter the parameters before the report can execute. Of course, you probably don't want to prompt the user for this information because your application has already done so via the user interface. To prevent this from happening, manually populate the parameter(s) via code with the information the user has already provided.

Caution! Crystal Reports can't connect to stored procedures that have output parameters defined. When attempting to do so, the report returns the error "Failed to open a rowset" and doesn?t display any data.

Listing shows how to use the viewer control to populate the paramter fields that will be passed to the stored procedure.

Private Sub SpWithViewer(ByVal UserId As String, ByVal Password As StringByVal SpParameter As String)    'Logon to the server
    Dim crReport As New CustomerSP()
    Dim crTable As CrystalDecisions.CrystalReports.Engine.Table
    Dim crLogonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
    CrystalReportViewer1.LogOnInfo = New CrystalDecisions.Shared.TableLogOnInfos()
    crLogonInfo.TableName = "spCustomers;1"

    With crLogonInfo.ConnectionInfo
        .ServerName = "(local)"
        .DatabaseName = "Northwind"
        .UserID = UserId
        .Password = Password
    EndWith

    CrystalReportViewer1.LogOnInfo.Add(crLogonInfo)
    'Create the parameter
    Dim ParameterFields As CrystalDecisions.Shared.ParameterFields
    Dim ParameterField As CrystalDecisions.Shared.ParameterField
    Dim ParameterRangeValue As CrystalDecisions.Shared.ParameterRangeValue
    Dim spValue As CrystalDecisions.Shared.ParameterDiscreteValue

    ParameterFields = New CrystalDecisions.Shared.ParameterFields()
    ParameterField = New CrystalDecisions.Shared.ParameterField()
    ParameterField.ParameterFieldName = "@CustPattern"
    spValue = New CrystalDecisions.Shared.ParameterDiscreteValue()
    spValue.Value = SpParameter
    ParameterField.CurrentValues.Add(spValue)
    ParameterFields.Add(ParameterField)
    CrystalReportViewer1.ParameterFieldInfo = ParameterFields

    'Show the report
    CrystalReportViewer1.ReportSource = crReport

End Sub

The first half logs onto the data source with the appropriate server name, database name, and login credentials. Notice that the TableName property is the name of the stored procedure with ?;1? shown at the end of it. This is how Crystal Reports identifies the stored procedures and you have to remember to include it as part of the table name. The second half of the code creates a new parameter field, adds is to the parameter fields collection and assigns this collection to the report viewer.You can also pass parameter using the ReportDocument object

Tip: If you want to pass a NULL value to a stored procedure parameter, set the parameter's Value property to Nothing in VB.Net and null in C#.

SET NOCOUNT ON

Although this section assumes you already familiar with stored procedures, there is one statement that doesn't get much attention but is very important.

SET NOCOUNT ON

If you are working with simple stored procedures, then the majority of them consist of a SELECT statement followed by a list of tables, fields and a join method. Crystal Reports handles this type of stored procedure fine. Once you start getting into writing more complex stored procedures you will find that you often need to execute multiple SQL statements within one stored procedure. This can happen when you are using temporary tables, and updating data prior to executing the final SELECT statement.

SET NOCOUNT ON
INSERT INTO AuditLog
SELECT * FROM tblSales WHERE

In the above code, the SET NOCOUNT ON statement is commented out. Running this code will generate two output messages for each statement. They will be in the format of ?xx records affected?. This message is passed prior to the records being returned from the stored procedure. This conflicts with what the report is expecting. Thus, it doesn't use the data from the SELECT statement as its resultset. By uncommenting the first line of code, you tell the database server not to report how many records are affected. This eliminates Crystal Reports from incorrectly using these messages as part of the database. Ideally, this statement would be the first statement in every stored procedure.

HTH

 

Tags:

ASP.Net | DotNet

Powered by BlogEngine.NET 2.5.0.6
Original Design by Laptop Geek, Adapted by onesoft