|
You have to automate Excel in order to save data properly in excel documents. You have to add a reference to MS Excel Library object. This article[^] will lead you on the right way.
regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
|
how can i delete from multiple table on a single button click
thanx
|
|
|
|
|
you can delete as many as you want with multiple delete command,
describe your problem more...
|
|
|
|
|
i hav no common field in the tables so i cann't use join.
on a button click i want to delete records from multiple table.
i'm writing individual query in different strings.
i'm confusing in commandobject and nonexecutequery ().
how would i use them for multiple queries.
thanx
|
|
|
|
|
there is two way for delete for you:
first way is that you use indivisual queries on command as you used
second way is merging queries as below:
delete * from table1;
delete * from table2;
...
put (;) semicolon between queries.
|
|
|
|
|
Hi all,
I am fairly new to ASP.NET and have been trying to upload a site to a 1&1 server, however when viewed on the net I am just seeing the source rather then the page. Any ideas?
Regards,
P.Cairns
|
|
|
|
|
The Framework may not be there on server, this is why .ASPX files dint get parse & execute . make sure Framework is there and IIS and farmwork is registred.
Nobody is perfect i'm Nobody
|
|
|
|
|
Thanks, thats what I have heard from other sources as well. It seems my package did not support the .NET framework, which I have now upgraded. There is a 24hr wait prior to the upgrade so I'll try again then. Thanks.
Regards,
Oz
|
|
|
|
|
Sir,
I am returning a table in the td tag of ot table(which is placed in the edititemtemplate of datagrid).Now the problem in it is returning a table but not the structure of the table and returnibg the text and the text value is System.Web.UI.HtmlControls.HtmlTable.But i want the complete structure of the table in that row of the datagrid.Is it possible?
-----------------------------------------------------------------
I am using the following code.
-----------------------------------------------------------------
public function FindAttribute (byval str as string) as System.Web.UI.HtmlControls.HtmlTable <br />
<br />
Dim t As New System.Web.UI.HtmlControls.HtmlTable<br />
t.Width = "100%"<br />
t.ID = "dynamic"<br />
Dim drow As System.Web.UI.HtmlControls.HtmlTableRow<br />
Dim dcell(1) As System.Web.UI.HtmlControls.HtmlTableCell<br />
Connect()<br />
Dim recordscount As Integer<br />
cmd = New OleDbCommand("select count(*) from Depositdetail where depositId=" & str, con)<br />
dr = cmd.ExecuteReader<br />
If (dr.Read) Then<br />
recordscount = dr.Item(0)<br />
End If<br />
dr.Close()<br />
<br />
<br />
cmd = New OleDbCommand("select * from Depositdetail where depositId=" & str, con)<br />
dr = cmd.ExecuteReader<br />
While (dr.Read)<br />
drow = New System.Web.UI.HtmlControls.HtmlTableRow<br />
dcell(0) = New System.Web.UI.HtmlControls.HtmlTableCell<br />
dcell(0).Width = "30%"<br />
dcell(1) = New System.Web.UI.HtmlControls.HtmlTableCell<br />
dcell(1).Width = "70%"<br />
dcell(0).InnerText = dr.Item(0)<br />
dcell(1).InnerText = dr.Item(1)<br />
drow.Cells.Add(dcell(0))<br />
drow.Cells.Add(dcell(1))<br />
t.Rows.Add(drow)<br />
End While<br />
FindAttribute = t
|
|
|
|
|
How did you call this code from where (codebehind/html)?
Please specify that part.
If you are using code behind, then you should add this htmltable into controls collection.
If you are accessing this code from html side, this will not work. You have to do some extra ....
So please specify the full code (where you access this function?).
Regards
R.Arockiapathinathan
|
|
|
|
|
How can I declarate class in JSctrpt
|
|
|
|
|
you mean using ASP.NET?
"Just about every question you've asked over the last 3-4 days has been "urgent". Perhaps a little planning would be helpful?" Colin Angus Mackay in the C# forum
led mike
|
|
|
|
|
Do you mean JScript? If so, look at JScript
<< >>
|
|
|
|
|
<br />
function myClassName<br />
{<br />
var m_firstVar;<br />
var m_secondVar=new String();<br />
<br />
this.method1 = method1;<br />
this.method2 = method2;<br />
<br />
myClassName = new function<br />
{<br />
}<br />
}<br />
<br />
function method1() {} <br />
<br />
<div class="ForumSig">"Now I guess I'll sit back and watch people misinterpret what I just said......" <br />
Christian Graus At The Soapbox<br />
</div>
|
|
|
|
|
I have Html button and i want to make text of button bold.
CAn anybody help in it?
|
|
|
|
|
hi
Every HTML Button has a property called Style in that u can set the text property Bold.
Hope this will work for u.
|
|
|
|
|
Just add style="font-weight:bold" in the HTML source of the button (<input id="Button1" type="button" value="button" style="font-weight:bold" /> )
regards,
Mircea
Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
|
|
|
|
|
>Hi Friends.
I am putting datalist in the edititemtemplate of the datagrid.After then some part of the datalist code (placed in the edititemtemplate of the datagrid)is not executing.I am placing the datalist in the edititemtemplate of datagrid.
-----------------------------------------------------------
I am using the following code.
-------------------------------------------------------------
<asp:DataGrid id="dg1" runat="server" Width="392px" Height="144px"
AutoGenerateColumns="False"
AllowPaging="True" PageSize="5">
--------------------------------------------------
<Columns>
<asp:TemplateColumn>
<HeaderTemplate>
<TABLE width="100%">
<TR>
<TD width="70%">Deposit Types
</TD>
<TD align="center" width="15%">Edit
</TD>
<TD align="center" width="15%">Delete
</TD>
</TR>
</TABLE>
</HeaderTemplate>
------------------------------------------------------------
<ItemTemplate>
<TABLE width="100%">
<TR>
<TD><%#Container.DataItem(1).ToString()%></TD>
<TD align="center" width="15%">
<asp:ImageButton id="edit" ImageUrl="images/edititem.gif" CommandName="edit" Runat="server"></asp:ImageButton></TD>
<TD align="center" width="15%">
<asp:ImageButton id="Imagebutton1" ImageUrl="images/cross.gif" CommandName="delete" Runat="server"> </TR>
</TABLE>
</ItemTemplate>
-----------------------------------------------------------------------
<EditItemTemplate>
<TABLE id="edititem" width="100%">
<TR>
<TD width="100%">
<asp:DataList id="dl1" Runat="server">
<ItemTemplate>
<table width="100%">
<tr>
<td width="30%">
<%#FindAttribute(Container.DataItem(0).ToString())%>
</td>
</tr>
</table>
</ItemTemplate>
</asp:DataList></TD>
</TR>
</TABLE>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
<pagerStyle Mode="NumericPages"></PagerStyle>
</asp:DataGrid>
Please help.
-- modified at 1:42 Saturday 15th July, 2006
|
|
|
|
|
I am developing a billing system. I'm having tables including packages and invoices. The packages are created for each invoices.
How can i renew the packages? For example one package is monthly plan and the second one is yearly plan. How can i renew the monthly plan package and generate an invoice for that package. This must also helps to track the invoice & package details.
I'm very much confused please help me!
|
|
|
|
|
|
Good day to all.
I got a problem to bind a data into datagrid in asp.net.
My problem is, i got several way to key in the data to search the relevant data to be bind in the datagrid.
Such as i got 3 textbox provide for the user to key in the input data, and how do i need to use this different data to filter out the most accurate data to be bind in the datagrid.
Can anyone give me a solution to solve this problem. If got sample code would be more better.
Thanks and have a nice day.
Best Regards,
Pei Sun
|
|
|
|
|
|
What?! No C# example?
"The key, the whole key, and nothing but the key, so help me Codd"
|
|
|
|
|
Hi there,
This is a gud site datagridgirl.com for you to learn how to bind data to datagrid...
<< >>
|
|
|
|
|
Hi Everyone!
I have a proplem of connection string to connect database
I have a SQL server, thi Name server this MSSQLxxx; (Not Local)
User: Xman;
Pass: Xmankk;
DataBase: TLxxx;
Now, I Dev a website in .Net 1.x & SQLSERVER 2000.
I use a connection string:
"user id=Xman;pwd=Xmankk;data source=MSSQLxxx;initial catalog=TLxxx;timeout=90"
But, can not connect to database.
I try doing connect to the database by tool of sqlserver 2000, it is sucessful, I can view all information of the data (TLxxx), I can view Tables, views ,... I can Create table there.
This is the my code:
public class UserDB
{
private string connectionString;
public UserDB()
{
// I try Hardcode to test connection string.
connectionString = "user id=Xman;pwd=Xmankk;data source=MSSQLxxx;initial catalog=TLxxx;timeout=90";//ConfigurationSettings.AppSettings["connectionString"];
}
public int GetUserID(string userName, string pass)
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand("TL_GetUserID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@userName", SqlDbType.NVarChar,50));
cmd.Parameters["@userName"].Value = userName;
cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar,32));
cmd.Parameters["@password"].Value = pass;
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
return Convert.ToInt32(reader["UserID"]);
}
else
{
return -1;
}
}
catch(SqlException)
{
throw new ApplicationException("data ");
}
finally
{
con.Close();
}
return -1;
}
....
}
Please, show me solution.
Many Thank.
I Don't Want Say No Wealth
|
|
|
|