|
I'd like to see if anyone here uses anything other than FCK Editor:
http://www.fckeditor.net/
It's the best opensource, cross platform one available... Someone's even started an opensource .NET component for extra easy integration
|
|
|
|
|
I have a nested datagrid. Because of the way the information is set up in the database, I have separate SQL queries to populate the grid:
private void BindData()<br />
{<br />
strPartNumberInputReference = txtPartNumberInput.Text <br />
string SQLString = "SELECT p.PartNumber, p.ID as ptID, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath FROM parts p INNER JOIN PartTypes pt on pt.ID =p.PartTypeID LEFT JOIN DraftingData dd on dd.PartID = p.ID WHERE p.PartNumber = @PartID;SELECT w.weight, wt.Description AS wtDescription, p.PartNumber from weights w INNER JOIN weighttypes wt on wt.ID = w.weighttypeid INNER JOIN Parts p on w.PartID = p.ID WHERE p.PartNumber = @PartID;SELECT c.cost, p.PartNumber, ct.Description AS ctDescription from Costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN CostTypes ct on ct.Id = c.CostTypeID WHERE p.PartNumber = @PartID; SELECT s.SubPartID, s.Quantity, s.Sequence, p.PartNumber FROM SubParts s INNER JOIN Parts p ON s.PartID = p.Id "; <br />
SqlCommand cmd = new SqlCommand();<br />
cmd.Connection = new SqlConnection(strConnectSQL);<br />
cmd.CommandText = SQLString;<br />
cmd.Parameters.Add ("@PartID", strPartNumberInputReference);<br />
SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
adapter.Fill(ds);<br />
<br />
ds.Tables[0].TableName = "Rest";<br />
ds.Tables[1].TableName = "Weights";<br />
ds.Tables[2].TableName = "Costs";<br />
ds.Tables[3].TableName = "Subparts";<br />
<br />
<br />
dgParts.DataSource = ds;<br />
dgParts.DataBind();<br />
txtPartNumberInput.Text = "";<br />
<br />
<br />
}
Using these separate table names is how I populate the three nested datagrids.
I have a button for the user to click to add a new blank row for the main datagrid (called "Rest"). I've been messing with it for several hours and get one error or another.
Currently I have:
private void add_Click(object sender, System.EventArgs e)<br />
{<br />
DataTable dt2 = ds.Tables["Rest"];<br />
DataRow row;<br />
row = dt2.NewRow();<br />
row.ItemArray = dt2.Rows[0].ItemArray;<br />
row["PartNumber"]=strPartNumberInputReference = txtPartNumberInput.Text;<br />
row["DrawingNumber"]=DBNull.Value;<br />
row["DrawingRevision"]=DBNull.Value;<br />
row["DwgPath"]=DBNull.Value; some additional code...
but I'm getting the error "There is no row at position 0."
How should I be programming this?
|
|
|
|
|
hi,
its probably because you are creating the new row but not adding it to the table.write dt2.Rows.Add(row)
Tirthadip
|
|
|
|
|
Hi
I am developing a web application in which i am writing a file in javasript then after reading the file i have to delete the file but while deleting the file it gives error Permission denied .
PLease help me
hevar strContents; strContents = "";
objFSO = new ActiveXObject("Scripting.FileSystemObject");
if (objFSO.FileExists(strFileName))
{
var objFile=objFSO.OpenTextFile(strFileName, 1);
while ( !objFile.AtEndOfStream )
{
strContents = objFile.ReadLine();
var temp=strContents.split("#");
var range=temp[0];
var address=temp[1];
AddItemToListBox(range,address);
}
objFile.Close ();
objFSO.DeleteFile(strFileName,true); }
red line gives error
|
|
|
|
|
Hi,
I would like developp a control treeview with asp.net with the possibility to research a text in the treeview. The research must work all the node of the treeview.
Have you a exemple, a tutoriel ?
Thanks of your response
|
|
|
|
|
try telerik treeview component... they are really working nice and fast... You can find the documentation and tons of running samples...
Here is a part from documentation (r.a.d.treeview Client-Side):
FindNodeByText(text) Returns the first instance of a node with the specified Text.
FindNodeByValue(value) Returns the first instance of a node with the specified Value.
HainKurt
|
|
|
|
|
Hello,
I am in a little pickle, as usual and need to point to this asp file from within my asp.net page, but I get errors each time I do a dry run of my app... it didn't work even after I added the following attribute to the Page directive of my asp.net file:
AspCompat="true"
Can somebody please help me out? Many many thanks in advance!!
-Nila
|
|
|
|
|
How to display a row of elements from a datagrid to next page using querystring.
|
|
|
|
|
hi all
select date from table
which date format return . i want to show the date in dd/mm/yyyy
pls send the solution.
Regards
Srinadan mall
-- modified at 10:20 Monday 26th June, 2006
|
|
|
|
|
It depends on what you are doing?
If you want the date formated when returned from your database query you can use the CONVERT function: CONVERT( VARCHAR(10), date, 103 )
If you want to format it after the results are returned, such as using a GridView, then you can use the format specifiers in that control.
|
|
|
|
|
If I wanted to create an ASP.NET app for use on our internal network that would list all computer names on the network, and other info on the workstations such as hardware and software installed, how could this be done? Would I need to create an object to reside on the server which ASP.NET could then call the objects functions to crawl the network for this info save it to a database, and then let ASP.NET create reports from the database? Anythoughts on the best way to do this.
|
|
|
|
|
I'm certain there is a way of doing this using Windows Management Instrumentation (aka WMI) though I'm not directly experienced using this technology. You could start by checking out WMI on MSDN though I'm sure that won't be all ya need to get started.
-swilly1
|
|
|
|
|
I m saving certain amount in database and i want when it is displayed back then there should be comma after every three digit.I m doing this application in asp.net.I dont want to change column type from number to varchar.That i have done already.I want that column type should be number only but it should display amount having comma after every three digit
thanks
varun
|
|
|
|
|
|
I am having the datagrid with textbox in it.User Fill values in textbox and i want to validate textbox in datagrid so that no textbox is left empty
Plz help me
varun
|
|
|
|
|
go into html code of ur page. you find this code
<edititemtemplate>
<asp:textbox id="TxtComments">
Now just add RequiredFieldValidator below ur textbox in EditItemTemplate column.
For eg:
<edititemtemplate>
<asp:textbox id="TxtComments">
<asp:requiredfieldvalidator id="ReqvalDesc" runat="server" errormessage="Please enter Description."
="" controltovalidate="TxtComments">
Abhijeet Tidke
-- modified at 9:35 Monday 26th June, 2006
|
|
|
|
|
How to generate Crystal Reports using WebServices.Plz give me some material or help regarding this.
Thanx in advance.
|
|
|
|
|
hello everyone,
i have a small query regarding images.
When i retrieve the images from SQL database the image is being retrived as System.byte[]. So,how to convert those bytes into images and display on the datagrid. On the datagrid it should be displayed as thumbnails and when i click on the thumbnail it should be displayed as full image.
I am using Sql database and Asp.net webapplicaton,C#.net
Plz, can anyone suggest me some websites and can anyone write be code for this.
With Regards,
balla
balla
|
|
|
|
|
This could work, I didn't test it.
byte[] bytes = GetBytesFromDbOrWhatEver();
System.Drawing.Image image = System.Drawing.Image.FromStream(new System.IO.MemoryStream(bytes));
|
|
|
|
|
Hi,
I have a website in ASP and we are planning to rewrite it to .Net. There are some 40-50 reports in the website. With the current site we use a native application for generating the reports. But with .Net we are planning to use some report engine to do the job for us. For SQL Server database we have SQL Server Reporting services. Can we use the same for Oracle data base or is there any other efficient reporting engine for .Net & Oracle. Please give me some suggestions.
Thanks & Regards,
Das.
|
|
|
|
|
Hi all,
Can anyone tell me how do I Enable and disable selected menus.I mean When I select a Menu item it should get Disable and when i select any other menu item it should get disable and other should be enable.
I want to do this through Javascript.
Please help.
Thanks in advance.
|
|
|
|
|
Hello All,
I have a panel, of which i can change width as well as color dynamically.
When i click on a save button, i need to save the contents of panel into a picture file.
Can anyone please suggest an answer.
Thank You.
jeeva
|
|
|
|
|
I want to add a child node to selected node in treeview .
can anyone please help me .
|
|
|
|
|
Hi,
I am new to mobile tech. I am trying to install MMIT for VS2005 in XP platform, while installing i am getting an error "Setup cannot be run because of incompatable Framework version.........". I am in an confusion ,how to overcome this problem.?
Plz guide me how to install the MMIT and overcome this problem
Regards
Sarathy
|
|
|
|
|
Dear All,
I am using Crystal Reports for my web appplication. The Report which I have designed is for the paper whose height half of that of A4 but the width is same as A4. I have created a custom papersize in my printer properties. When i am using this papersize for my crystal report it is not displaying the report in correct size.
Sample Source:
Dim Rdoc as new ReportDocument
Rdoc.Load(Server.Mappath("Rpt_Receipt"))
ReportViewer1.ReportSource=Rdoc
The code doesnt work.
I have even tried using the PrintOptions.PaperSize
Like,
Dim R as new Rpt_Receipt
Rdoc.PrintOptions.PaperSize=R.PrintOptions.PaperSize
But the output has same height as that of the A4 and not my custom height.
I have also changed the paper size properties in my browser and printer.
Even then I couldnt get a proper output.
Is there any way to create a custom paper size.
Pleas let me know if anyone have the solution.
Thanks & Regards,
M. Gangadhar.
When One Lamp lits another the Glow never dimnishes
|
|
|
|