Comments by Noman Suleman

Noman Suleman 5-Feb-24 7:34am View

Thanks for detailed explanation. I am working on own email mass software like mail chimp and send grid. As business point of view

Noman Suleman 5-Feb-24 2:03am View

Fine got it. Right now I using MS Office 365 for mass email. Is MS allow to such activity?

Noman Suleman 5-Feb-24 1:47am View

So how I able to send bulk emails without blocking my account, because when ever there is such email addresses which is not available MS notify me address not found and after number of bounce emails account blocked.. although i am sending 20 emails per minute

Noman Suleman 4-Feb-24 9:53am View

Yes Ansari i have check already know all these checks. and also implemented especially per minute 30 email restrictions.

Noman Suleman 4-Feb-24 9:50am View

Dave there are lots of API's available to validate is email address exists or not

Noman Suleman 4-Feb-24 9:50am View

Deleted

Dave there are lots of API's available to validate is email address exists or not

Noman Suleman 3-Feb-24 10:19am View

Yes i know you can't do any thing i just want to ask how mailchimp or other email shooters. shoots bulk emails? without verification of recipient whether email exists or not. they bounce backed it but without block email. need guide so i can implement it.
Thanks for your response.

Noman Suleman 14-Jan-22 5:17am View

ok but its not calling the mentioned row.

SELECT GoodDescription, dbo.fn_GetNumbers(GoodDescription)
FROM
(
SELECT '3 Bleaching' as GoodDescription
UNION ALL
SELECT 'hair lotions'
UNION ALL
SELECT 'dentifrices'
UNION ALL
SELECT '9 Glasses 3' //this line not calling if 2 numeric in a cloumn
UNION ALL
SELECT 'eyeglass lens'
UNION ALL
SELECT '14 Precious metals and their alloys'
UNION ALL
SELECT '18 Leather and imitations of leather'
) T
WHERE dbo.fn_GetNumbers(GoodDescription) IN (3, 18)

Noman Suleman 14-Jan-22 5:02am View

I have tested that function its return all numeric values from string like '391418' but it is impossible to get result based on that combined values.. but your second query i did not understand how do use it. because my all values in same column which you have show in query wise line in second query

Noman Suleman 14-Jan-22 4:51am View

Thanks. agreed with you. but i can not change DB design, but i am trying to implement as you said.

Noman Suleman 30-Sep-21 1:04am View

Thanks Let me try this

Noman Suleman 5-May-20 2:51am View

Thanks!

Noman Suleman 2-May-20 4:08am View

thanks a lot sir, i got it all , very nice and simple solution appreciated!

Noman Suleman 30-Apr-20 11:57am View

that is perfect would you provide me example link of a'ka dictionary how can i create this. kindly guide me more. thanks in advance

Noman Suleman 30-Apr-20 11:23am View

this shows a company name multiple times i need sum of all those

AgentName Local Foreign Total
UNITED TRADEMARK & 40 90 130
UNITED TRADE MARK 0 1 1
UNITED TRADEMARK PATENT 0 1 1

Noman Suleman 30-Apr-20 11:13am View

thanks and appreciated, let me change this well pointed out

Noman Suleman 30-Apr-20 6:19am View

ok thanks for suggestion. let me try

Noman Suleman 30-Apr-20 6:09am View

its not when i remove outer apply then this query will return within 1 sec, after outer apply its goes to high consumption, its due to where clause parameter @Fno and @Tjno , and this outer clause return thousand record that is why its getting slow, i want to know is there any way to replace with other apprach?

Noman Suleman 30-Apr-20 5:47am View

if i removed replace command than i will get duplicate records, after replace command its return unique record

Noman Suleman 20-Feb-20 1:26am View

yes its deployed properly even its also not running on local IIS when i deployed on local machine its not running even with same code on Visual studio its running properly

Noman Suleman 26-Jun-19 8:00am View

actually i unable find what is main reason for its query issue or sql server tuning issue

Noman Suleman 8-Jun-19 4:26am View

how i can change font and character ?

Noman Suleman 29-May-19 11:59am View

Firewall is off.. It's happening on live server on locally every thing is fine.. Another error I found after some change in code error is "remote sever not responding"

Noman Suleman 29-May-19 11:52am View

It's happens sometimes. When my network change email works fine to desired address.. I think you right this is dns issue.. On my local code works fine suddenly I change my Internet to other isp it's works

Noman Suleman 17-May-19 0:48am View

thanks for reply

Noman Suleman 29-Apr-19 7:15am View

thanks your solution works

Noman Suleman 26-Apr-19 9:29am View

yes doing. thanks for your solution

Noman Suleman 26-Apr-19 9:25am View

i have given url https:ipAddress:Port/ApplicationName/ImageFolder/Image.jpg (ApplicationName is that application where folder is placed)

both application placed on same IIS

Noman Suleman 26-Apr-19 9:22am View

ok let me check

Noman Suleman 26-Apr-19 9:21am View

Deleted

i have given url like this, https://ipaddress:port/ApplicationName/folderName/imagename.jpg (this application name where folder exist)
both applicaitions on same IIS

Noman Suleman 26-Apr-19 2:12am View

i have shared but image url hitting to login page when i copy paste it to browser

Noman Suleman 13-Dec-18 23:50pm View

yes i have replaced 32 with 2 then it works.

Noman Suleman 13-Dec-18 23:33pm View

thanks for answer

Noman Suleman 13-Dec-18 23:33pm View

thanks buddy for guidance

Noman Suleman 9-Oct-17 5:25am View

yes right...thanks for your answer

Noman Suleman 9-Oct-17 4:10am View

:) , i always find a quick response from you.

Noman Suleman 9-Oct-17 3:56am View

yes i understood. thanks

Noman Suleman 9-Oct-17 3:41am View

thanks, so suggest me any other solution for that.

Noman Suleman 26-Jul-17 11:23am View

ok , i am finding as suggest

Noman Suleman 26-Jul-17 10:31am View

how am i encounter it?

Noman Suleman 26-Jul-17 10:31am View

Deleted

how am i encounter it?

Noman Suleman 20-Apr-17 1:49am View

its return null values

Noman Suleman 1-Dec-16 7:09am View

thanks. i have done it by call query in views now its work fine showing my desire result with the help of your query thanks again

Noman Suleman 30-Nov-16 8:19am View

hi, when i trying to get column from other table with inner join its not getting desired result kindly guide and check my query

SELECT COUNT( t.ShopkeeperID) as tcount,t.DealerID, t.ShopkeeperID
,STUFF((SELECT ', ' + CAST(Config_LimitInsurance.Name AS VARCHAR(10)) [text()]
FROM InsuranceMaster t1
WHERE t1.ShopkeeperID = t.ShopkeeperID and t1.DealerID = 21
FOR XML PATH(''), TYPE)
.value('.','NVARCHAR(MAX)'),1,2,' ') List_Output
FROM InsuranceMaster t INNER JOIN

Config_LimitInsurance ON t.AmountLimit = Config_LimitInsurance.ID
WHERE (t.DealerID = 21)
GROUP BY t.DealerID, t.ShopkeeperID, Config_LimitInsurance.Name

result is

tcount DealerID ShopkeeperID List_Output
2 21 4 50k, 50k
1 21 10 50k
1 21 11854 50k

Noman Suleman 30-Nov-16 5:27am View

Thanks its perfect :)

Noman Suleman 30-Nov-16 1:38am View

its user's requirement

Noman Suleman 21-Oct-16 6:49am View

helpful
thanks .

Noman Suleman 21-Oct-16 6:15am View

in which line i have to mentioned path?

Noman Suleman 21-Oct-16 6:08am View

now mentioned

Noman Suleman 10-Sep-16 6:46am View

its is working fine on my local debugger also shows date as format "dd/mm/yyyy"ss:mm on server it shows error

Noman Suleman 10-Sep-16 6:15am View

sir i have checked in DB although all are set as you suggest, but still have same issue..

Noman Suleman 20-Jun-16 4:51am View

i have multiple parent child records in table means my child record in some cases become a parent of other child record and other child record would be parent of other child record.

Noman Suleman 20-Jun-16 3:12am View

i have mentioned above what i need

Noman Suleman 17-May-16 6:32am View

ok

Noman Suleman 17-May-16 5:51am View

yes i understand just need some reference link for that which were you provided

Noman Suleman 5-Jan-16 1:09am View

i want to insert all grid record one time on click insert button which is placed out side grid

Noman Suleman 9-Dec-15 0:15am View

protected void btnSaveNext_Click(object sender, EventArgs e)
{
for (int i = 0; i < gvDisList.VisibleRowCount; i++)
{

int ID=Convert.ToInt32( gvDisList.GetRowValues(i, "ID"));
string ab = (gvDisList.GetRowValues(i, "Name").ToString());
string abc = (gvDisList.GetRowValues(i, "TextBox1").ToString());
}

Noman Suleman 1-Dec-15 1:33am View

Deleted

my aspx GridLookUp are there of Country and Zone/Provice
<div class="col-md-3"> <asp:Label ID="lblCuntry" runat="server" Text="Country" Font-Size="SMALL"><asp:RequiredFieldValidator ID="RqValContry" runat="server" Text="*" ErrorMessage="Must Select Country" Font-Size="SMALL" ForeColor="Red" ControlToValidate="LokUpCountry" EnableClientScript="true" SetFocusOnError="true" >
<dx:ASPxGridLookup ID="LokUpCountry" runat="server" Width="220px" Height="35px" CssClass="form-control" Theme="SoftOrange" AutoGenerateColumns="False" TextFormatString="{0}" KeyFieldName="CountryID" IncrementalFilteringMode="Contains" AutoPostBack="True" >
<gridviewproperties>
<settingsbehavior allowfocusedrow="True" allowselectsinglerowonly="True">

<columns> <dx:gridviewdatatextcolumn caption="Country Name" fieldname="Name" visibleindex="0" xmlns:dx="#unknown">

<dx:gridviewdatatextcolumn caption="ID" fieldname="CountryID" visible="False" visibleindex="1" xmlns:dx="#unknown">

</div>
<dx:ASPxGridLookup ID="LokUpZone" runat="server" Width="220px" Height="35px" CssClass="form-control" Theme="SoftOrange" AutoGenerateColumns="False" KeyFieldName="ZoneID" IncrementalFilteringMode="Contains" AutoPostBack="True" TextFormatString="{0}" >
<gridviewproperties>
<settingsbehavior allowfocusedrow="True" allowselectsinglerowonly="True">

<columns> <dx:gridviewdatatextcolumn caption="Zone Name" fieldname="Name" visibleindex="1" xmlns:dx="#unknown">

<dx:gridviewdatatextcolumn caption="ID" fieldname="ZoneID" visible="False" visibleindex="0" xmlns:dx="#unknown">

My Aspx.cs Code is that for binding both of them

protected void LoadCountry()
{
LokUpCountry.DataSource = ObjAllConfigTable.SelectCountry();
LokUpCountry.DataBind();

}
protected void LoadZone()
{
ObjAllConfigTable.CountryID = Convert.ToInt32(LokUpCountry.Value);
LokUpZone.DataSource = ObjAllConfigTable.SelectZone();
LokUpZone.DataBind();

}

<pre lang="C#">protected void LokUpCountry_ButtonClick(object source, DevExpress.Web.ASPxEditors.ButtonEditClickEventArgs e)
{
ObjAllConfigTable.CountryID = Convert.ToInt32(LokUpCountry.Value);
LokUpZone.DataSource = ObjAllConfigTable.SelectZone();
LokUpZone.DataBind();
}</pre>

when i am search a country on GridLookUp gets sigle characters then bind the zone GridLookup edit on suppose i have county names Peru, Pakistan when i search peru its auto bind Pakistan because it is top on the list alphabetically wise, i also try it on text changed and as well value changed but issue still there

Noman Suleman 30-Nov-15 7:12am View

will post soon

Noman Suleman 27-Nov-15 5:58am View

ok sir

Noman Suleman 27-Nov-15 5:44am View

thank you sir now its works when i put proper path.. the way u define is good easy to understand.. may i get you email address?

Noman Suleman 27-Nov-15 5:23am View

sir i got the path image.jpg although the complete path is ~/DistributorShopImages/image.jpg folder name is missing in label

Noman Suleman 27-Nov-15 5:17am View

i did as you define but its not deleting image from folder

Noman Suleman 5-Nov-15 8:01am View

no its has extension :
my folder containing images like that
1a.jpg
2b.jpg
3c.jpg

Noman Suleman 5-Nov-15 7:59am View

image id means my image has unique name.

Noman Suleman 5-Nov-15 7:57am View

i am confuse, that where to pass id to get files from folder

{
string[] filePaths = Directory.GetFiles(Server.MapPath("~/DistributorShopImages/" ));
List<listitem> files = new List<listitem>();
foreach (string filePath in filePaths)
{
string fileName = Path.GetFileName(filePath);
files.Add(new ListItem(fileName, "~/DistributorShopImages/" + fileName));
}
DataList1.DataSource = files;
DataList1.DataBind();
}

Noman Suleman 5-Nov-15 7:43am View

i want to call images id wise from folder by using Asp:Data List

Noman Suleman 29-Oct-15 7:23am View

issue resolved

Noman Suleman 29-Oct-15 7:02am View

thanks

Noman Suleman 29-Oct-15 7:02am View

thanks

Noman Suleman 15-Oct-14 14:48pm View

my question
how to resolve this
The specified string is not in the form required for an e-mail address.

Noman Suleman 15-Oct-14 14:48pm View

The specified string is not in the form required for an e-mail address.

Noman Suleman 15-Oct-14 14:47pm View

The specified string is not in the form required for an e-mail address.

Noman Suleman 12-Sep-14 7:44am View

i tried but data not in script

Noman Suleman 12-Sep-14 7:43am View

yes

Noman Suleman 7-Aug-14 8:38am View

i working on project school management system in which i need to create class time table

Noman Suleman 7-Aug-14 8:38am View

i working on project school management system in which i need to create class time table

Noman Suleman 7-Aug-14 8:36am View

i working on project school management system in which i need to create class time table

Noman Suleman 29-Mar-14 6:37am View

Deleted

i said how to delete the data from grid view you answered me different

Comments by Noman Suleman (Top 79 by date)