|
|
|
Good Morning All
i have a Table
===================
DESCR CYCLE
===================
Rendle C | 5 |
Reid M Prof | 9 |
Randall S Ms | 3 |
Reid M Prof | 3 |
Rendall G Mr | 3 |
Rendle C | 3 |
Rendall G Mr | 2 |
===================
Now as you can see "Rendle C" and "Rendall G Mr" appears Twice, now i want append the cyle field if the descr appears twice, the above list should now look like this
===================
DESCR CYCLE
===================
Rendle C | 5 3 |
Reid M Prof | 9 3 |
Rendall G Mr | 3 2 |
===================
How can i do this in SQl
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
AS you said, this is a SQL question. It belongs in the SQL forum. But, one question - will you know for sure that each Descr will have the same number of entries ? You may want to do this in code, depending on how big the data set is.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Good Morning Chris
Am very Very Sorry for Posting this question here. i should better than. Please move it for me to the SQL Forum.
Christian : wrote
will you know for sure that each Descr will have the same number of entries ?
No, What am trying to achieve is that if the Field Descr appears more than once , take the Cycles and Append them
e.g if i have this
Descr | cycle
===============
James | 4
James | 3
Now if its like this i want to add the Cyles field
like this
Descr | cycle
===============
James | 4 3
Please note that this is not a Duplicate, am refining an old Functionality that used to Display them in a Grid. The Dataset will not be big. But i thought i should some manipulation in SQL, because at the end i will be displaying this on a Grid.
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
If the number of columns is going to be arbitrary, I really think your best bet is to get a single datatable, in the form you're getting it now, and then build the data in memory in a format that will bind to a repeater or grid.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hope this will help you
CREATE FUNCTION dbo.fn_Join_Cycles
(
@V_DESCR VARCHAR(20)
)
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @V_ConCat_Cycles varChar(1000)
SET @V_ConCat_Cycles = ''
SELECT @V_ConCat_Cycles = @V_ConCat_Cycles + ' ' + STR(CYCLE)
FROM YOURTABLE
WHERE DESCR = @V_DESCR
RETURN @V_ConCat_Cycles
END
SELECT DESCR, dbo.fn_Join_Cycles(DESCR)
FROM YOURTABLE
GROUP BY DESCR
|
|
|
|
|
Hi all,
I have to show a popup message in every page when a new customer added into my site (developing).When a page loads it shows a message with fadeIn effect and the user close the message with fadeOut effect....
Placed the label box and close button inside a div
<div class="close" id="fadediv" style="background-color:#FFF8E6; border:1px solid #ECC975 ; font-size:16px;">
<asp:Label ID="lblMessage" runat="server" />
<img src="images/close.gif" alt="" onclick="fadeOut('fadediv',20,500);"></div>
How to show?....I am trying but it every time shows all the label boxes...
Give some example sites....I will try...
Thanks in Advance
|
|
|
|
|
I assume there's a fadeIn method, so you want to call that, right ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
|
You can use AJAX Modal Popup Extender.
Either you love IT or leave IT...
|
|
|
|
|
Hi All, On my page, if data is not found, i want to redirect my page to some customized page ( saying data not found) with a status code 404 so that google dont crawl it. I am using following code - Response.Clear(); Response.Status = "404 not found."; Response.StatusCode = 404; Response.AddHeader( "Location", "error.htm"); Response.RedirectLocation= "/error.htm"; It sets my page status to 404 but doesnt redirect to "error.htm", however this code works for 301 & 302 redirection. If anyone have idea, please help me out.
anujsharma
|
|
|
|
|
anuj_24mar@yahoo.com wrote: It sets my page status to 404 but doesnt redirect to "error.htm"
I assume it redirects to the page which is configured in IIS. If yes, you need to change this to error.htm in IIS settings.
|
|
|
|
|
When running a tutorial project on LINQ, I'm getting an error:
The table name property of LinqDataSource 'LinqDataSource1' must specify a table property or field on the data context type.
I tried to set the TableName property to RegClient, which is the name of the actual table name of the database created within the project, however, VS does not seem to recognize it. From the horizontal dropdown next to LinqDataSource1.TableName the table name does not show up, which might mean that it was not configured.
Any ideas?
NOTE: Cannot paste code directly due to a network problem on the VM where the code resides.
Reference book
ASP.NET 3.5 - A Beginner's Guide written by William B. Sanders (2009).
Jon
|
|
|
|
|
jon_80 wrote: When running a tutorial project on LINQ, I'm getting an error:
The table name property of LinqDataSource 'LinqDataSource1' must specify a table property or field on the data context type.
Can you please put the line of code?
|
|
|
|
|
If you use object of Table class, it is must to provide the actual table map attribute on the header.
I think the DBML you made doesnt have the actual tables in the database. Just change the connectionstring and create the table structure as mentioned in the DBML.
This error will wiped out automatically....
|
|
|
|
|
I'm going through a tutorial which mentions the use of:
<br />
1. <asp: Label ID="myLabel" runat="server" Text=<%# boundMessage() %/><br />
This does not seem to compile. Error message: <br />
Attribute values must be enclosed in quotation marks.<br />
<br />
2. <%DataBinder.Eval (Container.DataItem, "SupID" %><br />
This does not compile. Error message:<br />
The name 'Container does not exist in the current context'<br />
<br />
3. When I use the following connection string, I get an error from SQL Server, only on DELETE <br />
statements:<br />
hookUp = new SqlConnection("Database=localhost\\$INSTANCENAME; Database=$DATABASE_NAME; Integrated Security = True".<br />
<br />
I resolved this by using the connection string generated by Visual Studio and the code compiled fine (lazy fashion), however, I could not understand how the same connection string returned no errors with<br />
SQL UPDATE and SELECT statements.<br />
<br />
Reference book
ASP.NET 3.5 - A Beginner's Guide written by William B. Sanders (2009).
Jon
|
|
|
|
|
jon_80 wrote: Attribute values must be enclosed in quotation marks.
Correct.
Text="<%# boundMessage() %>"
jon_80 wrote: The name 'Container does not exist in the current context'
I assume this code exists outside of a bound control. Actually, I think you need to use <%# or <%= ( I forget which )
jon_80 wrote: When I use the following connection string, I get an error from SQL Server, only on DELETE
statements:
And what is the error ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Well, I tried
<asp:Label ID="BindMe" runat="server" Text=<%= boundMessage() %/> to no avail, because VS generated the following error:
Server tags cannot contain <% ... %> constructs.
Jon
|
|
|
|
|
When first released, ASP.NET lacked a template engine.
So now, for .NET 2.0, ARE "master pages", ASP.NET'S version of a template Engine?
If no, how do regular Template engines (StringTemplate) differ from 'Master Pages'?
Thanks in advance,
Laura
|
|
|
|
|
A master page provides a template for all pages, by providing for some areas to be common to all pages, and yet written once. I have no idea how this differs from what you regard a template engine to be, but it feels like a good fit to me.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
hi..in my project..i m dng an execution of exe file(an updation of software version) for a software present in the different machine...i,e,the update file is present in one machine, and the real software is present in differetn machien..
when i run the update file,specifically an exe file, the update should go to the specifed machine software...i want to this in a asp.net web site
thanks,in advance
|
|
|
|
|
You can't. Imagine if any website could run any exe on your machine. Not a nice idea, is it ? You can provide a local link to a file path you assume exists, or have people just download and run it, but you can't make it run without the user asking it to.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hi,
I've used a CreateUserWizard control to create a user and send an email, informing the user of their account username and password. That works great and saves loads of effort because it does all the email stuff for me including using a text file that I use for the email's body and handling SMTP errors, etc.
My question concerns the fact that I also want to create a user programatically. Is there any way I can use the CreateUserWizard control to create a user and send an email without any user interaction?
Thanks 
|
|
|
|
|
More detail...
For example, my code is like this:
CreateUserWizard cuw = new CreateUserWizard();
cuw.UserName = "freddy";
cuw.Email = "myemail@somewhere.com";
cuw.MailDefinition.From = "myemail@somewhereelse.com";
cuw.MailDefinition.Subject = "New Account";
cuw.MailDefinition.BodyFileName = "~/body.txt";
cuw.AutoGeneratePassword = true;
cuw.LoginCreatedUser = false;
cuw.RequireEmail = true;
WizardStep step = new WizardStep();
step.StepType = WizardStepType.Start;
step.Title = "Create User Step";
step.ID = "CreateUserStep";
CompleteWizardStep cws = new CompleteWizardStep();
cws.ID = "wsCompletedStep";
cuw.WizardSteps.Add(step);
cuw.WizardSteps.Add(cws);
cuw.MoveTo(cuw.WizardSteps[0]);
cuw.MoveTo(cuw.WizardSteps[1]);
So I only have two steps, one to create the user and send the email and the other to complete the wizard.
I run this code but nothing happens. Is it even possible to use the control like this? It would be great if I can because it saves me so much effort writing methods to send email and utilise an external text file as the email body plus all the error handling the CreateUserWizard has.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
