I'm fetching records from a table as shown below <b>ID Name PID</b> 1 Ram 10 1 Ram 20 2 Shyam 30 2 Shyam 40 2 Shyam 50 3 Rohit 60 But i want to display records as shown below i. mean to show common name for similar fields <b>ID Name PID</b> 1 Ram 10 - - 20 2 Shyam 30 - - 40 - - 50 3 Rohit 60
NET India
Posts
-
Show Column Name once for similar records -
Retrieve the value from Dynamic SqlHello Friends, I've a dynamic sql and it's returning Max(TRN_AMOUNT) now i've to store this Max(TRN_AMOUNT) in a variable i.e. @NUM. Here is my code DECLARE @STRSQL VARCHAR(MAX),@NUM VARCHAR(MAX) SET @STRSQL='SELECT MAX(TRN_AMOUNT) FROM TRN' EXEC(@STRSQL) PRINT @NUM
-
How to register DLL manually in VISTAHello Friends, Can anybody let me know How to register DLL manually in VISTA Thnx
-
Print in Landscape formatHello Friends, I want to print in Landscape format. And here is my code below .landScape { width: 100%; height: 100%; margin: 0% 0% 0% 0%; filter: progid:DXImageTransform.Microsoft.BasicImage(Rotation=3); }**
........
but this code is not working**
-
How to Total Shared Variable in Crystal ReportI have a shared variable of sub report in main report. I want to sum it.
-
tabcontrol not working when using select command of gridviewHello Friends, I've a tab control in my form. and a GridView When click on the Select commaqnd of GridView then it's not displaying my tabcontrol and throwing a javascript error as shown below Sys.ArgumentNullException: Value cannot be null. Parmeter name: element
-
Convert a String into datetimeHello Friends, I've a date in string variable i want to convert this string into datetime format(mm/dd/yyyy) but it's giving me an error. Because my date is stored in dd/mm/yyyy but sql analyser require datetime in mm/dd/yyyy. So please suggest me the way. Here is my example Declare @str varchar(100),@strDate datetime Set @str='14/02/2010'--(dd/mm/yyyy) Set @strDate=@str Print @strDate
-
Save DataTable into DatabaseI mean is it any way to save the datatable in sql server at a single turn
-
Save DataTable into DatabaseI have a DataTable filled with Columns and Rows in ASP.NET. I would like to save my Datatable inside my Database(Sql Server 2005).
-
Asynchronous Postback for GridView's Select CommandHello Friends, I've a GridView inside an Update Panel. There is a Select Command inside the GridView as i click on Select Link for a row. It has to fill the labels with the value brought at RowCommand for Select Command but labels are outside of the Update Panel so it's not showing the values in the labels. But if i use PostBack Trigger then it's working fine but taking an postback. So i want to use something for AsynPostBack. So suggest me the way
-
Insert Record from Textbox into GridViewIt may be very easier for you to do but not for me. Actually I've to add row with data into gridview using javascript. And i've reached to an extent. But i'm not getting how to insert the record into gridview. I've done to add into a 'tbody' tag. Please suggest me the way or what changes i should make in my code. I'm giving my code below. { var myTable = document.getElementById("ctl00_cphAdminMaster_GridView1"); var tBody = myTable.getElementsByTagName('tbody')[0]; var newTR = document.createElement('tr'); var newTD = document.createElement('td'); newTD.innerHTML=document.getElementById("ctl00_cphAdminMaster_txtName").value; newTR.appendChild (newTD); //tBody.appendChild(newTR); myTable.appendChild(newTR); }
-
Insert Record from Textbox into GridViewHello Friends, I've a textbox and Button As i click on button it should generate a new row to insert and insert the data into GridView's row from textbox. Actually i've to save the data into gridview and finally into database from gridview.
-
Text-Align="Right" in themeHello Friends, Can anybody let me know how to set Text-Align="Right" in theme.
-
GridView with JavascriptHello Friends, If i disable javascript in browser then my gridview's Select command is not working. So is it any way to work without javascript.
-
Sending Mail over Intranet<mailSettings> <smtp> <network host="192.168.1.8" port="25" userName="myuserName" password ="1234"></network> </smtp> </mailSettings>
-
Sending Mail over IntranetHello Friends, I'm sending mail using the following code and mail is working fine. SmtpClient client = new SmtpClient(); string from = "manoj.msb1984@gmail.com"; MailAddress From = new MailAddress(from); //To whom the mail is being sent string to = "depth.heart@gmail.com"; MailAddress To = new MailAddress(to); //To whom Carbon copy is being sent if there is not don't write this code //string cc = "rawgirish@gmail.com"; //MailAddress Cc = new MailAddress(cc); //Creat an object for MailMessage MailMessage message = new MailMessage(From, To); //Set Message body HTML true otherwise sometime it send html code message.IsBodyHtml = true; //Add Your Subject message.Subject = "Add You Subject Here"; //Add Body of the Mail here string strBody = "Hello, This is Manoj Bisht <br> Got It"; message.Body = strBody; try { //Send the Mail client.Send(message); //Show sent message if mail is sent successfully Response.Write("Mail Sent Successfully"); } catch (Exception ex) { Response.Write(ex.Message.ToString()); } But when im using this code to send email over intranet it's throwing error as shown below {"Failure sending mail."} [System.Net.Mail.SmtpException]: {"Failure sending mail."} Data: {System.Collections.ListDictionaryInternal} HelpLink: null InnerException: {"Unable to connect to the remote server"} Message: "Failure sending mail." Source: "System" StackTrace: " at System.Net.Mail.SmtpClient.Send(MailMessage message)\r\n at Rough_New.cmdSend_Click(Object sender, EventArgs e)" TargetSite: {Void Send(System.Net.Mail.MailMessage)}
-
Total CountHello Friends, I've a table as shown below ID RefID 1 0 2 1 3 2 4 1 5 1 and i want to display it's output as shown below but i'm not getting the way please suggest a way ID RefID Total 1 0 3 2 1 1 3 2 0 4 1 0 5 1 0
-
Domain and SubdomainI've a single server but is it any other way to display the url as i want ex. http://noida.myDomain.com except the subdomain.
-
Domain and SubdomainHello Friends, I'm working on property portal where i've to implement subdomain concept. for example http://www.myDomain.com is url of my site. And also, there are some locations as Noida,Gurgaon and etc. As any user click on Noida then my site should display the url as shown here http://noida.myDomain.com. For this i've implemented subdomain concept and also created some subdomain in Domain Panel. But now i've to ask Should i've to keep App_code and web.config file in subdomain(noida) folder as well because if i don't upload App_Code and web.config file in subdomain folder then it raise error(s). Is it any other way to implement this concept(Sub domain) please let me know.
-
Removing Scrolling from a body tag in javascriptSorry, its not working document.body.scrolling="no";