Private Function getmax()
Dim no As Integer
Dim str1 As String
str1 = "select max(CD) from Item"
cmd1.Connection = con
cmd1.CommandType = CommandType.Text
cmd1.CommandText = str1
con.Open()
no = cmd1.ExecuteScalar()
If no = 0 Then
no = 1
Else
no = no + 1
End If
Return no
End Function
public Boolean FillCombo(ref DropDownList DD1, string DisplayColumn, string ValuColumn, string TableName)
{
try
{
string QueryString = "";
QueryString = "select " + DisplayColumn + "," + ValuColumn + " from " + TableName + " order by " + DisplayColumn;
cmd = new SqlCommand(QueryString, ObjCn.OpenDb());
DA = new SqlDataAdapter(cmd);
DtMain = new DataTable(TableName);
DA.Fill(DtMain);
DD1.DataTextField = DisplayColumn;
DD1.DataValueField = ValuColumn;
DD1.DataSource = DtMain;
DD1.DataBind();
ListItem LtSelect = new ListItem("Select", "0");
DD1.Items.Insert(0, LtSelect);
return true;
}
catch (Exception ex)
{
return false;
}
finally
{
ObjCn.CloseDB();
cmd.Dispose();
DA.Dispose();
}
}
{
try
{
string QueryString = "";
QueryString = "select " + DisplayColumn + "," + ValuColumn + " from " + TableName + " order by " + DisplayColumn;
cmd = new SqlCommand(QueryString, ObjCn.OpenDb());
DA = new SqlDataAdapter(cmd);
DtMain = new DataTable(TableName);
DA.Fill(DtMain);
DD1.DataTextField = DisplayColumn;
DD1.DataValueField = ValuColumn;
DD1.DataSource = DtMain;
DD1.DataBind();
ListItem LtSelect = new ListItem("Select", "0");
DD1.Items.Insert(0, LtSelect);
return true;
}
catch (Exception ex)
{
return false;
}
finally
{
ObjCn.CloseDB();
cmd.Dispose();
DA.Dispose();
}
}
The J# (pronounced 'jay-sharp') programming language is a transitional language for programmers of Sun's Java and Microsoft's Visual J++ languages, so they may use their existing knowledge and applications on Mircrosoft's .Net platform. J# can work with Java bytecode as well as source so it can be used to transition applications that use third party libraries evenn if their original source is unavilable. It was developed by the Hyderabad-based Microsoft India Development center at HITEC City in India.