I'd like to insert a TableRow into a Table at a specified index using AddAt(). The resultant row order is not what I expected which raises my question: Does AddAt() replace the row at the specified index or does it insert a row at the specified index and then increment the index of each row that follows by 1?
View 1 Replies
I have a GridView (BulkEditGridView), that has 10 rows from the datasource. I Add a TemplateField "Insert Row" button to insert 1 blank row at selected row using Rows.AddAt.First time i press "Insert Row", it works as expected, the row inserted at selected row. now i press another "Insert Row", the row is inserted, however the row (in first time inserted) now move to the last row. and so on.
View 7 RepliesI work with Visual studio 2005 and Sql server data base. I extract 1 million rows from a database and I put the rows in a Sql table. With a simple direct extraction, in a few minutes I complete the operation:
Dim cmd As New SqlCommand(query, cnSql)
cmd.ExecuteNonQuery()
cmd.Dispose().
But, if I must select and modify some fields between extraction and introduction, it takes a lot of time!
I work in this way. I extract rows from Dbase, Table1, and I put all into a Collection using dataReader:
Dim cmd As New SqlCommand(query, cnSql)
Dim coll As New Collection
coll.Clear()
Dim dr As SqlDataReader = cmd.ExecuteReader()
I replace some fields with the string "YES".
Dim toRepl As String = ""
If dr.HasRows Then
Do While dr.Read
toRepl = dr(5).ToString
If Len(toRepl) <= 3 Then ToRepl = "YES"
collPrel.Add(dr(0).ToString)
collPrel.Add(dr(1).ToString)
.................. ..............
collPrel.Add(toRepl)
collCount = collCount + 1
Loop
End If
dr.Close()
cmd.Dispose()
Now, I insert all into a SQL Table2:
Dim a As String = "", b As String = "", c As String = "" etc.
For i = 1 To collPrel.Count Step 6
a = collPrel.Item(i).ToString
b = collPrel.Item(i + 1).ToString
.............. ...............
f = collPrel.Item(i + 5).ToString
queryIns = "INSERT INTO Tab (name, adress, etc)
VALUES ('" & a & "', '" & b & "', '" & c & "', etc. )
Dim cmdIns As New SqlCommand(queryIns, cnSql)
cmdIns.CommandTimeout = 600
cmdIns.ExecuteNonQuery()
cmdIns.Dispose()
Next
This way to work goes right but it is necessary a lot of time for completing the operation.
I need to replace <span> entries in a string to legacy html code because it's going to be used in a report for Crystal Reports. <b> works with Crystal, but the<span>'s do not.
Here's the string which I'm trying to replace: <span style="font-weight: bold">%THIS CAN BE ANY TEXT%</span>. I want to replace it to
<b>%THIS CAN BE ANY TEXT%</b>.
[Code]....
How do you replace" with" using the replace method?
View 5 RepliesI have been handling everything in code which is not working consistently same in all scenarios.
View 1 RepliesWe are using ASP.NET 1.1 for a website development, using DataGrid control for showing data.Can some body suggest how can i insert rows in between two rows in datagrid control.
View 2 RepliesWe have developed a web based application for data anlysis. we want to hide its working URL's with some custome url.e.g
[URL]
I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and
rows as columns like below:
EMP1 1 2 3 4
EMP2 1 2 3 4
i am creating CMS and display the content of every page on a single page when i/user click on any URL the pageid is transferd through query string variable on default.aspx page and content is displayed in div, when value is transfered to default.aspx page the url is like this example [URL] now i want to change it like this................
View 2 Repliesi am posed like a question like this will asp.net works with WPF? is this correct like wpf is going to replace win forms and asp.net in future??
View 3 RepliesI've created an asp.net application, and most of my code that does something with the database throws ApplicationExceptions if you try to do something that I don't want you to. The problem is that, as is my understanding, Exceptions should only be used for truly unexpected events, not for validation/verification; however much of the validation/verification logic in my application simply can only be done in code, as opposed to with validation controls etc.
Can anyone point me in the right direction? One is apparently not really supposed to throw exceptions for validation reasons, but I can't figure out a better way of saying "NO" to the page and escaping the function, when criteria for, for example, inserting a row are not fulfilled.
I am getting taggings like the following in a string
<color> vocation </color>
<color> elation </color>
<color> sage </color>
you can notice that each tagging differs only in the wordings
vocation
elation
sage
But i want to write a code some thing like this
Regex.Replace(userAx, "<color> vocation </color>",
"<color> </color>"
so that the resulting output does not contain words at the centre.In the above code instead of giving the word vocation exclusively, i have to mention some pattern, so that it will replace all the words instead of doing it for first sentence only.How to modify my code?
i have convert one of my Repeater to html format using Stringbulider and HtmlTextWriter. now i got html string. my repeater had some image Tags which i don't need it. so i want to replace the image tag(s) with empty sapce. i came to know its possible with using System.Text.RegularExpressions; Regex Thing is dont know how to find the all img tags from the string.
View 2 Replieswriting the regex pattern for the below case ? I do not want to use string.replace so using Regex.Replace
[code]....
I have a textbox where I accept multiple email ids separated by a comma. I then split it in my code-behind. If an email id is invalid, I change the background of it using Regex.replace, like this:
Regex.Replace(InputTxt, Search_Str, StartTag & "$1" & EndTag, RegexOptions.IgnoreCase)
My start and end tags are definned as:
"<Span class=highlight>" and "</span>"and my CSS is defined
as:.highlight { text-decoration: none; color:black; background:yellow;}This doesn't work.
i want to find and replace img src path by regular expression.suppose i have the below html and from there i want to replace file path of all the src attribute of image tag.
<P>Hello</P>
<P> </P>
<P><IMG alt="C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg" src="C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg"></P>
here the file path is src="C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg"
and i want to replace it with path like src="www.mysite.com/images/a.gif" with regular expression.how can i do it with regular expression.
I need to replace a button with a link .. I used the ASP hyperlink control .. which allows me to enter in the "NavigateURL .. but .. I need my link to execute some lines of VB code before redirecting to the link ..
View 3 RepliesHow to replace url of browser according to pages like>>
I have a url with query string [URL] ....
I want url like this [URL] ....
In this case how we can find values of query strings...
I have one big DataTable with X rows. I want to select Y rows from it and bind them to a new ViewList. While doing it, I want to delete these rows from the DataTable (Having X - Y rows).
What is the best and fast way to do it?
I don't know if it is better to create a new DataTable to have the Y and after that bind them to a ViewList or something else?
I'm also looking for example in code how to select/delete rows from DataTable.
I came across a situation where a user selects no of rows from dropdown , depending upon the user input, automatically that no of editable rows should appear to input data...(maximum 8 rows only)
View 1 RepliesI'm trying to replace some code generated by the AJAX Control Toolkit HTMLEditor from the XHTML standard to legacy code; <span style=*> to <b>, <u>, <i>, etc. This needs to be done because Crystal Reports doesn't understand the <span style=*> and needs the legacy items.
This is the code being generated by the HTMLEditor:
[Code]....
Is Regex.Replace the best way to replace these items? I need to keep the text between the opening and closing statements as well as ensure the proper formatting to the text so doing just ReplacementText.Replace will not work. I've tried a number of different things to try and get Regex.Replace working properly but keep having different issues and different things happen. But why it's not using the the closing span for the bold statement but using the closing span for the italics is beyond me.
I receive data from a database that contain character such as '&', 'é', 'è', ... In the page, they corectly shown, but when I want them in a textbox, they appear like "&", é" ...
is there a way I can make them appear correctly?
I have a page with 20 textboxes and rather then write a script for every box ive been looking in to a for loopbelow is what i have so farAm i on the right lines? i cant find what value needs to go after the replace part, thats were im getting my error but not sure im on the right lines anyway!
Dim ctl As Control
For Each ctl In Page.Controls(1).Controls
If TypeOf ctl Is TextBox Then
[code]...
I have a form inside a table which looks like this
HEADER1 HEADER2
asp:Label asp:Label
asp:Label asp:Label
asp:Label asp:Label
asp:button text="edit"
asp:button text="save"
The labels under Header2 show data from database. I need to be able to edit this data. So when i click on Edit button the labels under Header2 should be replaced with asp:textbox so i can type new data in them and save changes with "save" button.
how to approach this problem and resolve it? I was thinking of using UpdatePanel to avoid the visible page refresh.
