Lowyat.NET: Latest topics by 7782268

SQL Server -> Insert Record to new column

7782268 — Fri, 09 Oct 2015 09:20:49 +0800

Hi Guys,

Need some help from who are expert in SQL Server 2008. Currently I have a table with the column call ID and the the record as per below:

Column Name : ID
PR14000001
PR14000001
PR14000002
PR14000003
PR14000005
PR14000005
.......
.......
.......
PR15001468
PR15001469
PR15001469

As for my case, i need create a new column call LineID and i need to write a script to update the data in the new column by referring the data from ID but with condition:
1. between the prefix and number, need to add "LN"
2. cannot have duplicate, the number will be increment, which mean when it detect one record, the LineID column will increment 1

My expected result for the script will be as per below :
Column Name : LineID
PRLN14000001
PRLN14000002
PRLN14000003
PRLN14000004
PRLN14000006
PRLN14000008
.......
.......
.......
PRLN15001470
PRLN15001471
PRLN15001472

Note : currently there are thousand of record in this table, so i need write a script to update data into LineID with the two condition which i had state.

Tqvm for the people who are reply this thread!

VB.Net - Drop Down List Issue

7782268 — Tue, 29 Apr 2014 18:12:30 +0800

I got some issue for below coding :

Sub BindFFBGrade(ByVal pv_strFFBGrade As String)
lstFFBGrade.Items.Add("A")
lstFFBGrade.Items.Add("B")
lstFFBGrade.Items.Add("C")

lstFFBGrade.SelectedIndex = -1

If pv_strFFBGrade <> "" Then
If pv_strFFBGrade = "A" Then
lstFFBGrade.SelectedIndex = 0
ElseIf pv_strFFBGrade = "B" Then
lstFFBGrade.SelectedIndex = 1
ElseIf pv_strFFBGrade = "C" Then
lstFFBGrade.SelectedIndex = 2
End If
End If
End Sub

Whenever I run, the selected index for lstFFBGrade will be keep remain on 0 instead of -1. Is there any mistake I had do on it?

Please kindly help me on this, thanks!

How to send email to WAN within using intranet

Thu, 01 Jan 1970 07:30:00 +0800

How to send email to WAN within using intranet

7782268 — Tue, 27 Aug 2013 11:45:43 +0800

Hi all, currently i am handling a project for my company and i nee some advice/solution on it.

My company is using intranet only for their daily work due to business purpose. And now, manager level
want to send email to their client for futher easy communication.

My question is how i can setup the email function to them by sending the email by using intranet only?

How to sort colums in gridview for ASP.NET

7782268 — Thu, 01 Aug 2013 11:34:25 +0800

Hi all, need some help for below issue.

I want to sort column which name is 'Last Calling Date & Time' from latest to oldest.

So, I had change my code as below:

<asp:Panel ID="Panel1" runat="server" Height="285px" ScrollBars="Vertical" Width="1200px">
<asp:GridView ID="ResultsGV" runat="server" Width="96%" CellPadding="3" DataSourceID="getResults" EmptyDataText="No Records" AutoGenerateColumns="False" BackColor="White" BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellSpacing="1" GridLines="None" AllowPaging="true" AllowSorting="true" OnSorting ="ResultsGV_OnSorting">

But after I change the coding, an error come to me is "ResultGV_OnSorting" is not a member of 'ASP.Collection_aspx'.

Is anyone know what problem with my coding?

ASP.NET - Condition for limit word

7782268 — Fri, 26 Jul 2013 14:43:17 +0800

Hi all, need some guideline in the asp.net who are expert

I need to limit 200 words for the textbox with a condition as below:

1) I got client A and B who are using this system
2) client A require to limit 200 words when they type and save in the txtMode_Remarks while client B does not require

Below is my coding to limit the word for txtMode_Remarks:

<script type="text/javascript"> //Function to limit word
function Count(text,long)
{
var maxlength = new Number(long); // Change number to your max length.
if (text.value.length > maxlength)
{
text.value = text.value.substring(0,maxlength);
alert(" Only " + long + " chars");
}
}

//Coding for the txtMode_Remarks
<asp:UpdatePanel ID="UpdateModeDetails" runat="server" ChildrenAsTriggers="False" UpdateMode="Conditional">
<ContentTemplate>
<table style="font: menu" id="Mode_Status_Q">
<tr>
<td style="height: 70px">
<asp:RadioButtonList ID="rbtn_acnomode" runat="server" RepeatDirection="Horizontal" AutoPostBack="True" RepeatColumns="5">
</asp:RadioButtonList>
<asp:HiddenField ID="sql_updateMaster" runat="server" />
<asp:HiddenField ID="sql_updateDebtorMaster" runat="server" />
<asp:HiddenField ID="sql_updateMemo" runat="server" />
<asp:HiddenField ID="sql_updateCTBDailyStatus" runat="server" />
<asp:HiddenField ID="sql_updateVisitation" runat="server" />
<asp:HiddenField ID="sql_insertOCBC" runat="server" />
<asp:HiddenField ID="sql_updateOCBC" runat="server" />
<asp:HiddenField ID="Datavalidation" runat="server" />
<asp:HiddenField ID="sql_updateOCBCDailyStatus" runat="server" /><asp:HiddenField ID="sql_updateHSBCDailyStatus" runat="server" /><asp:HiddenField ID="sql_insertCallFrequency" runat="server" />
 
  

</td>
<td align="right" style="height: 70px; width: 388px;">
 <asp:HyperLink ID="AddVisit" runat="server" Width="52px">Send Visit</asp:HyperLink>
 
<asp:HyperLink ID="AddDailyRequest" runat="server" Width="98px">Add Daily Request</asp:HyperLink></td>
</tr>
<tr>
<td colspan="2">
<asp:FormView ID="ModeStatusFV" runat="server" BackColor="White"
BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" DataSourceID="getModeDetails" Width="823px" OnItemCommand="ModeStatusFV_ItemCommand" CellSpacing="1">
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<EditRowStyle BackColor="#DEDFDE" Font-Bold="True" ForeColor="Black" />
<EditItemTemplate>
<table style="width: 930px;" border="1">
<tr>
<td colspan="3" bgcolor="#cccc99" style="height: 20px">
Mode Status</td>
<td align="right" bgcolor="#cccc99" style="width: 272px; height: 20px;">
<asp:LinkButton ID="btn_save" runat="server" CommandName="save">Save</asp:LinkButton>
 <asp:LinkButton ID="btnCancel" runat="server" CommandName="Cancel" CausesValidation="False">Cancel</asp:LinkButton></td>
</tr>
<tr>
<td align="right" valign="top">
Mode :</td>
<td valign="top" style="width: 356px">
<asp:DropDownList ID="ddlMode_ID" runat="server" Width="347px" OnSelectedIndexChanged="ddlMode_ID_SelectedIndexChanged">
<asp:ListItem Value="CTC-P">CONTACTABLE-PAID (CTC-P)</asp:ListItem>
<asp:ListItem Value="CTC-NP">CONTACTABLE-UNPAY (CTC-NP)</asp:ListItem>
<asp:ListItem Value="UTC">UNABLE TO CONTACT (UTC)</asp:ListItem>
</asp:DropDownList><br />
<asp:HiddenField ID="HF_mode" runat="server" />
</td>
<td align="right" valign="top" style="width: 172px">
Mode Amount :</td>
<td valign="top" style="width: 272px">
<asp:TextBox ID="txtMode_Amt" runat="server" Text='<%# convert.tostring(eval("Mode_Amt")) %>'
Width="157px"></asp:TextBox></td>
<asp:HiddenField ID="HF_Mode_Amount" runat="server" />
</tr>
<tr>
<td align="right" valign="top">
SubMode :</td>
<td valign="top" style="width: 356px">
<asp:DropDownList ID="ddlSubMode_ID" runat="server" Width="310px">
<asp:ListItem Value="COL">COLLECTION (COL)</asp:ListItem>
<asp:ListItem Value="O/S">OUTSTANDING RESULT FRM BANK (O/S)</asp:ListItem>
<asp:ListItem Value="PC">PAYMENT CHECKING (PC)</asp:ListItem>
<asp:ListItem Value="PFS">PENDING FULLY SETTLED (PFS)</asp:ListItem>
<asp:ListItem Value="PP">PARTIAL PAYMENT (PP)</asp:ListItem>
<asp:ListItem Value="PPSC">PROPOSAL CONFIRM (PPSC)</asp:ListItem>
<asp:ListItem Value="PPSP">PROPOSAL PENDING (PPSP)</asp:ListItem>
<asp:ListItem Value="PTP">PROMISE TO PAY (PTP)</asp:ListItem>
</asp:DropDownList><br />
<asp:HiddenField ID="HF_Submode" runat="server" />
</td>
<td align="right" valign="top" style="width: 172px">
Payment Type :</td>
<td valign="top" style="width: 272px">
<asp:DropDownList ID="ddlPayment_Type" runat="server" SelectedValue='<%# convert.tostring(eval("Mode_Payment_Type")) %>'
Width="160px">
<asp:ListItem Selected="True"></asp:ListItem>
<asp:ListItem>Cash</asp:ListItem>
<asp:ListItem>Cheque</asp:ListItem>
</asp:DropDownList></td>
<asp:HiddenField ID="HF_Payment_Type" runat="server" />
</tr>
<tr>
<td align="right" valign="top">
Mode Date :</td>
<td valign="top" style="width: 356px">
<asp:TextBox ID="txtMode_Date" runat="server" Text='<%# convert.tostring(eval("Mode_Date","{0:dd MMM yyyy}")) %>'></asp:TextBox><ajaxToolkit:CalendarExtender ID="CalendarExtender1" runat="server" Format="dd MMM yyyy" PopupPosition="BottomRight" TargetControlID="txtMode_Date">
</ajaxToolkit:CalendarExtender>
<asp:HiddenField ID="HF_Mode_Date" runat="server" />
<asp:HiddenField ID="HF_CreatedOn" runat="server" />
</td>
<td align="right" valign="top" style="width: 172px">
Follow Up Type :</td>
<td valign="top" style="width: 272px">
<asp:CheckBox ID="chk_FUT" runat="server"/>
<asp:Label ID="lbl_FUT" runat="server">PDC </asp:Label></td>
<asp:HiddenField ID="HF_FUT1" runat="server" />
<asp:HiddenField ID="HF_FUT2" runat="server" />

</tr>
<tr>
<td align="right" valign="top">
Mode Remarks :</td>
<td valign="top" style="width: 356px">
<asp:TextBox ID="txtMode_Remarks" runat="server" onKeyUp="Count(txtMode_Remarks,10)" onChange="Count(txtMode_Remarks,10)" Height="130px" Text='<%# convert.tostring(eval("Mode_Remarks")) %>'
TextMode="MultiLine" Width="343px" Font-Names="Arial" MaxLength="10"></asp:TextBox><br />
</td>
<asp:HiddenField ID="HF_Mode_Remarks" runat="server"/>

I meet two question which is:
1. how to set limit word when client A is using?
2. after i set the limit word, i got error which is txtMode_Remarks is undefined. How to solve it?

Outlook 2010 mail sending issue

7782268 — Thu, 11 Jul 2013 10:39:10 +0800

Hi all, need some help from who know on this issue.

I want to set a condition in Outlook 2010 which I can send email to specified people which is A & B only.

If I put another people's email address eg : C's email address inside, it will prompt error say that,
"You are not allowed to send to the following person, C" something like that.

Anyone know on this seeting for Outlook 2010, thanks!