Software engineering Problems and Source codes

Facebook programming with ASP3

2008-08-18T11:58:00.002+03:00

Programming an application for facebook usualy done with php, java and .net!

what about asp programmers?

As i started to develop and asp application and downloaded a class that implement the api of facebook, i decided to share it here and start a project to improve this class (this is not full class and not all funciton worked).

please help me and all asp programmers to build this class so we all can use it.

the class will be published here: http://www.byramix.com/blogForum/topic.asp?TOPIC_ID=35

thanks

NearConn published the beta version

2008-03-30T09:48:00.005+03:00

Lately, the NearConn team announced that they opened their system for a beta users.
NearConn is a unique cellular social network, it's a social network that enable the user to contact people around in any given time and place.
The main idea of the NearConn creators is to make the bluetooth name that on the cellular phone, a link to details that it's owner want to show the other,
think about it, you can share your profile or you can share your buisness details, advertise a service you offer.
it can be a new way to advertise things in a simple and cheap way...
I beileve that the idea of NearConn is exelent, usefull for milions of users and will be the next thing.
here you can watch a video of how it works : http://www.nearconn.com/demo.asp

you can sign up to nearconn here: http://www.nearconn.com/

Programming Discussion Forums

2008-03-20T16:03:00.005+02:00

I'm happy to announce that i opened the Blog Discussion forum.
i will add there a discussion post for all the materials on my blog.
Please feel free to help me build a rich forum.
if you think that you have an interesting material, source code, tips or tricks please share it with the other programmers.
Add your post at the related category.
thanks alot for your help and support.
the forum address is: http://www.byramix.com/blogforum

script.aculo.us drag and sort scrolling bug

2008-03-01T01:42:00.003+02:00

For those who uses the script.aculo.us drag and drop js libs, this is an explain for fixing a scrolling bug.
if your dragable element has a scrolling bar, when you try to scroll it also start dragging the element.
i fixed this bug, do the following steps and it will work perfectly:
open the file "dragdrop.js" for edit, after the following code:
if((tag_name = src.tagName.toUpperCase()) &&
( tag_name=='INPUT'
tag_name=='SELECT'
tag_name=='OPTION'
tag_name=='BUTTON'
tag_name=='TEXTAREA')) return;

add the following line:
if( src.undragable!=null) return;

this line means that if there's a tag in the element that called "undragable" so it wont move the element.

when you want to set an element with a scrollbar, just add the "undragable" tag to it and it will fix the problem, for example:

< d iv height="50%" width="100%"undragable style="height: 200px; overflow:auto;scrollbar-arrow-color: #808080; scrollbar-track-color: #FFFFFF; scrollbar-face-color: #FFFFFF; scrollbar-highlight-color: #808080; scrollbar-3dlight-color: #FFFFFF; scrollbar-darkshadow-color: #FFFFFF;scrollbar-shadow-color: #808080;"

Url Encode function. Encode a string according to W3C standards

2008-02-10T11:30:00.000+02:00

this is a function that turns all the chars in a string to the W3C Standards.

/**
  * Encode a string according to W3C standards.
  *
  */
 public static String urlEncoder(String s) {
  if (s == null)
   return s;
  StringBuffer sb = new StringBuffer(s.length() * 3);
  try {
   char c;
   for (int i = 0; i < s.length(); i++) {
    c = s.charAt(i);
    if (c == '&') {
     sb.append("&amp;");
    } else if (c == ' ') {
     sb.append('+');
    } else if (
     (c >= ',' && c <= ';')
       (c >= 'A' && c <= 'Z')
       (c >= 'a' && c <= 'z')
       c == '_'
       c == '?') {
     sb.append(c);
    } else {
     sb.append('%');
     if (c > 15) { // is it a non-control char, ie. >x0F so 2 chars
      sb.append(Integer.toHexString((int)c)); // just add % and the string
     } else {
      sb.append("0" + Integer.toHexString((int)c));
      // otherwise need to add a leading 0
     }
    }
   }

  } catch (Exception ex) {
   return (null);
  }
  return (sb.toString());
 }

source of this function : http://forum.java.sun.com/thread.jspa?threadID=594204&messageID=3596899

Replace relative links to absolute base links in HTML - Java

2008-01-28T16:12:00.003+02:00

this is a function that can add a base url to all urls in an html page, this code was translated from this vb function displayed here :http://www.motobit.com/tips/detpg_replace-relative-links/

special thanks to the original coder...

the function (java) was tested and run successfully!

public static String ReplaceLinksToBase(String HTML, String baseURL)
// replaces all links in an html to base url
// By Ramik, 28/1/2008
{
HTML = ReplaceTagToBase(HTML, "a", "href", baseURL);
// replace <img src=...> links
HTML = ReplaceTagToBase(HTML, "img", "src", baseURL);
HTML = ReplaceTagToBase(HTML, "link", "href", baseURL);
return HTML;
}

public static String ReplaceTagToBase (String HTML, String TagName, String ValueName, String BaseURL)
// replace a specific tag url to base Url
//By Ramik, 28/01/2008
{
int pos1, pos2;
String p1, p2, html;
html= HTML;
//Find the tag In HTML.
String temp = "<"+TagName ;
pos1 = HTML.indexOf(temp);
while (pos1>0)
{
//The tag was found. Find closing > of the tag.
pos2 = HTML.indexOf(">",pos1+TagName.length());
if (pos2>-1)
{
//separate tag text from HTML
String tag, tag1;
tag = HTML.substring(pos1, pos2);
//rewrite realative URL links In the one tag.
tag1 = ReplaceParamToBase(tag, ValueName, BaseURL);
//The tag was changed - relative links found.
if (!tag1.equals(tag)) //there is some change In the tag.
{
//get parts before And after the tag
p1 = HTML.substring(0,pos1);
p2 = HTML.substring(pos2,HTML.length());
//Compute new POs2 position
pos2 = pos2 + tag1.length() - tag.length() ;
//replace old tag with relative links with the new version
html = p1 + tag1 + p2 ;
}
}
if (pos2>0)
pos1 = HTML.indexOf("<"+TagName,pos2+1);
else
pos1 = 0 ;
}
return html;
}

public static String ReplaceParamToBase( String Tag, String ValueName,String BaseURL)
{
String p1, p2 , c1, URL, tag=Tag;
int pos1, pos2, lenVal ;
lenVal = ValueName.length() ;
//find position of the tag value
pos1 = Tag.indexOf(ValueName+"=");
if (pos1>-1)
{
//get a first char after =
c1 = Tag.substring(pos1+lenVal+1,pos1+lenVal+2);
if (c1.equals("\""))
{
pos1 = pos1+lenVal+1 ;
pos2 = Tag.indexOf("\"",pos1+1);
}
else if (c1.equals("'"))
{
pos1 = pos1+lenVal+1;
pos2 = Tag.indexOf("'",pos1+1);
}
else//the value ends with Space
{
pos1 = pos1+lenVal;
pos2 = Tag.indexOf(" ",pos1);
if (pos2==-1)
pos2 = Tag.length();
}
p1 = Tag.substring(0,pos1+1);
p2 = Tag.substring(pos2,Tag.length());
URL = Tag.substring(pos1+1,pos2);
//is the value relative URL?
if (URL.indexOf("://")==-1 && URL.indexOf("mailto:")==-1)
{
//make the new absolute URL
if (BaseURL.charAt(BaseURL.length()-1)!='/' && BaseURL.charAt(BaseURL.length()-1)!='\\' )
{
BaseURL=BaseURL+'/';
}
URL = BaseURL+URL ;
tag = p1+URL+p2;
}

}
return tag;
}

public static String replaceAllTags (String HTML, String TagName, String ValueName, String BaseURL)
//Replace all tags in html to base url
// by ramik 30/1/2008
{
String html = HTML , allHtml="";
int pos1=0, pos2 = HTML.indexOf(">");
if (pos2>-1)
pos2++;
while (pos2>-1)
{
html = HTML.substring(pos1,pos2);
allHtml = allHtml + ReplaceTagToBase(html,TagName, ValueName, BaseURL);
pos1=pos2;
pos2=HTML.indexOf(">",pos2);
if (pos2>-1)
pos2++;
}
allHtml = allHtml + HTML.substring(pos1);
return allHtml;
}

Discuss this Post

windows vista: access: local only

2007-09-15T13:25:00.000+03:00

Ok, this is my first post of non programming issue but it still usefull for computers users.
Last week i got a new HP Laptop, with windows vista insite, it's cool looking, i was so happy with it untill i had the first problem, i couldn't surf the net.
well, i will not talk alot, because i guess some of you is reading here after a few days of searching.
well, what i had is like that:
i could connect to the network and see other computers but could not surf the net
that what you should do:
go to the network connection icon on the tray - > right click ->network and Sharing Center -> on the left press of the Manage network connection - > right click on the network that you want to log in to -> properties -> now you have some check boxes :
uncheck the Internet Protocol Version 6
stand on the Internet Protocol Version 4 and press properties :
check the Use the following IP Address :
and on the fields fill the following:
IP Address : [put an IP the is fine with your router]
Subnet mask : 255.255.255.0
Default gateway: the ip of your router

then check : use the following DNS server addresses
Prefered DNS server: the ip of your router.

press OK -> OK and restart your computer.

for me it worked..
thanks to the guys here: http://www.daniweb.com/forums/thread73818.html

sql query for getting your users email servers

2007-07-04T09:16:00.001+03:00

this is a query that get you a list of the servers of the users emails that they registered with, for example if you have 100 people that has a hotmail account and 200 users with gmail you will get this table:
count server
-----------------
100 hotmail
200 gmail
...

here is the query:

select * from
(SELECT Count(users.UserID) AS Count, right(users.Useremail,len(users.Useremail)-instr(users.Useremail,'@')) as server
FROM users
where users.useremail <> ''
GROUP BY right(users.Useremail,len(users.Useremail)-instr(users.Useremail,'@')))
order by count

Selection.Find crash

2007-07-02T13:55:00.001+03:00

you wrote an application that works with Word object?
the application crashes in the middle of the run, after the debug you find that it crashes on this line:
WordObj.Selection.Find

well, it's not your fault, it's a microsoft bug. now, how you resolve it??
it's a tricky way,
what you should do is late binding
u should dim your word object as an General object and create it manualy, not by "new word"
here is a usefull code:
...


Dim wrdDoc As Object  ' setting the word object as a general object
Dim IsWordRunning As Boolean

IsWordRunning = ApplicationIsRunning("Word.Application")
If IsWordRunning = True Then ' do
   Set wrdApp = GetObject(, "Word.Application")
Else
   Set wrdApp = CreateObject("Word.Application")
End If
wrdApp.Visible = True
Set wrdDoc = wrdApp.Documents.Open(filename)

...

and here is the applicationisrunning function:

Function ApplicationIsRunning(ApplicationClassName As String) As Boolean
' returns True if the application is running
' example: If Not ApplicationIsRunning("Outlook.Application") Then Exit Sub
Dim AnyApp As Object
 On Error Resume Next
 Set AnyApp = GetObject(, ApplicationClassName)
 ApplicationIsRunning = Not AnyApp Is Nothing
 Set AnyApp = Nothing
 On Error GoTo 0
End Function

adding adsense to phpbb 3 forum

2007-06-28T08:31:00.000+03:00

do you want to add adsense advertising to your forum.
i could add adsense to the top of my forum by adding the code in the overall_header.htm file, i added it at the end of the file.
the important thing is that when i added it to the file manulay and then uploaded the file it didn't work, i succeded only when i changed the file through the admin system.
same i did with the google analytics code, i added it to the same file, but after the header tag.
if someone could do that after the first post only please write it here.

Beta Version for arabic language Google Adsense

2007-06-25T08:58:00.000+03:00

Lately the google adsense for content started to support arabic language websites, the www.arabsites.co.il website administrator said that his site is utf-8 incoded and two weeks ago he started to show ads in his site, more he said, the pay per click still low, it's about 1-2 centes per click, but i guess when the time pass, more advertisers will know about the service and they will pay beter for a click.
the first report was on the arabic seo forum www.seoarabia.com

register a domain name - how to do it

2007-06-24T15:02:00.000+03:00

if you want to build a website you need few thing for starting it successfully.
first, you should know if you site will be visited by a lot of visitors or few, that is a very important thing, because if you expect a high number of visitors, you should get a dedicated server , a standart hosting plan cant hold alot of traffic.
for good hosting plans i suggest to see what brinkster company offer, i work with them and i like it there.
they suggest you a free domain for each hosting plan, but i don't like that, i prefer to buy the domain name by my self, it's cheap (8.99$) and easy, i do that with godaddy, they have a great control panel that make it easy to manage my domains, and i have alot of them.
i already had on accident with a company that gave me a free domain, and after it expired the didn't renew that and i lost it with all my visitors. so watch out with that!
register a domain name:
so how to register a domain name? it's easy step but so important, i suggest you to register your domain in the main extensions like .com, .net , .info (it's cheap 1$ only) and .mobi (if you see that there is a use to your site with mobile)

how to choose your hosting plan
basicly you can choose a professional hosting plan, but if you think that a lot of users will be visiting you site you should change your choice, i got a basic host plan and i'm hosting many websites on it, i get 5000 visitors each day, i think it's the limit of this plan, so i think if you think you'll have more than this number of visitors daily, you should take a dedicated server.
if your websitet build with php/asp/.net/jsp
you should pay attention for that also, if you take a windows server so you should use asp/.net or you should check if the server support php, brinkster server support aslo php on their windows servers.

Unrecognized attribute 'xmlns'.

2007-05-03T14:10:00.000+03:00

this error actually means that the site is running old Framework version,
what you need to do is the following:
1.Open Internet Information Services and navigate to "Default Web Site" (or the site you're using as your default).
2.Right click the Site icon (the one with the globe).
3.Select the ASP.NET tab. You'll see a drop-down with the available versions (if you're getting the error, odds are, you'll see 1.1).
4.Select the proper build of ASP.NET 2.0 (or later, depends on the version you worked on in the developing stage).
5.Restart IIS.

Change master web server in interdev Project

2007-01-28T09:46:00.000+02:00

if you want to start using another web server for your asp projects which you created in interdev 6.0 then you need to change the master web that you set when you created the project.
to do that you should do those steps:
1. release your working copy:
right click on your project-> release working copy
2. on the upper toolbar (File Edit View...) choose Project -> Web Project -> Copy Web Application ... -> set the new server name and the directory you want to creat the project in, un check the Add to existing Web Project and the press OK.
3. now create a new project, in the 2nd stem, choose to use an existeing remote directory!

have a nice programming!

How to recognize google visit

2007-01-16T10:02:00.000+02:00

do you want to know if this visit is a google visit??
here is a simple asp code to do that:
< % robot=request.ServerVariables("HTTP_USER_AGENT") if (Instr(robot,"Googlebot")<>0) then
...
end if
% >

and this is how to do it with php script

< ? define("SYSTEM_FROM_NAME","Your name"); define("SYSTEM_FROM_EMAIL","Your email"); //---this script will send email to webmaster when google visit your pages. if(isset($_SERVER['HTTP_USER_AGENT']) && eregi("googlebot",$_SERVER['HTTP_USER_AGENT'])) { if ($QUERY_STRING != "") { $url = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'].'?'.$QUERY_STRING; } else { $url = "http://".$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF']; } $today = date("F j, Y, g:i a"); $headers = "From: ".SYSTEM_FROM_NAME." <".SYSTEM_FROM_EMAIL.">";
$message="";
$message.="Googlebot is crawling your site:\n";
$message.="Page: $url\n";
$message.="Date: $today \n";
$message.="IP: ".$_SERVER['REMOTE_ADDR']." \n";
mail(SYSTEM_FROM_EMAIL, "googlebot crawle - $url", "$message",$headers);}
? >

connecting btrieve database with vb6

2006-11-29T13:52:00.000+02:00

you have an old version of btrieve and you want to read data from it?? well, you'r luck if you read this message in the beginning of your search... i lost 3 days of intensive searching.. and finaly found it. and here i share it with you...
well, open vb program and bla bla bla ...
now you should define some consts for easy work:
i suggest you to create a separate modul for this code (that what i did)
DefInt A-Z
Global Const BOPEN = 0
Global Const BCLOSE = 1
Global Const BINSERT = 2
Global Const BUPDATE = 3
Global Const BDELETE = 4
Global Const BGETEQUAL = 5
Global Const BGETNEXT = 6
Global Const BGETGREATEROREQUAL = 9
Global Const BGETFIRST = 12
Global Const BCREATE = 14
Global Const BSTAT = 15
Global Const BSTOP = 25
Global Const BVERSION = 26
Global Const BRESET = 28
Global Const KEY_BUF_LEN = 255

Rem Key FlagsGlobal Const DUP = 1
Global Const MODIFIABLE = 2
Global Const BIN = 4
Global Const NUL = 8
Global Const SEGMENT = 16
Global Const SEQ = 32
Global Const DEC = 64
Global Const SUP = 128
Rem Key Types
Global Const EXTTYPE = 256
Global Const MANUAL = 512
Global Const BSTRING = 0
Global Const BINTEGER = 1
Global Const BFLOAT = 2
Global Const BDATE = 3
Global Const BTIME = 4
Global Const BDECIMAL = 5
Global Const BNUMERIC = 8
Global Const BZSTRING = 11
Global Const BAUTOINC = 15

' now declare the function BTRCALL with do all the I\O with the database
Private Declare Function BTRCALL Lib "wbtrv32.dll" (ByVal OP, ByVal Pb$, Db As Any, DL As Long, Kb As Any, ByVal Kl, ByVal Kn) As Integer

' define some data types for working with the database files
Type typ_byte4 f1(1 To 4) As ByteEnd TypeRem ***************************************************************************
Rem Btrieve Structures
Type KeySpec
KeyPos As Integer
KeyLen As Integer
KeyFlags As Integer
KeyTot As typ_byte4
KeyType As String * 1
Reserved As String * 5
End Type

Type FileSpec
RecLen As Integer
PageSize As Integer
IndxCnt As Integer
NotUsed As String * 4
FileFlags As Integer
Reserved As String * 2
Allocation As Integer
KeyBuf(0 To 1) As KeySpec
End Type

Type StatFileSpecs
RecLen As Integer
PageSize As Integer
IndexTot As Integer
RecTot As typ_byte4
FileFlags As Integer
Reserved As String * 2
UnusedPages As Integer
KeyBuf(0 To 1) As KeySpec
End Type

Type RecordBuffer
' here you should define the structure of the file that you are reading.. in this example i have 3 'fields, one is an id (int) description and another float type
'change this to your data structure
profID As Integer
profDesc As String * 28
profPrice As Double
End Type

Type VersionBuf
Major As Integer
Minor As Integer
Engine As String * 1
End Type

Type typ_PosBlk
f1(1 To 128) As Byte
End Type

' defining variables with the types we created
Global FileBuf As FileSpec
Global DataBuf As RecordBuffer
Global StatFileBuffer As StatFileSpecs
Global BufLen As Long
Global DBLen As Integer

Rem*******Added to Open multiple files
Public iMaxRuns As Integer
Public bFilesCreated As Boolean

Sub PrintLB(Item As String)
' function for printing data on screen
Dim fTxtFileName As String
BtrFrm32.List1.AddItem Item
Rem Added to write info to file
fTxtFileName = App.Path & "\" & App.EXEName & ".log"
Open fTxtFileName For Append As #1
Print #1, Item Close #1
Rem *************
End Sub

sub readDate()
PrintLB ("Btrieve Sample Test Started")
PrintLB ("")
Rem Local variables needed for conversion from byte to long.
Dim loc_RecTot As Long
Dim h_field1 As String
Dim h_field2 As String
Dim h_field3 As String
Dim h_field4 As String
Dim h_total As String
'Rem **************************
FileName$ = "XFACE.BTR"
PosBlk$ = Space$(128)KeyBuffer$ = Space$(KEY_BUF_LEN)
RemRem ***************** Btrieve Create *********************Rem
Rem ************* SET UP FILE SPECS
FileBuf.RecLen = 34
FileBuf.PageSize = 1024
FileBuf.IndxCnt = 2
FileBuf.FileFlags = 0
''Rem ************* SET UP KEY SPECS
FileBuf.KeyBuf(0).KeyPos = 1
FileBuf.KeyBuf(0).KeyLen = 8
FileBuf.KeyBuf(0).KeyFlags = EXTTYPE + MODIFIABLE
FileBuf.KeyBuf(0).KeyType = Chr$(BFLOAT)
FileBuf.KeyBuf(1).KeyPos = 9
FileBuf.KeyBuf(1).KeyLen = 26
FileBuf.KeyBuf(1).KeyFlags = EXTTYPE + MODIFIABLE + DUP
FileBuf.KeyBuf(1).KeyType = Chr$(BSTRING)

'Open File
KeyBufLen = KEY_BUF_LEN
KeyBuffer$ = txtFileName.txt
BufLen = Len(DataBuf)KeyNum = 0
Status = BTRCALL(BOPEN, PosBlk$, DataBuf, BufLen, ByVal KeyBuffer$, KeyBufLen, KeyNum)
If Status <> 0 Then
Msg$ = "Error Opening file! " + Str$(Status)
PrintLB (Msg$)
GoTo Fini
Else
Msg$ = "File Opened Successfully!" PrintLB (Msg$)
End If

BufLen = Len(DataBuf)
KeyBuffer$ = Space$(255)
KeyBufLen = KEY_BUF_LEN
'Status = BTRCALL(BGETFIRST, PosBlk$, DataBuf, BufLen, ByVal KeyBuffer$, KeyBufLen, 0)
If Status <> 0 Then
Msg$ = "Error on BGETFIRST. " + Str$(Status)
PrintLB (Msg$)
Else
Msg$ = "BGETFIRST okay for : " + DataBuf.profDesc PrintLB (Msg$)
End If
'Get Next Record
BufLen = Len(DataBuf)KeyBuffer$ = Space$(KEY_BUF_LEN)
KeyBufLen = KEY_BUF_LEN
Status = BTRCALL(BGETNEXT, PosBlk$, DataBuf, BufLen, ByVal KeyBuffer$, KeyBufLen, 0)
If Status <> 0 Then
Msg$ = "Error on BGETNEXT. " + Str$(Status)
PrintLB (Msg$)
Else
Msg$ = "BGETFIRST okay for : " + DataBuf.profDesc
PrintLB (Msg$)
End If

end sub

Using Notify Icon Object

2006-11-23T10:29:00.000+02:00

notifyIcon1.Icon = new System.Drawing.Icon(@"c:\1.ico");
notifyIcon1.Visible = true;
notifyIcon1.Text = "Test Notify Icon Demo";
notifyIcon1.BalloonTipTitle = "ByRamiX Product";
notifyIcon1.BalloonTipText = "This Product was programmed ByRamiX";
notifyIcon1.ShowBalloonTip(5000);

using the data base class

2006-10-10T09:17:00.000+02:00

here we built a simple search engine that uses the batabase class that we built before

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace databasetest
{
///

/// Summary description for WebForm1.
///

public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DG1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button BtnSearch;
protected System.Web.UI.WebControls.TextBox txtSearchWord;
db db1;
private void Page_Load(object sender, System.EventArgs e)
{
db1=new db("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("database//freddydb.mdb"));
DG1.DataSource = db1.executeSQL("select * from users");
DG1.DataBind();
db1.closeDBCommand();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///

private void InitializeComponent()
{
this.BtnSearch.Click += new System.EventHandler(this.BtnSearch_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void BtnSearch_Click(object sender, System.EventArgs e)
{
try
{
if (txtSearchWord.Text.Trim()!="" )
{
DG1.DataSource = db1.executeSQL("select * from users where username like '"+txtSearchWord.Text+"%' or userfirstName like '"+txtSearchWord.Text+"%' or userLastName like '"+txtSearchWord.Text+"%'");
DG1.DataBind();
db1.closeDBCommand();
}
}
catch (Exception ex)
{
response.write (ex.Message);
}
}
}
}

connecting a database with c# / asp.net

2006-10-10T00:24:00.000+02:00

this is the code of database connection and sql executing functions

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

///

/// data base class
///

public class db
{
OleDbConnection gDbConn;
OleDbCommand gDbCmd;
public string error;
public db(string connStr)
{
try
{
gDbCmd = new OleDbCommand();
gDbConn = new OleDbConnection();
gDbConn.ConnectionString = connStr;
error="class built successfully";
}
catch (Exception e)
{
error = "[class constructor] building class faild, error in connecting database error discribe: "+e.Message ;
}
}
public OleDbDataReader executeSQL(String sql)
{
try
{
OleDbDataReader rs ;
gDbConn.Open();
gDbCmd.Connection = gDbConn;
gDbCmd.CommandText = sql;
if (sql.Contains("select") )
rs = gDbCmd.ExecuteReader();
else
{
gDbCmd.ExecuteNonQuery();
rs = null;
}
error = "executeSQL executed successfully";
return rs;
}
catch(Exception e)
{
error = "[execute sql] failed to execute sql statement error discribe:" + e.Message
return null;
}
}
}

an example of using this class here: http://byramix.blogspot.com/2006/10/using-data-base-class.html

Cannot open database requested in login 'databaseName'. Login fails

2006-08-21T13:50:00.001+03:00

it happened to me with sql server 2000 and 2005, after restoring the database i couldn't login from asp or asp.net script.
this solution is for sql 2000 but i think it will work also with 2005.
i noticed that after the restore the user that i'm tring to loggin with appears on the logins of the specifice database but the culomn of Login Name is empty. i looked at the same place in the original database and i saw something there... it was lost with the restore! i don't know if it's a bug or what, but i lost few days of fighting with it!
anyway, you need to put the the user name... it's not so easy, i didn't find the way to do it, i had to delete it and add it again.. that also not so simple! so you can delete the login it shouldn;t own nothing... so i had to change all the objects that were owned by this login and then could do it!!
i hope you found this blog before losing too much time on this!! the time that i spent is enough :)
if that helped you so write a commemnt
have a nice programming!!

Discuss Post

message could not be dilevered to all servers

2006-08-10T10:30:00.000+03:00

this error recieved when the email address of the reciever is not legal email address, for example starting with number, or like this format xx@hot..com, or start or have an illegal character like ' ! ?

Publishing .net WebApplicatuib

2006-08-03T10:17:00.000+03:00

if you are tring to publish a .net webApplication, it doesn't matter if it's c# or VB.net you should do the following steps :
1. copy the files tin your projects
you don't need to copy them all, only the aspx, and the congidurations files and very important is to copy the bin directory other wise you'll get theis error message:
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'AppName.Global'.

2.Create Virtual Directory
this is a very important step, alot of people loose aloth of time untill they knwo they should do it (at least i did :)
go to the iis, stand on the default webSite (in the websites) and right click and the new virtual director.
if you don;t do this step so you will get the following error message:
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

SELECT random records from a database

2006-07-14T19:43:00.000+03:00

asp script:
randomize
sql="select max (ID) as maxid from table"rs.open sql,cn
max=rs("maxid")
rs.close
for i=0 to 100
rndNum=int(rnd()*max)+1
idstr=idstr&rndNum&","
next
idstr=idstr+"0"
sql="select top 25 ID, * from table where ID in ("+idstr+")"
rs.open sql,cn

<% randomize sql="select max (ID) as maxid from table" rs.open sql,cn max=rs("maxid") rs.close for i=0 to 100 rndNum=int(rnd()*max)+1 idstr=idstr&rndNum&"," next idstr=idstr+"0" sql="select top 25 ID, * from table where ID in ("+idstr+")" rs.open sql,cn %>

asp smartupload subscript out of range

2006-07-02T14:57:00.000+03:00

you are using smart upload for uploading a file to the server and you get this ugly erro message "asp smartupload subscript out of range" and i'm sure that you didn't write the uploading script.. well, i spent one whole day with this error, and a got angry when i knew that it's a stupid mistake. just look at the html form the the data sent from, you shoud set the enctype to multipart/form-data

that's all!!

Request for the permission of type System.Net.WebPermission

2006-05-18T11:48:00.000+03:00

your spent too much time on tring tounderstand why your application dons'nt work?? yea tell me about it, security request ...
i'm looking for it two weeks ago.. no one has no idea! until i foud this blog... http://blogs.conchango.com/kenibarwick/archive/2004/11/05/195.aspx
he said it simple! don't put your aplication on shared folder....
i stored my application on a mapped drive on my network!!
so if you did like me just copy the folder to your C drive and it's work properly!
http://www.byramix.com