|
Search for macro in Excel easy and faster
|
|
|
|
|
could you throw more light on this!!!
Gautham
|
|
|
|
|
Ya Macro is in VB and is Excel Language it is always better to write Macro than Using Excel Object You will find on net search by 'reading data Excel macro'
|
|
|
|
|
OPen the Excel sheet GO to tools macro and Visual basic Editor find examples from net how to get data from Excel using macro
|
|
|
|
|
/*
This is my oracle function
*/
create or replace function EngUnitConvert(sSrcEng in varchar2, sDstEng in varchar2)
return number
is
AtLeastLostOneCoefficient exception;
vSrcEng Number;
vDstEng Number;
vValue Number;
BEGIN
begin
-- Get source
SELECT Mult_Fctr
INTO vSrcEng
From ip_eng_unit t
WHERE t.units = UPPER(sSrcEng);
dbms_output.put_line('Source Coefficient :' || to_char(vSrcEng));
-- Get destination
SELECT Mult_Fctr
INTO vDstEng
From ip_eng_unit t
WHERE t.units = UPPER(sDstEng);
dbms_output.put_line('Destination Coefficient :' || to_char(vDstEng));
if ((vSrcEng is null) or (vDstEng is null)) then
dbms_output.put_line('At Least Lost One Coefficient!');
raise AtLeastLostOneCoefficient;
else
vValue := vDstEng / vSrcEng;
dbms_output.put_line('Result Coefficient :' || to_char(vValue));
end if;
dbms_output.put_line('Finished!');
return vValue;
end;
exception
when AtLeastLostOneCoefficient
then null;
WHEN OTHERS THEN NULL;
END;
/*
This is my OleDbCommand call,but it failed
*/
// here OleDbConnecton have opened
OleDbCommand sqlcmd = new OleDbCommand();
sqlcmd.CommandText = "unitconvert";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Connection = olecn;// olecn -- OleDbConnecton
OleDbParameter ps = new OleDbParameter("s_from_eng",System.Data.OleDb.OleDbType.VarChar,32);
ps.Direction = System.Data.ParameterDirection.Input;
ps.Value = sFromUnit;
OleDbParameter pd = new OleDbParameter("s_from_eng",System.Data.OleDb.OleDbType.VarChar,32);
pd.Direction = System.Data.ParameterDirection.Input;
pd.Value = sToUnit;
OleDbParameter pr = new OleDbParameter("vvalue",System.Data.OleDb.OleDbType.Numeric,16);
pr.Direction = System.Data.ParameterDirection.ReturnValue;
sqlcmd.Parameters.Add(ps);
sqlcmd.Parameters.Add(pd);
sqlcmd.Parameters.Add(pr);
sqlcmd.ExecuteNonQuery();
string sValue = sqlcmd.Parameters["vValue"].Value.ToString();
/*
The error messages is:
*/
ORA-06550: line 1, column 7:\nPLS-00201: identifier 'UNITCONVERT' must be declared\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored
/*
Here is OracleDbCommand call,it success
*/
OracleConnection orcn=new OracleConnection("user id=totalplant;data source=totalplant;password=totalplant");
OracleCommand cmd=new OracleCommand("unitconvert",orcn);
cmd.CommandType=CommandType.StoredProcedure;
OracleParameter p1=new OracleParameter("s_from_eng",OracleType.VarChar,32);
p1.Direction=System.Data.ParameterDirection.Input;
p1.Value= "g";
OracleParameter p2=new OracleParameter("s_to_eng",OracleType.VarChar,32);
p2.Direction=System.Data.ParameterDirection.Input;
p2.Value= "tonne";
OracleParameter p3=new OracleParameter("vValue",OracleType.Number,100);
p3.Direction=System.Data.ParameterDirection.ReturnValue;
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
orcn.Open();
cmd.ExecuteNonQuery();
orcn.Close();
|
|
|
|
|
Hi,
I have created user control called UserCtrl.ascs in my solution which includes two textboxes in that usercontrol and and also i have added the following code in .ascx.cs page.
public string pUser
{
get
{
return TextBox1.Text.Trim;
}
set
{
TextBox1.Text = value;
}
}
public string pPass
{
get
{
return TextBox2.Text.Trim;
}
set
{
TextBox2.Text = value;
}
I added that user control to my aspx page. Please tell me how to use that textboxes inside aspx.cs page.
Thanks in Advance,
Regards,
Prya
|
|
|
|
|
create object of that user control class, and and set the value of properties...
|
|
|
|
|
this.UserCtrl.TextBox1.value this way
|
|
|
|
|
As blue_arc said, you use user control from page codebehind same way as if it was standard ASP.NET web control.
Assuming you have in your aspx file:
<uc:userCtrl runat="server" id="myCtrl"/>
in codebehind do:
string password = myCtrl.pPass;
Is it clear?
You should not try to access textboxes directly, as it goes against encapsulation principle (hence I downvoted guy above me :P).
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
Hi,
Can any1 provide me ASP.NET 2.0 or 1.1 interview questions or FAQs????.. If u have compiled list then send it to ganesh_d1@yahoo.com
Thanx in advance.
|
|
|
|
|
I want it for ASP.NET with C#.
|
|
|
|
|
use google.. you will get faq related to the topic in abundance..
Best Regards,
Apurva Kaushal
|
|
|
|
|
hai,
anybody knows anything about whiteboard technology. how to use that in asp.net webapplications.
please give some tips
thanks in advance
sebastian
|
|
|
|
|
Hi everybody
I have used a datagrid in my form. and every thing is Ok.
I can see the items I want in datagrid but the problem is about paging.
I have set the paging to 5 ..it means the datagrid should show 5 items in page 1 and the next 5 items in the next page( page 2 ) and ...
but it doesnt work ... it shows the page but when I click on page 2 it already shows the items in page 1 ...
I mean just page 1 works ...what should I do?
whats wrong with properties or code?
please tell me ...
thank you very much.
|
|
|
|
|
Hope this helps u.
private void dgGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgGrid.CurrentPageIndex = e.NewPageIndex ;
DataSet ds = GetEmployeeList();//Bind List again
}
|
|
|
|
|
hi it didnt work...
here is my code ... can u please tell me what is wrong with it ?
thanks alot.
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
FillDataGrid();
}
}
private void FillDataGrid()
{
cUpload upload=new cUpload();
bool Success;
dsUpload1=upload.GetAllUpload(out Success);
if(Success)
{
dgUpLoad.DataSource=dsUpload1.tblUpLoad;
}
dgUpLoad.DataBind();
}
private void dgUpload_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
cUpload upload=new cUpload();
bool Success;
dgUpLoad.CurrentPageIndex= e.NewPageIndex ;
dsUpload1=upload.GetAllUpload(out Success);
//Bind List again
}
|
|
|
|
|
What is out Success and dgUpLoad.DataSource=dsUpload1.tblUpLoad;??
U can dierctly bind datagrid with dataset.
|
|
|
|
|
Thats because I want to bind My datagrid to dataset which is connected to table name tblupload ...
the items which is shown in datagrid is the items in my table ( tblupload ) ...
So,If you have any suggestion please correct my code above and write it here...thanks alot
|
|
|
|
|
No need to that way.Try this:
Dim strSql as String
strsql = "Select * from tblupload"
'Open DB connection here
Dim dtad As SqlDataAdapter
Dim dtst As DataSet
dtst = New DataSet
dtad = New SqlDataAdapter(strsql, GetConnection)
'Close DB connection here
dtad.Fill(dtst)
DataGrid1.DataSource = dtst
DataGrid1.DataBind()
I think this much is enough to display the Datagrid.
|
|
|
|
|
1.the language I use is C#
2.I have problem with working numbers of pages not showing the grid.
thanks
|
|
|
|
|
Try this :
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
FillDataGrid();
}
}
private void FillDataGrid()
{
string strsql = "Select * from tblupload"
//Open DB Connection here
DataSet ds = con.GetDataSet(SQL,tableName);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
//Close DB Connection here
}
private DataSet GetDataSet(String sql)
{
string tableName = "tblupload";
SqlDataAdapter da = new SqlDataAdapter(sql, connectionStr);
da.Fill(ds, tableName);
return ds;
}
|
|
|
|
|
Hi All,
I have 2 combo, a textbox and a checkbox. On Add button Click event(which is outside the Gridview) I put all the values in datatable and then bind it the GridView.
I am creating dynamically columns for datatable and keeping them in Viewstate.I have two columns of edit and delete in Girdview.Now my problem is that when I click on edit image button which is in the Gridview Edit column I want to add the above combo ,textbox and checkbox in the gridview so that I can edit that row.
Also I need to delete the record.
Can anyone tell me how do I do this.
Thanks in advance.
-- modified at 5:12 Thursday 1st February, 2007
|
|
|
|
|
hi alll,
how can i get the ajaxToolkit:PopupControlExtender.
control to use in as.net 2.0 project.
pls help.
thanks in advance.
srinandan.
-- modified at 4:27 Thursday 1st February, 2007
|
|
|
|
|
Download the toolkit, add the DLL as a reference, add the control to the toolbox (right click->choose items, browse to the DLL). Hey presto....but then it would of been easier to read the instructions....
|
|
|
|
|
How to do load balancing in an application
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
|
|
|
|