473,598 Members | 3,324 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Displaying Stored Procedures using Grid View

Hi,

using .net 2
sql server 2005

Here is my situation:

I'm passing a variable in the url from a selection on Page A and need
to display the results on the Results page be based on that variable
in the url. I would like that variable to trigger a stored and
display information in formView or Grid View. Whats the best way to
accomplish this?

Page A

This is passing var from grid view:
<asp:HyperLinkF ield DataTextField=" Open Issues"
DataNavigateUrl Fields="Ticket Number"
DataNavigateUrl FormatString="r esults2.aspx?{0 }" Target="_blank"
HeaderText="Ope n Issues" />

Results Page

<asp:FormView ID="FormView1" runat="server" DataKeyNames="T icket
Number"
DataSourceID="S qlDataSource1"
OnPageIndexChan ging="FormView1 _PageIndexChang ing">
<EditItemTempla te>
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel1" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:TextBox ID="Technician_ AssignedTextBox "
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:TextBox><br />
Issue Description:
<asp:TextBox ID="Issue_Descr iptionTextBox"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:TextBox><br />
Open Date:
<asp:TextBox ID="Open_DateTe xtBox" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:TextBox><br />
Work Notes:
<asp:TextBox ID="Work_NotesT extBox" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="UpdateButto n" runat="server"
CausesValidatio n="True" CommandName="Up date"
Text="Update">
</asp:LinkButton>
<asp:LinkButt on ID="UpdateCance lButton"
runat="server" CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplat e>
<InsertItemTemp late>
Ticket Number:
<asp:TextBox ID="Ticket_Numb erTextBox"
runat="server" Text='<%# Bind("[Ticket Number]") %>'>
</asp:TextBox><br />
Technician Assigned:
<asp:TextBox ID="Technician_ AssignedTextBox "
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:TextBox><br />
Issue Description:
<asp:TextBox ID="Issue_Descr iptionTextBox"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:TextBox><br />
Open Date:
<asp:TextBox ID="Open_DateTe xtBox" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:TextBox><br />
Work Notes:
<asp:TextBox ID="Work_NotesT extBox" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="InsertButto n" runat="server"
CausesValidatio n="True" CommandName="In sert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButt on ID="InsertCance lButton"
runat="server" CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTempl ate>
<ItemTemplate >
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:Label ID="Technician_ AssignedLabel"
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:Label><br />
Issue Description:
<asp:Label ID="Issue_Descr iptionLabel"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:Label><br />
Open Date:
<asp:Label ID="Open_DateLa bel" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:Label><br />
Work Notes:
<asp:Label ID="Work_NotesL abel" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:Label><br />
</ItemTemplate>
</asp:FormView>

May 6 '07 #1
12 4699
On May 6, 6:29 pm, brwalias <brwal...@gmail .comwrote:
Hi,

using .net 2
sql server 2005

Here is my situation:

I'm passing a variable in the url from a selection on Page A and need
to display the results on the Results page be based on that variable
in the url. I would like that variable to trigger a stored and
display information in formView or Grid View. Whats the best way to
accomplish this?

Page A

This is passing var from grid view:
<asp:HyperLinkF ield DataTextField=" Open Issues"
DataNavigateUrl Fields="Ticket Number"
DataNavigateUrl FormatString="r esults2.aspx?{0 }" Target="_blank"
HeaderText="Ope n Issues" />

Results Page

<asp:FormView ID="FormView1" runat="server" DataKeyNames="T icket
Number"
DataSourceID="S qlDataSource1"
OnPageIndexChan ging="FormView1 _PageIndexChang ing">
<EditItemTempla te>
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel1" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:TextBox ID="Technician_ AssignedTextBox "
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:TextBox><br />
Issue Description:
<asp:TextBox ID="Issue_Descr iptionTextBox"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:TextBox><br />
Open Date:
<asp:TextBox ID="Open_DateTe xtBox" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:TextBox><br />
Work Notes:
<asp:TextBox ID="Work_NotesT extBox" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="UpdateButto n" runat="server"
CausesValidatio n="True" CommandName="Up date"
Text="Update">
</asp:LinkButton>
<asp:LinkButt on ID="UpdateCance lButton"
runat="server" CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</EditItemTemplat e>
<InsertItemTemp late>
Ticket Number:
<asp:TextBox ID="Ticket_Numb erTextBox"
runat="server" Text='<%# Bind("[Ticket Number]") %>'>
</asp:TextBox><br />
Technician Assigned:
<asp:TextBox ID="Technician_ AssignedTextBox "
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:TextBox><br />
Issue Description:
<asp:TextBox ID="Issue_Descr iptionTextBox"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:TextBox><br />
Open Date:
<asp:TextBox ID="Open_DateTe xtBox" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:TextBox><br />
Work Notes:
<asp:TextBox ID="Work_NotesT extBox" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:TextBox><br />
<asp:LinkButt on ID="InsertButto n" runat="server"
CausesValidatio n="True" CommandName="In sert"
Text="Insert">
</asp:LinkButton>
<asp:LinkButt on ID="InsertCance lButton"
runat="server" CausesValidatio n="False" CommandName="Ca ncel"
Text="Cancel">
</asp:LinkButton>
</InsertItemTempl ate>
<ItemTemplate >
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:Label ID="Technician_ AssignedLabel"
runat="server" Text='<%# Bind("[Technician Assigned]") %>'>
</asp:Label><br />
Issue Description:
<asp:Label ID="Issue_Descr iptionLabel"
runat="server" Text='<%# Bind("[Issue Description]") %>'>
</asp:Label><br />
Open Date:
<asp:Label ID="Open_DateLa bel" runat="server"
Text='<%# Bind("[Open Date]") %>'>
</asp:Label><br />
Work Notes:
<asp:Label ID="Work_NotesL abel" runat="server"
Text='<%# Bind("[Work Notes]") %>'>
</asp:Label><br />
</ItemTemplate>
</asp:FormView>
The SqlDataSource Control has a SelectParameter section where you can
specify parameters for your query. There is the QueryStringPara meter
section used to bind the values of the query string to a parameter
used in a parameterized query.

So, your code would be as the follows

<asp:SqlDataSou rce ID="SqlDataSour ce1"
SelectCommand=" SELECT .... WHERE state=@state"
....>
<SelectParamete rs>
<asp:QueryStrin gParameter Name="state" QueryStringFiel d="state" />
</SelectParameter s>
</asp:SqlDataSour ce>

Where:

Name is the name of @parameter
QueryStringFiel d is the key section of the QueryString

Note, usage of the QueryStringPara meter does not perform any
validation of input from the client and the real best way to
accomplish this is the code-behind model.

The QueryStringPara meter does not validate the value passed by the
query string in any way; it uses the raw value. In

May 6 '07 #2
On May 6, 8:53 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :
>
The QueryStringPara meter does not validate the value passed by the
query string in any way; it uses the raw value. In- Hide quoted text -
Too quick on send button: The QueryStringPara meter does not validate
the value passed by the query string in any way; it uses the raw
value. In most cases you can validate the value of the
QueryStringPara meter before it is used by a data source control by
handling an event, such as the Selecting, Updating, Inserting, or
Deleting event exposed by the data source control you are using. If
the value of the parameter does not pass your validation tests, you
can cancel the data operation by setting the Cancel property of the
associated CancelEventArgs class to true.

http://msdn2.microsoft.com/en-us/lib...er(VS.80).aspx
May 6 '07 #3
Page A:

This is a hyper link which represents ticketid generated from sql that
the user will click on to view row. once clicked, a new window needs
to open with additional details from that row stored in a stored
procedure.

<asp:HyperLinkF ield DataTextField=" Open Issues"
DataNavigateUrl Fields="Ticket Number"
DataNavigateUrl FormatString="r esults2.aspx?ti cketid={0}"
Target="_blank" HeaderText="Ope n Issues" />

--------------------------

var seems to pass as i have it printing on the results page just to
confirm. I have also added the details view as follows:

<asp:DataList ID="DataList1" runat="server" DataKeyField="T icket
Number" DataSourceID="S qlDataSource1">

<ItemTemplate >
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:Label ID="Technician_ AssignedLabel"
runat="server" Text='<%# Eval("[Technician Assigned]") %>'>
</asp:Label><br />
Issue Description:
<asp:Label ID="Issue_Descr iptionLabel"
runat="server" Text='<%# Eval("[Issue Description]") %>'>
</asp:Label><br />
Open Date:
<asp:Label ID="Open_DateLa bel" runat="server"
Text='<%# Eval("[Open Date]") %>'>
</asp:Label><br />
Work Notes:
<asp:Label ID="Work_NotesL abel" runat="server"
Text='<%# Eval("[Work Notes]") %>'>
</asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList><a sp:SqlDataSourc e ID="SqlDataSour ce1"
runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:webhelp2Conn ectionString %>"
SelectCommand=" sp_dticket"
SelectCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="ticketid"
QueryStringFiel d="ticketid" />
</SelectParameter s>
</asp:SqlDataSour ce>

--------------------------------------------

Stored procedure i'm using:

Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)
set @Technician=(SE LECT email

FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assi gned_tech_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20)))

SELECT job_ticket.job_ ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_t icket.subject 'Issue Description',
report_date 'Open Date',tech_note .note_text 'Work Notes'

FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_t icket_Id =
job_ticket.job_ ticket_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20))
the query works as it should in sql but once i bring it into vs web
developer the browser gives me errors. It just need the details view
on the results page to pull the sp from sql based off the var being
passed in the url.

Thanks again,

Bryan

May 7 '07 #4
On May 6, 11:57 am, Alexey Smirnov <alexey.smir... @gmail.comwrote :
On May 6, 8:53 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :
The QueryStringPara meter does not validate the value passed by the
query string in any way; it uses the raw value. In- Hide quoted text -

Too quick on send button: The QueryStringPara meter does not validate
the value passed by the query string in any way; it uses the raw
value. In most cases you can validate the value of the
QueryStringPara meter before it is used by a data source control by
handling an event, such as the Selecting, Updating, Inserting, or
Deleting event exposed by the data source control you are using. If
the value of the parameter does not pass your validation tests, you
can cancel the data operation by setting the Cancel property of the
associated CancelEventArgs class to true.

http://msdn2.microsoft.com/en-us/lib...webcontrols.qu...


Page A:

This is a hyper link which represents ticketid generated from sql that
the user will click on to view row. once clicked, a new window needs
to open with additional details from that row stored in a stored
procedure.

<asp:HyperLinkF ield DataTextField=" Open Issues"
DataNavigateUrl Fields="Ticket Number"
DataNavigateUrl FormatString="r esults2.aspx?ti cketid={0}"
Target="_blank" HeaderText="Ope n Issues" />

--------------------------

var seems to pass as i have it printing on the results page just to
confirm. I have also added the details view as follows:

<asp:DataList ID="DataList1" runat="server" DataKeyField="T icket
Number" DataSourceID="S qlDataSource1">

<ItemTemplate >
Ticket Number:
<asp:Label ID="Ticket_Numb erLabel" runat="server"
Text='<%# Eval("[Ticket Number]") %>'>
</asp:Label><br />
Technician Assigned:
<asp:Label ID="Technician_ AssignedLabel"
runat="server" Text='<%# Eval("[Technician Assigned]") %>'>
</asp:Label><br />
Issue Description:
<asp:Label ID="Issue_Descr iptionLabel"
runat="server" Text='<%# Eval("[Issue Description]") %>'>
</asp:Label><br />
Open Date:
<asp:Label ID="Open_DateLa bel" runat="server"
Text='<%# Eval("[Open Date]") %>'>
</asp:Label><br />
Work Notes:
<asp:Label ID="Work_NotesL abel" runat="server"
Text='<%# Eval("[Work Notes]") %>'>
</asp:Label><br />
<br />
</ItemTemplate>
</asp:DataList><a sp:SqlDataSourc e ID="SqlDataSour ce1"
runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:webhelp2Conn ectionString %>"
SelectCommand=" sp_dticket"
SelectCommandTy pe="StoredProce dure">
<SelectParamete rs>
<asp:QueryStrin gParameter Name="ticketid"
QueryStringFiel d="ticketid" />
</SelectParameter s>
</asp:SqlDataSour ce>

--------------------------------------------

Stored procedure i'm using:

Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)
set @Technician=(SE LECT email

FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assi gned_tech_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20)))

SELECT job_ticket.job_ ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_t icket.subject 'Issue Description',
report_date 'Open Date',tech_note .note_text 'Work Notes'

FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_t icket_Id =
job_ticket.job_ ticket_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20))
the query works as it should in sql but once i bring it into vs web
developer the browser gives me errors. It just need the details view
on the results page to pull the sp from sql based off the var being
passed in the url.

Thanks again

May 7 '07 #5
On May 7, 11:27 pm, brwalias <brwal...@gmail .comwrote:
>
the query works as it should in sql but once i bring it into vs web
developer the browser gives me errors. It just need the details view
on the results page to pull the sp from sql based off the var being
passed in the url.
The code you have posted here a T-SQL, do you mean that it is created
as a stored procedure in the database?

CREATE PROCEDURE ...

What is the "sp_dticket "?

May 7 '07 #6
On May 7, 2:48 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :
On May 7, 11:27 pm,brwalias<brw al...@gmail.com wrote:
the query works as it should in sql but once i bring it into vs web
developer the browser gives me errors. It just need the details view
on the results page to pull the sp from sql based off the var being
passed in the url.

The code you have posted here a T-SQL, do you mean that it is created
as a stored procedure in the database?

CREATE PROCEDURE ...

What is the "sp_dticket "?
Yes you are correct, we created sp_dticket as a stored procedure in
the database.

May 7 '07 #7
On May 7, 3:00 pm, brwalias <brwal...@gmail .comwrote:
On May 7, 2:48 pm, Alexey Smirnov <alexey.smir... @gmail.comwrote :
On May 7, 11:27 pm,brwalias<brw al...@gmail.com wrote:
the query works as it should in sql but once i bring it into vs web
developer the browser gives me errors. It just need the details view
on the results page to pull the sp from sql based off the var being
passed in the url.
The code you have posted here a T-SQL, do you mean that it is created
as a stored procedure in the database?
CREATE PROCEDURE ...
What is the "sp_dticket "?

Yes you are correct, we created sp_dticket as a stored procedure in
the database.
here is the stored procedure:

Stored procedure i'm using:

Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)

set @Technician=(SE LECT email

FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assi gned_tech_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20)))

SELECT job_ticket.job_ ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_t icket.subject 'Issue Description',
report_date 'Open Date',tech_note .note_text 'Work Notes'

FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_t icket_Id =
job_ticket.job_ ticket_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20))

May 7 '07 #8
On May 8, 12:00 am, brwalias <brwal...@gmail .comwrote:
>
Yes you are correct, we created sp_dticket as a stored procedure in
the database.
Well, but the following code does then?

Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)

when you have the following code:

<asp:QueryStrin gParameter Name="ticketid"
QueryStringFiel d="ticketid" />

you mean that the ticketid has to be the input parameter of the stored
procedure. And here as I see you do "Declare @ticketid", it means you
create a new parameter inside(?) the stored procedure

Please post the complete code of the sp_dticket here (starting CREATE
PROCEDURE...)
I want to look on it.

Thanks!

May 7 '07 #9
On May 8, 12:10 am, brwalias <brwal...@gmail .comwrote:
>
here is the stored procedure:

Stored procedure i'm using:

Declare @ticketid as varchar (20)
Declare @Technician as varchar (20)

set @Technician=(SE LECT email

FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assi gned_tech_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20)))

SELECT job_ticket.job_ ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_t icket.subject 'Issue Description',
report_date 'Open Date',tech_note .note_text 'Work Notes'

FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_t icket_Id =
job_ticket.job_ ticket_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20))- Hide quoted text -
Bryan, sorry it is not the stored procedure :-)

The real stored procedure should look like

---------------------------------------------
CREATE PROCEDURE dbo.sp_dticket
(
@ticketid as varchar(20)
)
AS

Declare @Technician as varchar (20)

set @Technician=(SE LECT email

FROM dbo.tech INNER JOIN dbo.job_ticket ON tech.client_id =
job_ticket.assi gned_tech_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20)))

SELECT job_ticket.job_ ticket_id 'Ticket Number', @Technician
'Technician Assigned',job_t icket.subject 'Issue Description',
report_date 'Open Date',tech_note .note_text 'Work Notes'
FROM job_ticket INNER JOIN dbo.tech_note ON tech_note.job_t icket_Id =
job_ticket.job_ ticket_id WHERE job_ticket.job_ ticket_id =Cast
(@ticketid as varchar (20))

GO
---------------------------------------------

You should execute this code to create the procedure.

Once created you can test it as

EXEC sp_dticket 'yourtestticket id'

May 7 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
6576
by: Jarrod Morrison | last post by:
Hi all Im relatively new to using stored procedures and im not sure if it is possible to do what I am trying to do so any help here is greatly appreciated. I am using the variable @MachineName which is obviously the local machine name mainly in this procedure. What is loop through from the first character of the variable to the last and use this data in a select statement. I have included the code below for what I have tried so far but I...
1
1662
by: rdshultz | last post by:
Good morning everyone. Could someone tell me if there is a book out there which gives examples of both VB.net code and creating SQL Server 2000 stored procedures and how you get them to work together in the most efficient way. Right now we have a server at our Philadelphia office and I am in our St. Louis office we are connected with a T1 line. We have several Access 2000 applications on the Philly server but when you try to run them...
0
2567
by: billmiami2 | last post by:
Perhaps many of you MS Access fanatics already know this, but it seems that stored procedures and views are possible in Jet. I thought I would leave this message just in case it would help anyone. I discovered this the other day while doing some experiments with ADO and ADO.NET. Basically, I wanted to run a stored MS Access query with parameters using the syntax Execute MyProcedure @Param1, @Param2...
5
3468
by: Tim Marshall | last post by:
I was following the thread "Re: Access Treeview - Is it Safe Yet?" with interest and on reading the post describing Lauren Quantrell's SmartTree, I've run into something I don't understand: Stored Procedures. I thought stored pricedures were an Oracle/MS SQL Server thing and don't know how they work with Access Jet. I've looked at some of the help on stored procedures in A2003, but really don't understand what's going on. Can someone...
1
2156
by: mimo | last post by:
Hi, I'm trying to use Stored Procedures with a Grid View and everytime I try the update and the delete stored procedures fail. By the way I am doing this through the wizard. Is there a sample somewhere on how to do this? When I type in the statements directly it works, but I really need to be able to call stored procedures. And the stored procedures work fine in query analyzer.
28
72415
by: mooreit | last post by:
The purpose for my questions is accessing these technologies from applications. I develop both applications and databases. Working with Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test Environments. What is the purpose of a view if I can just copy the vode from a view and put it into a stored procedure? Should I be accessing views from stored procedures?
12
2291
by: Jason Huang | last post by:
Hi, In my C# Windows Form application project, I have done all queries on my codes. Now I wanna try using the Stored Procedure. But I am not clear about why using the stored procedure. Would some one give me some advice? Thanks for help.
1
4164
by: mandible | last post by:
Hello I was wondering if I"m doing something wrong with using db2advis I have 2 stored procedures are are massive, I created an input file to call both of these stored procedures and I dont' seem to get any index help, but if I put the main body of these stored procs in a view and do a select * from that view I get a tonne of index help. this is my input file I have run it with the views uncommented and get great results but I really...
0
1406
by: vanesa | last post by:
Hi, In a client we must begin to program many stored procedures of DB2. The following doubts arise to me that I raise you to see if you can help me: 1. From a point of view of the programming: I need some document or manual (preferably in Spanish) that explains rules on like programming a procedure stored so that their yield is optimal, like structuring it (for example, if he is better to do several procedures stored small or is better to...
0
7902
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8395
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8265
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5438
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3898
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3939
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2412
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1504
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1250
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.