copy sheets one work book to other work book using open xml in windows azure - ASP.NET Discussion Boards

i have a lot of controls in a webpage like buttons labels and textbox,,,and in the bottom page i kept one grid view..while in run time i kept hide the gridview during the page load,if the button view is clicked,i want to disable the textboxes and labels and buttons which i kept in the top page,and replace that in gridview controls..i did it but gridview is displayed in bottom page only,,it will appear in the top of the page..can u pls help

Wrap all of the controls at the top in one div and the grid in another. Use a bit of javascript to hide the top div and move the lower up to the top is one way to do it.

You could also use an asp:Panel to surround each and set the visibility of the top one to false on PostBack.

I'm sure there are other ways to do this but these should get you going.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

You can place the grid into one div tag
and specify the position: absolute and specify the location where do you want to display the grid.

and make the div visible true false on the basis of the requirement

what is different between DataAdapter.Update() and Dataset AcceptChange() in ADO.Net??

AcceptChanges is used to update the dataset while Update method is used to update the database.

The Update method of the DataAdapter is called to resolve changes from a DataSet back to the data source. The Update method, like the Fill method, takes as arguments an instance of a DataSet, and an optional DataTable object or DataTable name. The DataSet instance is the DataSet that contains the changes that have been made, and the DataTable identifies the table from which to retrieve the changes.

Whereas

Calling AcceptChanges on the DataSet, DataTable, or DataRow causes all Original values for a DataRow to be overwritten with the Current values for the DataRow. If the field values that identify the row as unique have been modified, after calling AcceptChanges the Original values will no longer match the values in the data source. AcceptChanges is called automatically for each row during a call to the Update method of a DataAdapter.

Details here: MSDN: Updating Data Sources with DataAdapters[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Needed help inorder to implement a component that facilitates SFTP in .NET.A normal FTP component can be implemented using in-built .NET Libraries. Thumbs Up | :thumbsup:

Alesha Mary Milred Fernandes

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.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

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 Suspicious | :suss:

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 Suspicious | :suss:

if you can't read my code, try converting it here[^]