Click here to Skip to main content
15,895,841 members
Home / Discussions / C#
   

C#

 
GeneralRe: string and array are immutable? Pin
George_George25-Aug-08 1:30
George_George25-Aug-08 1:30 
QuestionCreate a full screen C# program... Pin
Hirakawa24-Aug-08 23:33
Hirakawa24-Aug-08 23:33 
AnswerRe: Create a full screen C# program... Pin
AhsanS25-Aug-08 1:14
AhsanS25-Aug-08 1:14 
GeneralRe: Create a full screen C# program... Pin
chaiguy133725-Aug-08 15:14
chaiguy133725-Aug-08 15:14 
AnswerRe: Create a full screen C# program... Pin
Manas Bhardwaj25-Aug-08 1:28
professionalManas Bhardwaj25-Aug-08 1:28 
AnswerRe: Create a full screen C# program... Pin
Hirakawa25-Aug-08 15:13
Hirakawa25-Aug-08 15:13 
GeneralRe: Create a full screen C# program... Pin
Manas Bhardwaj25-Aug-08 20:48
professionalManas Bhardwaj25-Aug-08 20:48 
QuestionHelp me resolve problem! Pin
medop8224-Aug-08 23:31
medop8224-Aug-08 23:31 
I had to buid the programs but when i run it which had to occupy butffer. So that i need to help to resolve this problem.
Evething idea please send fllowing Address mail: medop82@yahoo.com
Thanks you very much!
the class of me

public class CatalogueArea
{
#region Define
private System.Data.SqlClient.SqlConnection con = Medop.Define.Global.Static.ClassStatic.con;
private string[] _ArrayReturn = new string[] { Medop.Define.Global.Static.ClassStatic.DefaultEmpty, Medop.Define.Global.Static.ClassStatic.DefaultEmpty, Medop.Define.Global.Static.ClassStatic.DefaultEmpty };
private System.Data.DataSet _DsNull = null;
private string _CodeReturn;
#endregion Define

#region Contruct
public CatalogueArea()
{
}
#endregion Contruct

#region Public
public int VoidCheckExit(string input, string NameFile, string NameTable)
{
try
{
string sql;
if (con.State != ConnectionState.Open) con.Open();
sql = "SELECT * from " + NameTable + " where 1=1 and " + NameFile + "=" + "'" + input + "' ";
SqlCommand cm = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet mDataset = new DataSet();
cm = new SqlCommand(sql, con);
cm.ExecuteNonQuery();
da = new SqlDataAdapter(sql, con);
da.Fill(mDataset, Define.Global.Static.ClassStatic.NameTable);
da.Dispose();this.con.Close();

if (mDataset.Tables[Medop.Define.Global.Static.ClassStatic.NameTable].Rows.Count != 0)
return 0;
else
return 1;
}
catch
{
return 10;
}
}
public DataSet VoidGetNoneDataset()
{
try
{
string sql;
if (con.State != ConnectionState.Open) con.Open();
sql = "SELECT 0 AS STT, CODE_AREA, NAME_AREA, NOTE FROM dbo.AREA WHERE (1 <>1)";
SqlCommand cm = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet mDataset = new DataSet();
cm = new SqlCommand(sql, con);
cm.ExecuteNonQuery();
da = new SqlDataAdapter(sql, con);
da.Fill(mDataset, Define.Global.Static.ClassStatic.NameTable);
da.Dispose();this.con.Close();

return mDataset;
}
catch
{
return _DsNull;
}
}
public int VoidInsert(string CODE_AREA, string NAME_AREA, string NOTE)
{
try
{
if (VoidGetDataset(CODE_AREA, true).Tables[Medop.Define.Global.Static.ClassStatic.NameTable].Rows.Count != 0)
{
return 0;
}
string sql = Medop.Define.Global.Static.ClassStatic.DefaultEmpty;
sql = " set dateformat dmy; INSERT INTO dbo.AREA (";
sql += "CODE_AREA,";
sql += "NAME_AREA,";
sql += "NOTE";
sql += ") values (";
sql += "N'" + CODE_AREA + "'";
sql += ",N'" + NAME_AREA + "'";
sql += ",N'" + NOTE + "'";
sql += ")";
if (con.State != ConnectionState.Open) con.Open();
SqlCommand vCommand = new SqlCommand(sql, con);
vCommand.ExecuteNonQuery();
vCommand.Dispose();

_CodeReturn = CODE_AREA;
return 1;
}
catch
{
return 10;
}
}
public int VoidUpdate(string CODE_AREA, string NAME_AREA, string NOTE)
{
try
{
SqlCommand vCommand = new SqlCommand();
string sql = Medop.Define.Global.Static.ClassStatic.DefaultEmpty;
sql = "set dateformat dmy; update dbo.AREA set ";
sql += "NAME_AREA=N'" + NAME_AREA.Trim() + "'";
sql += " ,NOTE=N'" + NOTE.Trim() + "'";
sql += " WHERE CODE_AREA=N'" + CODE_AREA.Trim() + "'";
if (con.State != ConnectionState.Open) con.Open();
vCommand = new SqlCommand(sql, con);
vCommand.ExecuteNonQuery();
vCommand.Dispose();

_CodeReturn = CODE_AREA;
return 1;
}
catch
{
return 10;
}
}
public int VoidDelete(string CODE_AREA)
{
try
{
string sql = Medop.Define.Global.Static.ClassStatic.DefaultEmpty;
sql = "delete from dbo.AREA where CODE_AREA=N'" + CODE_AREA.Trim() + "'";
if (con.State != ConnectionState.Open) con.Open();
SqlCommand vCommand = con.CreateCommand();
vCommand.CommandText = sql;
vCommand.ExecuteNonQuery();
vCommand.Dispose();

return 1;
}
catch
{
return 10;
}
}
#endregion Public

#region Private
public DataSet VoidGetDataset(string _Input, bool CodeorAll)
{
try
{
string sql;
if (con.State != ConnectionState.Open) con.Open();
if (CodeorAll)
{
if (_Input.Trim().Equals(Medop.Define.Global.Static.ClassStatic.DefaultEmpty))
{
sql = "SELECT 0 AS STT, CODE_AREA, NAME_AREA, NOTE FROM dbo.AREA where 1=1 order by CODE_AREA,NAME_AREA,NOTE";
}
else
{
sql = "SELECT 0 AS STT, CODE_AREA, NAME_AREA, NOTE FROM dbo.AREA where 1=1 and CODE_AREA=N'" + Medop.Dispose.Conveniently.Conveniently.Replate(_Input.Trim()) + "' order by CODE_AREA,NAME_AREA,NOTE";
}

}
else
{
if (_Input.Trim().Equals(Medop.Define.Global.Static.ClassStatic.DefaultEmpty))
{
sql = "SELECT 0 AS STT, CODE_AREA, NAME_AREA, NOTE FROM dbo.AREA where 1=1 order by CODE_AREA,NAME_AREA,NOTE";
}
else
{
sql = "SELECT 0 AS STT, CODE_AREA, NAME_AREA, NOTE FROM dbo.AREA where 1=1 and CODE_AREA like N'%" + Medop.Dispose.Conveniently.Conveniently.Replate(_Input.Trim()) + "%' or NAME_AREA like N'%" + Medop.Dispose.Conveniently.Conveniently.Replate(_Input.Trim()) + "%' order by CODE_AREA,NAME_AREA,NOTE";
}
}
SqlCommand cm = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet mDataset = new DataSet();
cm = new SqlCommand(sql, con);
cm.ExecuteNonQuery();
da = new SqlDataAdapter(sql, con);
da.Fill(mDataset, Define.Global.Static.ClassStatic.NameTable);
da.Dispose();this.con.Close();
if (mDataset.Tables[Define.Global.Static.ClassStatic.NameTable].Rows.Count != 0)
{
_ArrayReturn[0] = mDataset.Tables[Define.Global.Static.ClassStatic.NameTable].Rows[0][Medop.Define.FieldInDatabase.StaticCatalogue.CODE_AREA].ToString().Trim();
_ArrayReturn[1] = mDataset.Tables[Define.Global.Static.ClassStatic.NameTable].Rows[0][Medop.Define.FieldInDatabase.StaticCatalogue.NAME_AREA].ToString().Trim();
_ArrayReturn[2] = mDataset.Tables[Define.Global.Static.ClassStatic.NameTable].Rows[0][Medop.Define.FieldInDatabase.StaticCatalogue.NOTE].ToString().Trim();
}

return Medop.Dispose.Conveniently.Conveniently.MakeStandardDataSet(mDataset);
}
catch
{
return null;
}

}

#endregion Private

#region Property

public string[] ArrayReturn
{
get { return _ArrayReturn; }
}
public string CodeReturn
{
get { return _CodeReturn; }
}
#endregion
}

đ

AnswerRe: Help me resolve problem! Pin
N a v a n e e t h24-Aug-08 23:44
N a v a n e e t h24-Aug-08 23:44 
JokeRe: Help me resolve problem! Pin
lisan_al_ghaib25-Aug-08 0:14
lisan_al_ghaib25-Aug-08 0:14 
AnswerRe: Help me resolve problem! Pin
Guffa25-Aug-08 1:43
Guffa25-Aug-08 1:43 
GeneralRe: Help me resolve problem! Pin
chaiguy133725-Aug-08 15:18
chaiguy133725-Aug-08 15:18 
QuestionHow to convert a structure data into bytes Pin
kk.tvm24-Aug-08 22:54
kk.tvm24-Aug-08 22:54 
AnswerRe: How to convert a structure data into bytes Pin
DaveyM6924-Aug-08 23:08
professionalDaveyM6924-Aug-08 23:08 
AnswerRe: How to convert a structure data into bytes Pin
N a v a n e e t h24-Aug-08 23:42
N a v a n e e t h24-Aug-08 23:42 
AnswerRe: How to convert a structure data into bytes Pin
lisan_al_ghaib24-Aug-08 23:45
lisan_al_ghaib24-Aug-08 23:45 
GeneralRe: How to convert a structure data into bytes Pin
kk.tvm25-Aug-08 1:09
kk.tvm25-Aug-08 1:09 
GeneralRe: How to convert a structure data into bytes Pin
lisan_al_ghaib25-Aug-08 1:24
lisan_al_ghaib25-Aug-08 1:24 
Questionworkflow Pin
A.firooz24-Aug-08 22:48
A.firooz24-Aug-08 22:48 
AnswerRe: workflow Pin
Brij24-Aug-08 23:51
mentorBrij24-Aug-08 23:51 
AnswerRe: workflow Pin
Manas Bhardwaj25-Aug-08 1:31
professionalManas Bhardwaj25-Aug-08 1:31 
Questionworkflow Pin
A.firooz24-Aug-08 22:46
A.firooz24-Aug-08 22:46 
QuestionI want to know some of the most advantages and disadvantages of WPF in comparison to the Forms Pin
anishkannan24-Aug-08 22:22
anishkannan24-Aug-08 22:22 
AnswerRe: I want to know some of the most advantages and disadvantages of WPF in comparison to the Forms Pin
lisan_al_ghaib24-Aug-08 22:51
lisan_al_ghaib24-Aug-08 22:51 
GeneralRe: I want to know some of the most advantages and disadvantages of WPF in comparison to the Forms Pin
chaiguy133725-Aug-08 15:22
chaiguy133725-Aug-08 15:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.