ASP.NET Discussion Boards

Re: ObjectDataSource does not display valid BLL classes from BIN folder

zrrbite5-Jul-06 23:53

zrrbite

5-Jul-06 23:53

Hi again, Here's one of the BLL test classes i'm using.

using System;<br />
using System.Collections.Generic;<br />
using System.Text;<br />
using DALTest.EmployeesDataSetTableAdapters;<br />
using DALTest;<br />
<br />
namespace BLL<br />
{<br />
    [System.ComponentModel.DataObject]<br />
    class EmployeesBLL<br />
    {<br />
        private EmployeesTableAdapter _employeesAdapter = null;<br />
<br />
        protected EmployeesTableAdapter Adapter<br />
        {<br />
            get<br />
            {<br />
                if (_employeesAdapter == null)<br />
                    _employeesAdapter = new EmployeesTableAdapter();<br />
<br />
                return _employeesAdapter;<br />
            }<br />
        }<br />
<br />
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select,true)]<br />
        public DALTest.EmployeesDataSet.EmployeesDataTable GetEmployee(int employeeId)<br />
        {<br />
            return Adapter.GetData(employeeId);<br />
        }<br />
<br />
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select,false)]<br />
        public DALTest.EmployeesDataSet.EmployeesDataTable GetEmployeesByCountry(string country)<br />
        {<br />
            return Adapter.GetDataByCountry(country);<br />
        }<br />
<br />
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]<br />
        public bool AddEmployee(string employeeName)<br />
        {<br />
            DALTest.EmployeesDataSet.EmployeesDataTable employees = new DALTest.EmployeesDataSet.EmployeesDataTable();<br />
            DALTest.EmployeesDataSet.EmployeesRow employee = employees.NewEmployeesRow();<br />
            employee.FirstName = employeeName;<br />
            employee.LastName = employeeName;<br />
            employees.AddEmployeesRow(employee);<br />
            int rowsAffected = Adapter.Update(employee);<br />
            return rowsAffected == 1;<br />
        }<br />
<br />
 [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]<br />
        public bool DeleteEmployee(int employeeId)<br />
        {<br />
            int rowsAffected = Adapter.Delete(employeeId, new DateTime());<br />
            return rowsAffected == 1;<br />
        }<br />
<br />
    }<br />
}

Re: ObjectDataSource does not display valid BLL classes from BIN folder

minhpc_bk6-Jul-06 0:06

minhpc_bk

6-Jul-06 0:06

zrrbite wrote:
class EmployeesBLL

Here's the culprit, the class needs to be declared as public.

Re: ObjectDataSource does not display valid BLL classes from BIN folder

zrrbite6-Jul-06 0:17

zrrbite

6-Jul-06 0:17

Wow, what a horrible mistake. I feel stupid Big Grin | :-D

Thanks alot.

Re: ObjectDataSource does not display valid BLL classes from BIN folder

minhpc_bk6-Jul-06 0:26

minhpc_bk

6-Jul-06 0:26

zrrbite wrote:
I feel stupid :

Not at all Smile | :)

, it's because of VS as it by default generates the class template with the default access modifier, and I guess you simply use it.

TreeView in javascripting.

ritu43215-Jul-06 21:05

ritu4321

5-Jul-06 21:05

I want to build a treeview in javascripting. Can anyone please
give me some links or coding for this.

thanks in advance. Laugh | :laugh:

Re: TreeView in javascripting.

DIMPLE_R5-Jul-06 21:22

DIMPLE_R

5-Jul-06 21:22

See if this helps
http://www.codeproject.com/jscript/tree_view.asp

Writing Client Scripting in ASP.Net 2.0

Muhammad Chitrali5-Jul-06 21:00

Muhammad Chitrali

5-Jul-06 21:00

How can i write Client Scripting like JAVASCRIPT in ASP.NET 2.0 Using C#.

Re: Writing Client Scripting in ASP.Net 2.0

lavanya_satheesh5-Jul-06 21:53

lavanya_satheesh

5-Jul-06 21:53

If u ask me there is no need to write in javascript. u just use the code behind.

if u still want to use javascript i think there is some way in the code behind file itself.

u can also include javascript just like u did for normal asp pages. using the <%%> and script tags.

i am not sure abt this. coz i have never used it.

Re: Writing Client Scripting in ASP.Net 2.0

RichardGrimmer6-Jul-06 1:22

RichardGrimmer

6-Jul-06 1:22

lavanya_satheesh wrote:
If u ask me there is no need to write in javascript. u just use the code behind.

Who's a clever boy then - that's quite a trick....how are you doing AJAX?

lavanya_satheesh wrote:
if u still want to use javascript i think there is some way in the code behind file itself.

Kinda - Page.RegisterStartupScript allows you to code the js as text in the codebehind, then squirts it at the page

lavanya_satheesh wrote:
u can also include javascript just like u did for normal asp pages. using the <%%> and script tags.

Except that <%%> will cause it to runat server.

To add some client side js, just add :

<br />
<script language="javascript" type="text/javascript"><br />
code goes here<br />
</script><br />

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

chat

mai20065-Jul-06 20:52

mai2006

5-Jul-06 20:52

how to make chat using asp.net

Re: chat

Muhammad Chitrali5-Jul-06 20:57

Muhammad Chitrali

5-Jul-06 20:57

you can make a Vypress or MSN like chat easily using Windows based form in ASP.Net. There are some good sites that have some source code for download. Search the google.

Re: How do I select column from datagrid?

Vipin Venugopal5-Jul-06 21:29

Vipin Venugopal

5-Jul-06 21:29

Try any of these 3 code. Probably this may help u resolve ur problem

stringVariable = dataGridView.Rows[index].Cells[index].Value.toString();

stringVariable = dataGridView.Rows[index].Cells["ColumnName"].Value.toString();

stringVariable = dataGridView.CurrentRow.Cells[index].Value.toString();

Vipin

Re: How do I select column from datagrid?

blurMember5-Jul-06 21:55

blurMember

5-Jul-06 21:55

How can I achieved that? Unsure | :~

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

wilssmith5-Jul-06 22:32

wilssmith

5-Jul-06 22:32

in the data grid properties make the column as the template column and then add check box inside...

Re: How do I select column from datagrid?

blurMember5-Jul-06 22:40

blurMember

5-Jul-06 22:40

How should I add the check box with the datagrid.

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

_AK_5-Jul-06 22:44

_AK_

5-Jul-06 22:44

here you will get lot of examples on datagrid.
http://www.datagridgirl.com/articles.aspx

Best Regards,
Apurva Kaushal

Re: How do I select column from datagrid?

blurMember5-Jul-06 23:08

blurMember

5-Jul-06 23:08

Thanks. I recall knowing that website through this forum. You reminded me. I hope I will find something useful.

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

Vipin Venugopal5-Jul-06 22:39

Vipin Venugopal

5-Jul-06 22:39

use the code i had mentioned earlier. store that value to a string and the u can use that anywhere u want to.

stringVariable = dataGridView.Rows[index].Cells[index].Value.toString();

Here U give the index of the cell thats is if u want the first cell give as 1 or if u want the second then give it as 2 etc etc.

stringVariable = dataGridView.Rows[index].Cells["ColumnName"].Value.toString();

Here U give the name of the column of the grid

Vipin

Re: How do I select column from datagrid?

blurMember5-Jul-06 22:48

blurMember

5-Jul-06 22:48

My problem earlier was, "how do I select certain column and its data, then pass or transfer it to another page".
Is this method correct? To tell you the truth, its my six week in learning C#.

dataGridView refers to the dgDisplay is it?

thanks in advance. Much appreciated.

Re: How do I select column from datagrid?

Vipin Venugopal5-Jul-06 23:59

Vipin Venugopal

5-Jul-06 23:59

for selecting the entire row create a new tempelate column and add a select button in the created tempelate column.Give a command name "Select" for that button in its properties.end the templelate editing. select the event properties of the grid. go to command name event. give this event as datagrid_commandname. it will take u to the code behind.
give the code as
if(e.CommandName="Select");
{
//write the code i had suggested before;
}
this will help u.

Vipin

QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed

kavithapuranik5-Jul-06 20:39

kavithapuranik

5-Jul-06 20:39

Hi,

im developing a web application using vb.net,where in im creating an excel sheet ,fillin the cells and saving it,
im using windows 2000,and i have installed office 2003.
in my application i have added reference to Excel and microsoft.office.core

in the code ,im using
Imports Excel = Microsoft.Office.Interop.Excel

and in page load ,i have wriiten

Dim excelobj As New Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlsheet As Excel.Worksheet
    Dim i As Int32

  Dim xlApp As Excel.Application
        Dim xlBook As Excel.Workbook
        Dim xlSheet As Excel.Worksheet
        xlApp = CreateObject("Excel.Application")
        xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)
        xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)

        xlSheet.Cells(2, 2) = "This is column B row 2"
        xlSheet.Application.Visible = True
        xlSheet.SaveAs("C:\Test.xls")
        xlApp.Quit()
        xlApp = Nothing

im not getting any error when i compile ,but during execution,i get
"QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed."

Exception Details: System.InvalidCastException: QueryInterface for interface Microsoft.Office.Interop.Excel._Application

failed.

Execption occurs here
xlBook = CType(xlApp.Workbooks.Add, Excel.Workbook)

pls help to solve this error

thanks

kavitha

-- modified at 2:57 Thursday 6th July, 2006

Re: QueryInterface for interface Microsoft.Office.Interop.Excel._Application failed

RichardGrimmer6-Jul-06 1:25

RichardGrimmer

6-Jul-06 1:25

Actually, I'd suggest that it's failing when you try to instantiate the Application object. QueryInterface is a COM call that returns the interfaces avail for a COM Obj. Looks like somewhere it's trying to cast it to an invalid type (needs to be IUnknown)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

processes running in remote system

mehnazash5-Jul-06 20:35

mehnazash

5-Jul-06 20:35

hi,

we can get processes runnug in ones macine using getprocess()
can someone help me to get process running in remote machine
if we use getprocess(), an eror is displyed saying access denied
anybody, anythought of how to get over it??

Thanks
Jiny

How can i get the list of Email clients installed on my computer

sharma sanjeev5-Jul-06 20:32

sharma sanjeev

5-Jul-06 20:32

Hi I want to show a list of Email clients installed on my computer in a list box........can any one help me out to get that list ..........veryyyyyyyyy urgent...i hope this is doable in .net.......

pls reply if u hav any idea or read any article.. pls give link

thanks in advance

happy coding

sanjeev sharma

Generating HTML FROM XML File

King Shez5-Jul-06 20:25

King Shez

5-Jul-06 20:25

HI

I have got the data from CSV file with the help of query in DataSet then from dataset writeXML method i have made the XML File , now i want to Convert this File to HTML.I know i have to do this by XSLT , can any one let me know the solution ASAP , thankx in advace,please guys do remember i have made the XML File from DataSet write XML Method.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.