Hi Iam adding an HTML DIV to an ASPX page dynamically using HTMLGenericcontrol class. After every addition of div to the page, i wanted to add some spaces EX:  so that the page should show the content aligned in a format with spaces between two Divs. Any help on this is appreciated. Thanks!

Santhosh Kumar Edukulla

Hi I am working on a portal which is exactly the same as this one like a discussion forum internal to our org you can say. Here i have a requirement where users internal to our org will use it. When the user connect to our portal, we want to show on the page a welcome message EX: " Welcome Santhosh..." I suppose this information is fetched from AD. Can we have a code with similar requirements written for any of you. I have to do it, but i have very little time frame and it is the added requirement at the end. You may want to share the code if it is ok with any of you. Thanks in Advance! Santhosh

Santhosh Kumar Edukulla

You can connect to your local server by using "." Just type the "." in the name field and then login using credentials either "windows" or SQL. Hope this helps. Thanks!

Santhosh Kumar Edukulla

I have an ntext column in a table. I wanted this column value to be uploaded to a text file. I was using some code of my own, but it is not working out.Does anybody has any pointers on this? Any simple method to do this programmatically would be highly appreciated. I need to pull this code in one of my button click event on a windows page. Thanks in Advance!

Santhosh Kumar Edukulla

Patindex is used to check whether the given 'id' is in products table. Then Use the same input id to query the productstate table to know the statename accordingly. Thanks!

Santhosh Kumar Edukulla

We can do this, if you can give us more information about other tables like a)Where is the state information stored? Is it in a separate table and how "product" table and this table are related? b)What input you pass to the query EX: you just wanted to pass the number Ex: 1 or 2 etc right? I can provide you currently the abstract code it will look some thing like this. Suppose the input request from webform to db is '15' Declare @check_cond int Select @check_cond = PATINDEX('%15%',product state) from products Now, @check_cond contains the position of your input in the product state column of products table. patindex returns zero if it does not match your input. Thanks!

Santhosh Kumar Edukulla

Apologies, ignore my previous post.. Try this DateTime ShDate = DateTime.Parse(txtDate.Text); cmd1.CommandText = 'SELECT ShipedDate FROM Details WHERE Details.ShipedDate like' + '''' + '%' + ShDate + '%' + ''''; I tried it on my sql box and it worked. Hope this helps Thanks!

Santhosh Kumar Edukulla

Can you try this out... DateTime ShDate = DateTime.Parse(txtDate.Text); cmd1.CommandText = 'SELECT ShipedDate FROM Details WHERE Details.ShipedDate =%' + ShDate + '%'; See if it helps. Thanks! Santhosh

Santhosh Kumar Edukulla