|
Hi all,
I am making one web application using ASP.NET and VB.NET 2.0. I want to make alerts and reminders for this application. User can set reminder for some specific date and they get mail as a reminder on that. Plus one day every week system check for users if they fill one form or not. If not then they will get mail to alert it. Can I know how I can do this? I am using SQL Server 2000 as a database.
Thanks in advance,
Priyank
|
|
|
|
|
Hi,
I think that you can use two solutions. First, you can create windows service which will do something automatically. In another way, you can create simple tool which will send e-mails and configure Windows "Schedule Task" to run it.
You can send e-mails using .NET Framework. But you also can create stored procedure for SQL Server fo e-mail sending. How to do this see here. If you will do this using SQL Server only, you can run this stired procedure using osql.exe in BAT-files.
|
|
|
|
|
Hi,
I want to create a popup calendar in .aspx page using javascript.
Can some one send and explain the code step by step.
Thanks,
Montu
Hello There
|
|
|
|
|
Sure,
Step 1) Open Internet browser of your choice
Step 2) Type www.google.com into address bar
Step 3) Press enter button
Step 4) Type javascript calandar into search box
Step 5) Click Search button
Step 6) Read
only two letters away from being an asset
|
|
|
|
|
http://www.asp.net/learn/ajax-videos/[^]
"Neque porro quisquam est qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit..."
"There is no one who loves pain itself, who seeks after it and wants to have it, simply because it is pain..."
|
|
|
|
|
Hi All,
I am using ASP.NET 2.0 (C#). I have a datatable where all the values are there now I need to write a recursive function but I am not getting the proper values. My datatable has the following data:
CID Desc PID
A T1 NULL
B T2 A
C T3 B
D T4 A
Please help me with this...
Thanks in advance...
|
|
|
|
|
ASP.NET 2.0 wrote: now I need to write a recursive function
Recursive function for what ?
|
|
|
|
|
Thanks for the reply. I have to write the recursive function to show the output as treeview.
|
|
|
|
|
ASP.NET 2.0 wrote: need to write a recursive function but I am not getting the proper values.
What are you trying to do? Where is your code?
Paul Marfleet
|
|
|
|
|
Thanks for the reply. I have to write the recursive function to show the output as treeview.
I have to generate the script based on the datatable rows. My normal function works fine if it has only one level but now in my datatable there can be more levels and for this I need to write recursive function. Following is the code:
private void FillValues(DataTable dtFinal)
{
int intChildRowCnt = 0;
StringBuilder strDBScript = new StringBuilder("");
strDBScript.Append("<script language='javascript' type='text/javascript'>");
// Create wsGrid Instance
strDBScript.Append("var m_wsGridCtrl = new jsTreeGridCtrl();");
// Param1: width
// Param2: OnMouseOver Color
//strDBScript += "m_wsGridCtrl.initializeDocument(1000, '#FF9999');";
strDBScript.Append("m_wsGridCtrl.initializeDocument(1000, '#8A9FFF');");
// Titles
// Param1: Text
// Param2: Width
// DataTable dtFinal = GetDataTable();
Int32 intColCnt;
if (dtFinal.Rows.Count > 0)
{
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0)
{
strDBScript.Append("m_wsGridCtrl.InsTab('Show All', '30');");
}
else if (intColCnt == 2)
{
}
else if (intColCnt == 1)
{
strDBScript.Append("m_wsGridCtrl.InsTab('" + dtFinal.Columns[intColCnt].ColumnName + "', '50');");
}
else
{
strDBScript.Append("m_wsGridCtrl.InsTab('" + dtFinal.Columns[intColCnt].ColumnName + "', '20');");
}
}
DataRow[] foundParent;
DataRow[] foundChild;
foundParent = dtFinal.Select("PresentationParentSpecElementID Is null");
if (foundParent.GetUpperBound(0) > 0)
{
for (Int32 intRowCnt = 0; intRowCnt <= foundParent.GetUpperBound(0); intRowCnt++)
{
foundChild = dtFinal.Select("PresentationParentSpecElementID=" + foundParent[intRowCnt]["SpecElementID"]);
if (foundChild.GetUpperBound(0) > 0)
{
strDBScript.Append("var iItem" + intRowCnt + "=");
}
strDBScript.Append("m_wsGridCtrl.InsItem(null, '");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(foundParent[intRowCnt][intColCnt] + ";");
}
}
strDBScript.Append("');");
for (intChildRowCnt = 0; intChildRowCnt <= foundChild.GetUpperBound(0) - 1; intChildRowCnt++)
{
strDBScript.Append("m_wsGridCtrl.InsItem(iItem" + intRowCnt + ",'");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(foundChild[intChildRowCnt][intColCnt] + ";"); }
}
strDBScript.Append("');");
}
}
}
else
{
foreach (DataRow row in dtFinal.Rows)
{
strDBScript.Append("m_wsGridCtrl.InsItem(null, '");
for (intColCnt = 0; intColCnt <= dtFinal.Columns.Count - 1; intColCnt++)
{
if (intColCnt == 0 || intColCnt == 2)
{
}
else
{
strDBScript.Append(row[intColCnt] + ";");
}
}
strDBScript.Append("');");
}
}
strDBScript.Append("m_wsGridCtrl.GenerateCode();");
strDBScript.Append("m_wsGridCtrl.RecudeAllTree();");
strDBScript.Append("</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "onload", strDBScript.ToString()); }
}
Now I need to convert this in recursive function..
Please help me...
Thanks again...
|
|
|
|
|
You could consider using the SQLXML managed classes to return the results of your query as an XML document. I don't know what treeview control you are using (some 3rd party / bespoke component) but if you use the TreeView control in ASP.NET 2.0 then you can bind the control to an XML datasource. You then don't have the hassle of writing your own population routine.
Paul Marfleet
|
|
|
|
|
Thanks for the reply. I have to use Treeview only as I have to show the data as TreeGird (TreeView Inside GridView) and so I am generating script for the same which builds the TreeGrid control.
Please help me with this...
Thanka again....
|
|
|
|
|
How to pass url of upload control in to session varibles.
when we are uploading a image before it was upload (i.e after browsing) that image displayed in another page.
Please give sufficient websites
priority: very high
|
|
|
|
|
kishoregani wrote: priority: very high
If your question is of such high priority, why are you not paying for assistance instead of coming to a site where people offer their help for free?
Anyway, you haven't expressed the problem intelligibly so I don't understand what you are trying to do.
Paul Marfleet
|
|
|
|
|
kishoregani wrote: when we are uploading a image before it was upload (i.e after browsing) that image displayed in another page
You can take the file name to session easily like following code
Session["FileName"] = FileUpload1.PostedFile.FileName
But this won't help you to show the image on next page until it is not uploaded. This filename gives client path for image. This can't be loaded using a server side scripting.
Are you looking for an image preview ? Then try using some javascript and show the image.
|
|
|
|
|
if exists(select CombinationId from tblItemsIdComposition where Id = @itemid and SubId = @subitemid and SSubId = @ssubitemid )
begin
select @combinationid = CombinationId from tblItemsIdComposition where Id = @itemid and SubId = @subitemid and SSubId = @ssubitemid
end
can i improve it a little bit?
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
You should ask questions like this in the SQL forum - it has nothing to do with ASP.NET.
Paul Marfleet
|
|
|
|
|
Hi Sonia,
Here u throw same query twice, which is not necessary.. instead u can write like this:
select @combinationid = CombinationId from tblItemsIdComposition where Id = @itemid and SubId = @subitemid and SSubId = @ssubitemid
-- @combinationid is null implicitly means that record does not exist!!
if @combinationid is null
begin
select 'not found'
end
else
begin
select 'found'
end
Hope this helps
Mitesh
|
|
|
|
|
what about
@combinationid = isnull(select CombinationId from tblItemsIdComposition where Id = @itemid and SubId = @subitemid and SSubId = @ssubitemid,0)
Hope its correct!!!
Paras Kaneriya The difference between genius and stupidity is that genius has its limits.
|
|
|
|
|
hi all,
i have to validate a textbox that which allow the user to type other than special charecters.
Thanks And Regards,
GuruKiran.
|
|
|
|
|
Write a javascript function validating..
|
|
|
|
|
I need regular expression to validate i writeen method but i hav to pass regular expression.
Thanks And Regards,
Guru
|
|
|
|
|
You could use a RegularExpressionValidatorControl and link it to your text box to constrain its input.
What characters do you want to allow/exclude? By way of example, the following regular expression will match if a string contains only alphanumeric characters, apostrophes, full stops and spaces.
^[a-zA-Z0-9'.\s]*$
Paul Marfleet
|
|
|
|
|
thanks I am waiting for this answer
|
|
|
|
|
That's OK. It's probably a good idea if you learned how to regular expressions work if you need to use them in your .NET code. I find the Expresso[^] tool useful whenever I am working with regular expressions.
Paul Marfleet
|
|
|
|