|
It does not work like this here. You need to share what have you tried so far and where are you stuck - be specific.
For now, look at this discussion thread: SFTP with .net 3.5?[^] - try out.
|
|
|
|
|
i am using open xml in .net 4.0
i want to copy the data contain in one sheet in one work book and paste into sheet different work book with sheet name, i have done this by using miscrosoft.interop.excel, i want same thing using open xml please give the solution
i have done this by using miscrosoft.interop.excel this is the following code the same thing need to be done using openxml please help me on this
Excel.Application oXL;
Excel.Workbook oWB;
Excel.Worksheet oSheet;
Excel.Range oRange;
oXL = new Excel.Application();
// // Set some properties
oXL.Visible = true;
oXL.DisplayAlerts = false
for (int iWorkbook = 0; iWorkbook < Files.Length; iWorkbook++)
{
if (Files[iWorkbook] != string.Empty)
{
oXL.Workbooks.Add(Files[iWorkbook]);
}
}
for (int i = 2; i <= oXL.Workbooks.Count; i++)
{
int count = oXL.Workbooks[i].Worksheets.Count;
oXL.Workbooks[i].Activate();
for (int j = 2; j <= count; j++)
{
Excel._Worksheet ws = (Excel._Worksheet)oXL.Workbooks[i].Worksheets[j];
ws.Select(Type.Missing);
ws.Cells.Select();
string name = ws.Name;
Excel.Range sel = (Excel.Range)oXL.Selection;
if (sel.Cells.Text != string.Empty)
{
sel.Copy(Type.Missing);
Excel._Worksheet sheet = (Excel._Worksheet)oXL.Workbooks[1].Worksheets.Add(
Type.Missing, Type.Missing, Type.Missing, Type.Missing
);
sheet.Paste(Type.Missing, Type.Missing);
sheet.Name = name;
}
}
}
string[] ConsolidatedFiles = Directory.GetFiles(filepath);
if (ConsolidatedFiles.Length > 0)
{
string filetemplates = filepath + "\\" + TemplateType + ".xlsx";
for (int file = 0; file < ConsolidatedFiles.Length; file++)
{
if (ConsolidatedFiles[file].ToString() == filetemplates)
{
File.Delete(ConsolidatedFiles[file]);
}
}
}
filepath = filepath + "\\" + TemplateType + ".xlsx";
oWB.SaveAs(filepath, Excel.XlFileFormat.xlWorkbookDefault,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Excel.XlSaveAsAccessMode.xlExclusive,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
oWB.Close(Type.Missing, Type.Missing, Type.Missing);
oWB = null;
oXL.Quit();
|
|
|
|
|
how to design a master page in asp.net and what is use of mater page ..
|
|
|
|
|
I think the following article will give you all the information needed to get started with master pages.
Beginner's Tutorial on Master Pages in ASP.NET[^]
Every now and then say, "What the Elephant." "What the Elephant" gives you freedom. Freedom brings opportunity. Opportunity makes your future.
|
|
|
|
|
I use masterpages all the time, every project
I start with the landing masterpage first. Build the HTML framework, add a Landing CSS Sheet with master layout, then add content placeholders for head content, body content, sitemap content, and test it across all browsers. Then I dial in the artwork, the color palettes to be used (usually about 6 colors that are harmonic), the menu systems, and test and test and test.
I usually spend about 2 days on the landing masterpage, then I make a copy of it, for other masterpages, and tweak the designs a bit. I'll make a copy that has a 2/3 1/3 column layout, one for a 1/1 layout, 1/4 3/4 layout for left side menu and content, and give them names that represent the languadge and layout.
You can globalize masterpages, one for English, one for French, etc.
Once your masterpages are perfect, it's easy to start building pages after that, but you have to have all your masterpages built first, or else it slows down your workflow process.
The masterpage is like a container, in the old days, you had to put the master page container content on every page, and you would lose track of the start and stop points of it. If you wanted to make a change to the master content, you had to do it on every page.
In classic asp, we made a header and footer HTML file, to contain master content. and you had to do an include for every page.
Once you get it down, you won't turn back to the old ways.
|
|
|
|
|
Start here.[^]
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
i think start from "hello word" beginning ^_^
|
|
|
|
|
Hi,
I am hosting on a remote host somewhere in US.
I have a folder with sub folders inside it. The folder name is : member
I want when creating a new member to copy the folder and all its subfolder to a new folder called xxx
both member folders and xxx folder are in ~/images/
how can I do this?
Thanks,
|
|
|
|
|
I tried this but not working:
string path = "~/images/" + "TTTTTTT";
DirectoryInfo directoryInfo = new DirectoryInfo(Server.MapPath(path));
if (!directoryInfo.Exists)
{ directoryInfo.Create(); }
I am not getting any error but directory is not getting created either!
|
|
|
|
|
Can you have a logger to log the 'path' like this
logger.Debug(path) in both if and else routes?
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!
|
|
|
|
|
I decided to use Oracle 11.g for a new website job I sold that sells chips.
A small project to experiment with Oracle, and see how good it works, what's up with it, it is better than SQL Server 2008
I figured out most of the stuff, got the databases, tablespaces, permissions going.
Having trouble understanding parameters, and using the OracleDataReader in asp.net, and I'm not quite sure if I used the OracleConnection and OracleCommand correctly.
1. Specified cast is not valid. I know what it means, but I'm trying to figure out a different way of expressing it below.
p_Count = oReader.GetInt32(0) 'TheCount
2. Using the Parameters, I think Oracle doesn't like the @ char in the parameter name.
I want to say "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX WHERE MANUFACTURE=@MANUFACTURE"
But I get a error - ORA-00936: missing expression
Anyways, I was just looking for some pointers, or just a different set of eyes on my code, most of stuff I found was for data binding.
Dim p_Count As Integer = 0
Dim conStr As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DellC521-01.redcopper.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));User Id=WWW;Password=UTF888888"
Dim cmdQuery As String = "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX"
Dim con As New OracleConnection(conStr)
Dim cmd As New OracleCommand(cmdQuery)
cmd.Connection = con
cmd.CommandType = Data.CommandType.Text
Dim param_MANUFACTURER As OracleParameter
param_MANUFACTURER = New OracleParameter("@MANUFACTURER", OracleDbType.Varchar2, 80)
param_MANUFACTURER.Value = m_Manufacturer
cmd.Parameters.Add(param_MANUFACTURER)
Try
con.Open()
Dim oReader As OracleDataReader = cmd.ExecuteReader
While oReader.Read()
p_Count = oReader.GetInt32(0) 'TheCount
End While
oReader.Close()
con.Close()
oReader = Nothing
Catch ex As Exception
End Try
con = Nothing
cmd = Nothing
Return p_Count
|
|
|
|
|
Well that was interesting. This Oracle is a little different on the asp.net side
Oracle didn't like the @ char, so I changed it to :, and you can't name the parameter the same as the column name, so I change the name to just :M1
As far as getting the value, it's GetValue(0), go figure. Not sure if I should cast it to a integer.
So now I see there is a Microsoft Data Access Client for Oracle included in asp.net 4.0, and a Oracle Data Access Client, the one that ships with Oracle 11.g Express, so which one to choose?
Well I choose the one from Oracle, figured maybe it's more fine tuned, I don't know, comments are welcomed.
Well I think I'm ready to start writing code for this now. I welcome any comments or conversation on this subject.
This is what I ended up with so far, it works, but needs further testing.
Dim p_Count As Integer = 0
Dim conStr As String = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DellC521-01.redcopper.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))); User Id=PUBLIC_USER; Password=xxxxxxxx"
Dim cmdQuery As String = "SELECT COUNT(*) FROM RC_PUBLIC_USER.RC$_PRODUCTINDEX WHERE MANUFACTURE=:M1"
Dim con As New OracleConnection(conStr)
Dim cmd As New OracleCommand(cmdQuery, con)
cmd.CommandType = Data.CommandType.Text
Dim param_Manufacture As OracleParameter
param_Manufacture = New OracleParameter(":M1", OracleDbType.Varchar2, 80)
param_Manufacture.Value = m_Manufacturer
cmd.Parameters.Add(param_Manufacture)
Try
con.Open()
Dim oReader As OracleDataReader = cmd.ExecuteReader
While oReader.Read()
p_Count = oReader.GetValue(0) 'TheCount
End While
oReader.Close()
con.Close()
oReader = Nothing
Catch ex As Exception
End Try
con = Nothing
cmd = Nothing
Return p_Count
|
|
|
|
|
In place of oracle connection i suggest you to go with the oledb connection, Which provided by the .net framework it self
You have to import the library as
Imports System.Data.OleDb
then your code will look like:
Dim p_Count As Integer = 0
Dim conStr As String = ""
Dim cmdQuery As String = ""
Dim con As OleDbConnection = Nothing
Dim cmd As OleDbCommand = Nothing
Dim oReader As OleDbDataReader = Nothing
Try
conStr = "<Connection string for oledb connection>"
cmdQuery = "SELECT COUNT(*) FROM WWW.RC$_PRODUCTINDEX"
con = New OleDbConnection(conStr)
cmd = New OleDbCommand(cmdQuery)
cmd.Connection = con
cmd.CommandType = Data.CommandType.Text
cmd.Parameters.Add("@MANUFACTURER", OleDbType.VarChar, 80).Value = m_Manufacturer
con.Open()
oReader = cmd.ExecuteReader
While oReader.Read()
p_Count = oReader.GetInt32(0) 'TheCount
End While
Catch ex As Exception
Finally
con.Close()
oReader = Nothing
End Try
con = Nothing
cmd = Nothing
Return p_Count
|
|
|
|
|
I am interested in making a universal way for all my programs to be able to switch SQL Database Programs, and I think OLEDB was going to be the standard in the future. I did some research on it during my C++ development last year, and I just need to look at my code to see what I used.
I ended up using the Oracle ODP.NET 11.2, the latest one, and finished installing the Oracle 11.g to my production database server, and setup the ODP client on the web server, so I'm ready to go.
i will tool around with teh OLEDB this weekend, and take it for a spin.
Thanks for the discussion on it, anything on the subject is welcomed.
|
|
|
|
|
I have a java web service, RPC that is not accessible direct creating proxy class in .net.
How can we consume java web service RPC not saop in my .net application.
I am getting error :
Client found response content type of 'multipart/related; boundary=MIMEBoundaryurn_uuid_C426126584B07577941351575273892;
Thanks,
|
|
|
|
|
Hi,
I want to create a Facebook application.
Form the examples on the web I see that there's a use of php on the server side.
Is there a way to create the application with asp.net web forms / asp.net MVC and achieve the same results?
Thanks,
Avi
|
|
|
|
|
ThetaClear wrote: Form the examples on the web I see that there's a use of php on the server side.
Outside of the server, that difference is not visible. Server code runs on the server, it's only the result that one can see.
There's an example on C# and FB here[^].
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
My query is that i am doing a shopping cart site.I have a repeater control loaded with products and when user clicks on a specific product ,the selected product should get loaded to the gridview which is at the rightcorner .It should happen without postback and when user selects another product the gridview should get updated with another product.How to attain the result. Expecting ur suggestions.
Thank you
|
|
|
|
|
fahad.1 wrote: Expecting ur suggestions.
Use AJAX.
Sorry, but you'll have to research the technology and see how it will fit in your application.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
Use AJAX UpdatePanel control.
Put all the code that is being postback to the server in side the UpdatePanel control
|
|
|
|
|
Your going to have to use Javascript, and create your sort of fake grid, and update that fake grid in the DOM. At the same time the item is added, you need to use a web service to update the cart with that item. So when you do a postback, all the items can repopulate that same space.
fahad.1 wrote: .It should happen without postback
Update panels do a partial postback of the page, but it's still a postback.
The only way to get around a postback is to use a web service in the background, in combination with Javascript, to just keep manipulating the dom, until you leave the page.
As far as manipulating the Gridview in JavaScript, I have no idea how.
That's alot of work for that feature or confirmation.
|
|
|
|
|
I am using dropdownlist in c# asp.net. Here one dropdown list getting data's from database and its having required field validator also.,
My ASP design coding is.,
<asp:dropdownlist id="zonename" runat="server" width="195px" tooltip="Select Zone">
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" controltovalidate="zonename" errormessage="Zone Name Required" initialvalue="Select Zone">
And MY C# coding is....,
da = new MySqlDataAdapter("select name from zone", mysqlcon);
dt = new DataTable();
da.Fill(dt);
zonename.Items.Clear();
zonename.Items.Add("Select Zone");
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
zonename.Items.Add(dt.Rows[i]["name"].ToString());
}
mysqlcon.Close();
WHEN I AM SAVING THIS DROPDOWNLIST TEXT TO THE DATABASE.,THE WORD "Select Zone" ONLY GOING TO THE DATABASE.
MY INSERT QUERY IS.,
"insert into TABLENAME(zonename) values('"+zonename.text+"')";
Here i couldnt understand what is going on.,i need to save the selected text to the database. If anybody know how to solve this problem, Please let me know.,
Thanks.,
|
|
|
|
|
zonename looks like it is some sort of list so it is unlikely to have a member called text. It would also help if you formatted your code and put <pre> tags around it, to make it more readable thus:
da = new MySqlDataAdapter("select name from zone", mysqlcon);
dt = new DataTable();
da.Fill(dt);
zonename.Items.Clear();
zonename.Items.Add("Select Zone");
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
zonename.Items.Add(dt.Rows[i]["name"].ToString());
}
mysqlcon.Close();
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
Look at the SelectedText and SelectedValue properties of the DropDownList control.
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
|
|
|
|
|
it's
ddl.items.clear();
ddl.items.add(new listitem("Select a Zone", "--")
ddl.items.add(new listitem(Name, Value));
'Check that the selection is not "--" or > 0
string pvalue = ddl.selectedvalue;
insert into table pvalue
and get the selected value of the ddl, not the selected text
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
