Sunday, November 20, 2011

bresenham line drawing algorithm implementation in C#

This code snippet is based on the most popular line rendering algorithm displayed at Wikipedia, and exposes an IEnumerable that can be used for graphics or collision detection routines.


Monday, June 27, 2011

Unrecognized attribute 'targetFramework'

for .net 3.5

the setting of web.config




else follow below link

for changing setting of your application property

http://msdn.microsoft.com/en-us/library/bb398791.aspx

Saturday, June 25, 2011

Sql server connection with Foxpro 9.0

LOCAL hConn
STORE SPACE(40) TO strname
STORE SPACE(1000) TO strstring
hConn = SQLStringConnect("Dsn=Sql Server;trusted_connection=Yes;wsid=MachineName-PC;database=Hackensack")
hConn = SQLConnect("Sql Server", "falseuser", "")
IF (hConn < 0)
LOCAL ARRAY laError[1]
AERROR(laError)
MESSAGEBOX( ;
laError[2], ;
"Error " + TRANSFORM(laError[5]))
*laError[5] --show the what error happen
ELSE
CLEAR

@10,10 say "Enter the Name :" Get strname
read
*--sql insert string
strstring = "insert into Table1 (Name) values ('"+RTRIM(strname) +"')"

@ 17, 2 SAY [String : ] + TRIM(strstring)
SQLEXEC(hConn ,strstring )
MESSAGEBOX("Add Successfully")

SQLEXEC(hConn , 'SELECT * FROM Table1', 'Table1')
BROWSE
SQLDISCONNECT(hConn )


ENDIF

Tuesday, May 17, 2011

Write Datatable to XML

SP ::
ALTER PROCEDURE dbo.WriteToXml
@var varchar(max),-- Root of elements
@tbl varchar(100) -- tablename
--@ResultVar XML output
AS
SET NOCOUNT ON
declare @ss as nvarchar(max)
declare @root as nvarchar(max)
declare @FName xml
declare @ResultVar as XmL
SET NOCOUNT ON
set @root = ''''+ 'MainRootName'+''''
set @ss = 'select * from '+ @tbl +' where IsActive = 1 FOR XML PATH(';
set @ss += @var;
set @ss+='),ROOT(';
set @ss+= @root;
set @ss += ')'
print(@ss)
print(convert(nvarchar(max),@ResultVar))
exec( @ss)
select @ResultVar as Result
return

---------------------------------------------------------
Coding in .cs Page::
protected void CreateXML()
{
XmlDocument xml = new XmlDocument();

DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(SqlConnection);
SqlCommand cmd = new SqlCommand("WriteToXml", con);
cmd.CommandType = CommandType.StoredProcedure;
string var = "'" + DDXMLList.SelectedItem.Text + "'";
cmd.Parameters.AddWithValue("@var", var);
cmd.Parameters.AddWithValue("@tbl", DDXMLList.SelectedItem.Value);

try
{
con.Open();
string val = cmd.ExecuteScalar().ToString();
con.Close();
xml.LoadXml(val);
XmlNode node;
node = xml.DocumentElement;
foreach (XmlNode node1 in node.ChildNodes)
{
foreach (XmlNode node2 in node1.ChildNodes)
{
string val1 = node2.InnerText;
node2.InnerText = val1;
}
}
string path = Path + DDXMLList.SelectedItem.Text + ".xml";
if (Directory.Exists(Server.MapPath(Path)) == false)
{
lblmsg.Text = "Directory Not avaliable ";
Directory.CreateDirectory(Server.MapPath(Path));
}
if (File.Exists(Server.MapPath(path)) == false)
{
FileStream fs = null;
fs = File.Create(Server.MapPath(path));
fs.Close();
}
xml.Save(Server.MapPath(path));
lblmsg.Text = "XML File Generated";
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
con.Close();
}
}

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

If any Query Please Inform me