I have a table1 with first column having: usjim, uskim, uspeter, john ....
I need to insert this column into table2 excluding us if contains any ( extract substring basically)
I have tried doing this but doesn't work
[code]....
One of the fields in a table stores a long article. I just want to extract the beginnig part of it; could be any portion of it, like first one or two or three paragraphs. The vb code shows below:
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code]....
I really don't want the whole article displaying in the literalBrief. A few paragraphs from that article would be good enough. Is it possible to achieve that? At SQL level, or in VB coding, something like substring function?
I am having one column named Location in My MS SQL 2008 Database and the values in the Column is like "Region/State/City" region, city and states are saperated by forward slash.
In that column some times City is given and somtime it is not provided means only Region and state.
Now, i need to extract that Region, state and city from one column to a view and in view there should be three columns State ,City and region.
I have tried the SUBString but it works on no. of characters but for different city and regions the no.
in my database table there are 200 records.in description column record value is like .....
sometextLASER
sometext1LASER
sometext2LASER
i want to delete LASER from every record using sql.can enyone tell me how to do it.
Table1 - T1Col1(varchar) T1Col2(int) T1Col3(varchar)
Table2- T2Col1(varchar), T2Col2(varchar), T2Col3(int)
Table3- T3col1(varchar),T3col2(varchar)
For every record in Table1 I need to loop through top 10 records in Table2 - check this condition if( T1Col2 element & T2Col3 element)/T2Col3 element = 1 and insert T1Col1,T2col1 in to Table3
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
To be fair, this is a part two follow up to Using C# to recursively get a collection of controls from a controlcollection. - and rather than heap another question onto the old one, I created a new one. Here is the code that I'm using:
private void GetControlList<T>(ControlCollection controlCollection, ref List<T> resultCollection) where T : Control
{
foreach (Control control in controlCollection) [code]...
and is involked like this when the form is submitted
List<CheckBox> checkboxes = new List<CheckBox>();
GetControlList(RepeaterCapability.Controls, ref checkboxes);
I don't get any results when I clearly added several during the repeater OnItemDataBound event.
Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2).
My constraints are:
That I have to match the first 4 letters of a column in T2 to one column in T1 I have to identify that the first letter in a column in T1 corresponds to one letter in the middle of a string in a column in T2 For instance:
My Table (T1):
Order Type Combined
Place
0090 0001 YYXX 1YY
0091 1001 YYXX YYY
0092 1002 XXXX 2XX
Table 2 (T2):
Order Value
00900001YY XX
00911001YY XX
00921002XX XX
The Combined column in T1 is what i'm trying to complete. The T1.Place column contains the first character that I want to check for.
If it's a "1" then I want to make sure the 5th letter in T2.Order is a "0" If its a "Y" then I want to look for a "1001" If its a "2" then I want to make sure the 8th letter is a "2" in T2.Order
If all that matches then I was the last two letters in T2.Order + T2.Value to be combined and put into the appropiate spot in T1.Combined
Here's what I have:
[Code]....
I know it's a little complex, but i'm really stuck on it and any help would be greatly appreciated.
would like to know how to feed data for columns like Logged-in user id , Updated date, created date etc... I have these audit columns on each and every table. User id: Logged in user idCreated date or modified date: current system date time. and don'nt want to show these columns on the UI as well.
View 7 RepliesI have a form where i take request into the database. I also have a place to insert attachments into another table. On the backend...the attachement column is "image". I got it to insert. but when i try to retieve it from the database and put inside my gridview shows me system.byte[]. I have searched online to see what i can do to convert it but i seem not to be able to find anything. i am just writing a "select attachment from table " to retieve it.
View 16 RepliesI have an insert table with identity specification set. And I getthis error. I'm using a stored procedure to store it. How do I correct it. I'm also using a details view on my insert page.
Exception Details: System.Data.SqlClient.SqlException: Cannot insert explicit value for identity column in table 'Insert' when IDENTITY_INSERT is set to OFF.
I have a stored procedure that is close to working. It takes the values of a details view puts them into the respective table 'entity' then should also put the @@identity into 'entloan' and should put the LoanID which is in the query string of the page the detials view is loaded on, into the LoanID field of entLoan as well. Everything works except for getting the querystring value to pass to a insert variable on my stored procedure.
Stored Procedure
[Code]....
I do not have a LoanID Insert parameter set as it is not in entity table:
[Code]....
I have been playing around with different code in the backend but always get errors:
[Code]....
i have a data column which contains data in the folowing format :
12345-ABC-1234
1234-AB-123
123-A-12
how can i retrive columns based on the characters between the hyphens
e.g. only those columns which contain AB between hyphens(-)..
How i extract 0 from " flag=0" OR "flag = 0".
These are string value.
I am using a web service and get a SOAP envelope back and I am trying to extract some data but constantly run into errors. I have tried with LINQ, using xsl transform and so on.
The response is:
<?xml version="1.0" encoding="utf-8" ?>
- <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <soap:Body>
- <ABRSearchByABNResponse xmlns="some service /">
- <ABRPayloadSearchResults>
- <request>
- <identifierSearchRequest>
<authenticationGUID>some guid</authenticationGUID>
<identifierType>ABN</identifierType>
<identifierValue>54 108 408 566</identifierValue>
<history>N</history>
</identifierSearchRequest>
</request>
- <response>
<usageStatement>some statementusageStatement>
<dateRegisterLastUpdated>2011-01-26</dateRegisterLastUpdated>
<dateTimeRetrieved>2011-01-26T15:14:45.9776800+11:00</dateTimeRetrieved>
- <businessEntity>
<recordLastUpdatedDate>2000-08-26</recordLastUpdatedDate>
- <ABN>
<identifierValue>11111111111</identifierValue>
<isCurrentIndicator>Y</isCurrentIndicator>
<replacedIdentifierValue xsi:nil="true" />
<replacedFrom>0001-01-01</replacedFrom>
</ABN>
- <entityStatus>
<entityStatusCode>Active</entityStatusCode>
<effectiveFrom>2000-06-05</effectiveFrom>
<effectiveTo>0001-01-01</effectiveTo>
</entityStatus>
<ASICNumber />
- <entityType>
<entityTypeCode>IND</entityTypeCode>
<entityDescription>Individual/Sole Trader</entityDescription>
</entityType>
- <goodsAndServicesTax>
<effectiveFrom>2000-07-01</effectiveFrom>
<effectiveTo>0001-01-01</effectiveTo>
</goodsAndServicesTax>
- <legalName>
<givenName>some name</givenName>
<otherGivenName />
<familyName>some name</familyName>
<effectiveFrom>2000-08-26</effectiveFrom>
<effectiveTo>0001-01-01</effectiveTo>
</legalName>
- <mainBusinessPhysicalAddress>
<stateCode>QLD</stateCode>
<postcode>4350</postcode>
<effectiveFrom>2000-08-26</effectiveFrom>
<effectiveTo>0001-01-01</effectiveTo>
</mainBusinessPhysicalAddress>
</businessEntity>
</response>
</ABRPayloadSearchResults>
</ABRSearchByABNResponse>
</soap:Body>
</soap:Envelope>
My xslt file:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl" xmlns:soap="http://soap/Envelope/Body/">
<xsl:output method="html" indent="yes"/>
<xsl:template match="/">
Edit2:
I realized now that I can do:
foreach(var item in ABN)
{
label1.Text += item.identifierValue.ToString();
}
I have a table with three fileds userID, userName, userPassword.I have 100 rows in that table, now I want to update the userPassword column with new random generated string password.
View 1 Repliesi hve a data column containing data in this format...
1234-ab-1234
123-xy-123
12-ab-12
123-xy-123
1234-a-1234
12-s-1234
1234-xy-1234
how can i extract data between hyphens (ab, xy, a, s).. i need to extract distinct data only...
What is the most efficient way to extract part of a url stored as a string?
Examples
~/admin/default.aspx
~/home.aspx
~/forum/private/page.aspx?Testid=12
In each of these cases all I need is the page part. I.e. default.aspx, home.aspx or page.aspx.
I am trying to check if a string ends in "@something" and extract "something" from it if it does. For example, I am trying to do something like this:
string temp = "//something//img/@src"
if (temp ends with @xxx)
{
string extracted = (get "src");
...
}
else
{
}
How can I accomplish this?
I would like to know if someone can please help me with the followingI would like to create a bulk entering textbox...every sentence seperated by a line break should go in to the Database as a new column.....Im gonna use SqlDatasource for the inserting..How can I get all the sentences to break up at the linebreak and then get inserted in a separate database column?
View 3 RepliesExample- %%D1,100,0,0004[data...][0d0a]
[code]....
from the above example i want to extract picture data and need to store in to the sql table.sql table olumname is image and datatype is also image.after that i wanted to display this image column to an aspx page.
I need to extract chinese characters from the query string in a ASP.NET web application.
When I tried it, I get "????" instead of the actual text. I know I need to decode it with UTF-8 but its doesnot work. I have used String text = System.Web.HttpUtility.UrlDecode(Request.QueryString["text"], System.Text.Encoding.UTF8);
I want to write this
<elmah>
<errorlog type="Elmah.XmlFilerErrorLog, Elmah" logPath="~/App_Data" />
</elmah>
or
<elmah>
<errorLog type="Elmah.SQLiteErrorLog, Elmah" logPath="~/App_Data" />
</elmah>
however every place i tried putting this tag in i get an Unrecognized configuration section elmah. error. I found this question [URL] however i tried that (solution at the bottom of the question) and still get the error. Where do i put this? i found the issue. I didnt set <sectionGroup name="elmah"> properly. I couldnt find it online then remembered the demo had sqlite logging and i checked the demo config for clues.
I'm trying to use a function in my code behind to let me select a different column each time by calling the function with a different parameter.
However, I keep being told 'invalid column name', even though in the error page the column name appears perfectly valid.
Private Function getData(ByVal s As String) As String
I am using the following code for extracting a number from string 'sentence'.
Regex.Split(sentence, @"D+");
For Ex: This is test , message contains 192837 and the message ends here.
This output would be 192837.
Now, Let say: sentence is: This is test, 2736 message contains 293743 and message ends here.
This output would be 2736293743.
But, I want only 2736. i.e The first number in a string omit rest all others.
How to deal with this?