This blog provide knowledge of all type of query. I want to share my experience with all.
Tuesday, 21 April 2009
Load Report Failed.
CrystalDecisions.CrystalReports.Engine.ReportDocument rp;
string reportPath = Server.MapPath("LogReport.rpt");
rp = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
sql = "Select 'User Name :'+lmaster.l_name as username,'' as sno, userdetail.user_ip as uip from userdetail order by servertime";
dsmain = mydata.GetDataSet(sql, 1);// this method my own method will be return query data in dataset.
rp.FileName = reportPath;
rp.SetDataSource(dsmain.Tables[0]);
crviewer.ReportSource = rp;
Thursday, 16 April 2009
Difference between dataset and array
I remember that once in my project I need to compare single column value from text file. Then i used DataSet, but row is more then 90,00,000 so it is failed there.
So i used normal array. It is working so fine. Normal Array can hold more then 10,000,000 value.
It is very easy to compare with array because we can use binary search.
Change Report Viewer Toolbar Images.
Inetpub\wwwroot\aspnet_client\system_web\2_0_50727\
If in your server crystal report support installed then you found below path
Under below path you get then all images of report viewer control.
Inetpub\wwwroot\aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\images\toolbar
You can replace your images with default images.
Note. Images name are same as default images.
Please Let me know if any query.
Monday, 13 April 2009
Sending Mail
MailMessage objmail = new MailMessage("from mail address", "to mail address", "mail subject", mail message);
SmtpClient Objsmtpclient = new SmtpClient();
Objsmtpclient.Host = "write here your smtp ip (your smtp server ip)";
Objsmtpclient.Send(objmail);
Saturday, 4 April 2009
What is SOA?
The .Net technology introduces the SOA by mean of web services.

The SOA can be used as the concept to connect multiple systems to provide services. It has it's great share in the future of the IT world.
According to the imaginary diagram above, we can see how the Service Oriented Architecture is being used to provide a set of centralized services to the citizens of a country. The citizens are given a unique identifying card, where that card carries all personal information of each citizen. Each service centers such as shopping complex, hospital, station, and factory are equipped with a computer system where that system is connected to a central server, which is responsible of providing service to a city. As an example when a customer enter the shopping complex the regional computer system report it to the central server and obtain information about the customer before providing access to the premises. The system welcomes the customer. The customer finished the shopping and then by the time he leaves the shopping complex, he will be asked to go through a billing process, where the regional computer system will manage the process. The payment will be automatically handled with the input details obtain from the customer identifying card.
The regional system will report to the city (computer system of the city) while the city will report to the country (computer system of the country).
What is Software Architecture?
* Partitioning the problem and the system to be built into discrete pieces
* Techniques used to create interfaces between these pieces
* Techniques used to manage overall structure and flow
* Techniques used to interface the system to its environment
* Appropriate use of development and delivery approaches, techniques and tools.
Download Data From Website
Dim ObjWebClient as new WebClient
ObjWebClient.DownloadFileAsync(uri, SavePath)
While ObjWebClient.IsBusy = True
comehere:
If ObjWebClient.IsBusy = True Then
GoTo comehere
Else
GoTo exitloop
End If
End While