create FUNCTION [dbo].[SM_SPLIT](
@delimited NVARCHAR(MAX),
@delimiter NVARCHAR(100)
) RETURNS @table TABLE (id INT IDENTITY(1,1), [value] NVARCHAR(MAX))
AS
BEGIN
DECLARE @xml XML
SET @xml = N'' + REPLACE(@delimited,@delimiter,'') + ''
INSERT INTO @table([value])
SELECT r.value('.','Nvarchar(MAX)') as item
FROM @xml.nodes('/t') as records(r)
RETURN
END
select * from dbo.SM_SPLIT(REPLACE('0, 111, 121, 131, 141, 211, 221, 231, 241, 251, 261, 271, 281, 212, 222, 232, 242, 252, 262, 272',' ',''),',')
Tag: row
C# DEVEXPRESS ASPXGRIDVIEW SELECTED ROWS TOTAL
protected void Button1_Click(object sender, EventArgs e)
{
//List SelectedDebts = grid.GetSelectedFieldValues(new string[] { "FISNO", "TL_BORC" });
//foreach (object debts in SelectedDebts)
//{
// IList items = debts as IList;
// if (items == null) return;
// SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CarringtonWebConnectionString1"].ConnectionString);
// con.Open();
// SqlCommand cmd = new SqlCommand("update ACIKHESAP set ODEME_DURUMU=1, ODENEN_TUTAR=" + items[1].ToString() + " where ID=" + items[0].ToString(), con);
// cmd.ExecuteNonQuery();
// Labeltesekkurler.Visible = true;
//}
//List SelectedDebts = grid.GetSelectedFieldValues(new string[] { "FISNO", "TL_BORC" });
Decimal selectedTUTAR = 0;
foreach (object value in ASPxGridView2.GetSelectedFieldValues("TL_BORC"))
{
{
selectedTUTAR += Convert.ToDecimal(value);
}
}
Global.TUTAR = null;
Global.TUTAR = selectedTUTAR.ToString();
Server.Transfer("payment.aspx");
}
Blog of Sem 