Re: Create select stored procedure and create connection string - ASP.NET Discussion Boards

First Prev Next

Re: use one gridview with two tables having no common field?

shankbond10-Jul-09 1:34

shankbond

10-Jul-09 1:34

each of the table is having field name as:

table(1)

fname lname mname abid

table(2)

fname lname mname cdid

gridview

fname lname mname abid

Now as you can see the gridview has a field name abid and this field is databound that is it has to have the same name as that with the respective table, so by my limited knowledge this gridview will show only one table's data but I want to display data of two tables in one gridview.

Is there a way out from this problem?

Re: use one gridview with two tables having no common field?

Zafar A khan 10-Jul-09 19:27

Zafar A khan

10-Jul-09 19:27

you have to change in select Query Like this .

for table(1) use the following Query.

select fname,lname,mname,abid from table(1)

and for table(2) the select Query will be.

select fname,lname,mname,cdid as abid from table(2)

now u have the same column name for both tables.

and if u want to change the headerText text of the column with condition of radio buttons.
after data bound like this.

GridView1.DataBind();

if (RadioButtonList1.SelectedValue == "one")
{
GridView1.Columns[3].HeaderText = "abid";
}
else
{
GridView1.Columns[3].HeaderText = "cdid";
}

Create select stored procedure and create connection string

Mix Wheels9-Jul-09 3:08

Mix Wheels

9-Jul-09 3:08

How to select and return more than one values using select stored procedure.
How to configure login control using wizard.
How to edit connection string at configuration file or how to change database name, server name, username nad password.

Re: Create select stored procedure and create connection string

Christian Graus9-Jul-09 3:15

Christian Graus

9-Jul-09 3:15

I think you need to read my article on how to use google. Or perhaps try asking detailed, intelligent questions. You've asked three very different things. In each case, I have to ask, where are you stuck ? Do you not have any books on ASP.NET ? Do you not have access to google ? Have you tried reading some articles on the site ?

What have you tried ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Create select stored procedure and create connection string

Manas Bhardwaj9-Jul-09 3:21

Manas Bhardwaj

9-Jul-09 3:21

Christian Graus wrote:
I think you need to read my article on how to use google

I feel that people just post a question at CP and go for a coffee break.
And boy, they have the answer by the time they come back.
So, it like why should I take any pains when someone else can do it for them. Sigh | :sigh:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Create select stored procedure and create connection string

Christian Graus9-Jul-09 3:26

Christian Graus

9-Jul-09 3:26

It sure looks that way.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Create select stored procedure and create connection string

Manas Bhardwaj9-Jul-09 3:17

Manas Bhardwaj

9-Jul-09 3:17

I would rather suggest to buy a beginners’ book and start reading.
The questions you have asked are very basic and it would be difficult for you to continue with the task.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Create select stored procedure and create connection string

Sun Rays9-Jul-09 3:30

Sun Rays

9-Jul-09 3:30

Hi,

Mix Wheels wrote:
How to select and return more than one values using select stored procedure.

ANS 1 : Ans1[^]

Mix Wheels wrote:
How to configure login control using wizard.

ANS 2 : Ans2[^]

Mix Wheels wrote:
How to edit connection string at configuration file or how to change database name, server name, username nad password.

ANS 3 : Ans3[^]

See and try using the same method from GOOGLE and then post questions when you have any errors or if you stuck anywhere.

Hope you got it....
Cool | :cool:

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

Deploy report via code

mehrdadc489-Jul-09 2:43

mehrdadc48

9-Jul-09 2:43

Hi everybody,
I've written this code for publish reports on ReportServer.Everything is ok, but if I have SharedDataSource it says:
---------------------------
The dataset ‘NewDT’ refers to the shared data source ‘NewDT’, which is not published on the report server.
---------------------------
what's wrong?

Dim TmpEncoding As New System.Text.UTF8Encoding
        Dim TmpReportDefinition() As Byte = TmpEncoding.GetBytes(PRdl)

        Dim TmpWarnings() As Warning = TmpRsProxy.CreateReport(PReportName, PParentPath, True, TmpReportDefinition, Nothing)

        Dim TmpDataSources As DataSource() = TmpRsProxy.GetItemDataSources(PParentPath & "/" & PReportName)

        For Each TmpDataSource As DataSource In TmpDataSources

            Dim dSource As New DataSource
            Dim dDefinition As New DataSourceDefinition()
            dSource.Item = dDefinition
            dDefinition.Extension = "Sql"
            dDefinition.ConnectString = "Data Source=" + ClsSetting.DbServerName + ";Initial Catalog=" + ClsSetting.DbName
            dDefinition.ImpersonateUserSpecified = True
            dDefinition.Prompt = Nothing
            dDefinition.WindowsCredentials = True
            dDefinition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
            dSource.Name = TmpDataSource.Name

            Try

                TmpRsProxy.CreateDataSource(dSource.Name, ClsSetting.DataSourceLocation, True, dDefinition, Nothing)

                If TypeOf (TmpDataSource.Item) Is DataSourceReference Then

                    Dim DsReference As New DataSourceReference()
                    Dim ds As New DataSource
                    DsReference.Reference = ClsSetting.DataSourceLocation + "/" + dSource.Name
                    Dim DataSources() As DataSource = TmpRsProxy.GetItemDataSources(PParentPath & "/" & PReportName)
                    ds = DataSources(0)
                    ds.Item = CType(DsReference, DataSourceReference)
                    ds.Name = TmpDataSource.Name
                    TmpRsProxy.SetItemDataSources(PParentPath + "/" + PReportName, DataSources)
                End If

            Catch ex As System.Web.Services.Protocols.SoapException
                Throw ex
            End Try
        Next
</pre> 

<div class="ForumSig">Best wishes</div>

Re: Deploy report via code

Sun Rays9-Jul-09 3:32

Sun Rays

9-Jul-09 3:32

Hey,
here is one solution you may need the same.

Try it[^]

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

asp.NET connection string and list<perametertype></perametertype>

Phumlani Kunene9-Jul-09 2:39

Phumlani Kunene

9-Jul-09 2:39

How to add database name, server name, username, password to the connection string configuration file when you compiling the website.
And How to convert from object of class where you add parameter to the list<perametertype>. Confused | :confused:

Phumlani Sandile Kunene
Country South Afica
Province KwaZulu Natal
City Vryheid
Township Emvuyane, eS'mashwini
Room number 540

Re: asp.NET connection string and list

Christian Graus9-Jul-09 3:14

Christian Graus

9-Jul-09 3:14

I don't understand the question. When you compile is not the time to add to the config file.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: asp.NET connection string and list

Manas Bhardwaj9-Jul-09 3:25

Manas Bhardwaj

9-Jul-09 3:25

Phumlani Kunene wrote:
How to add database name, server name, username, password to the connection string configuration file when you compiling the website.

This one[^] tells you every thing about Connections Strings

Phumlani Kunene wrote:
And How to convert from object of class where you add parameter to the list.

What to you want to convert?

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

problem in attaching files in mail

souravghosh189-Jul-09 2:20

souravghosh18

9-Jul-09 2:20

In my application i want to attach a file of (.xls) type.which is created from a grid view.how to achieve it.

Re: problem in attaching files in mail

Christian Graus9-Jul-09 2:35

Christian Graus

9-Jul-09 2:35

Not sure how this is ASP.NET related, but, how are you sending email, that this isn't easy ? I just add to the Attachments collection on the mail class.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: problem in attaching files in mail

Sun Rays9-Jul-09 2:44

Sun Rays

9-Jul-09 2:44

Hi,
if you are having any file.
You can use This[^] links to get your answer..

Thanks,
Sun Rays

To get something you must have to try once.

My Articles

update on linkbutton click

vikas shukla9-Jul-09 1:20

vikas shukla

9-Jul-09 1:20

suppose i have a gridview and it contain 3 column first column contain userid,second column contain linkbutton and third column contain text locked but it is not visible.and now i want update user information of locked on clicking linkbutton.
how is it possible?
please help me.

Re: update on linkbutton click

Christian Graus9-Jul-09 2:08

Christian Graus

9-Jul-09 2:08

I don't think I understand your question. you seem to me to be asking how to update some text on a click event. How is that hard ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: update on linkbutton click

Sun Rays9-Jul-09 2:42

Sun Rays

9-Jul-09 2:42