Database

CREATE PROCEDURE SplitInsert 
@cNameCountry varchar(500)
AS

declare @nLocNameStart int
declare @nLocComma int
declare @nLocDelim int
declare @cName varchar(100)
declare @cCountry varchar(100)

select @nLocNameStart = 1

while (@nLocNameStart<len(@cNameCountry))
begin
	select @nLocDelim = CHARINDEX('$&',@cNameCountry,@nLocNameStart + 1 )
	select @nLocComma = CHARINDEX(',',@cNameCountry,@nLocNameStart + 1 ) + 1

	if (@nLocDelim=0)
	  	select @nLocDelim = len(@cNameCountry) + 1
	
	select @cName = ltrim(SUBSTRING(@cNameCountry,@nLocNameStart,@nLocComma-@nLocNameStart-1))
	select @cCountry = ltrim(SUBSTRING(@cNameCountry,@nLocComma,@nLocDelim-@nLocComma))

	insert into tblNameCountry (Name,Country) values (@cName,@cCountry)

	select @nLocNameStart = @nLocDelim + 2
end
GO

AnhTin wrote:

thanks u verry much but @cNameCountry varchar(500)
when u assgin cNameCountry is varchar or nvarchar have only character (4000) but when
larger 4000 only type TEXT or NTEXT but will have error "The text, ntext, and image data types are invalid for local variables."

AnhTin wrote:

And Your Example have while (@nLocNameStartbegin is error Syntax can u see again

ToddHileHoffer wrote:

DataRow r = dt.rows[0];
Textbox1.text = r["policy"].ToString();
I'm assuming you can figure out how to get a datatable from this code. Then set the textbox.text property equal to

ghost181 wrote:

OleDbDataAdapter1.SelectCommand.CommandText = _
"SELECT * FROM Login WHERE username = " &
TextBox1.Text & ""

OleDbDataAdapter1.SelectCommand.CommandText = 
    "SELECT * FROM Login WHERE username = ?";
OleDbDataAdapter1.SelectCommand.Parameters.Add("", TextBox1.Text);