Solutions For You

Best Content Writing for Websites,Blog

2010-09-07T01:19:00.000-07:00

I am working as a Sr. Content Writer and have been handling content writing projects for the past 3+ yrs now.

Content Writing Services
1) Content Writing for Websites: Creating Web Content for Websites based on highly searched keywords, individual products, services and more

2) Blog Writing: Furnishing Premium Quality Content& News Articles for your website & blogs on daily, weekly and monthly basis respectively

3) Press Releases: Writing Press Releases for new launches, products & services

4)EBooks: Developing the Content for e-books, case studies & magazines

5) Technical Writing: Writing Technical Writing, Travel Writing, Medical, Technology, Business, Product Reviews & more

6) Newsletters: Writing Newsletters for different purposes - For your website promotion, to introduce your services, or for your product promotion, on a weekly, fortnightly, or monthly basis.

7) SEO Writing: Writing Articles for Directory Submission, to earn good number of backlinks
Proof Reading and Re-writing: Re-writing Your Website Content to include the best keywords and title

MY WORK STRATEGY

I create content that is keyword based and SEO oriented.

I produce unique content that is proof-read and checked through copyscape, before sending it to my clients. This ensures originality and has helped me in maintaining a healthy relationship with my clients.

You own the complete copyright of the articles.

Give me a time limit and I shall deliver hundreds of articles within the deadline.

All Articles are 100% original & proofread. No plagiarism.

MY VISION

Producing More than 30 Quality Articles Daily – I will surely meet the deadlines.

Expanding My Aspiring Team of Content Service Providers – Presently I am providing content on daily basis, and I hope to build a team of 50 writers by the approaching 2011

Establish A Brand Name In The Content Producing Field – I am looking forward to carve a niche in the field of Content Writing and establish my own Brand Name.

View My Profile at odesk: odesk profile
Email: punitamarwaha@yahoo.com

Learn ASP.NET DOTNET Training Mohali

2010-08-29T22:56:00.000-07:00

Learn ASP.NET/C#/SQL SERVER FROM IT experts in Mohali.Please read details at

http://learnlinq.blogspot.com/2010/03/learn-aspnet-at-panchkula.html

Backup mysql database using batch file and asp.net

2010-08-24T20:59:00.000-07:00

Create a batch file with the following code

set pathchoice=%1%

"C:\wamp\MySQL\bin\mysqldump" -u root dbname -p password > %pathchoice%\filename.sql

and then you need to create a aspx file to run this bat file:here is the code for backup file

protected void ExecuteBatchFile(string batchFileName, string[] argumentsToBatchFile)
{
string argumentsString = string.Empty;
try
{
//Add up all arguments as string with space separator between the arguments
if (argumentsToBatchFile != null)
{
for (int count = 0; count < argumentsToBatchFile.Length; count++)
{
argumentsString += " ";
argumentsString += argumentsToBatchFile[count];
//argumentsString += "\"";
}
}

//Create process start information
System.Diagnostics.ProcessStartInfo DBProcessStartInfo = new System.Diagnostics.ProcessStartInfo(batchFileName, argumentsString);

//Redirect the output to standard window
DBProcessStartInfo.RedirectStandardOutput = true;

//The output display window need not be falshed onto the front.
DBProcessStartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
DBProcessStartInfo.UseShellExecute = false;

//Create the process and run it
System.Diagnostics.Process dbProcess;
dbProcess = System.Diagnostics.Process.Start(DBProcessStartInfo);

//Catch the output text from the console so that if error happens, the output text can be logged.
System.IO.StreamReader standardOutput = dbProcess.StandardOutput;

/* Wait as long as the DB Backup or Restore or Repair is going on.
Ping once in every 2 seconds to check whether process is completed. */
while (!dbProcess.HasExited)
dbProcess.WaitForExit(2000);

if (dbProcess.HasExited)
{
string consoleOutputText = standardOutput.ReadToEnd();
//TODO - log consoleOutputText to the log file.
}
}
// Catch the SQL exception and throw the customized exception made out of that
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
// ExceptionManager.Publish(ex);
// throw SQLExceptionClassHelper.GetCustomMsSqlException(ex.Number);
}
// Catch all general exceptions

}
protected void Button1_Click(object sender, EventArgs e)
{
string[] names = new string[1];
names[0] = TextBox1.Text;

ExecuteBatchFile("E:\\b.bat", names);
}

Learn ASP.NET at Panchkula

2010-03-01T03:39:00.000-08:00

Computer Education	Website/Software Development Services
Computer Fundamentals	Basic Website
HTML	Content Management System
VbScript/JavaScript	Ecommerce Website
ASP	Any Kind of Website Development
ASP.NET 2.0/3.5	Desktop Application Development
C#	Annual Maintenance Contract for websites
VB.NET	Domain Registration/Website hosting
SQL Server 2005/2008	Hardware & Networking Solutions
Ajax	IT Consulting
ADO.NET	Career Counseling
è Oracle	Corporate/Campus Training
C/C++	Expert Guidance For Projects/Project Reports
Contact us for guidance on any computer related subjects

--Attention, No batch system, Flexible Timings to suit your needs

-- Learn from Industry experts having 5 years of experience in Software development in various IT companies.

-- Interview Preparation for IT companies

--Learn from basics to advance concepts of website development like payment gateway integration, url re-writing, developing ecommerce websites/job websites and lots more.

--Contact us once to find the difference between faculty at computer centers and industry experts.

looking to learn asp.net,c# or vb.net at panchkula/chandigarh/mohali .please feel free to contact us.

If you are looking to learn ASP.NET/C#/SQL SERVER AT mohali Please do contact us.

Cheap Website maintenance

2010-02-24T08:24:00.000-08:00

We provide the following service,we have the cheap and best prices,offers,packages for
Website maintenance services, web site maintenance agreement, web site maintenance, website maintenance india, website contract india, website maintenace information services

cheap website maintenance, website updating, update websites, update content, Content management contracts, web updation india, website updation services, maintenance contracts, web maintenance services, software updation, software maintenance, html updation, javascript, cgi script updations, content maintenance program, application maintenance solution, web page updation and maintenance services, website design maintenance, web maintenance india

Best Website maintenance services check out http://bestwebadvisor.com/

Cheap and Best Website Maintaince:Web Administration

2010-02-17T19:07:00.000-08:00

Looking for maintaining your website,please read http://bestwebadvisor.com/2010/02/website-maintenance/

cheap website administration,best and cheap webmasters,web administration

Best Web Advisor:Best Web Solutions

2009-10-16T22:54:00.000-07:00

Looking for excellent web solutions or you want advice for your online business.We offer the cheapest web solutions,cheapest web developmets,Cheapest HTML websites,Cheapest wordpress websites,asp.net websites,cheap SEO and SMM...

Please visit Best Web Advisor and Web Solution Provider: BestWebAdvisor

Get Ecommerce/Shopping Cart Website in 3 simple steps

2009-09-09T08:52:00.000-07:00

If you are looking to get an ecommerce website or a shopping cart.I can tell you how to get an cheapest ecommerce website or a shopping cart in 3 very simple steps...

1) Check open source ecommerce solutions like oscommerce.com or Prestashop.com or zencart.com .Select which ever you want

2) Search for pre designed templates that are easily available on internet.I can help you with that.

3) Get an expert like me who can setup the shopping cart solution with the design you want.

Cheers
Admin

Seo Tips for Dynamic Content/Website

2009-07-19T00:41:00.000-07:00

Most of the websites have dynamic content(text,links) coming from database.The developers should keep in mind the following few points for making the website search engine friendly:

1) Make sure each page have different title and meta description.You can pick headline/title of the content as Page Title and few words of the content in meta tag or meta description. If each dynamic page has different title and description
it will be more search engine friendly.

2)Make sure the url's do not have query strings.Avoid using query strings.

3)Make sure that every image has an alt tag.

4) Hyperlink should not have any javascript,it should display url when mouse is moved over them

5)Create a sitemap,it should have url for every dynamic page.

6)Links should not be 3-4 levels deep down.

I am sure if the developers use the above SEO tips in their asp.net/php dynamic websites,they will surely rank higher in search engines and make clients happy..

if you have any questions/views feel free to share

Social Media Marketing:Increasing Web Traffic

2009-07-19T00:02:00.000-07:00

Social media marketing is now widely used for increasing web traffic on the websites or blogs.Its basically

1)creating profiles,groups,communities related to your website on social networking websites like orkut, facebook, myspace, hi5 and other similar social networking sites.

2) Searching other forums,blogs related to content on your website and creating your profile/account on them and actively posting new topics/comments on the discussion going on there,you can use digg,yahoo answers etc

3)You can also use social bookmarking to increase traffic on your website.

If you have any questions/views on social media marketing please feel free to post your comments.

So use social media marketing to increase traffic on your website....cheers

Unable to cast object of type 'System.Int32' to type 'System.String' :Error in Facebook Application

2009-06-29T05:38:00.000-07:00

If you are getting "Unable to cast object of type 'System.Int32' to type "'System.String' error while using facebook.net from nikhil (http://www.nikhilk.net/FacebookNET.aspx) ,

to solve this error download source code for this dll and make a change in Framework\Service\Core\FacebookRequest.cs line 180 change

//userID = (string)result["uid"];
to userID = Convert.ToString(result["uid"]);

failed to enable constriants,One or more rows contain values violating non-null, unique

2009-04-19T22:27:00.000-07:00

Error:asp.net/c#/typed data set,strong datasets,xsd files
"failed to enable constriants,One or more rows contain values violating non-null, unique"

If this is the error you get into your dataset/xsd files then there is a problem with the table u r using to fetch records.You might have altered the datatype/length of the column.

the best way to resolve it is to re create the dataset/xsd file or use a simple stored procedure to fetch records...

The SMTP server requires a secure connection or the client was not authenticated. The server response was: denied access

2009-04-08T22:07:00.000-07:00

Error while sending email...asp.net 2.0

"The SMTP server requires a secure connection or the client was not authenticated. The server response was: denied access

you can resolve this error by setting
mailclient.UseDefaultCredentials = true; in the code you are using to send email. use this code

System.Net.Mail.SmtpClient mailclient = new System.Net.Mail.SmtpClient();
System.Net.NetworkCredential auth = new System.Net.NetworkCredential("support@abc.com", "123#");
mailclient.Host = "mail.abc.com";
mailclient.UseDefaultCredentials = true;
mailclient.Credentials = auth;
mailclient.Send(msg);

Stored Procudre to Find next 5 records alphabetically

2008-12-14T22:13:00.000-08:00

Stored procedure to find next 5 records alphabetically.Like next 5 records with alphabets starting from a will be b,c,d,e,f

----------

-------------

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[FindNext5RecordsByCharacter]
(
@CityCharacter char(1)
)
AS
BEGIN
declare @alpha varchar(1)
declare @alpha1 varchar(1)
declare @alpha2 varchar(1)
declare @alpha3 varchar(1)
declare @alpha4 varchar(1)
declare @alpha5 varchar(1)
if (@CityCharacter='y' or @CityCharacter='Y')
begin
set @CityCharacter='a'
set @alpha=@CityCharacter
select @alpha1= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha order by CityName desc
--print @alpha1
select @alpha2= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha1 order by CityName desc
--print @alpha2
select @alpha3= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha2 order by CityName desc
--print @alpha3
select @alpha4= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha3 order by CityName desc
--print @alpha4
end
else if(@CityCharacter<>'z' or @CityCharacter<>'Z' )
begin
set @alpha=@CityCharacter
select @alpha1= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha order by CityName desc
--print @alpha1
select @alpha2= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha1 order by CityName desc
--print @alpha2
select @alpha3= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha2 order by CityName desc
--print @alpha3
select @alpha4= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha3 order by CityName desc
--print @alpha4
end
else
begin
set @CityCharacter='a'
set @alpha=@CityCharacter
select @alpha1= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha order by CityName desc
--print @alpha1
select @alpha2= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha1 order by CityName desc
--print @alpha2
select @alpha3= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha2 order by CityName desc
--print @alpha3
select @alpha4= substring(CityName,1,1) from tbl_city where substring(CityName,1,1) > @alpha3 order by CityName desc
--print @alpha4
end

CREATE TABLE #Temp(
CityId int,
CityName char(30) )

INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha
INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha1
INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha2
INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha3
INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha4
INSERT INTO #Temp (CityId, CityName)
SELECT top 1 CityId, CityName
FROM tbl_city where substring(CityName,1,1) >@alpha5

select * from #temp
drop table #temp
END

Implementing St George Payment Gateway using asp.net or c#

2008-11-13T03:47:00.001-08:00

St.George Internet Payment Gateway
In order to implement internet payment gateway using St George api,using asp.net and c# you require followings things

1) webpay.dll and Org.Mentalis.Security.dll
2) Client Id from the st george bank
3) digital certificate and its pwd from the bank

then in the pay button click paste the following code

Int32 pay1 = Convert.ToInt32(amount.Text);
if (pay1>=pay)
{
//Set the following values appropriately for your Bank/Service Provider
//String responseURL = "http://www.gwipg.stgeorge.com.au/";
String responseURL = "";

//To avoid processing duplicate payments, for this user, check the
//if ( Session.Contents[ "WEBPAYOBJECT" ] == null )
//{
webpay.client.Webpay w = new webpay.client.Webpay("10000xxx", "e:\\net.pfx", "yourpwd");
Session.Contents["WEBPAYOBJECT"] = w;
responseURL = processPayment(w);
String expdate = mm.SelectedValue + "/" + yy.SelectedValue;
obj.Insert(Convert.ToInt32(Session["MId"]), Convert.ToDecimal(amount.Text), ddlpaymentmethod.SelectedValue, cardName.Text, txtCardData.Text, cvc2.Text, expdate.ToString());
//}
Response.Redirect(responseURL);
}
else
{
lblpayment.Text = "Payment Should be greater than " + pay;
}

use the following function

private String processPayment(webpay.client.Webpay w)
{
System.Random randObj = new System.Random(5325);
w.setServers("www.gwipg.stgeorge.com.au");
w.setPort(3006); //use 3005 for testing
w.setValue("CLIENTID", "10000xxx");

w.setValue("INTERFACE", "CREDITCARD");
w.setValue("TRANSACTIONTYPE", "PURCHASE");
//Set the following values based on user input, or calculations from other parts of
//your application.
//Please consult your service provider's documentation for
//required and optional fields.
w.setValue("CARDHOLDER_NAME", cardName.Text);
w.setValue("CARDDATA", txtCardData.Text);
w.setValue("CARDEXPIRYDATE", mm.SelectedValue + yy.SelectedValue);
w.setValue("CVC2", cvc2.Text);

w.setValue("TOTALAMOUNT", amount.Text);
w.setValue("CLIENTREF", "" + randObj.Next());

//Store the Webpay Object in the session. So it can be retrieved easily by other pages (results/errors, etc)
Session.Contents["WEBPAYOBJECT"] = w;

System.Exception ex = null;
for (int i = 0; i < 2; i++)
{
try
{
w.execute();
ex = null;
break;
}
catch (webpay.client.ConnectException cex)
{
//Log the error, and try again.
ex = cex;
continue;
}
catch (System.Exception ioex)
{
//If a TXNREFERENCE is available, check the status of the transaction.
//The number of times to loop, and the sleep time may vary depending on the
//requirements of your application.
ex = ioex;
w.setValue("TRANSACTIONTYPE", "STATUS");
for (int j = 0; j < 2; j++)
{
try
{
//In case we the connection was dropped part way thru,
//give the transacton time to complete at the back end
System.Threading.Thread.Sleep(1500);
}
catch (Exception e)
{
}
try
{
w.execute();
//If the responsecode is still "IP", then wait and check the status again.
if (w.getValue("RESPONSECODE") != "IP")
{
//We have a result, continue
break;
}
}
catch (System.Exception e)
{
ex = e;
}
}
}
}
if (ex != null)
{
//An exception was encounteded which could not be recovered, possibly
//while attempting to retry or check status. Set the redirect to a
//page/process which can handle error conditions.
Session.Contents["ERROR"] = ex;
return "ErrorPage.aspx";
}
//Processing completed normally - redirect and display the results to the user.
//NOTE: Your applicaton will need also need to inspect the RESPONSECODE parameter and
//store the transaction result somewhere. This should be done here, and not in the
//Result display code, as this code will only execute once, while the display code has the potential
//to be re-executed if the user clicks "Refresh" or attempts to re-process the transaction
//using the "Back" button.
return "ResultsPage.aspx";
}

}
// if you face any problem please feel free to ask

HTC TOUCH : Reviews and Price

2008-10-30T19:23:00.000-07:00

HTC touch is a great smart phone.It has latest windows mobile operating system.It has all the applications like word,ppt,excel,you can send emails.it has a 2 mega pixel camera and a very unique touch flow.1 gb memory card which is expandable upto 4 gb.

Lots of great features.a must buy phone if you are looking for a cheap smartphone.In india its costs around rs 15k.

Feel free to post your reviews here....

GoDaddy Reviews:GoDaddy Web Hosting Review

2008-10-23T02:37:00.000-07:00

Webmaters,

if you are looking to get hosting from godaddy.com please think twice before getting a web hosting account from them.Their support is very bad...they always say..this is a coding or 3rd party scripting issue and we can not help.I have atleast 3-4 sites and everyone has some problem.If you are taking windows hosting..pls keep in mind they do not provide remote access to sql server.You have to use their sql server web admin which i feel is not good.so....think twice before going with godaddy.

I will recommend using 3ix...they have very cheap hosting..they have $1 web hosting packages and $3 web hosting packages.They have very good support.I have 2 personal sites with them check below

SRS: Sample SRS Templates

2008-10-21T21:40:00.000-07:00

1.Background

This document describes the requirements necessary for the Software Project.

2.Scope

Explain what the software product will do

3.Software Requirement Specification
3.1. System scope

list all the features for which specifications must be created, designed, coded and tested as part of the project.>

3.2. Definitions, Acronyms, Abbreviations

The following is a list of commonly used definitions used throughout this document

5. UI Prototype (Optional)

Attach screen shots and explain control flow.

6. Assumptions and Dependencies

State any known assumptions and dependencies

7. Non-Functional Requirements

7.1. Environmental Requirements

Hardware and Software requirements

7.2. System Performance Requirements

7.3. Security

7.4. Design and Implementation Constraints

7.5. Standards

8. Evisioned Future Enhancements / Open Issues

9. References

10. Annexures

$1 Hosting:Cheapest Web Hosting

2008-10-21T19:22:00.000-07:00

Guys,

Looking to host your site...find the cheapest web hosting package here...

$1 Web Hosting.You will find cheapest and best web hosting package here.

How to change owner of object/Stored Procedure

2008-10-17T04:17:00.000-07:00

to change owner of object/Stored Procedure

exec sp_changeobjectowner 'objectname','username'

for example

exec sp_changeobjectowner 'proc_getallrecords','dbo'

Grant Execute Permission to User in Database:Sql Servers

2008-10-17T04:15:00.000-07:00

---Stored Procedure to grant execute permission to user on all stored procedures

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGrantExectoAllStoredProcs] @user sysname

AS
/

SET NOCOUNT ON

DECLARE @CMD1 varchar(8000)

DECLARE @MAXOID int

DECLARE @OwnerName varchar(128)

DECLARE @ObjectName varchar(128)

CREATE TABLE #StoredProcedures

(OID int IDENTITY (1,1),

StoredProcOwner varchar(128) NOT NULL,

StoredProcName varchar(128) NOT NULL)

INSERT INTO #StoredProcedures (StoredProcOwner, StoredProcName)

SELECT u.[Name], o.[Name]

FROM dbo.sysobjects o

INNER JOIN dbo.sysusers u

ON o.uid = u.uid

WHERE o.Type = 'P'

AND o.[Name] NOT LIKE 'dt_%'

SELECT @MAXOID = MAX(OID) FROM #StoredProcedures

WHILE @MAXOID > 0

BEGIN

SELECT @OwnerName = StoredProcOwner,

@ObjectName = StoredProcName

FROM #StoredProcedures

WHERE OID = @MAXOID

SELECT @CMD1 = 'GRANT EXEC ON ' + '[' + @OwnerName + ']' + '.' + '[' + @ObjectName + ']' + ' TO ' + @user

EXEC(@CMD1)

SET @MAXOID = @MAXOID - 1

END

DROP TABLE #StoredProcedures

SET NOCOUNT OFF

code for 301 redirect pages with querystring using asp.net/c#

2008-10-13T05:09:00.000-07:00

if you have a page with query string and you want to redirect it using asp.net please check the code below..

string c_absUri = Request.Url.DnsSafeHost;
string c_absPath = Request.Url.AbsolutePath;
//c_absPath = "/test.aspx";

string c_queryString = Request.QueryString.ToString().Length > 0 ? Request.QueryString.ToString() : String.Empty;

if (c_queryString.Contains("sname=")) //where sname is querystring
{

Int32 Countqry = 0;
Int32 qrylength = 0;
qrylength = c_queryString.Length;

Countqry = c_queryString.LastIndexOf("=");
Int32 rem = qrylength - Countqry;

string sname = c_queryString.Substring(Countqry + 1, rem - 1);

sname = sname.Replace("*", "&");
sname = sname.Replace("+", " ");

string newUrl = "http://www.abc.com" + c_absPath;

HttpContext context = HttpContext.Current;
context.Response.Status = "301 Moved Permanently";
context.Response.StatusCode = 301;
context.Response.AddHeader("Location", newUrl);

Response.Redirect(newUrl);
}

Code for 301 Redirect using c#/ASP.NET

2008-10-13T05:05:00.000-07:00

if you want to do a 301 permanent redirect using asp.net and c# copy and paste the code in ur global.asax file.

protected void Application_BeginRequest(object sender, EventArgs e)
{
string newpath = "";
string newpath1 = "";

string sOldPath = HttpContext.Current.Request.Url.ToString();
sOldPath =sOldPath.Substring(sOldPath.LastIndexOf("/")+1);
//
if(sOldPath=="Online.aspx")
{
newpath = "http://www.the.com/online-degree.aspx";
HttpApplication app = sender as HttpApplication;

app.Context.Response.RedirectLocation = newpath.ToString();
app.Context.Response.StatusCode = 301;
app.Context.Response.End();

}}

if you have any questions on doing a 301 redirect please let me know.

using sqlparameter and dataset in C#

2008-09-29T22:21:00.000-07:00

// using sqlparameter in C#,Dataset with sqlparameters in c#

SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@TypeID", SqlDbType.Int);
param[0].Value = ddlArticleType.SelectedValue;

DataSet ds = new DataSet();
ds = Obj.GetDataSet(strconnect, "Proc_GetActiveTypeID", param);
DdlCategory.DataSource = ds;
DdlCategory.DataTextField = "Categoryname";
DdlCategory.DataValueField = "CategoryId";
DdlCategory.DataBind();
DdlCategory.Items.Insert(0, "Select Category");

'Please rate this if you like it

Using Sql Parameters :ASP.NET & C#

2008-09-29T22:18:00.000-07:00

//How to use sql parameters to fetch records using dataset (C#).
//Sql Parameters with Dataset

public DataSet GetDataSet(string strConnect, string ProcName,Array parameters)
{
//**************************************
//* Purpose: Getting DataSet for the given Procedure if we have to pass parameters
//* Input parameters:
//*strConnect----Connection string
//*ProcName ---StoredProcedures name
//* Returns :
//*Dataset contains data
//* ************************************
string strCommandText = ProcName;
DataSet ds = new DataSet();

SqlConnection objConnect = new SqlConnection(strConnect);

SqlCommand objCommand = new SqlCommand(strCommandText, objConnect);
objCommand.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter param in parameters)
{
objCommand.Parameters.Add(param);
}

objConnect.Open();
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
objDataAdapter.SelectCommand = objCommand;
objDataAdapter.Fill(ds);
objConnect.Close();
return ds;

}

'Please rate this if you like it

How to fetch records from database and write a text file using vbscript

2008-09-29T21:49:00.000-07:00

'How to fetch records from database and write a text file using vbscript.
'If you want to get records from database and write to a text file please use the 'following code
'VBSCRIPT CODE TO WRITE A TEXT FILE,Windows Scipt file to backup database. vbs file
Option Explicit

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' Configure this script then run from CMD using cscript
'
' Use the constants below to configure the script
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

' Database server name
Const server = ""

' Use trusted (windows authenitcation) or standard (SQL Server authentication)

Const trusted = FALSE

' Database user name - not needed for trusted connection

Const userId = ""

' Database password - not needed for trusted connection

Const password = ""

' Database

Const dataBase = ""

Const useUnicode = TRUE
' Set the name of the created file
Const fileName = "records.txt"

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' DO NOT EDIT BELOW THIS LINE UNLESS YOU WANT TO ENCHANCE/CHANGE
' THE FUNCTIONALLITY OF THE SCRIPT
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

' Variables used in the script
Dim db,i,connectString,fields,rs

' Userful ADODB constants
Const adOpenStatic = 3
Const adLockReadOnly = 1
Const adCmdText = 1
Const adUseClient = 3
Const adLockBatchOptimistic = 4

If trusted Then
connectString="Provider=SQLNCLI;Server=" & server & ";Database=" & dataBase & ";Trusted_Connection=yes;"
Else
connectString="Provider=SQLNCLI;Server=" & server & ";Database=" & dataBase & ";Uid=" & userId & ";Pwd=" & password & ";"
End If

Set db = CreateObject("ADODB.Connection")
db.Open connectString
db.Execute "USE " + dataBase

DumpDBDataToFile db,fileName,dataBase,useUnicode
WScript.Echo "All done"
WScript.Quit

Public Sub DumpDBDataToFile(ado, fileName, dataBase,useUnicode)
Dim trc
trc=0
Dim fs
' Open the output file and select the chosen format
Set fs = CreateObject("Scripting.FileSystemObject")
Dim ts
If useUnicode Then
Set ts = fs.OpenTextFile(fileName, 2, True,-1)
Else
Set ts = fs.OpenTextFile(fileName, 2, True)
End If

Dim t,tt
Dim rec
Dim c
Dim trigs

ado.Execute "BEGIN TRANSACTION"
'write sql quey\ry here
Set rec = GetDisconRS(ado,"SELECT * from tablename" )
Dim sql
Dim sql1
Dim first
first = True
If Not rec.EOF Then
rec.MoveFirst
While Not rec.EOF
Dim i
If first Then

sql1 = sql1
first = False

End If
sql = sql1
Dim vt
Dim f,col

For i = 0 To rec.fields.count - 1
f = rec.fields(i).value
col = rec.fields(i).name

''''''''''''''check for padding'''''''''''''
if col="ColumnNAme" then
' MsgBox(f)
f=Rpad(f," ",3)
' MsgBox(Rpad("1"," ",3))
end if

'''''end padding''''''''''

vt = varType(f)
If vt = 1 Then
f = "Null"
ElseIf vt = 2 Or vt = 3 Or vt = 4 Or vt = 5 Or vt = 6 Or vt = 14 Then
f = DBEscapeNumber(CStr(f))
ElseIf vt = 11 Then
If vt Then
f = "1"
Else
f = "0"
End If
ElseIf vt = 8 Then
f = DBEscapeString(CStr(f))
ElseIf vt = 7 Then
f = DBEscapeDate(CStr(f))
ElseIf vt = 17 Then
f = "0x" + Right( "0" & Hex(f),2)
ElseIf vt = 8209 Then
f = "0x" + BinToHex(f)
Else
WScript.Echo "Could not reformat", "Table=" & t & " Col=" & rec.fields(i).name & " vt=" & vt
WScript.Quit
End If
If i > 0 Then sql = sql + ","
sql = sql + f
Next
sql = sql
ts.WriteLine sql

trc=trc+1

rec.MoveNext
Wend

End If
rec.Close

ts.Close
End Sub

'''function for padding
Function Rpad (MyValue, MyPadChar, MyPaddedLength)
'MsgBox(string(MyPaddedLength - Len(MyValue), MyPadChar))
Rpad = MyValue & string(MyPaddedLength - Len(MyValue), MyPadChar)
End Function

Function GetDisconRS(ado,sql)
Dim recset
Set recset = CreateObject("ADODB.Recordset")
recset.CursorLocation = adUseClient
recset.CursorType = adOpenStatic
recset.LockType = adLockBatchOptimistic

recset.Open sql, ado, , , adCmdText
Set recset.ActiveConnection = Nothing
Set GetDisconRS = recset
End Function

Function DateLong(myDate)
Dim months
months=Split("january,february,march,april,may,june,july,august,september,october,november,december",",")
DateLong= _
DatePart("D",mydate) & " " & _
months( DatePart("M",myDate)-1) & " " & _
DatePart("YYYY",mydate)
End Function

''
Function DBEscapeDate(myDate)

DBEscapeDate=DBEscapeString(DateLong(myDate))
End Function

Function DBEscapeString(myString)
DBEscapeString="'" & Replace(myString,"'","''") & "'"
End Function

Function DBEscapeNumber(myNumber)
If NOT IsNumeric(myNumber) Then myNumber=0
myNumber=myNumber*1.0
DBEscapeNumber=Replace(myNumber & "","'","''")
End Function

Function BinToHex(data)
Dim ret
Dim l
Dim i
Dim lb
Dim h
Dim d
Dim o
lb = LBound(data) - 1
l = UBound(data) - LBound(data) + 1
ret = String(l * 2, "0")
Redim o(l-1)

For i = 1 To l
d = 255 and ascb(midb(data,i,1))
If d > 15 Then
o(i-1) = Hex(d)
Else
o(i-1) = "0" + Hex(d)
End If
Next
BinToHex = Join(o,"")
End Function

'Please rate this if you like it

The server response was: sorry, your mail was administratively denied.

2008-09-28T21:51:00.000-07:00

If you get this error. here is what you need to do.While sending mail,in the from field use the email address with your domainname say admin@domainname.com.

This problem comes in godaddy shared hosting if you use anyother email address in the from field,user something@domainname.com

if you have any questions please feel to post..

cheers
admin

The message could not be sent to the SMTP server. The transport error code was 0x800ccc6a

2008-09-28T21:08:00.001-07:00

Guys,

Getting this error:

"The message could not be sent to the SMTP server. The transport error code was 0x800ccc6a. The server response was 451 See http://pobox.com/~djb/docs/smtplf.html."

This problem is because of Bare LF ie new line feed.

This error comes when you have a multline textbox and while tying in it you press enter.When you press enter it is repalced by "\r\n" in IE and "\n" in mozilla.

just add the following line of code.Lets say you have a string called msg

msg = msg.Replace("\r\n", "
"); //This is to solve this error in IE
msg = msg.Replace("\n", "
"); //This is to solve this error in //Firefox,mozilla

msg = msg.Replace(Environment.NewLine, "
");

If you still have any problems please feel free to post here.

Cheers
admin

More From Us

2008-09-27T03:10:00.000-07:00

Please visit our main site and Blogs

1) Find Things For You
2) Blogs

Merging Word Docs using ASP.NET,C#

2008-05-12T01:46:00.000-07:00

Guys if you wana merge word documents thn you can get the code from here

http://www.codeproject.com/KB/office/mswmergecs.aspx

and you will need to download few dll's that you can get from here

http://www.microsoft.com/downloads/details.aspx?familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en

if you need the working code let me know

cheers
Ric

USING GDI TO DYNAMICALLY ADD IMAGE OR TEXT ON IMAGE ASP.NET

2008-05-02T06:51:00.000-07:00

Using GDI to dynamically add image or text on another image in asp.net/vb.net

Public Function writeimage()

' 'USING GDI TO DYNAMICALLY ADD TEXT AND IMAGES ON IMAGE
' INCULDE THE FOLLOWING :
' Imports System.Drawing
'Imports System.Drawing.Image
'Imports System.Drawing.Drawing2D
'Imports System.Drawing.Imaging

Dim myBitmap As New Bitmap(Server.MapPath(ViewState("Imagepath").ToString))
Dim myGraphic As Graphics = Graphics.FromImage(myBitmap)

'set the smoothing mode
myGraphic.SmoothingMode = SmoothingMode.AntiAlias

'draw the oval
'myGraphic.DrawArc(New Pen(Color.White, 2), 280, 0, 120, 50, 0, 360)

'draw the text
'Session("Text") = AddText.Text

Dim ds As New DataSet
ds = getdata()
Dim i, j As Integer
j = ds.Tables(0).Rows.Count

Dim drow As DataRow
If ds.Tables(0).Rows.Count > 0 Then
For Each drow In ds.Tables(0).Rows
Dim textcheck As String = drow("Text").ToString
Dim imagecheck = drow("imagename").ToString

If textcheck <> "NA" Then
'adding text to the image
myGraphic.DrawString(drow("Text"), New Font("Helvetica", 20, FontStyle.Bold), SystemBrushes.WindowText, New PointF(drow("PosX"), drow("PosY")))

ElseIf imagecheck <> "NA" Then
'adding image to the image
Session("imagepath1") = "Uploadedimages/" & LTrim(drow("imagename"))
Dim myimage1 As New Bitmap(Server.MapPath(Session("Imagepath1").ToString))
Dim myThumbNail As New Bitmap(myimage1, 60, 60) 'this will craete a thumbnail of the image
myGraphic.DrawImage(myThumbNail, New PointF(drow("PosX"), drow("PosY")))
' myGraphic.DrawImage(
End If
Next

End If

'note: enable these 3 lines and disable the previous if you want to see vertical text in action
'Dim stringFormat As New StringFormat()
'stringFormat.FormatFlags = StringFormatFlags.DirectionVertical
'myGraphic.DrawString("Alima!", New Font("Helvetica", 30, FontStyle.Bold), SystemBrushes.WindowText, New PointF(290, 10), stringFormat)

'set the content type
'======Getting Error=========================
'Response.ContentType = "image/jpg"
'============================

'save to the outputstream
Dim myBitmap1 As New Bitmap(myBitmap)

myBitmap1.Save(Server.MapPath("DemoImages/" & Session.SessionID & ".jpg"))
myGraphic.Dispose()
myBitmap.Dispose()
Dim testpath As String = "Demoimages/" & Session.SessionID & ".jpg"
Session("testpath") = testpath
prodimg.ImageUrl = testpath
BindGrid()
AddText.Visible = True

GridView1.Visible = True
Panel1.Visible = False

End Function

USING LINQ TO SQL CLASSES ASP.NET 2008

2008-05-01T21:20:00.000-07:00

'USING linq TO SQL TO iNSERT AND bIND GRID ASP.NET 2008

' Ist of all add Linq to sql classes by right click on project and add new item
' Then from server explorer Drag and drop the Database you want to use on the dbml

file u ' added

'then create and object of tht class and use the code below to add and bind gridview

check code below:

Dim db As New DataClassesDataContext '

Dim insemp As New emp
insemp.EName = TextBox1.Text
insemp.Salary = Convert.ToInt32(TextBox2.Text)
db.emps.InsertOnSubmit(insemp)
db.SubmitChanges()

Dim q = From c In db.emps Select c.EName, c.Salary Where Salary >= 1000

GridView2.DataSource = q
GridView2.DataBind()

Print Gridview Data using Javascript

2008-04-30T07:25:00.000-07:00

copy and paste this function into your aspx file and use an anchor tag to call this function.
function Print()
{ var printgrid = document.getElementById('');
printgrid .border = 0; //set no border here var strOldOne=prtContent.innerHTML; var Printpop = window.open('','','letf=100,top=100,width=1000,height=1000,toolbar=0,scrollbars=1,status=0,resizable=1'); Printpop .document.write(printgrid .outerHTML); Printpop .document.close(); Printpop .focus(); Printpop .print(); Printpop .close();}

Welcome Friends

2008-04-30T07:18:00.000-07:00

Hi Friends,
This Blog is all about helping ASP.NET/C#/VB.NET developers.You guys can post your problems that you face in coding.I will try to help on those.I will also post some nice examples which will include using GDI,Ajax,Linq and other coding related issues.
Please feel free to use this blog for posting your queries and comments

Cheers
Ric