ASP.NET

DoctorMick9-Jul-09 5:04

DoctorMick

9-Jul-09 5:04

There are 2 obvious ways I can think of....

1 - Store the order date in the database, that way the order numbers don't need to be reset, you can simply provide a screen to display the total number of orders for a given day.
2 - Store the order date and order number in the database against each order. Create a new table called something like currentordernumber, with 2 columns date and nextordernumber, each time you create a new order query this table to get the next order number and update the table to set the nextordernumber +1. If the current date is different to the date in the currentordernumber table update the date in the table and set the order number to 1.

Option 1 is by far the best option IMO.

VivekUtsa9-Jul-09 5:47

VivekUtsa

9-Jul-09 5:47

Thank you DoctorMick for a quick solution.

If I go with Option 1, there is a small issue. I also have to show the "Order Number" to the user so that they can take that to the store with them[Carry Out].

Like 7/9/09 -- orders 1 to 100. Purchaser can go a tell the restaurant for their order number that day.
7/10/09 -- order 1 to 150.

Manas Bhardwaj9-Jul-09 5:59

9-Jul-09 5:59

Well, for that reason you can add another column to the table, lets say OrderNrOfDay.
Every time you insert the order in the table, check if the date today is same as that of the last order. If yes, the increment the OrderNrOfDay else set it to 1.

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.

VivekUtsa9-Jul-09 6:14

VivekUtsa

9-Jul-09 6:14

Thank You Manas

That makes sense, let me try that should fix me.

N a v a n e e t h9-Jul-09 17:45

N a v a n e e t h

9-Jul-09 17:45

That's again problematic. You should take extra care to make the increment atomic as multiple users will be using the web site simultaneously. Your client's idea of resetting the order numbers to 0 each day is plain stupid. In such case, how do you refer to a order? You may need order number and the day order placed.

The option 1 suggested in the other reply is good. I am not getting what is the issue you are facing with that approach?

Smile | :)

Navaneeth

How to use google | Ask smart questions

use one gridview with two tables having no common field?

VivekUtsa11-Jul-09 6:03

VivekUtsa

11-Jul-09 6:03

I accomplished this task by creating another table which has OrderId,OrderNum, Date, OrderNrOfDay. OrderNum is the FK here to PK of orders table.

Then OrderNum from marchant warehouse is always saved in database and for clients sake generating daily order numbers starting from 1 to so on and for records we have OrderNum.

This solved the issue.

shankbond9-Jul-09 4:36

shankbond

9-Jul-09 4:36

Hi,

Guys I have a peculiar problem here, I need to display data from two tables having no fields at all common and want to display them in one gridview on the click of a radio button .

If radiobuttton(1) is selected then data from table one will be displayed and if radiobuttton(2) is selected then data from table two will be displayed.

each of the table is having field name as:

table(1)

fname lname mname abid

table(2)

fname lname mname cdid

is there some advice you guys can help me?

thanks

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

Christian Graus9-Jul-09 4:39

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

9-Jul-09 4:39

this seems easy enough to me. Change the data source of the gridview on the event of the radio button being clicked

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.

shankbond9-Jul-09 5:39

shankbond

9-Jul-09 5:39

Hi Chris,

The problem is that even if I change the data sources ,the gridview which I am using has only one name(name of the coloumn here) so how will the grid view show second table's data?

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

Re: Create select stored procedure and create connection string

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.

Manas Bhardwaj9-Jul-09 3:21

Re: Create select stored procedure and create connection string

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.

Christian Graus9-Jul-09 3:26

Re: Create select stored procedure and create connection string

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.

Manas Bhardwaj9-Jul-09 3:17

Re: Create select stored procedure and create connection string

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.

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

Re: asp.NET connection string and list

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.

Manas Bhardwaj9-Jul-09 3:25

problem in attaching files in mail

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.

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